How to export or save data or results from R into CSV and xlsx (Excel) format
HTML-код
- Опубликовано: 11 сен 2024
- It is pretty much easier importing data in R or R-studio than exporting data, DataFrame, results, objects etc from R and transforming it into xlsx (Excel) format. This video shows how to export data from R in csv format as well as transforming the csv file into xlsx or Excel file.
Please subscribe to my channel :
/ minukuututorials
French version of the video:
• Du logiciel R à l'Exce...
Other videos:
Quick statistical data summary using the Analysis ToolPak and pivot table:
• Quick statistical data...
Biostatistics - Grouping quantitative data into classes using Excel:
• Biostatistics - Groupi...
Statistical hypotheses testing procedure:
• Statistical hypotheses...
#MinukuuTutorials #exportdatafromr #R
Thank you! This was a big help with my thesis.
You're most welcome. I am glad it help. I wish you a successful graduation, Bro:)
Thank you so much!!!!! I almost cried when it worked, was trying it for hours until I found your tutorial!
Awesome!! Thank you very much for the feedback. I am glad it helped :)
Merci beaucoup monsieur 🌹🌹🌹🌹🌹
Je vous en prie. Je suis content que ce tutoriel vous ait aidé :)
Great work, clear and concise. Thanks for sharing.
You are most welcome. Thanks for watching:)
Your tutorial was so helpful for me, thank you🌷
Glad it was helpful! Thanks for the feedback:)
Thank you very much. It helps me a lot.
You’re most welcome :)
Tahnkyou So much God bless your knowledge 🥰
You are most welcome. I hope it worked. Thank you for watching:)
Very useful! Thank you.
You’re most welcome :)
Thank you Sir. You helped me a lot
You are most welcome. I am glad it helped :)
@@MinukuuTutorials do you know how i calcule "SOMME =" with many "feuille excel " .. when I did it, it came #VALEUR! in the box of the calcul
.. what should I do please?
@@haddaazharboukhris5517 Hi, if I have understood your question, you want to calculate sum in excel, right ? To do that, use the sum function :
=SUM(use your mouse to select the first cell+select the second cell+....)
and hit enter.
I don't understand where is the probleme, even if I open the file in R STUDIO I cant export THE RESULT TO THE same file :
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 'D:\Data\my dataset\spi': Permission denied
Hi, I don’t understand what you mean by you “can’t export the results to the same fine…”. Please check and make sure the your working directory is well set. Also make sure you turn all the “\” into “/“ in the code.
2023. Write the code in the console, allow it to correct for current version of R
Oh ok, I never knew that, thank you :)
When I write the code, this shows up:
Error: unexpected symbol in "write.table(PRCP_T, "C:/Users/annaf/Documents/PET.csv",sep="."row.names"
What should I do? :(
You probably might have made a mistake in writing the code. Could you please copy and paste the exact code that you wrote for me to see if there's any mistake?
@@MinukuuTutorials i figured out the problem, but thank you so much. Your videos are very helpful 🤩
@@annamarijafirere8040 Awesome! You're welcome and thanks for the positive feedback. Much appreciated:)
thank you so much for the video,but when I write the ode, this hows up write.table(OutputsCalib,"C:/Users/kasta/OneDrive/Desktop/resultat.csv ",sep=",",row.name=FALSE)
Error in as.data.frame.default(x[[i]], optional = TRUE, stringsAsFactors = stringsAsFactors) :
cannot coerce class ‘c("OutputsCalib", "HBAN")’ to a data.frame
can you help me plz, thanks
Hi, I don’t know what is causing this error, but I will search. If I find something I will let you know