How can I strip the whitespace from Pandas DataFrame headers?

by

You can give functions to the rename method. The str.strip() method should do what you want:

In [5]: df
Out[5]: 
   Year  Month   Value
0     1       2      3

[1 rows x 3 columns]

In [6]: df.rename(columns=lambda x: x.strip())
Out[6]: 
   Year  Month  Value
0     1      2      3

[1 rows x 3 columns]

Note: that this returns a DataFrame object and it’s shown as output on screen, but the changes are not actually set on your columns. To make the changes, either use this in a method chain or re-assign the df variabe:

df = df.rename(columns=lambda x: x.strip())

More Related Contents:

  1. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  2. Any built-in function in pandas/python which converts a list like data into a list
  3. Logical operators for Boolean indexing in Pandas
  4. Pandas groupby with delimiter join
  5. What is the difference between size and count in pandas?
  6. How to join two dataframes for which column values are within a certain range?
  7. Pandas fillna using groupby
  8. How to plot multiple Seaborn Jointplot in Subplot
  9. Pandas to_html() truncates string contents
  10. How to remove parentheses and all data within using Pandas/Python?
  11. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  12. Recursive definitions in Pandas
  13. Fastest way to populate QTableView from Pandas data frame
  14. Tilde sign in pandas DataFrame
  15. Drop columns whose name contains a specific string from pandas DataFrame
  16. Pivoting a Pandas Dataframe containing strings – ‘No numeric types to aggregate’ error
  17. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  18. Panda’s Write CSV – Append vs. Write
  19. From password-protected Excel file to pandas DataFrame
  20. How to add multiple annotations to a bar plot
  21. How can repetitive rows of data be collected in a single row in pandas?
  22. Converting time zone pandas dataframe
  23. Set value for particular cell in pandas DataFrame with iloc
  24. Plot the x-axis as a date
  25. pandas get position of a given index in DataFrame
  26. Plot two levels of x_ticklabels on a pandas multi-index dataframe [duplicate]
  27. How to update/create column in pandas based on values in a list
  28. Split strings in tuples into columns, in Pandas
  29. drop unused categories using groupby on categorical variable in pandas
  30. Split pandas dataframe in two if it has more than 10 rows

Leave a Comment