Python - 重新命名 Pandas DataFrame 的列
要重新命名 DataFrame 的列,請使用 rename() 方法。在 rename() 方法的 “columns” 引數下設定要重新命名的列名。例如,將 “Car” 列更改為 “Car Name” −
dataFrame.rename(columns={'Car': 'Car Name'}, inplace=False)
首先,讀取 CSV 並建立一個 DataFrame −
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\SalesRecords.csv")
現在,重新命名列名。此處,我們正在重新命名列 “Car”、“Date_of_Purchase” 和 “Reg_Price” −
dataFrame = dataFrame.rename(columns={'Car': 'Car Name', 'Date_of_Purchase': 'Sold On', 'Reg_Price' : 'Booking Price'}, inplace=False)
示例
以下是程式碼
import pandas as pd # reading csv file dataFrame = pd.read_csv("C:\Users\amit_\Desktop\SalesRecords.csv") print("DataFrame...\n",dataFrame) # count the rows and columns in a DataFrame print("\nNumber of rows and column in our DataFrame = ",dataFrame.shape) dataFrame = dataFrame.rename(columns={'Car': 'Car Name', 'Date_of_Purchase': 'Sold On', 'Reg_Price' : 'Booking Price'}, inplace=False) print("\nDataFrame with updated Column Name ...\n",dataFrame)
輸出
這將產生以下輸出 −
DataFrame... Car Date_of_Purchase Reg_Price 0 BMW 10/10/2020 1000 1 Lexus 10/12/2020 750 2 Audi 10/17/2020 750 3 Jaguar 10/16/2020 1500 4 Mustang 10/19/2020 1100 5 Lamborghini 10/22/2020 1000 Number of rows and column in our DataFrame = (6, 3) DataFrame with updated Column Name ... Car Name Sold On Booking Price 0 BMW 10/10/2020 1000 1 Lexus 10/12/2020 750 2 Audi 10/17/2020 750 3 Jaguar 10/16/2020 1500 4 Mustang 10/19/2020 1100 5 Lamborghini 10/22/2020 1000
廣告