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:
… [Trackback]
[…] Here you can find 72526 additional Info to that Topic: geeksforgeeks.org/remove-spaces-from-column-names-in-pandas/ […]
… [Trackback]
[…] Find More on to that Topic: geeksforgeeks.org/remove-spaces-from-column-names-in-pandas/ […]