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

[@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👍

[@akashdeepdas69]

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 ;-)

[@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.

[@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

[@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?

[@fincharus5659]

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

[@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!

[@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

[@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!

[@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!

[@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

[@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!

[@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!

[@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!

[@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!

[@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 !

[@ShahidIqbal-sq7bf]

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

[@gabrielbarros6789]

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

[@marinstatlectures]

thanks +Gabriel Barros , appreciate that!

[@pkhuntiable]

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

[@marinstatlectures]

thanks +puja khunti , e appreciate that!

[@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

[@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 :)

[@alexg4121]

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

[@marinstatlectures]

thanks. and you're welcome :)

[@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!

[@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

[@ramjielangovan6817]

most straight forward and easy approach thank you so much

[@kushalmiglani2691]

Best channel for R tutorials

[@marinstatlectures]

thanks +Kushal Miglani , we appreciate that!

[@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

[@olsjonbaxhija6720]

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

[@marinstatlectures]

You're welcome Olsjon Baxhija !

[@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.

[@aratoud5756]

best R tutorials on KZbin...

[@smrazaabidi1495]

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

[@gigiem2580]

THIS. IS. SO. HELPFUL.

[@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 !

[@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!

[@kumarsvc]

Nice illustration, thanks Marin for keeping it very simple.

[@marinstatlectures]

You're welcome vs123 !

[@Jaiston]

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

[@wisdomandpeace2668]

Great instructions for a R Programming newbie.

[@marinstatlectures]

Thanks Wisdom and Peace !

[@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!

[@hanatekletekle7121]

God bless you for simplifying this.

[@knowledgeisthepowerofhuman8966]

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

[@ganjedalieva4528]

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

[@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 !

[@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!

[@mukailarafiu2718]

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

[@nicolasbalmaceda9155]

very helpful! the best explained tutorials i've seen yet on R in youtube.

[@marinstatlectures]

Thanks +Nicolas Balmaceda we appreciate that!

[@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".

[@fanish10]

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

[@marinstatlectures]

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

[@user-tl4jl7bg3i]

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

[@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!

[@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 ","

[@mikorees5853]

Thanks Mike. Your video really makes my life simple!

[@marinstatlectures]

good to hear :)

[@庞广来]

very straightforward and helpful. Thank you

[@marinstatlectures]

Thank you +庞广来 !

[@wenfangliu2421]

You made fabulous lectures. Thanks a lot.

[@marinstatlectures]

you're welcome +Wenfang Liu !

[@mpgrewal00]

Very good work Marin.. thanks for this wonderful series.

[@marinstatlectures]

you're welcome +mpgrewal00 !

[@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!

[@Preppster83]

You rock. Thank you for making this straightforward.

[@rochuka]

wonderful experience through your tuitorials

[@marinstatlectures]

Thanks +rodgers closec !

[@shahzaibkhoso2240]

I like the way you are teaching

[@sudhaashri2429]

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

[@marinstatlectures]

you're welcome

[@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!

[@matthewott7878]

Very, very helpful - thank you MarinStatsLectures!

[@marinstatlectures]

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

[@anitamcdowell9702]

Very helpful! Thank you, Mike and Ladan.

[@ohnyx6015]

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

[@marinstatlectures]

You're welcome Oh! Nyx

[@naox1411]

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

[@simonshrestha]

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

[@gwizamaryse9363]

Thank you, very easy to understand.

[@griscellimarianne9769]

Thanks!! Great explanation!

[@shainishadevi1907]

Amazing channel! Really useful!

[@porchheng1320]

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

[@milenaoliveira2626]

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

[@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.

[@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.

[@juniorjunior1666]

Thanks for sharing it. That is a very informative video

[@Dr_RishiGanesan]

Amazing work Marin.. Loving it :)

[@marinstatlectures]

thanks +Saptharishi L G , we appreciate you saying that!

[@lamiyamammadova8179]

Thanks a lot! You explained everything so easily!

[@MichaelSmith-zm5qi]

Thank you! These videos are awesome!

[@marinstatlectures]

you're welcome :)

[@meganmccarthy3731]

THANK YOU. You are my savior.

[@marinstatlectures]

you're welcome +Megan McCarthy !

[@JoysiUSSR]

thanks for your videos (I use it for self-study). Especially for subtitles (my level of English basic only)!

[@marinstatlectures]

You're very welcome Marat Sadykov! We've tried to make them accessible to as many people as possible, so its very encouraging to hear your comment, thanks!

[@RAVIKUMAR-me3th]

you are good mentor love to learn from you

[@s0obinxp]

Very helpful video for my stats class. Thank you!! Subscribed :)

[@marinstatlectures]

You're welcome, glad you're finding them useful!

[@ako1489]

very useful) and very good sound! thanks

[@Saqlain7861]

very good lectures, thank you. and beautiful desktop background picture :)

[@anukulburanapratheprat7483]

Really helpful. Thank you very much.

[@abrahammusembi6762]

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

[@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.

[@JackTGreat]

Excellent Lecture Series, thank you!

[@marinstatlectures]

Thanks JackTGreat !

[@BolasDaGrk]

Marin, you are awesome!

[@marinstatlectures]

thanks :)

[@tinhoan3556]

very good, great, awesome, excellent Video!

[@junhotan2096]

amazing person doing stunning thing, what a man

[@camardi1234]

Helped so much!!! thanks bro

[@swatimandavawalla1265]

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

[@hkiranabc]

Hey this video and you rocks. Thank you for providing such a valuable information. will be great full to you

[@marinstatlectures]

Thanks Kiran H ! We've put a lot of work into them, and appreciate hearing this!

[@zacharysegal8212]

I found this very helpful, thanks for posting this.

[@resilientprogrammer8466]

Thanks so much. I learned a lot

[@randaburaideh4905]

Thank you for saving my time !

[@statisticstime4734]

Excellent! It is very useful.