在Pandas中删除列名中的空格
在pandas中删除列名中的空格并不难,我们可以用replace()函数轻松地删除pandas中列名中的空格。我们也可以用另一个字符来替换空格。让我们逐一看看两者的例子。
例子1:删除列名中的空格。
# import pandas
import pandas as pd
# create data frame
Data = {'Employee Name': ['Mukul', 'Rohan', 'Mayank',
'Shubham', 'Aakash'],
'Location': ['Saharanpur', 'Meerut', 'Agra',
'Saharanpur', 'Meerut'],
'Sales Code': ['muk123', 'roh232', 'may989',
'shu564', 'aka343']}
df = pd.DataFrame(Data)
# print original data frame
print(df)
# remove special character
df.columns = df.columns.str.replace(' ', '')
# print file after removing special character
print("\n\n", df)
Python
输出:
例子2:用其他字符替换空格
# import pandas
import pandas as pd
# create data frame
Data = {'Employee Name': ['Mukul', 'Rohan', 'Mayank',
'Shubham', 'Aakash'],
'Location': ['Saharanpur', 'Meerut', 'Agra',
'Saharanpur', 'Meerut'],
'Sales Code': ['muk123', 'roh232', 'may989',
'shu564', 'aka343']}
df = pd.DataFrame(Data)
# print original data frame
print(df)
# replace space with another character
df.columns = df.columns.str.replace(' ', '_')
# print file after removing special character
print("\n\n", df)
Python
输出: