Home > Software design >  Python Pandas read_csv quote issue, impossible to separate data
Python Pandas read_csv quote issue, impossible to separate data

Time:04-29

I'm working with several csv with Pandas. I changed some data name on the original csv file and saved the file. Then, I restarted and reloaded my jupyter notebook but now I got something like this for all dataframe I charged the data source :

   Department  Zone    Element     Product     Year    Unit    Value
0   U1,"Z3","ODD 2.a.1...   NaN     NaN     NaN     NaN     NaN     NaN
1   U1,"Z3","ODD 2.a.1...   NaN     NaN     NaN     NaN     NaN     NaN
2   U1,"Z5","ODD 2.a.1...   NaN     NaN     NaN     NaN     NaN     NaN
3   U1,"Z6","ODD 2.a.1...   NaN     NaN     NaN     NaN     NaN     NaN
4   U1,"Z9","ODD 2.a.1...   NaN     NaN     NaN     NaN     NaN     NaN

I tried to use sep=',', encoding='UTF-8-SIG',quotechar='"', quoting=0, engine='python' but same issue. I don't know how to parse the csv because even when I created a new csv form the data (without the quote and separator as ; ) the same issue appears...

csv is 321 rows, as this example with the problem : enter image description here

  • Related