Hi All,
I am building a wep-app with Flask, which has the goal to allow people to upload a .csv file which will then be modified by my code. To do so I put the content of the .csv into a pandas df. So far everything works perfectly fine if I specify the separator precisely, such as:
df = pd.read_csv(filename, sep=";")
In the meantime I have come to realize that Europe uses a ";" as separator, while in the US a "," is used. So I want to modify my code in a way that both kind of .csv files can be read. I modiefied my code as follows:
df = pd.read_csv(filename, sep=None, engine="python")
This works if I run it locally in the Python Shell on my computer, but doesnt work in pythonanywhere. Does anyone know how to fix this problem and how to make the code run again, allowing both kinds of input to be processed?
Thanks a lot!
Martin