Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #75342

Re: Load a CSV with different row lengths

Show all headers | View raw

Ryan de Vera wrote:

> I am trying to load a csv with different row lengths. For example,
> 
> I have the csv
> 
> a,b
> a,b,c,d
> a,b,c
> 
> How can I load this into python? I tried using both NumPy and Pandas.

The csv module in the standard library can deal with varying row lengths 
just fine:

>>> import csv
>>> with open("data.csv") as f:
...     data = list(csv.reader(f))
... 
>>> data
[['a', 'b'], ['a', 'b', 'c', 'd'], ['a', 'b', 'c']]

Depending on your use case you may need to do some post-processing in your 
code (e. g. converting strings to numbers).

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Load a CSV with different row lengths Peter Otten <__peter__@web.de> - 2014-07-29 09:37 +0200

csiph-web