uneven csv with mixed datatypes

[keshav3...@gmail.com]

Hi,

Encountered the following data in a csv

1,2,3,4,5,,,

a,3,4,t,y,....

1,2,3

3,y,t,,,,,,

moto is to just drop this data as is into sqllite , any hints on this.

Regards,

Keshav

[Joris Van den Bossche]

What is your desired result?

You have some options with read_csv to skip lines with less values, or to select certain columns, eg see http://pandas.pydata.org/pandas-docs/stable/io.html#handling-bad-lines

Joris

--
You received this message because you are subscribed to the Google Groups "PyData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Julien Marrec]

From the example you give (and accepting that I know nothing about your data), it looks like “....” might be there to indicate that the row continues on the following line (some older programs still have 80 char limits...), in which case you could just preprocess the CSV to reconstruct proper lines.

——

Sent from a mobile device, please excuse the brevity.

Julien Marrec, EBCP, BPI MFBA
Owner

Direct: +33 6 95 14 42 13
Website: www.effibem.com

LinkedIn (en) | (fr)

To unsubscribe from this group and stop receiving emails from it, send an email to pydata+un...@googlegroups.com.