Problem :
I wanted to read all the csv files from my folder and after that concatenate them to create a big csv file. The structure of all my files was the same, After concatenating I want to save it and read it again. All this was done by me using Pandas. But I am facing the Error while reading.
Below is my csv reader code :-
import csv
with open("C:\mywork\DATA\Raw_data\\store.csv",'rb') as csv:
csvreader = csv. csvreader (csv)
l = list(csvreader)
My Error:-
Error Traceback (most recent call last)
<ipython-input-36-9249469f31a6> in <module>()
1 with open('C:\ mywork \DATA\Raw_data\\store.csv', 'rb') as csv:
2 csvreader = csv. csvreader (csv)
----> 3 l = list(csvreader)
Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?