public static Map<String,List<String>> readRainfallCSV(String pathFile,String fileName) {
Map<String,List<String>> result= new HashMap<>();
try {
File file = new File(pathFile+File.separator+fileName);
List<String> lines = Files.readAllLines(file.toPath(),
StandardCharsets.UTF_8);
List<String> names = Arrays.asList(lines.get(0).split(","));
//第一个null值
//循环逐列读取
List<List<String>> lineList = new ArrayList<>();
lines.stream().forEach(item->lineList.add(Arrays.asList(item.split(","))));
lineList.remove(lineList.get(0));
for(int i=1;i<names.size();i++){
int finalI = i;
//每一列的数据
result.put(names.get(finalI),lineList.stream().map(item -> item.get(finalI)).collect(Collectors.toList()));
}
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
csv读取列数据(一列一列读取成一个集合)
最新推荐文章于 2023-07-12 19:50:00 发布