Import Data, Copy Data from Excel to R CSV & TXT Files | R Tutorial 1.5 | MarinStatsLectures

Import Data, Copy Data from Excel (or other spreadsheets) to R: CSV & TXT Files with Free Practice Dataset: (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 Like! Either way We Thank You!
How to Import CSV data into R or How to Import TXT files into R from Excel or other spreadsheets using function in R
►How to import CSV data into R? We will be using "read.table" function to import comma separated data into R
► How to import txt data file into R? You will learn to use "read.delim" function to import the tab-delimited text file into R
► You will also learn to use "file.choose" argument for file location, "header" argument to let R know the data has headers or variable names and "sep" argument to let R know how the data values are separated.
►►Download the dataset here: statslectures....
►►Like to support us? You can Donate bit.ly/2CWxnP2 or Share the Videos!
►► Watch More:
► Intro to Statistics Course: bit.ly/2SQOxDH
►R Tutorials for Data Science 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 series bit.ly/2zBwjgL
►Linear Regression Concept and with R bit.ly/2z8fXg1
►Puppet Master of Statistics: bit.ly/2RDAAv4
►Hypothesis Testing: Concepts in Statistics bit.ly/2Ff3J9e
◼︎ Table of Content
0:00:17 What are the two main file types for saving a data file (CSV and TXT)
0:00:36 How to save an Excel file as a CSV file (comma-separated value)
0:01:10 How to open a CSV data file in Excel
0:01:20 How to open a CSV file in a text editor
0:01:36 How to import CSV file into R? using read.csv function
0:01:44 How to access the help menu for different commands/functions in R
0:02:04 How to specify file location for R? using file.choose argument on read.csv function
0:02:31 How to let R know our data has headers or variable names when importing the data into R? By using the “header” argument on read.csv function
0:03:22 How to import CSV file into R? using read.table function
0:03:38 How to specify the file location for the read.table function in R? using file.choose argument
0:03:46 How to specify how variables/columns are separated when importing data into R? the "sep" argument on read.table function will do that; for example if you don't specify that your data is comma separated, R ends up reading it all in as one variable
0:04:10 How to save a file in Excel as tab-delimited text (TXT) file
0:04:50 How to open a tab-delimited (.TXT) data file in a text editor
0:05:07 How to open a tab-delimited (.TXT) data file in excel
0:05:20 How to import tab-delimited (.TXT) data file into R? using read.delim function
0:05:44 How to specify the file path for read.delim function in R? using file.choose argument
0:06:06 How to import tab-delimited (.TXT) data file into R? using read.table function
0:06:23 How to specify that the data has headers or variable names when importing the data into R? using header argument on read.table function
This video is a tutorial for programming in R Statistical Software for beginners, using RStudio.
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!

[@marinstatlectures]

In this R video tutorial, you will learn step by step how to import CSV data file or TXT data file into R from Excel or other spreadsheets using different functions and arguments of R. For example, you will learn to use "read.table" and "read.delim" functions and "file.choose", "header" and "sep" arguments. All these and more will help you import your data into R very easily. For example, if you don't specify that your data is comma separated, R ends up reading it all as one variable so using (sep=",") will help avoid this issue. Make sure to Download the datasets for practice: statslectures.com/r-scripts-datasets and if you Like to support us, you can donate here bit.ly/2CWxnP2 or share our videos with others!

[@Jimmy_utsav]

Ok thank u👍

[@akashdeepdas7695]

When I input the data class always shows object not found pls help me

[@vamsi24791]

Trust me sir. After trying various various online tutorials and e-books, I am writing this review. These videos are the most amazing videos on R one could ever discover and it is almost impossible for anyone to not praise you for this awesome help you are doing to people who cannot afford to take courses. You will always be blessed for this help you are doing to thousands of people. I will make sure that all my friends in my college will watch these videos and get benefited. Thanks a ton again sir. Keep up the good work going. You are truly loved by all of us here who are on your page. Vamsi Krishna.

[@marinstatlectures]

Hi +vamsi24791 , thanks, we really appreciate you saying that! it's hearing things like this that help motivate us to keep producing these videos, so thank you for that!

[@marinstatlectures]

Thanks, glad to know you're finding them useful...we've put a lot of work into them. Thanks for watching ;-)

[@gimbulino]

