Opening a csv file

[Oliviermoonen]

I’m having a lot of trouble opening a certain csv file. I have to do this for my study and everyone else seems to be able to open it fine but mine doesn’t for some reason.
There are supposed to be two rows; var1 and var2. However, the file is opened as one row and this messes up the plot I’m supposed to make. Does anyone know how to fix this?

[jrkrideau]

Without some sample data, this is just a guess but it seems likely that you may need to specify the separator between the 2 columns of data.

Probably the easiest way to check this is to open the file in a text editor and see if the fire is using an unusual separater.

As examples of different separators
Comma

dat1 <-   read.csv("mydata.csv", sep = ",")

Tab

dat1 <-   read.csv("mydata.csv", sep = "\t")

Semi-colon

dat1 <-   read.csv("mydata.csv", sep = ";")

[Oliviermoonen]

This is the CSV file I'm working with. I tried the different separators but they all rendered the same result

[Oliviermoonen]

The Image below is the lines I have used on the file a1_data1, and the result of plotting is is on the right while it should be a concave spread instead of a straight line

[jlugarrancho]

Hi Olivier,

First, welcome to R Studio Community forums.

I suggest you to use the import dataset tool in the menu. You can click in the upper left menu File > Import Dataset > From Text (Base) and select the file to import it. Then you can copy the code that appears in the R console with the code required for import the data in .csv and then copy it in your script in order to have a more reproducible script.

Hope it helps.

Greetings.

[Oliviermoonen]

Thank you! This helped a lot in finding what was wrong with the excel file!

Kind regards,
Olivier

[Oliviermoonen]

The solution was that there were too many quotation marks in the file which messed it up in Rstudio. I removed them and the data became clear in R immediately.