从 pandas 数据框中删除标题列 [英] Removing header column from pandas dataframe

问题描述

我有傻瓜.数据框:

df

   A   B
0  23  12
1  21  44
2  98  21

如何从此数据框中删除列名A和B?一种方法是将其写入csv文件，然后在指定header = None的情况下读取它.有没有办法写出csv并重新读取?

How do I remove the column names A and B from this dataframe? One way might be to write it into a csv file and then read it in specifying header=None. is there a way to do that without writing out to csv and re-reading?

推荐答案

我认为您无法删除列名，只能使用

I think you cant remove column names, only reset them by range with shape:

print df.shape[1]
2

print range(df.shape[1])
[0, 1]

df.columns = range(df.shape[1])
print df
    0   1
0  23  12
1  21  44
2  98  21

这与使用 to_csv 和 read_csv :

This is same as using to_csv and read_csv:

print df.to_csv(header=None,index=False)
23,12
21,44
98,21

print pd.read_csv(io.StringIO(u""+df.to_csv(header=None,index=False)), header=None)
    0   1
0  23  12
1  21  44
2  98  21

使用skiprows的下一个解决方案:

Next solution with skiprows:

print df.to_csv(index=False)
A,B
23,12
21,44
98,21

print pd.read_csv(io.StringIO(u""+df.to_csv(index=False)), header=None, skiprows=1)
    0   1
0  23  12
1  21  44
2  98  21

这篇关于从 pandas 数据框中删除标题列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！