如何在python中转换CSV

Question

我有这个csv:

id1, var1, value1_id1,
id1,var2, value2_id1,
id2,var1, value1_id2,
id2,var2, value2_id2,

如何将csv转换为：

id, var1, var2,
id1, value1_id1, value2_id1,
id2, value1_id2, value2_id2,

Answer 1

跟随@de1

您应该使用pandas:

import pandas as pd
df = pd.read_csv("data.csv", header=None) #import csv
df.columns = ['ID', 'VAR', 'VALUE','extra'] #defining the column header
data = df[['ID', 'VAR', 'VALUE']] #defining a new database without the extra column
data.pivot(index='ID', columns='VAR')