KeyError when indexing Pandas dataframe

by

As mentioned by alko, it is probably extra character at the beginning of your file.
When using read_csv, you can specify encoding to deal with encoding and heading character, known as BOM (Byte order mark)

df = pd.read_csv('values.csv', delimiter=",", encoding="utf-8-sig")

This question finds some echoes on Stackoverflow:
Pandas seems to ignore first column name when reading tab-delimited data, gives KeyError

More Related Contents:

  1. How to deal with SettingWithCopyWarning in Pandas
  2. Apply multiple functions to multiple groupby columns
  3. GroupBy results to dictionary of lists
  4. Pandas timeseries plot setting x-axis major and minor ticks and labels
  5. How to remove nan value while combining two column in Panda Data frame?
  6. Improve subplot size/spacing with many subplots in matplotlib
  7. Restart cumsum and get index if cumsum more than value
  8. Remove non-numeric rows in one column with pandas
  9. How to deal with multi-level column names downloaded with yfinance
  10. Replace all occurrences of a string in a pandas dataframe (Python)
  11. ValueError: numpy.dtype has the wrong size, try recompiling
  12. Add months to a date in Pandas
  13. Python – How to convert JSON File to Dataframe
  14. How to change the datetime tick label frequency for matplotlib plots
  15. Pandas DataFrame aggregate function using multiple columns
  16. How to add a suffix (or prefix) to each column name?
  17. Python Pandas: Is Order Preserved When Using groupby() and agg()?
  18. Pass percentiles to pandas agg function
  19. Capitalize first letter of each word in a dataframe column
  20. Compute the running (cumulative) maximum for a series in pandas
  21. Get total of Pandas column
  22. Sorting columns and selecting top n rows in each group pandas dataframe
  23. Get first and second highest values in pandas columns
  24. ImportError: No module named ‘pandas.indexes’
  25. select columns based on columns names containing a specific string in pandas
  26. Pandas: split column of lists of unequal length into multiple columns
  27. Python Pandas – Read csv file containing multiple tables
  28. Add column of empty lists to DataFrame
  29. Color a scatter plot by Column Values
  30. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path

Leave a Comment