Pandas rename()函数的主要任务是重命名任何索引,列或行。此方法对于重命名某些选定的列很有用,因为我们只需要为要重命名的列指定信息。
它主要根据某些映射(dict或Series)或任意函数来更改轴标签。该函数必须唯一,并且参数应为 1 到 -1 。如果字典或Series中未包含标签,则会保留标签。如果列出一些额外的标签,它将引发错误。
DataFrame.rename(mapper=None, index=None, columns=None, axis=None, copy=True, inplace=False, level=None, errors='ignore')
它返回带有重命名轴标签的DataFrame。
示例1:以下示例重命名了单个列:
import pandas as pd # Define a dictionary containing information of employees info = {'name': ['Parker', 'Smith', 'William', 'Robert'], 'age': [38, 47, 44, 34], 'language': ['Java', 'Python', 'JavaScript', 'Python']} # Convert dictionary into DataFrame info_pd = pd.DataFrame(info) # Before renaming columns print(info_pd) info_pd.rename(columns = {'name':'Name'}, inplace = True) # After renaming columns print("\nAfter modifying first column:\n", info_pd.columns
输出:
name age language 0 Parker 38 Java 1 Smith 47 Python 2 William 44 JavaScript 3 Robert 34 Python After modifying first column: Index(['Name', 'age', 'language'], dtype='object')
示例2 :以下示例重命名了多列:
import pandas as pd # Define a dictionary containing information of employees info = {'name': ['Parker', 'Smith', 'William', 'Robert'], 'age': [38, 47, 44, 34], 'language': ['Java', 'Python', 'JavaScript', 'Python']} # Convert dictionary into DataFrame info_pd = pd.DataFrame(info) # Before renaming columns print(info_pd) info_pd.rename(columns = {'name':'Name', 'age':'Age', 'language':'Language'}, inplace = True) # After renaming columns print(info_pd.columns)
输出:
name age language 0 Parker 38 Java 1 Smith 47 Python 2 William 44 JavaScript 3 Robert 34 Python Index(['Name', 'Age', 'Language'], dtype='object')
示例3 :以下示例重命名了特定列的索引:
import pandas as pd data = {'Name': ['Smith', 'Parker', 'William'], 'Emp_ID': [101, 102, 103], 'Language': ['Python', 'Java', 'JavaScript']} info1 = pd.DataFrame(data) print('DataFrame:\n', info1) info2 = info.rename(index={0: '#0', 1: '#1', 2: '#2'}) print('Renamed Indexes:\n', info2)
输出:
DataFrame: Name Emp_ID Language 0 Smith 101 Python 1 Parker 102 Java 2 William 103 JavaScript Renamed Indexes: Name Emp_ID Language #0 Smith 101 Python #1 Parker 102 Java #2 William 103 JavaScript
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)