I trust Numpy a lot for CSV handling. It deals with lots of edge cases including missing data, weird delimiters (pipes '|' are popular in astro for some reason

I trust Numpy a lot for CSV handling. It deals with lots of edge cases including missing data, weird delimiters (pipes '|' are popular in astro for some reason) and massive files. If in doubt, whack it into Excel which has been doing this stuff for decades now. I prefer using Numpy to Python's CSV library which I find a bit clunky. Very little data is actually true CSV. The code isn't particularly long (~900 lines), it's Python (hence readable) and it's well commented: https://github.com/numpy/numpy/blob/v1.8.1/numpy/lib/npyio.py#L1172 https://github.com/numpy/numpy/blob/v1.8.1/numpy/lib/npyio.p...