更改 pandas DataFrame 中的特定列名 [英] Changing a specific column name in pandas DataFrame
本文介绍了更改 pandas DataFrame 中的特定列名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我一直在寻找一种优雅的方式来更改 DataFrame
中的指定列名.
播放数据...
将pandas导入为pdd = {'一': [1, 2, 3, 4, 5],'二': [9, 8, 7, 6, 5],'三': ['a', 'b', 'c', 'd', 'e']}df = pd.DataFrame(d)
迄今为止我发现的最优雅的解决方案......
names = df.columns.tolist()名称[names.index('two')] = 'new_name'df.columns = 名称
我希望有一个简单的单线……这次尝试失败了……
df.columns[df.columns.tolist().index('one')] = 'another_name'
感谢收到任何提示.
解决方案
确实存在单行:
在[27]中:df=df.rename(columns = {'two':'new_name'})在 [28] 中:df出[28]:一三新名字0 1 一个 91 2 乙 82 3 73 4 d 64 5 5
以下是 rename
方法的文档字符串.
I was looking for an elegant way to change a specified column name in a DataFrame
.
play data ...
import pandas as pd
d = {
'one': [1, 2, 3, 4, 5],
'two': [9, 8, 7, 6, 5],
'three': ['a', 'b', 'c', 'd', 'e']
}
df = pd.DataFrame(d)
The most elegant solution I have found so far ...
names = df.columns.tolist()
names[names.index('two')] = 'new_name'
df.columns = names
I was hoping for a simple one-liner ... this attempt failed ...
df.columns[df.columns.tolist().index('one')] = 'another_name'
Any hints gratefully received.
解决方案
A one liner does exist:
In [27]: df=df.rename(columns = {'two':'new_name'})
In [28]: df
Out[28]:
one three new_name
0 1 a 9
1 2 b 8
2 3 c 7
3 4 d 6
4 5 e 5
Following is the docstring for the rename
method.
Definition: df.rename(self, index=None, columns=None, copy=True, inplace=False) Docstring: Alter index and / or columns using input function or functions. Function / dict values must be unique (1-to-1). Labels not contained in a dict / Series will be left as-is. Parameters ---------- index : dict-like or function, optional Transformation to apply to index values columns : dict-like or function, optional Transformation to apply to column values copy : boolean, default True Also copy underlying data inplace : boolean, default False Whether to return a new DataFrame. If True then value of copy is ignored. See also -------- Series.rename Returns ------- renamed : DataFrame (new object)
这篇关于更改 pandas DataFrame 中的特定列名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文