I've exported a dataframe from R into a .csv file and then tried to open it in Tableau. What is the correct way to import these files? I've done connect to data source > to a file > text file then simply clicked on the csv.

However, the columns and rows are all mixed up and I'm not sure what's gone wrong as the files can open in Numbers and Excel just fine!

Please see the incorrectly imported data rem_posts.csv and correctly imported data kylie_posts.csv.

CodePudding user response：

Try using the Data Interpreter

Yo may also try using Tableu Prep , to do some cleanup

CodePudding user response：

It was an issue with some columns having string data with commas in it so it was messing up the import when using csv format. I resolved this by exporting it in excel instead.