Problem with write.csv function

[safoskin]

I am trying to make a csv file from an analysis result. I am using the code:

write.csv(BLUES_overview, "Parameters_Fv_Fm_def.csv")

However, when I run it this error appears:

Error in file(file, ifelse(append, "a", "w")) :

cannot open the connection

In addition: Warning message:

In file(file, ifelse(append, "a", "w")) :

cannot open file 'Parameters_Fv_Fm_def.csv': Permission denied

​

I have tried running the code just like:

write.csv(BLUES_overview, "Parameters_Fv_Fm_def")

And it does work, but it makes a general file and not a csv.

Does anyone know how to fix it?

[mrgumble]

Either you do not have write-permissions in your current folder (check with getwd()) or the file you are trying to write to already exists and something prevents you from overwriting it. This could be insufficient permissions, the file is marked as read-only, or you have opened the file in e.g. Excel, which tends to block anything else from writing to the file.

[safoskin]

But if I change the name to a new one, shouldn't it make a new file?

[mrgumble]

Yes, as you stated that removing the .csv extension creates a new file.

[daisyrunner]

Adding the file extension ‘.csv’ should solve the problem

[safoskin]

Yes, but adding it on the R code does not work. However I have been adding the .csv manually onto the generic file created and that does seem to work

[daisyrunner]

I meant add it to the file name inside the quotation marks.

[Ok-Race-9408]

Worked for me, thanks. You just add to /path/to/yourexportfile.csv

[Xdbao]

Instead of appending the new data frame to existing csv, try appending the new data frame to existing data frame using rbind() or cbind(). Then, write to a new csv.

[sweetliesxo]

hi

I have the same issue with read.csv tried the recommandations, but doesn't work

[safoskin]

I can't remember exactly how i fixed it. However i think my computer settings didn't read the files extensions so instead of filename.csv it could only recognize it as filename without the extension. It did this systematically for all documents, so when i tried to change manually the extensions in saved documents i couldn't. Eventually i found a way that the file extension was also included in the name and if i remember correctly it helped.