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