如何将数据框列的索引重置为0,1,2,3,4?
(为什么执行df.reset_index()
不会重置列索引?)
>>> data = data.drop(data.columns[[1,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]], axis=1)
>>> data = data.drop(data.index[[0,1]],axis = 0)
>>> print(data.head())
0 2 3 4 20
2 500292014600 .00 .00 .00 NaN
3 500292014600 100.00 .00 .00 NaN
4 500292014600 11202.00 .00 .00 NaN
>>> data = data.reset_index(drop = True)
>>> print(data.head())
0 2 3 4 20
0 500292014600 .00 .00 .00 NaN
1 500292014600 100.00 .00 .00 NaN
2 500292014600 11202.00 .00 .00 NaN
reset_index
方法可能也适用于列索引。 - ClementWalterdf = pd.DataFrame({'A': [1,2,3], 'B': list('ABC')})
会有int64/object,但df.T.T
将全部变成object。此外,转置可能会很耗费资源。 - mozway