我有这些数据:
1975,a,b
1976,b,c
1977,b,a
1977,a,b
1978,c,d
1979,e,f
1980,a,f
我想要一个包含年份和项目的两列列表,如下所示:
1975,a
1975,b
...
我有这个代码:
import pandas
# Set column names
colnames=['Date','Item1','Item2']
# read csv adding column names
data = pandas.read_csv('/Users/Simon/Dropbox/Work/Datasets/lagtest.csv', names=colnames)
# create a dataframe with info on dates for first column
datelist1 = data[['Date', 'Item1']]
# create a dataframe with info on dates for first column
datelist2 = data[['Date', 'Item2']]
bigdatelist = datelist1.append(datelist2)
print bigdatelist
但它给了我这个:
Date Item1 Item2
0 1975 a NaN
1 1976 b NaN<