How to rename a column name in Pandas DataFrame
This article mainly introduces how to rename the column names in Pandas DataFrame. It is very detailed and has a certain reference value. Friends who are interested must finish it!
Getting started exampl
The above code:
# how to rename column names in pandas dataframe # In [32]: import pandas as pd# In [33]: data = pd.read_csv ('ufo.csv') # View the type of data # In [34]: type (data) # display the first few pieces of data # In [35]: data.head () # print all column names # In [36]: data.columns# use rename () rename and list # In [37]: data.rename (columns= {'Shape Reported':'Shape_Reported' \ 'Colors Reported':'Colors_Reported'}, inplace=True) # print the renamed column # In [38]: data.columns# define a list overall replacement column name # In [39]: data_cols= [' city', 'colors reported',' shape reported',\ 'state' 'time'] # In [40]: data.columns = data_cols# In [41]: data.head () # specify the column name # In [42]: data = pd.read_csv (' ufo.csv',names= data_cols,header=0) data.head () # In [43]: data.columns# modify the column name # In [44]: data.columns = data.columns.str.replace ('') using replace () '_') # In [45]: data.columns
The above is all the contents of the article "how to rename columns in Pandas DataFrame". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!
