java csv排序,在java中按升序对csv文件中的一列数据排序

import java.io.*;

import java.util.*;

public class Sort {

public static void main(String[] args) throws Exception {

BufferedReader reader = new BufferedReader(new FileReader("data1.csv"));

Map map=new TreeMap();

String line="";

while((line=reader.readLine())!=null){

map.put(getField(line),line);

}

reader.close();

FileWriter writer = new FileWriter("sorted_numbers.txt");

for(String val : map.values()){

writer.write(val);

writer.write('\n');

}

writer.close();

}

private static String getField(String line) {

return line.split(",")[0];//extract value you want to sort on

}

}

Hia

I am trying to read a unsorted file and get Java to sort one column of the csv data file and print those results in a new file. I borrowed this solution whilst I was searching on this website because I think it is ideal for what I am trying to acomplish. I have a 282 rows of data in the form of

UserID, Module, Mark

Ab004ui, g46PRo, 54

cb004ui, g46GRo, 94

gy004ui, g46GRo, 12

ab004ui, g46PRo, 34

this is in the csv file.

when I use the above code it only gives me one line in the sorted_marks.txt, like this

ab004ui, g46PRo, 34

and I believe it wasnt even sorted.

I want all the results from the new file to be sorted based on their userID and nothing else but I can't seem to get it to work, please any help would be greatful

解决方案

Remove the new lines from data1.csv.

I would prefer to use the second generic String of the Map as a list of string and everything is almost same like below

import java.io.BufferedReader;

import java.io.FileReader;

import java.io.FileWriter;

import java.util.LinkedList;

import java.util.List;

import java.util.Map;

import java.util.TreeMap;

public class Sort {

public static void main(String[] args) throws Exception {

BufferedReader reader = new BufferedReader(new FileReader("data1.csv"));

Map> map = new TreeMap>();

String line = reader.readLine();//read header

while ((line = reader.readLine()) != null) {

String key = getField(line);

List l = map.get(key);

if (l == null) {

l = new LinkedList();

map.put(key, l);

}

l.add(line);

}

reader.close();

FileWriter writer = new FileWriter("sorted_numbers.txt");

writer.write("UserID, Module, Mark\n");

for (List list : map.values()) {

for (String val : list) {

writer.write(val);

writer.write("\n");

}

}

writer.close();

}

private static String getField(String line) {

return line.split(",")[0];// extract value you want to sort on

}

}