Export Data from R (csv , txt and other formats) | R Tutorial 1.6 | MarinStatsLectures

[@marinstatlectures]

In this R stats video, we learn to use various R functions such as "write.table", "write.csv", "write.csv2", “write.command” and "write.delim" to export data out of R and save in various formats such as csv, tab-delimited, space-delimited. Make sure to practice with the free Dataset(‘DataToExport’) and R Script here: (bit.ly/2rOfgEJ); ) If Like to support us you can Donate (bit.ly/2CWxnP2), Share our Videos, Leave us a Comment, Give us a Like 👍🏼 or write us a review! Either way We Thank You!

[@atifdai313]

how to check the current working directory?

[@ParanoidMarvinMk2]

I recommend this series as THE go-to intro reference for undergrads learning R. I still use it as a reference myself sometimes. Keep up the good work!

[@marinstatlectures]

we think that's a great recommendation ;)

[@khramterl]

You are a hero of science, my friend.

[@katomoon6170]

Many thanks. Your students are very previliged and lucky to have you as their professor. You are such a wonderful instructor capable of making complex topics so easy to understand. God bless you and your entire team behind these videos including your little son whose voice appears at the end of some of stats /R these videos.

[@sartiw]

Hi Marins, Hello from Brazil. This is my second try to lerning R. You are the best teacher I ever seen. Thanks for the classes.

[@crazystats1413]

Thank you Martin, you are really doing a great job of explaining R

[@yaseminozturk5863]

You are wizard of R. Simple and straightforward explanations. Really helpful. These videos saved my day :)

[@izabelaedmunds9746]

Nice to see you back on this channel 👍

[@marinstatlectures]

thanks, things got quite busy in our lives for the past couple of years, but we're gearing up to create a bunch of new videos over the coming months :)

[@deepandharmaraj4513]

Hi Mike your tutorials are absolutely fantastic and very easy to follow superb work please keep posting tutorials on R! Thank you so much for producing excellent R video tutorials!

[@marinstatlectures]

thanks, we appreciate that!

[@umaralhajiabubakar4869]

Great. This is so self explanatory and help-full. Thanks

[@bliksum58]

Awesome!!! I love the way you teach.

[@sokielevel1]

you saved my life. good contents.

[@charleshenderson4373]

Excellent, "to the point" presentation! Thanks!

[@marinstatlectures]

thanks, appreciate that Charles! we try our best to pack as much info into as little time as possible, while keeping it easily digestible and not feeling like a cognitive overload!

[@luizguilhermedefreitasbord5802]

Thank you professor! That helps me

[@sibusisomani1746]

Thanks a lot for this demonstration

[@kalpeshyajnik]

I am getting error: Error in is.data.frame(x) : object 'DataToExport' not found. How to resolve it?

[@easydatascience2508]

You can watch mine. Playlists for Python and R provide most of the fundamentals, step by step tutorials with downloadable source files.

[@flamboyantperson5936]

Great to see you back. Could you please make videos on advance machine learning in R? Thank you.

[@marinstatlectures]

thanks, we will likely get there at some point, but for the time being we are more focussed on introductory and intermediate methods, and we also have a bit of a focus on applications of stats in Epidemiology, as i teach biostatistics in the school of population and public health at UBC, and so a lot of what we create is relevant to the courses I'm teaching here.

[@flamboyantperson5936]

That would be awesome if you teach us application of statistics in Epidemiology. I'm waiting to learn from your videos.

[@sophieroux2063]

Hi Mike, can you please tell me the code you used to save the data as the object 'DataToExport'?

[@Sina69devil]

Your videos are so helpful! I want to thank you, and plz keep making these learning videos

[@marinstatlectures]

thanks! we plan on continually making these videos :)

[@sangeethab3652]

Thanks a lot for the series...

[@MitaTRAN]

I have .txt file, I dont know how to export file .bed or .bedGraph? Could you nice help me how to do? Thank you very much!

[@infinitecosmos]

you are very good teacher

[@romerootavio368]

tks Marin for the excellent class! Hugs

[@Ommbye]

Thanks very easy to understand!

[@magnetar2i]

