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
5 жыл бұрын
Ok thank u👍
@akashdeepdas7695
3 жыл бұрын
When I input the data class always shows object not found pls help me
@vamsi24791
8 жыл бұрын
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
8 жыл бұрын
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
11 жыл бұрын
Thanks, glad to know you're finding them useful...we've put a lot of work into them. Thanks for watching ;-)
@gimbulino
19 күн бұрын
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
@meganmeunier8698
3 жыл бұрын
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.
@alfredkik3675
5 жыл бұрын
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
5 жыл бұрын
happy to hear that!
@fincharus5659
3 жыл бұрын
Thank you a bunch been screaming at the PC for hours only to find the header= TRUE would fix all my class issues.
@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
7 ай бұрын
How good did you get in R?
@TheMadKaz
9 жыл бұрын
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
9 жыл бұрын
happy to help TheMadKaz
@borisjankovic8067
9 жыл бұрын
Wow, high quality lectures, very thouroughly designed, covering everything, easily understood by beginners + free?! You have a new subscriber, keep making these!
@naox1411
9 жыл бұрын
all the things крипто-анархисты said plusTHANK YOUUU. WAS HELPFUL. keep doing this videos of R so i can learn more and MOORE
@marinstatlectures
9 жыл бұрын
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!
@vitinho0610
9 жыл бұрын
You're way more that a teacher! I'm really really grateful : D
@autoai7966
4 жыл бұрын
you are the father of my kids
@1917cutlass
9 жыл бұрын
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
9 жыл бұрын
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
3 жыл бұрын
Thank you so much. For someone like me with zero programming/coding background, you gave me an eureka moment.
@adrianapetrova196
4 жыл бұрын
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
@LL-hj8yh
9 жыл бұрын
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
9 жыл бұрын
Hi Jianzhe Liu , glad to hear your problem is solved!
@lukasiohan1289
7 жыл бұрын
Thanks for sharing your knowledge with us!!!! The World needs more people like you. Greetings from Brazil.
@marinstatlectures
7 жыл бұрын
thanks +Lukas Iohan , we appreciate that!
@marinstatlectures
9 жыл бұрын
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.
@vishnu8899
2 жыл бұрын
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
2 жыл бұрын
Thanks. Glad to hear you’re enjoying them :)
@aratoud5756
9 жыл бұрын
best R tutorials on KZitem...
@hanatekletekle7121
3 жыл бұрын
God bless you for simplifying this.
@ramjielangovan6817
5 жыл бұрын
most straight forward and easy approach thank you so much
@mukailarafiu2718
4 жыл бұрын
May Allah bless you in abundance, you are a HERO for saving my life.
@husseinfadin3354
4 жыл бұрын
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.
@samr598
4 жыл бұрын
Hi Marin, Most straight forward and easy approach Your lectures and teaching style have left me speechless. Thank you very much..!!
@marinstatlectures
4 жыл бұрын
great to hear, thanks!
@Preppster83
6 жыл бұрын
You rock. Thank you for making this straightforward.
@ilangovanetambidore6431
4 жыл бұрын
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
@xavierharo5425
9 жыл бұрын
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
9 жыл бұрын
glad to hear you're finding them helpful Xavier Haro !
@ShahidIqbal-sq7bf
6 жыл бұрын
for someone like me you are an angel i struggled so much with it.
@madelynnowak-roddy5121
9 жыл бұрын
you are literally a grade saver. I'm so happy I found your channel. Thank you very very much :)
@marinstatlectures
9 жыл бұрын
Madelina Nowak-Roddy you're welcome, glad you've found our videos helpful!
@smrazaabidi1495
6 жыл бұрын
Mike, You are awesome. Thanks buddy for such a succinct demonstration. Really plausible.
@TOMH9227
10 жыл бұрын
great video, I spend hours on importing basic matrices. This video explains it in 5 minutes
@marinstatlectures
10 жыл бұрын
Thanks Tom Hermans , glad to hear you're finding our videos useful! Thanks for watching!
@TJ-gp6to
9 жыл бұрын
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
9 жыл бұрын
You're welcome ***** , glad you find them useful!
@charlesturner6844
3 ай бұрын
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
@kushalmiglani2691
8 жыл бұрын
Best channel for R tutorials
@marinstatlectures
8 жыл бұрын
thanks +Kushal Miglani , we appreciate that!
@Zhingkham
6 жыл бұрын
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
@MrAlivallo
5 жыл бұрын
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.
@wisdomandpeace2668
10 жыл бұрын
Great instructions for a R Programming newbie.
@marinstatlectures
10 жыл бұрын
Thanks Wisdom and Peace !
@ganjedalieva4528
2 жыл бұрын
Thank you so much! Your tutorial helped me a lot. Once again THANK YOU!
@gabrielbarros6789
7 жыл бұрын
Best tutorial ever, you certainly have a teaching soul... congrats. Wish you all the best.
@marinstatlectures
7 жыл бұрын
thanks +Gabriel Barros , appreciate that!
@alexg4121
4 жыл бұрын
one of the best tutorials I found on the subject. Thank you very much.
@marinstatlectures
4 жыл бұрын
thanks. and you're welcome :)
@olsjonbaxhija6720
9 жыл бұрын
I love these! Thank you for making them freely available. You got yourself a new subscriber.
@marinstatlectures
9 жыл бұрын
You're welcome Olsjon Baxhija !
@user-tl4jl7bg3i
6 жыл бұрын
Thank you thank you! Your a life saver! Was struggling so much with my stats assignment but now I finally understand it!
@299redd
8 жыл бұрын
Dude I want to thank you so much. You are helping me learn so much that my uni lecturers miss out
@marinstatlectures
8 жыл бұрын
great to hear +299redd , and you're welcome!
@naox1411
9 жыл бұрын
All the things крипто-анархисты said plusTHANK YOUUU. WAS HELPFUL. keep doing this videos of R so i can learn more and MOORE
@pkhuntiable
8 жыл бұрын
oh my god !!! these are best collection of R tutorials !!!
@marinstatlectures
8 жыл бұрын
thanks +puja khunti , e appreciate that!
@mididoddi
6 жыл бұрын
Great job with the videos Mike! There are only few things in this world for which you can say "Can't make it better".
@nicolasbalmaceda9155
8 жыл бұрын
very helpful! the best explained tutorials i've seen yet on R in youtube.
@marinstatlectures
8 жыл бұрын
Thanks +Nicolas Balmaceda we appreciate that!
@mikorees5853
5 жыл бұрын
Thanks Mike. Your video really makes my life simple!
@marinstatlectures
5 жыл бұрын
good to hear :)
@ibee244
8 жыл бұрын
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
8 жыл бұрын
You're welcome +I Bee !
@ohnyx6015
9 жыл бұрын
Thank you for sharing stuff of such quality for free . God bless!
@marinstatlectures
9 жыл бұрын
You're welcome Oh! Nyx
@knowledgeisthepowerofhuman8966
6 жыл бұрын
god bless you as you spread the knowledge for needy people god will enhance your courage and do more in depth of r
@treescully
10 жыл бұрын
totally forgot how to do some of these simple things very quick and helpful video, thank you!
@marinstatlectures
10 жыл бұрын
You're very welcome treescully , thanks for watching!
@kguadl
8 жыл бұрын
Thanks a million for making R tutorials without JARGON!!!! Yay!!
@marinstatlectures
8 жыл бұрын
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!
@simonshrestha
10 жыл бұрын
the first time I came across file.choose() and it is very helpful,
@parthahs
10 жыл бұрын
Thanks for explaining in the simplest way.I am looking for other videos for processing data. Best Regards Partha
@marinstatlectures
10 жыл бұрын
You're welcome Hassan Parthasarathy !
@gigiem2580
4 жыл бұрын
THIS. IS. SO. HELPFUL.
@griscellimarianne9769
7 жыл бұрын
Thanks!! Great explanation!
@sanjeebkumar8539
10 жыл бұрын
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
10 жыл бұрын
Thanks sanjeeb kumar ! Our goal was to provide the best resource for an intro to R on KZitem! 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!
@fanish10
10 жыл бұрын
Thank you so much!! Great tutorial. I have been struggling for hours
@marinstatlectures
10 жыл бұрын
You're welcome Isha Sookharee , glad you found it helpful!
@wenfangliu2421
8 жыл бұрын
You made fabulous lectures. Thanks a lot.
@marinstatlectures
8 жыл бұрын
you're welcome +Wenfang Liu !
@user-rs7mi5fw5n
8 жыл бұрын
very straightforward and helpful. Thank you
@marinstatlectures
8 жыл бұрын
Thank you +庞广来 !
@Dyokoto
9 жыл бұрын
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
9 жыл бұрын
Thanks Dyokoto , glad to hear it has been helpful!
@nstar0203
7 жыл бұрын
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
7 жыл бұрын
you're welcome +Nd_1115773
@Jaiston
3 жыл бұрын
Thanks a lot for making such an amazing video. It was very easy. God bless you.
@shahzaibkhoso2240
4 жыл бұрын
I like the way you are teaching
@sudhaashri2429
5 жыл бұрын
i learn import excel file to r so easily thank u sir
@marinstatlectures
5 жыл бұрын
you're welcome
@milenaoliveira2626
5 жыл бұрын
Wow!!!!! Amazing help. God bless you!
@swatithakkar7221
8 жыл бұрын
thanks a lot Mr. Marin , sir didnt get about comma(,)...actully i am a beginner in R.
@kishorejaganccb
8 жыл бұрын
+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 ","
@kumarsvc
10 жыл бұрын
Nice illustration, thanks Marin for keeping it very simple.
@marinstatlectures
10 жыл бұрын
You're welcome vs123 !
@anitamcdowell9702
4 жыл бұрын
Very helpful! Thank you, Mike and Ladan.
@rochuka
8 жыл бұрын
wonderful experience through your tuitorials
@marinstatlectures
8 жыл бұрын
Thanks +rodgers closec !
@porchheng1320
Жыл бұрын
this is very helpful to me, thank you very much sir.
@matthewott7878
9 жыл бұрын
Very, very helpful - thank you MarinStatsLectures!
@marinstatlectures
9 жыл бұрын
You're welcome Matthew Ott , glad you found them helpful!
@swatimandavawalla1265
5 жыл бұрын
Thank u so much Wonderful I can learn r software Small such vedio help to learn faster Thank u
@nd.drones
6 жыл бұрын
Thank you so much. Really like your tutorial~
@meganmccarthy3731
9 жыл бұрын
THANK YOU. You are my savior.
@marinstatlectures
9 жыл бұрын
you're welcome +Megan McCarthy !
@Plaid_Druid
5 жыл бұрын
This was so helpful. Thank you!
@lamiyamammadova8179
6 жыл бұрын
Thanks a lot! You explained everything so easily!
@junhotan2096
5 жыл бұрын
amazing person doing stunning thing, what a man
@danieljhonatanpomacuri9236
5 жыл бұрын
Dear, since you are ready to answer questions, I have really had a big problem, it happens that if the location of the file contains accents, this will generate an error.
@zahrahosseini9523
4 жыл бұрын
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.
@juniorjunior1666
4 жыл бұрын
Thanks for sharing it. That is a very informative video
@alexanderwoods5610
10 жыл бұрын
Hey this video was amazingly helpful!!!!! You made R much less intimidating! Thank you!!!!!
@marinstatlectures
10 жыл бұрын
You're welcome Alexander Woods , glad you found it useful!
@anukulburanapratheprat7483
3 жыл бұрын
Really helpful. Thank you very much.
@swathiganji2542
8 жыл бұрын
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
8 жыл бұрын
thanks +swathi ganji , we appreciate that! we haven't prepared anything for decision trees yet.
@bhattaraimanish4957
10 жыл бұрын
Great Tutorials..found really informative to get grounds in R to solve some optimization problems
@marinstatlectures
10 жыл бұрын
Thanks Bhattarai Manish , happy to hear you found them useful!
@marinstatlectures
11 жыл бұрын
Thanks for watching Gustavo!! We use many different softwares to put them together. Mainly Camtasia and Snaggit to do the screen captures and some of the editing. Then a bit of iMovie for editing as well as photoshop and powerpoint for creating some of the visuals, and a few other programs here and there when little specific things are needed.
@mpgrewal00
8 жыл бұрын
Very good work Marin.. thanks for this wonderful series.
@marinstatlectures
8 жыл бұрын
you're welcome +mpgrewal00 !
@shainishadevi1907
3 жыл бұрын
Amazing channel! Really useful!
@zacharysegal8212
6 жыл бұрын
I found this very helpful, thanks for posting this.
@MichaelSmith-zm5qi
5 жыл бұрын
Thank you! These videos are awesome!
@marinstatlectures
5 жыл бұрын
you're welcome :)
@RAVIKUMAR-me3th
4 жыл бұрын
you are good mentor love to learn from you
@MrAlivallo
5 жыл бұрын
Also Super Important; Go to "Session" - - > Set working directory -- ; set to a folder you typically save your Excel files in. Now in the bottom right window under "Files tab" you can Browse all the files in that folder You can click on any file an import, delete, rename, and more, all with mouse clicks no code needed.
@randaburaideh4905
2 жыл бұрын
Thank you for saving my time !
@alisaber502
Жыл бұрын
Hi, I didn't get the difference between a more generic table that we use "sep", and the normal one... They both look similar
@resilientprogrammer8466
2 жыл бұрын
Thanks so much. I learned a lot
@tinhoan3556
7 жыл бұрын
very good, great, awesome, excellent Video!
@JoysiUSSR
10 жыл бұрын
thanks for your videos (I use it for self-study). Especially for subtitles (my level of English basic only)!
@marinstatlectures
10 жыл бұрын
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!
@medouneineneine991
7 жыл бұрын
Dankeschön , Thank you so much for your Videos form germany
@chakwingsin8783
10 жыл бұрын
thanks. The Excel file link successfully opened by Google Doc with a long list of data. The text file link - Google Doc reported "no data to show". Saved the link and open by Gedit - gibberish. Cheers.
Пікірлер: 517