CSV reader behavior with None and empty string

by

The documentation suggests that what you want is not possible:

To make it as easy as possible to interface with modules which implement the DB API, the value None is written as the empty string.

This is in the documentation for the writer class, suggesting it is true for all dialects and is an intrinsic limitation of the csv module.

I for one would support changing this (along with various other limitations of the csv module), but it may be that people would want to offload this sort of work into a different library, and keep the CSV module simple (or at least as simple as it is).

If you need more powerful file-reading capabilities, you might want to look at the CSV reading functions in numpy, scipy, and pandas, which as I recall have more options.

More Related Contents:

  1. Create Pandas DataFrame from a string
  2. How to write to a CSV line by line?
  3. Python csv string to array
  4. How do I write data into CSV format as string (not file)?
  5. Filter string data based on its string length
  6. Pandas read_csv dtype leading zeros
  7. pandas – convert string into list of strings [duplicate]
  8. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  9. How do I read a large csv file with pandas?
  10. Pandas filtering for multiple substrings in series
  11. How to get a string after a specific substring?
  12. How to “test” NoneType in python?
  13. Create a .csv file with values from a Python list
  14. How do I format a string using a dictionary in python-3.x?
  15. _csv.Error: field larger than field limit (131072)
  16. How to split strings into text and number?
  17. ValueError: could not convert string to float: id
  18. String to Dictionary in Python [duplicate]
  19. Inline CSV File Editing with Python
  20. How do I convert a list into a string with spaces in Python?
  21. What does ‘killed’ mean when processing a huge CSV with Python, which suddenly stops?
  22. Deleting rows with Python in a CSV file
  23. Python: How to check a string for substrings from a list? [duplicate]
  24. How to parse a string and return a nested array?
  25. Should I avoid converting to a string if a value is already a string?
  26. How do I put a variable’s value inside a string (interpolate it into the string)?
  27. Python string to unicode [duplicate]
  28. How to remove all integer values from a list in python
  29. ValueError: not enough values to unpack (expected 11, got 1)
  30. Convert nested JSON to CSV file in Python

Leave a Comment