Cool, very nice and to the point, I wasted half hour trying to do it using websites and blogs, they all overcomplicated things, this is so much easier, R is easy if some wankers don't try to make it look difficult (ps. sorry that I said it like that).

[@puspitalestarikhanna8582]

thanks, so helpful !!

[@swastikaputri]

i have a data imported using GetSymbols (quantmod), and tried to export it in excel sheet. Yet, using write.table command, the date column is left out. Please suggest what best to do.. thank you!

[@Ninenine3]

Very useful ! Thanks a lot

[@chiragsharma4606]

how do I export 100 files as a CSV format in a folder without writing scripts again and again?

[@nisarbaig3050]

thank you so much for this video.

[@marinstatlectures]

you're welcome

[@MsRSecon]

Thank you for the video . Have you done or can you do a video on how to consolidate data set using different sources . Thank you

[@cindyelizabethchavarriamin7999]

I love your videos! This video was super helpful.

[@marinstatlectures]

Thanks!

[@cindyelizabethchavarriamin7999]

@@marinstatlectures Have you considered doing python videos?

[@ravikrishnarpan]

Can we export the data from R studio to a Web Application?

[@tharushanonis8046]

Thank you very much it is really helpful

[@amatwumwaaacheampong3227]

Thanks very much. The best so far

[@marinstatlectures]

you're welcome :)

[@Aviseniamarina]

Thank you for the informative tutorial. I have a small question, how to export an r object which contains data in tibble format to csv file. and also how to convert tibble to normal data.frame object. Thank you so much for your help.

[@macramalho]

Hi! Do you know or have a tutorial about how I export a .csv file or table to a Sharepoint folder? Thank you!

[@infamousprince88]

Is there a way to export graphs from R to Excel?

[@myworld6303]

😍 it was perfect

[@roiad876]

Hello thanks for the tutorial, do you know the best way to export data produced with lavaan? I created a df with the summary of cfa but it came up all wrangled up, no headers or nothing.

[@user-bf6sk3gu5u]

Is there a convenient way to open the exported file automatically from an R script? (Equivalent to double clicking the file and having it open in excel, etc)

[@thegdt37]

Hello Mike, When I export my data as .csv and open it in Excel, all data are fit in only one column and data in the same row are seperated by commas. How can I solve this problem? Thanks for the videos by the way.

[@thegdt37]

*I used write.csv2 and it is solved.*

[@exelyugure]

@@thegdt37 thanks

[@runsenliu3226]

Hi, in order to export data, there should be data in advance. But I can only see the code in the link and where is the data? Thanks.

[@marinstatlectures]

Hi there, you should be able to see the dataset (DataToExport) now (statslectures.com/r-scripts-datasets)

[@runsenliu3226]

@@marinstatlectures I click the website and it shows Error 404.

[@shahabuddin1559]

@@runsenliu3226 correct one is statslectures.com/r-scripts-datasets

[@cyrilatung8467]

@@runsenliu3226 Mike you are a life saver in this tutorial. All your tutorials are simple and clear

[@alexisjose7515]

Hi Marin, I'd like calculate the odds radio with library "finalfit", buy I can't open my data set, which is .sav (spss file). Do you now a form to open this file and calculate the odds radio?, please. Thank you

[@sia_ibk]

I exported data using the write.csv function, but the table gets truncated. The original table has 4,073,561 rows, but the csv file has about 700,000 rows. Please how do I rectify this?

[@lucasguidi]

Hello, I'm trying to export a table by Power Query using R, I tried the following code # 'dataset' has input data for this script write.table (dataset, file = paste0 ("C: / Users / Acer / OneDrive / ALLPARTS / VIN_", Sys.time (), ".csv")) I want to save it with the date so I don't overlap my files, can you help me? Do you have another suggestion? I wanted a date format that was yyyymmdd. It's possible? Thank's for your time!

[@wardahmustahsan888]

What if it's a large amount of data with max.print = 100,000. The reason I am asking is sometimes at the end of data you may get omitted ### entries. If I try sink it gives the same output the consel gives not the complete output. How do I fix that?

[@magdalenaa99]

that helped a lot, THANK YOU!!!

[@marinstatlectures]

you're welcome :)

[@chrisbrook3480]

