Skip to main content

Hi,

 

I am currently using the Machine Learning Platform on Celonis to read a csv file using pd.read_csv which has been working perfectly until I had to update it with a new csv file. 

 

There's a weird problem where, when I read_csv the file in the Jupyter environment all the data is thrown into one column. It's even more odd because if I view the csv file directly on Excel or by opening it on another tab in Celonis Machine Learning, all the data seems to be formatted correctly into a table.

 

So, I'm not sure why it's suddenly reading everything into one column.

 

Thanks,

Terence

Maybe the new csv file has a different delimiter than the previous file and you need to specify what that delimiter is in the pd.read_csv() function?

 

See here: https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html


Reply