我有一个如下所示的 .csv 文件:
Male, Male, Male, Female, Female
R, R, L, R, R
.86, .67, .88, .78, .81
我想将其读入 df,这样我就有:
Male Female
R L R
0 .86 .67 .88 .78 .81
I did:
df = pd.read_csv('file.csv', header=[0,1])
But headers
不削减它。这导致
Empty DataFrame
Columns: [(Male, R), (Male, R), (Male, L), (Female, R), (Female, R)]
Index: []
然而,标题上的文档说:
(...)Can be a list of integers that specify row
locations for a multi-index on the columns E.g. [0,1,3]
我究竟做错了什么?我怎样才能让它发挥作用?