Export Data from R (csv , txt and other formats) | R Tutorial 1.6 | MarinStatsLectures
HTML-код
- Опубликовано: 23 авг 2024
- Export data out of R: How to Export Data out of R and Save in Various Formats: csv, tab-delimited, space-delimited. Find the Practice Dataset(DataToExport) and R Script: (bit.ly/2rOfgEJ); 👍🏼Best Statistics & R Programming Language Tutorials: ( goo.gl/4vDQzT )
►► Like to support us? You can Donate (bit.ly/2CWxnP2), Share our Videos, Leave us a Comment and Give us a Thumbs up! Either way We Thank You!
How to export data out of R and save in various formats such as csv, tab-delimited, space-delimited:
▶︎ In this R programming video tutorial, you will 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.
▶︎ In this tutorial, you will learn to use "sep" argument to specify the file format or separator for the values, “row.names” argument to include or exclude the row names.
◼︎ Table of Content:
0:00:34 Introducing the 'write. table' command for exporting data out of R.
0:00:39 How to access the help menu for a command in R
0:00:53 How to use the 'write.table' command in R Software
0:01:08 How to use "sep" argument to specify the file format or separator for the values in R
0:01:50 How to include or exclude the row names while exporting data out of R Programming software using 'row.names' argument
0:02:21 How to save file exported from R to a folder other than the current working directory:
0:03:01 How to use the "write.csv" command to export data from R (this will not require using "sep" argument as it is implied in the write.csv that we would like this to be saved as a comma separated value file)
0:03:22 a quick overview of "write.csv2" command that is used in Western Europe and would use a comma for a decimal point and a semicolon for a separator rather than a comma
0:03:33 How to use write.command in for saving in other file formats for example a tab delimited text file
These video tutorials are useful for anyone interested in learning data science and statistics with R programming language using RStudio.
► ► Watch More:
► Intro to Statistics Course: bit.ly/2SQOxDH
►Data Science with R bit.ly/1A1Pixc
►Getting Started with R (Series 1): bit.ly/2PkTneg
►Graphs and Descriptive Statistics in R (Series 2): bit.ly/2PkTneg
►Probability distributions in R (Series 3): bit.ly/2AT3wpI
►Bivariate analysis in R (Series 4): bit.ly/2SXvcRi
►Linear Regression in R (Series 5): bit.ly/1iytAtm
►ANOVA Concept and with R bit.ly/2zBwjgL
►Hypothesis Testing: bit.ly/2Ff3J9e
►Linear Regression Concept and with R Lectures bit.ly/2z8fXg1
Follow MarinStatsLectures
Subscribe: goo.gl/4vDQzT
website: statslectures.com
Facebook:goo.gl/qYQavS
Twitter:goo.gl/393AQG
Instagram: goo.gl/fdPiDn
Our Team:
Content Creator: Mike Marin (B.Sc., MSc.) Senior Instructor at UBC.
Producer and Creative Manager: Ladan Hamadani (B.Sc., BA., MPH)
These videos are created by #marinstatslectures to support some courses at The University of British Columbia (UBC) (#IntroductoryStatistics and #RVideoTutorials for Health Science Research), although we make all videos available to the everyone everywhere for free.
Thanks for watching! Have fun and remember that statistics is almost as beautiful as a unicorn!
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!
how to check the current working directory?
You are a hero of science, my friend.
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!
we think that's a great recommendation ;)
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.
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.
Thank you Martin, you are really doing a great job of explaining R
You are wizard of R. Simple and straightforward explanations. Really helpful. These videos saved my day :)
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!
thanks, we appreciate that!
Nice to see you back on this channel 👍
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 :)
Great. This is so self explanatory and help-full. Thanks
Excellent, "to the point" presentation! Thanks!
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!
you saved my life. good contents.
Great to see you back. Could you please make videos on advance machine learning in R? Thank you.
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.
That would be awesome if you teach us application of statistics in Epidemiology. I'm waiting to learn from your videos.
Awesome!!! I love the way you teach.
Your videos are so helpful! I want to thank you, and plz keep making these learning videos
thanks! we plan on continually making these videos :)
Thank you professor! That helps me
you are very good teacher
Thanks a lot for the series...
tks Marin for the excellent class! Hugs
thank you so much for this video.
you're welcome
Thanks very easy to understand!
Thanks a lot for this demonstration
Hi Mike, can you please tell me the code you used to save the data as the object 'DataToExport'?
Thanks very much. The best so far
you're welcome :)
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).
Thank you very much it is really helpful
thanks, so helpful !!
Very useful ! Thanks a lot
I love your videos! This video was super helpful.
Thanks!
@@marinstatlectures Have you considered doing python videos?
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.
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!
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
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.
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!
how do I export 100 files as a CSV format in a folder without writing scripts again and again?
Thanks!!!
😍 it was perfect
that helped a lot, THANK YOU!!!
you're welcome :)
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)
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!
May the lord bless you
Hi!
Do you know or have a tutorial about how I export a .csv file or table to a Sharepoint folder?
Thank you!
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.
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?
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.
*I used write.csv2 and it is solved.*
@@thegdt37 thanks
Can we export the data from R studio to a Web Application?
TYSM
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?
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
I am getting error: Error in is.data.frame(x) : object 'DataToExport' not found. How to resolve it?
You can watch mine. Playlists for Python and R provide most of the fundamentals, step by step tutorials with downloadable source files.
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 :)
thx sir🥰🥰
Is there a way to export graphs from R to Excel?
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!
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.
Hi there, you should be able to see the dataset (DataToExport) now (statslectures.com/r-scripts-datasets)
@@marinstatlectures I click the website and it shows Error 404.
@@runsenliu3226 correct one is statslectures.com/r-scripts-datasets
@@runsenliu3226 Mike you are a life saver in this tutorial. All your tutorials are simple and clear
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"
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
Why I am getting error "DataToExport" not found :/
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?
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
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?
Yes, it should be no problem to do so
I've clicked on both links in the description, and I can't find the Dataset "DatatoExport". I only see the R script
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
Thanks so much. I got it
i try it ! but i can't run its show me error in data frame
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
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.
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?
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).
@@marinstatlectures that is correct. It is a fitted model. What command can I use to export?
How to download directly to excel instead of CSV..bcos I need format..any expert pls explain
You can open a csv file in Excel
Donald Trump is -25.5 lol
glad to see someone caught that! and i must say, that score is still probably too high ;)
The score of Donald Trump is -25 hahahaha :DDDDD
On my PC I have to use \\ instead of /, why?
Windows uses \\ while Mac uses /
Package: Translations (dont know wich version)
how can i export data i XML file plz???
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
Hi Mike, the link - statslectures.com/r-stats-datasets is not working, please check. Thank you!
this was so unhelful tbh
Thanks!