Pandas column access w/column names containing spaces

by

Old post, but may be interesting: an idea (which is destructive, but does the job if you want it quick and dirty) is to rename columns using underscores:

df1.columns = [c.replace(' ', '_') for c in df1.columns]

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. How to test if a string contains one of the substrings in a list, in pandas?
  3. Pandas filtering for multiple substrings in series
  4. Remove unwanted parts from strings in a column
  5. String concatenation of two pandas columns
  6. Find column whose name contains a specific string
  7. add a string prefix to each value in a string column using Pandas
  8. pandas dataframe str.contains() AND operation
  9. Pandas DataFrame stored list as string: How to convert back to list
  10. How to remove square bracket from pandas dataframe
  11. NLTK-based text processing with pandas
  12. Left justify string values in a pandas DataFrame
  13. Count number of words per row
  14. Converting a column within pandas dataframe from int to string
  15. Capitalize first letter of each word in a dataframe column
  16. How to use str.contains() with multiple expressions in pandas dataframes
  17. Copy text between parentheses in pandas DataFrame column into another column
  18. Fast punctuation removal with pandas
  19. Rename Pandas DataFrame Index
  20. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  21. Merge multiple column values into one column in python pandas
  22. How do I get the row count of a Pandas DataFrame?
  23. selecting from multi-index pandas
  24. Dataframe set_index not setting
  25. How can I replicate rows in Pandas?
  26. How to create a DataFrame of random integers with Pandas?
  27. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  28. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  29. Selecting a range of columns in a dataframe
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment