Get pandas.read_csv to read empty values as empty string instead of nan

by

I was still confused after reading the other answers and comments. But the answer now seems simpler, so here you go.

Since Pandas version 0.9 (from 2012), you can read your csv with empty cells interpreted as empty strings by simply setting keep_default_na=False:

pd.read_csv('test.csv', keep_default_na=False)

This issue is more clearly explained in

That was fixed on on Aug 19, 2012 for Pandas version 0.9 in

More Related Contents:

  1. Import multiple csv files into pandas and concatenate into one DataFrame
  2. Writing a pandas DataFrame to CSV file
  3. Pandas read_csv from url
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Python Pandas Error tokenizing data
  6. How to read a file with a semi colon separator in pandas
  7. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  8. How to read file with space separated values in pandas
  9. pandas read_csv and filter columns with usecols
  10. selecting across multiple columns with python pandas?
  11. import text to pandas with multiple delimiters
  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. pandas DataFrame output end of csv
  15. How to read a column of csv as dtype list using pandas?
  16. Panda’s Write CSV – Append vs. Write
  17. Loading multiple csv files of a folder into one dataframe
  18. python pandas read_csv delimiter in column data
  19. Read csv from Google Cloud storage to pandas dataframe
  20. Pandas dataframe read_csv on bad data
  21. Pandas read_csv dtype leading zeros
  22. pandas.read_csv from string or package data
  23. Conditional row read of csv in pandas
  24. Pandas read_csv dtype read all columns but few as string
  25. Calculate summary statistics of columns in dataframe
  26. double quoted elements in csv cant read with pandas
  27. how to specify the datetime format in read_csv
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign

Leave a Comment