Finally handy videos extremely helpful for a guy aged 58 wanting to fill the technological gap and for the first time ever seriously considering investin time and energy in R and progressevely make the transition from Excel

[@alfredkik3675]

Without having any background knowledge about r, I could analyze my data for MSc thesis really well by following your amazing videos. You high quality tutorials are really helpful, thank you very much.

[@marinstatlectures]

happy to hear that!

[@meganmeunier8698]

I know this video was posted years ago but I just wanted to say thank you! My professor at uni said that R was much better than excel once you got to grips with the coding language but unfortunately the uni only offers courses on using excel for data analysis. I'm so excited to start using these skills for writing papers and not having to deal with the whole messiness of excel.

[@fincharus5659]

Thank you a bunch been screaming at the PC for hours only to find the header= TRUE would fix all my class issues.

[@TheMadKaz]

Thank you for this!!! Spent 2 hours googling and getting irritated at all the patronising "help" blogs and the help sites full of computer jargon but finally cracked it.

[@marinstatlectures]

happy to help TheMadKaz

[@rabinkc831]

This is the first excel datasheet I ever read in R. After 7 years with R, I thought I would visit Marinstats....It was a great start. Thanks.

[@karag4487]

How good did you get in R?

[@vishnu8899]

Hey Mike,huge fan of your videos .Just for FYI the data sets you have attached has 725 obs.of 6 variables.(probably duplication of data)This is trivial information with no impact whatsoever on the steps to retrieve an excel file. First time viewers may be wondering about the large nature of the data set. Cheers

[@marinstatlectures]

Thanks. Glad to hear you’re enjoying them :)

[@borisjankovic8067]

Wow, high quality lectures, very thouroughly designed, covering everything, easily understood by beginners + free?! You have a new subscriber, keep making these!

[@naox1411]

all the things крипто-анархисты said plusTHANK YOUUU. WAS HELPFUL. keep doing this videos of R so i can learn more and MOORE

[@marinstatlectures]

Thanks крипто-анархисты and Lissette Rodriguez , we appreciate you saying that! and yes, our goal is to provide the best tutorials available online, and free! this summer we are hoping to create a series of videos teaching general statistical concepts, so keep your eyes out for those! thanks for the support!

[@1917cutlass]

Hello good sir! I would like to personally thank you on the behalf of graduate students everywhere, who are being introduced to R for the very first time. You are a life saver. Cheers sir!

[@marinstatlectures]

Thanks 1917cutlass , we really appreciate hearing you say that! We've put a lot of work into producing these, and happy to hear that they are having such an impact!

[@naseerbhat8267]

Thank you so much. For someone like me with zero programming/coding background, you gave me an eureka moment.

[@LL-hj8yh]

I've tried so hard finding why I couldn't input my csv data, since I just started R Studio. Thank you very much!!! Especially the first half part already solved my problem! Thanks!

[@marinstatlectures]

Hi Jianzhe Liu , glad to hear your problem is solved!

[@vitinho0610]

You're way more that a teacher! I'm really really grateful : D

[@autoai7966]

you are the father of my kids

[@hanatekletekle7121]

God bless you for simplifying this.

[@ShahidIqbal-sq7bf]

for someone like me you are an angel i struggled so much with it.

[@lukasiohan1289]

Thanks for sharing your knowledge with us!!!! The World needs more people like you. Greetings from Brazil.

[@marinstatlectures]

thanks +Lukas Iohan , we appreciate that!

[@marinstatlectures]

Hi ***** , you have your youtube settings set so that i can not reply to your comment, so i hope you see this message here. the reason that your data appears as one column is that you have not specified how variables are separated correctly. (e.g.) if the data is separated using commas: 5,15,female,smoke,... and you don't tell R that it is comma separated, using *sep=","*, the R ends up reading it all in as one variable...as it does not know what separates each of the variables/columns. so yo need to check how your data is separated, and make sure to specify that correctly. the problem with the rows, is most likely not a problem. the data viewer in RStudio only shows at most 1000 rows, so it is likely that all of the rows have been read in, but that RStudio only shows 1000 of them. you can type *dim(data)*, replacing data with the name you've given your data, so see the # of rows/columns in it, or look in the top-right corner of RStudio in the workspace, and it will show the name of the data, along with the number of observations and number of variables.