how do you set the name of the file as data from a variable e.g. creating the file in a for loop (so it wouldn't be overwritten when the next file is created) thanks in advance :)

[@aishwaryawalkar5950]

Why I am getting error "DataToExport" not found :/

[@divyamehra2708]

i try it ! but i can't run its show me error in data frame

[@gehadmohamed9751]

thx sir🥰🥰

[@alexrika5692]

Hey, you create a CSV file but how does it show in an Excel file on each column. I do that then i get a file where the rows contain the data separated by ",". Can you help me?

[@marinstatlectures]

Hi, either click on the file and use “open with”, and then select Excel. Or, go into Excel, then under file select to “open” a file, and then select the csv file there

[@yadunandanacharya8951]

Like these can you please send Python for Data science, because of this channel I'am getting confidence to study Data Science, thank you so much sir.

[@marinstatlectures]

Hi, at the moment we dont have plans to create videos for Python. we have too much to cover with R and with general statistics concepts. glad to hear that youre finding our videos useful!

[@jarena009]

The 2nd step where you attempt to set row.names = f does not work. It produces an error message "Error in isTRUE(row.names) : object 'f' not found"

[@marinstatlectures]

It needs to be either F or FALSE , R is case-sensitive, and so it doesn’t recognize a lower-case f as meaning false

[@Pontiakos]

Help, when I do this I get the following error: Error in as.data.frame.default(x[[i]], optional = TRUE, stringsAsFactors = stringsAsFactors) : cannot coerce class ""summary.multinom"" to a data.frame. What can I do to correct the error?

[@marinstatlectures]

Hi, it is hard to tell without knowing the code you've used, and what you're trying to export, etc... but the error message suggests that you are trying to export the "summary" from a fitted model...and this won't work. the write.table is to export something that is saved as a data frame (or in a matrix format).

[@Pontiakos]

@@marinstatlectures that is correct. It is a fitted model. What command can I use to export?

[@lalitjoshi97]

If I have to export a table into CSV format, which I've just imported from some Database, using R, will I be able to do so?

[@marinstatlectures]

Yes, it should be no problem to do so

[@aklepatzky]

On my PC I have to use \\ instead of /, why?

[@marinstatlectures]

Windows uses \\ while Mac uses /

[@anandanmremo]

How to download directly to excel instead of CSV..bcos I need format..any expert pls explain

[@marinstatlectures]

You can open a csv file in Excel

[@Bromoteknada]

Thanks!!!

[@markk364]

Great video - thank you. For me - the write.table command is returning errors - can anyone help please? write.table(datatoexport, file="ExportedLundDataExample.csv", sep=",") 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 'ExportedLundDataExample.csv': Permission denied

[@prabpharm07]

for file argument, supply the "complete directory path" (e.g. file="D:/PrabhakarP/LungCapData.csv"), not just the name of the file, how would R know where that file is stored in your computer. Also, note the use of \ instead of / while writing the directory path.

[@Damadedatos]

May the lord bless you

[@tamikabrown1409]

I've clicked on both links in the description, and I can't find the Dataset "DatatoExport". I only see the R script

[@marinstatlectures]

Hello there, thanks for letting us know!It is fixed now, you should be able to find the dataset now statslectures.com/r-scripts-datasets

[@tamikabrown1409]

Thanks so much. I got it

[@aminabahri7638]

how can i export data i XML file plz???

[@marinstatlectures]

Hi, very similar to what is shown ins this video, except use *write.xml*. you can see here for more: www.rdocumentation.org/packages/kulife/versions/0.1-14/topics/write.xml

[@Joe8172yeaaaa]

TYSM

[@juandiegomunozprieto1224]

Package: Translations (dont know wich version)

[@prabpharm07]

Hi Mike, the link - statslectures.com/r-stats-datasets is not working, please check. Thank you!

[@slumdogskillionaire923]

The score of Donald Trump is -25 hahahaha :DDDDD

[@naomisatam1519]

Donald Trump is -25.5 lol

[@marinstatlectures]

glad to see someone caught that! and i must say, that score is still probably too high ;)

[@chrysenthenum2]

this was so unhelful tbh

[@prfgee8788]

Thanks!