CSV file escaping characters

[lokhtar]

Hello,

I am trying to do something relatively simple - load a csv file and create a list (or a dataframe). The separator for my file is "|", but the data in my csv file can have all the other characters - ",':, space, etc. Need to ignore them all - but the code that I have messes up when looking through that file. Any help would be appreciated!

#load dataframe from csv
import csv
import pandas as pd

df1 = pd.read_csv('reports/reports_test.csv', delimiter='|')
print(df1)

---

I am still not able to upload files (do not have five posts yet), so I am posting the sample CSV:

1|2|3|4
"A zasdff|B sdafasfd,as dfsadf""|C & D are here|D
More data|12, 124, 12|weird delimiters:'no way|stuff
12|><(yes|111|stuff and other stuff

What I need to have is a table/list that look like this:



Basically, it should ignore all characters other than "|" when creating each of the fields (theoretically the CSV field can have tabs, newlines, etc as well).

I would appreciate any help!

[buran]

theoretically the CSV field can have tabs, newlines, etc as well

are you sure about the newlines? If you have newline inside a field you will need to write own parser it still could be tricky

[lokhtar]

Hmm, well there actually might be. But I might be able to manually remove that if necessary prior to reading the file.