[@adrianapetrova196]

You make it so easy. Thanks, that's the second time I watch your videos. The first time I saw it all, after that I couldn't find anyone that explains like you do, I left it and I forgot it all. Now I'm back and you have even more videos :D

[@mukailarafiu2718]

May Allah bless you in abundance, you are a HERO for saving my life.

[@ramjielangovan6817]

most straight forward and easy approach thank you so much

[@wisdomandpeace2668]

Great instructions for a R Programming newbie.

[@marinstatlectures]

Thanks Wisdom and Peace !

[@aratoud5756]

best R tutorials on KZbin...

[@samr598]

Hi Marin, Most straight forward and easy approach Your lectures and teaching style have left me speechless. Thank you very much..!!

[@marinstatlectures]

great to hear, thanks!

[@Jaiston]

Thanks a lot for making such an amazing video. It was very easy. God bless you.

[@299redd]

Dude I want to thank you so much. You are helping me learn so much that my uni lecturers miss out

[@marinstatlectures]

great to hear +299redd , and you're welcome!

[@TOMH9227]

great video, I spend hours on importing basic matrices. This video explains it in 5 minutes

[@marinstatlectures]

Thanks Tom Hermans , glad to hear you're finding our videos useful! Thanks for watching!

[@ganjedalieva4528]

Thank you so much! Your tutorial helped me a lot. Once again THANK YOU!

[@Zhingkham]

Thanks....by far it is the best ..simple and effective....others kept on talking about getwd and setwd...which i found quite difficult...so it really helped...thank you marin

[@charlesturner6844]

Since the most current .csv file for this example has 726 rows (including headers), I had to run this corrected code: options(max.print = 20000) data1

[@treescully]

totally forgot how to do some of these simple things very quick and helpful video, thank you!

[@marinstatlectures]

You're very welcome treescully , thanks for watching!

[@ilangovanetambidore6431]

Congratulations to MarinStatsLectures Your presentation is very clear. The explanations are direct, very simple to use Thanks a lot From Paris Thursday 4 June 2020 15h26

[@MrAlivallo]

file.chose is pretty cool. *** but you can do this by doing to 'import dataset' icon ***; the benefit to this is that it loads the global variables and objects. It will allow you to set proper parameters on import such as Tab delimiter. and its a visual menu that ```{r} writes the code for you ```. you can copy/paste the code later. Now you can refer to the imported files by their 'file names' for all future needs.

[@user-rs7mi5fw5n]

very straightforward and helpful. Thank you

[@marinstatlectures]

Thank you +庞广来 !

[@kushalmiglani2691]

Best channel for R tutorials

[@marinstatlectures]

thanks +Kushal Miglani , we appreciate that!

[@sudhaashri2429]

i learn import excel file to r so easily thank u sir

[@marinstatlectures]

you're welcome

[@xavierharo5425]

This is just Excellent. After some traumatic experiences trying to learn to program, you made me have a bit of hope. You got a new subscriber!

[@marinstatlectures]

glad to hear you're finding them helpful Xavier Haro !

[@simonshrestha]

the first time I came across file.choose() and it is very helpful,

[@knowledgeisthepowerofhuman8966]

god bless you as you spread the knowledge for needy people god will enhance your courage and do more in depth of r

[@shahzaibkhoso2240]

I like the way you are teaching

[@kguadl]

Thanks a million for making R tutorials without JARGON!!!! Yay!!

[@marinstatlectures]

you're welcome +Kelly Lyons ! and i agree with you sentiment...while jargon is important in a discipline, it often only means something to one who already understands the concept...and gets in the way of learning for those who don't yet know the concept!

[@madelynnowak-roddy5121]

you are literally a grade saver. I'm so happy I found your channel. Thank you very very much :)

[@marinstatlectures]

Madelina Nowak-Roddy you're welcome, glad you've found our videos helpful!

[@husseinfadin3354]

love his channel so much, you helped me a lot, I was having a hard time using statistic with R, not a lot of courses about it,keep up the good work.

[@smrazaabidi1495]

Mike, You are awesome. Thanks buddy for such a succinct demonstration. Really plausible.

[@swatithakkar7221]

thanks a lot Mr. Marin , sir didnt get about comma(,)...actully i am a beginner in R.

[@kishorejaganccb]

