Reading a CSV file to pandas works in windows, not in ubuntu
Well, at then end I solved it by changing the explorer I was using to download the csv file with webdriver from Firefox to Chrome, not sure what´s the reason behind but maybe this will help if you have the same issue in the future
I have written some scrip in python using windows and want to run it in my raspberry with Ubuntu.
I am reading a csv file with line separator new line. When I load the df I use the following code:
dfaux = pd.read_csv(r'/home/ubuntu/Downloads/data.csv', sep=';') 
which loads a df with just one row. I have also tried including the argument  lineterminator = '\n\t' which throws this error message:
ValueError: Only length-1 line terminators supported
In windows I see the line breaks in the csv file, whereas when I open it with mousepad in ubuntu I don't see the line breakers, but I see the columns color coded.
How could I read properly the csv?
Thanks!