Hier sind die ersten 4 Datensätze der CSV-Datei. Die vollständige Datei umfasst 219.590 Datensätze:-
Code: Select all
0,23,1,0,[email protected],"Construction/Contractors/Contractors"
0,43,1,0,[email protected],"Engineering/Electrical Engineering/Electrical Engineering"
0,395,1,0,[email protected],"Sales/Sales Force Management/Sales Management"
0,398,1,0,[email protected],"Sales/Sales Strategy/Sales"
Code: Select all
File csvFile = new File("data/userattrib2_30day.csv");
ColumnPositionMappingStrategy strategy = new ColumnPositionMappingStrategy();
strategy.setType(UserAttribRecord.class);
String[] columns = new String[] {"userId", "attributeId", "rating", "timestamp", "email", "attributeDesc"};
strategy.setColumnMapping(columns);
CSVReader reader = new CSVReader(new FileReader(csvFile));
CsvToBean csv = new CsvToBean();
List userAttribList = csv.parse(strategy,reader);
Code: Select all
Exception in thread "main" java.lang.RuntimeException: Error parsing CSV!
at com.opencsv.bean.CsvToBean.parse(CsvToBean.java:95)
at com.opencsv.bean.CsvToBean.parse(CsvToBean.java:75)
Vielen Dank
Mobile version