How do I read .csv files

Gys invalid at invalid.com
Tue Mar 16 08:23:19 EDT 2021


On 3/12/21 11:28 AM, Johann Klammer wrote:
> Specifically ones with quoted strings. I'll have whitespace in
> there and possibly escaped quotechars.
> maybe newlines too.
> Which means that pyparsing commaSeparatedList.parseString(line) won't work.
> 
> I also like to edit them for visual alignment, so there'll
> be whitespaces outside the strings(more than one)
> ...therefore, csv.DictReader() won't work.
> 
> I'd like them read into a dict or something..

Hi Johann Klammer,
I use Pandas for handling *.csv files

pandas documentation :

<https://pandas.pydata.org/pandas-docs/stable/index.html>

Hands on example :

<https://chrisalbon.com/python/data_wrangling/pandas_dataframe_importing_csv/>

-hth
Gys



More information about the Python-list mailing list