Key error when selecting columns in pandas dataframe after read_csv

by

use sep='\s*,\s*' so that you will take care of spaces in column-names:

transactions = pd.read_csv('transactions.csv', sep=r'\s*,\s*',
                           header=0, encoding='ascii', engine="python")

alternatively you can make sure that you don’t have unquoted spaces in your CSV file and use your command (unchanged)

prove:

print(transactions.columns.tolist())

Output:

['product_id', 'customer_id', 'store_id', 'promotion_id', 'month_of_year', 'quarter', 'the_year', 'store_sales', 'store_cost', 'unit_sales', 'fact_count']

More Related Contents:

  1. UnicodeDecodeError when reading CSV file in Pandas with Python
  2. Writing a pandas DataFrame to CSV file
  3. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  4. Skip rows during csv import pandas
  5. How to avoid Python/Pandas creating an index in a saved csv?
  6. datetime dtypes in pandas read_csv
  7. Python Pandas Error tokenizing data
  8. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  9. python – Using pandas structures with large csv(iterate and chunksize)
  10. Pandas read csv file with float values results in weird rounding and decimal digits
  11. pandas read_csv and filter columns with usecols
  12. Using numpy.genfromtxt to read a csv file with strings containing commas
  13. How to keep leading zeros in a column when reading CSV with Pandas?
  14. How to read a column of csv as dtype list using pandas?
  15. OSError: Initializing from file failed on csv in Pandas
  16. python pandas read_csv delimiter in column data
  17. Read csv from Google Cloud storage to pandas dataframe
  18. Read CSV into a dataFrame with varying row lengths using Pandas
  19. Read specific columns with pandas or other python module
  20. Convert percent string to float in pandas read_csv
  21. Conditional row read of csv in pandas
  22. Easiest way to read csv files with multiprocessing in Pandas
  23. Load CSV to Pandas MultiIndex DataFrame
  24. pandas read csv with extra commas in column
  25. Pandas to_csv call is prepending a comma
  26. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  27. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  28. start index at 1 for Pandas DataFrame
  29. pandas – convert string into list of strings [duplicate]
  30. Bin values based on ranges with pandas [duplicate]

Leave a Comment