如何摆脱“未命名:0" pandas DataFrame中的列? [英] How to get rid of "Unnamed: 0" column in a pandas DataFrame?
本文介绍了如何摆脱“未命名:0" pandas DataFrame中的列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一种情况,有时当我从df
读取csv
时,会得到一个不需要的类似索引的列,名为unnamed:0
.
I have a situation wherein sometimes when I read a csv
from df
I get an unwanted index-like column named unnamed:0
.
file.csv
,A,B,C
0,1,2,3
1,4,5,6
2,7,8,9
以此读取CSV:
pd.read_csv('file.csv')
Unnamed: 0 A B C
0 0 1 2 3
1 1 4 5 6
2 2 7 8 9
这很烦人!有谁知道如何摆脱这一点?
This is very annoying! Does anyone have an idea on how to get rid of this?
推荐答案
It's the index column, pass index=False
to not write it out, see the docs
示例:
In [37]:
df = pd.DataFrame(np.random.randn(5,3), columns=list('abc'))
pd.read_csv(io.StringIO(df.to_csv()))
Out[37]:
Unnamed: 0 a b c
0 0 0.109066 -1.112704 -0.545209
1 1 0.447114 1.525341 0.317252
2 2 0.507495 0.137863 0.886283
3 3 1.452867 1.888363 1.168101
4 4 0.901371 -0.704805 0.088335
比较:
In [38]:
pd.read_csv(io.StringIO(df.to_csv(index=False)))
Out[38]:
a b c
0 0.109066 -1.112704 -0.545209
1 0.447114 1.525341 0.317252
2 0.507495 0.137863 0.886283
3 1.452867 1.888363 1.168101
4 0.901371 -0.704805 0.088335
您还可以通过传递index_col=0
来告诉read_csv
第一列是索引列:
You could also optionally tell read_csv
that the first column is the index column by passing index_col=0
:
In [40]:
pd.read_csv(io.StringIO(df.to_csv()), index_col=0)
Out[40]:
a b c
0 0.109066 -1.112704 -0.545209
1 0.447114 1.525341 0.317252
2 0.507495 0.137863 0.886283
3 1.452867 1.888363 1.168101
4 0.901371 -0.704805 0.088335
这篇关于如何摆脱“未命名:0" pandas DataFrame中的列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文