I'm doing some data analysis using some very large csv files (one has 2 million+ lines of data). What is the best way to quickly read the file and parse the lines into javabean classes?
Example Object class:
public class Crime {
private String district;
private String psa;
private String dispatchDateTime;
private String dispatchDate;
private String dispatchTime;
private String hour;
private String dcKey;
private String locationBlock;
private String ucrGeneral;
private String generalCode;
private String month;
private String lon;
private String lat;
public Crime() {
//
}
public void setDistrict(String district) {
this.district = district;
}
........
public String getDispatchDateTime() {
return dispatchDateTime;
}
public String getDispatchDate() {
return dispatchDate;
}
}
Example line of data:
35,D,2009-07-19 01:09:00,2009-07-19,01:09:00,1,200935061008,5500 BLOCK N 5TH ST,1500,Weapon Violations,20,2009-07,-75.130477,40.036389