Removing spaces from column names in pandas is not very hard we easily remove spaces from column names in pandas using replace() function. We can also replace space with another character. Let’s see the example of both one by one.
Example 1: remove the space from column name
Python
# import pandasimport pandas as pd # create data frameData = {'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 frameprint(df) # remove special characterdf.columns = df.columns.str.replace(' ', '') # print file after removing special characterprint("\n\n", df) |
Output:
Example 2: replace space with another character
Python
# import pandasimport pandas as pd # create data frameData = {'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 frameprint(df) # replace space with another characterdf.columns = df.columns.str.replace(' ', '_') # print file after removing special characterprint("\n\n", df) |
Output:
