search

jdunck / python-unicodecsv

Python2's stdlib csv module is nice, but it doesn't support unicode. This module is a drop-in replacement which *does*. If you prefer python 3's semantics but need support in py2, you probably want https://github.com/ryanhiebert/backports.csv
Other
594 stars 87 forks source link

unicodecsv reads some cells as empty despite the fact they have values. #48

Closed dchaplinsky closed 9 years ago

dchaplinsky commented 9 years ago

I'm having problems reading pretty simple CSV file, that I've exported from google spreadsheet: https://gist.github.com/dchaplinsky/9791d15fb1b66b429044

This fields returned as "" (see https://gist.github.com/dchaplinsky/fb4533e7b27b456aabce).

I've tried to debug it last night, but had no success. monosnap 2015-03-11 13-42-13

dchaplinsky commented 9 years ago

I've also found that native CSV DictReader has the very same problem, while reader doesn't.

dchaplinsky commented 9 years ago

I'm an idiot, please ignore me.

jdunck commented 9 years ago

I doubt that's true -- if there was something confusing about using it, could you clarify how you were misled? Perhaps a runtime warning or better docs are in order?

dchaplinsky commented 9 years ago

CSV that I was trying to use had two columns with identical names. Second one was always empty.

jdunck commented 9 years ago

OK, I just made #50 to make this less difficult to avoid in the future.