+Swati Thakkar csv is coma separated values. whatever we hav it in excel sheet are nothing bt csv s.. saved in the extension .csv . so if we want to import those values in csv file to R as data frames we need to specify the separator in csv file which is nothing but ","

[@gabrielbarros6789]

Best tutorial ever, you certainly have a teaching soul... congrats. Wish you all the best.

[@marinstatlectures]

thanks +Gabriel Barros , appreciate that!

[@porchheng1320]

this is very helpful to me, thank you very much sir.

[@parthahs]

Thanks for explaining in the simplest way.I am looking for other videos for processing data. Best Regards Partha

[@marinstatlectures]

You're welcome Hassan Parthasarathy !

[@alexg4121]

one of the best tutorials I found on the subject. Thank you very much.

[@marinstatlectures]

thanks. and you're welcome :)

[@Preppster83]

You rock. Thank you for making this straightforward.

[@sanjeebkumar8539]

Hey Marin, You Rock.. You made easy to learn some thing diff from books..Kudos for your effort.. You are a grt faculty/Teacher..

[@marinstatlectures]

Thanks sanjeeb kumar ! Our goal was to provide the best resource for an intro to R on KZbin! We plan on making general stats educational videos as well, once we have the time, so keep your eyes out for those when we get to making them. thanks for your support!

[@Dyokoto]

Thank you very much. It is very helpful. This is what I have been looking for since most of my data are in Excel sheets.

[@marinstatlectures]

Thanks Dyokoto , glad to hear it has been helpful!

[@rochuka]

wonderful experience through your tuitorials

[@marinstatlectures]

Thanks +rodgers closec !

[@naox1411]

All the things крипто-анархисты said plusTHANK YOUUU. WAS HELPFUL. keep doing this videos of R so i can learn more and MOORE

[@TJ-gp6to]

Excellent! Thank you for all your great tutorials. I'm new to this and you keep it simple enough for beginners to understand. Much appreciated.

[@marinstatlectures]

You're welcome ***** , glad you find them useful!

[@juniorjunior1666]

Thanks for sharing it. That is a very informative video

[@gigiem2580]

THIS. IS. SO. HELPFUL.

[@pkhuntiable]

oh my god !!! these are best collection of R tutorials !!!

[@marinstatlectures]

thanks +puja khunti , e appreciate that!

[@griscellimarianne9769]

Thanks!! Great explanation!

[@ohnyx6015]

Thank you for sharing stuff of such quality for free . God bless!

[@marinstatlectures]

You're welcome Oh! Nyx

[@RAVIKUMAR-me3th]

you are good mentor love to learn from you

[@meganmccarthy3731]

THANK YOU. You are my savior.

[@marinstatlectures]

you're welcome +Megan McCarthy !

[@wenfangliu2421]

You made fabulous lectures. Thanks a lot.

[@marinstatlectures]

you're welcome +Wenfang Liu !

[@anukulburanapratheprat7483]

Really helpful. Thank you very much.

[@user-tl4jl7bg3i]

Thank you thank you! Your a life saver! Was struggling so much with my stats assignment but now I finally understand it!

[@ibee244]

you are a life saver! thank you for these videos, you cover so many commands and make it so simple and easy to follow. thank you thank you.

[@marinstatlectures]

You're welcome +I Bee !

[@fanish10]

Thank you so much!! Great tutorial. I have been struggling for hours

[@marinstatlectures]

You're welcome Isha Sookharee , glad you found it helpful!

[@swatimandavawalla1265]

Thank u so much Wonderful I can learn r software Small such vedio help to learn faster Thank u

[@mikorees5853]

Thanks Mike. Your video really makes my life simple!

[@marinstatlectures]

good to hear :)

[@tinhoan3556]

very good, great, awesome, excellent Video!

[@ako1489]

very useful) and very good sound! thanks

[@randaburaideh4905]

Thank you for saving my time !

[@resilientprogrammer8466]

Thanks so much. I learned a lot

[@zahrahosseini9523]

Thank you very clear explanation I do not know nothing about R programming analysis but that’s helps me to get knack of it. Btw how can I bring workplace sheet? I don’t have (can’t see) the right window in front.

[@mididoddi]

Great job with the videos Mike! There are only few things in this world for which you can say "Can't make it better".

