怎么用java转置csv,如何在CSV文件中转置数据集？

For example, i would like to transform:

Name,Time,Score

Dan,68,20

Suse,42,40

Tracy,50,38

Into:

Name,Dan,Suse,Tracy

Time,68,42,50

Score,20,40,38

EDIT: the original question used the term "transpose" incorrectly.

解决方案

If the whole file contents fits into memory, you can use

import csv

from itertools import izip

a = izip(*csv.reader(open("input.csv", "rb")))

csv.writer(open("output.csv", "wb")).writerows(a)

You can basically think of zip() and izip() as transpose operations:

a = [(1, 2, 3),

(4, 5, 6),

(7, 8, 9)]

zip(*a)

# [(1, 4, 7),

# (2, 5, 8),

# (3, 6, 9)]

izip() avoids the immediate copying of the data, but will basically do the same.