[@shainishadevi1907]

Amazing channel! Really useful!

[@kumarsvc]

Nice illustration, thanks Marin for keeping it very simple.

[@marinstatlectures]

You're welcome vs123 !

[@hectormercedes6553]

hello friend, very important video. thaks

[@MichaelSmith-zm5qi]

Thank you! These videos are awesome!

[@marinstatlectures]

you're welcome :)

[@olsjonbaxhija6720]

I love these! Thank you for making them freely available. You got yourself a new subscriber.

[@marinstatlectures]

You're welcome Olsjon Baxhija !

[@SolidSnake_95]

Sir, your lectures are awesome and i am stunned by the amount of effort you are putting it in.I am for electronics and communication engineering and thinking of making my career into data analytics and i founded these videos very helpful..Thank you so much sir..!! And what tips would you like to give regarding to make career in analytics and what should i do more in respect to this field..??Your help will be so much appreciated..!!

[@marinstatlectures]

it really depends on what area you want to go into. as a general statement, the more programming (and programming languages) you know, the better. learning something like "Python" is a good next step....that would definitely improve your marketability.

[@swathiganji2542]

one of the best tutorials I have ever watched..Thank you very much.. Just wanted to check if you told any decision tree videos using R...

[@marinstatlectures]

thanks +swathi ganji , we appreciate that! we haven't prepared anything for decision trees yet.

[@scottstrange8809]

Thank You! No other way worked on importing CSV files I needed

[@marinstatlectures]

No problem Scott Strange , happy to hear it was useful for you!

[@nstar0203]

Awesome and very useful. I subscribed to your channel! The command you introduced to open a data file directly into R was great! Thank you!

[@marinstatlectures]

you're welcome +Nd_1115773

[@jasleenchadha4659]

Hi, You really are doing absolutely wonderful. Your way of explaining things is very interesting and most of the times very easy. I know I would be contradicting my statement however I am unable to understand everything you say. I am not from a technical background and find it difficult to understand most of the times and have to google and check other sources. Could you please suggest me what to do to understand R and learn it efficiently , that would really help. I am looking forward to build a career in data analytics and know a little bit of SQL. Also if you could tell me the pre-requisites to learn R. Thanks a ton.

[@marinstatlectures]

Thanks +Jasleen Chadha ! it's hard to suggest "what to do to learn R". there are a ton of resources out there, and it depends a lot on what your background is, what other programming languages you may know, etc, etc. i would say to search through resources, and find ones that you like. the way i learned it was through courses i took and working on research, and learning things as i needed to. it's also difficult to say that the "pre-requisites" for R are.having some background in programming in any language will help, as the underlying concepts of programming is generally the same, and it's just a matter of learning new syntax, and a few nuances about how a particular software works. im sorry i cant provide something more specific, but R really is a huge tool, with nearly unlimited possibilities...and it really depends a lot on the specifics...

[@camardi1234]

Helped so much!!! thanks bro

[@anitamcdowell9702]

Very helpful! Thank you, Mike and Ladan.

[@TimevalueVideos]

Oh, I will be using this a lot!

[@marinstatlectures]

good to hear +TimevalueVideos !

[@sebui2471]

than you ! from france

[@statisticstime4734]

Excellent! It is very useful.

[@milenaoliveira2626]

Wow!!!!! Amazing help. God bless you!

[@bhattaraimanish4957]

Great Tutorials..found really informative to get grounds in R to solve some optimization problems

[@marinstatlectures]

Thanks Bhattarai Manish , happy to hear you found them useful!

[@alexanderwoods5610]

Hey this video was amazingly helpful!!!!! You made R much less intimidating! Thank you!!!!!

[@marinstatlectures]

You're welcome Alexander Woods , glad you found it useful!

[@abrahammusembi6762]

Good one too. wish you can also do a full combined tutorial for R. kindly

[@matthewott7878]

Very, very helpful - thank you MarinStatsLectures!

[@marinstatlectures]

You're welcome Matthew Ott , glad you found them helpful!

[@yosraaleahmad9760]

it was really useful

[@marinstatlectures]

great to hear!

[@gwizamaryse9363]

Thank you, very easy to understand.

[@medouneineneine991]

Dankeschön , Thank you so much for your Videos form germany

[@happymindedness5326]

significantly useful