How to import data from excel into R studio. R programming for beginners

Importing data from excel into R is easy. Learn how to import data from excel by using both R code and by using the tools within R studio. This video is part of the R programming for beginners series.

Пікірлер: 179

  • @RProgramming101
    @RProgramming10110 ай бұрын

    Get my FREE cheat sheets for R programming and statistics (including transcripts of these lessons) here: www.learnmore365.com/courses/rprogramming-resource-library

  • @arantxamartinezaguilar5260
    @arantxamartinezaguilar52603 жыл бұрын

    I know this might seem like an easy step but this video just saved me from a mental breakdown. I have to deliver an R homework tomorrow and couldn't go past the first lines of code. I just want to thank you for making these videos, truly, they have helped me a lot. Please continue with this amazing work!

  • @MohammadAli-sg8bj

    @MohammadAli-sg8bj

    3 жыл бұрын

    same here, ever since classes went online, i am getting a hard time learning anything, just today i was in the zoom class and wasted 2 hours on how to import an excel file.

  • @malikyasirsohaibsohaib8423

    @malikyasirsohaibsohaib8423

    3 жыл бұрын

    Same here but i going to start my journey please i need your advice if possible.....

  • @Eve.Daniels

    @Eve.Daniels

    2 жыл бұрын

    Reading files is honestly my point of breakdown. I felt like such an idiot until I discovered this channel!!

  • @TyoStudy

    @TyoStudy

    2 жыл бұрын

    What major are y'all?

  • @hypervious8878

    @hypervious8878

    2 жыл бұрын

    I know!! It's unbelievable how many 'tutors' and 'instructors' out there NEVER explain exactly how to set up and get to the so-called "first step".

  • @chemicalcha0s
    @chemicalcha0s3 жыл бұрын

    Thank you for this, ive had to move from spss to r for my masters and your videos are a massive help and much easier than the terrible word documents our lecturers gave us!

  • @araujopsy
    @araujopsy4 жыл бұрын

    These videos are a great introduction to R. I imagine that Professor Greg must be very busy with other activities, but I hope he can continue producing material for this channel. I love data analysis.

  • @emmanuelhoustonkwashie9222
    @emmanuelhoustonkwashie92223 жыл бұрын

    Some people are really born to teach. Greg Martin deserves my Professors' monthly salary. R is not difficult but my Professor made it too complicated...I learnt a whole semester's course in 8 minutes....wow!

  • @paulajunior8602
    @paulajunior86025 жыл бұрын

    You’re an AMAZING EDUCATOR!!! A lot of professors and teachers can learn how to teach from you!

  • @onurucar1112
    @onurucar11122 жыл бұрын

    Thank you, it was really useful. I have been using the R programming language for over 6 months and didn't know we could do these.

  • @Nedwin
    @Nedwin4 жыл бұрын

    very informative and educative. Thank you master Greg.

  • Жыл бұрын

    Thank you for this video! I couldn't figure out how to properly write a file path,, now with this explanation how to import files, I finally know how does that work.

  • @mk4195421
    @mk41954215 жыл бұрын

    Thanks so much for the videos. I'm looking forward to learning more R from you!

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks Michael. I'm glad that you found it helpful. Please do send suggestions and requests for videos and I'll try to make them.

  • @MR-eg6np
    @MR-eg6np4 жыл бұрын

    I have been trying to learn R in my spare time for a year now, and I have learned more in the first 3 videos here than all my previous attempts... amazing!

  • @sujithnavabothu802

    @sujithnavabothu802

    3 жыл бұрын

    Have you seen those two comments above me? They are bots and they can be found in almost every comment section. For those who don't know that they are spammers, do not waste your time trying to figure out that insta-hacking thing.

  • @tonystark7915
    @tonystark79154 жыл бұрын

    You are a genius sir , making complex things simple 🙏

  • @syedatasneemfatima7062
    @syedatasneemfatima70622 жыл бұрын

    Watching in July 21.... Videos r great...My goodness... Can't believe it's available for free... Great explanation... Clear, crisp, to the point... Thanks a lot 🙏 .. God bless you

  • @Epicjoy5036
    @Epicjoy50364 жыл бұрын

    loving my Journey into R

  • @gregmartin
    @gregmartin5 жыл бұрын

    Got to love R programming!! :)

  • @zoxozoxo

    @zoxozoxo

    5 жыл бұрын

    Thanks to you, I love it too

  • @MatinsVlog

    @MatinsVlog

    3 жыл бұрын

    Is it possible to recap using the latest R Version 4.0.4? Its truly amazing. I had zero knowledge on this.

  • @janaegayle7605
    @janaegayle76052 жыл бұрын

    Bruh.... you are literally a lifesaver!!!

  • @TcRiverrat18
    @TcRiverrat18 Жыл бұрын

    This was INCREDIBLY HELPFUL. Thank you so so much! ☺

  • @RProgramming101

    @RProgramming101

    Жыл бұрын

    Glad it was helpful! Thanks for watching 😁

  • @nnennaumelloh8834
    @nnennaumelloh88343 жыл бұрын

    This was so helpful! Thank you so much!

  • @miliardsolomon475
    @miliardsolomon4755 жыл бұрын

    You should be proud of yourself. You are GREAT. Love all your videos.

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    That's a very kind thing to say Miliard - thanks (much appreciated)

  • @MohammadAli-sg8bj
    @MohammadAli-sg8bj3 жыл бұрын

    your videos are simple and descriptive, keep up the good work.

  • @TheAvgWoman
    @TheAvgWoman4 жыл бұрын

    So helpful! Thank you, sir. Please post more videos.

  • @r-come1230
    @r-come12302 жыл бұрын

    I'm commenting in the middle of the video because at least I have the guts to smile after getting a solution after stucking for some time. Thank you man

  • @kgosietsilemodisane8459
    @kgosietsilemodisane84592 жыл бұрын

    Lol very surprising to hear a South African accent on KZread. The work you've done here is insane. Thanks Greg!!

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Wow, thanks! Much appreciated !!

  • @Brightwing_
    @Brightwing_3 жыл бұрын

    Thank you so much for the wonderful and concise tutorial!

  • @RProgramming101

    @RProgramming101

    3 жыл бұрын

    Glad you enjoyed it! Please send suggestions for future videos Tori

  • @valentinechigarev6970
    @valentinechigarev69703 жыл бұрын

    Thank you! It was extremely useful for me!

  • @nurhantoguc9807
    @nurhantoguc98072 жыл бұрын

    I am grateful for this amazing R program series, you are a great help, Thank you

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    You're very welcome!

  • @samanthaclyne2011
    @samanthaclyne20112 жыл бұрын

    Thank you-such a helpful video! Direct instructions!

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Thank you for the kind feedback!

  • @alvarofigueroa4693
    @alvarofigueroa46935 жыл бұрын

    great work man! one can tell your enthusiasm about this R programming language and its capabilities. I will recommend your channel to friends and colleagues as I think you are doing a great job, your videos are very engaging and I think R is indeed powerful.

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks so much Alvaro! That's a fantastic (I really appreciate it). And thanks for sharing the channel with others!! Please feel free to send any questions or suggested video and I'll try to make them. Greg

  • @sterneyoung1431
    @sterneyoung14314 жыл бұрын

    Thank you for taking the time to make this video and all the others. Could you make more videos that demonstrate the use of GG plot, corrplot, word frequency or web scraping?

  • @rexevan6714
    @rexevan67145 жыл бұрын

    This is awesome. A little bit advice, it will be really good if you also include R package called `unpivotr`

  • @sannytriutami
    @sannytriutami4 жыл бұрын

    i just want to say, thank you very much. It's really helpful for me to start learn R. You are doing such a good think. Keep inspiring!

  • @mariavega8825

    @mariavega8825

    4 жыл бұрын

    sanny triutami y su Rubí nrirvitgiiiv o al ro que Orión ose de de embarque en

  • @mariavega8825

    @mariavega8825

    4 жыл бұрын

    Que no Fe

  • @setarehsohail5422
    @setarehsohail54222 жыл бұрын

    It is a very perfect way to teach! THANKS!

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Much appreciated Setareh !!

  • @eduartmisiraj8031
    @eduartmisiraj80315 жыл бұрын

    Thanks a lot, can't wait for more :)

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks Eduart. More to come soon 😁

  • @raycobb327
    @raycobb327 Жыл бұрын

    And STILL the number 1 R Studio video on KZread!!!!

  • @RProgramming101

    @RProgramming101

    Жыл бұрын

    Wow Ray - what a nice thing to say (thanks!!)

  • @wahyudiwahyudi2353
    @wahyudiwahyudi23535 жыл бұрын

    thank you so much for the videos.

  • @Eve.Daniels
    @Eve.Daniels2 жыл бұрын

    *Love the extra touch of turning yourself into a sketch in the intro. +500 xp video edition

  • @yuliatreister-goltzman5329
    @yuliatreister-goltzman53292 жыл бұрын

    A great video, helped me a lot, thank you so much

  • @smartwebpromote6396
    @smartwebpromote63962 ай бұрын

    Many thanks for these videos. Your lessons are clear and very helpful. I am following them with great pleasure. My compliments. A small note, don't use rhythmic background music at a high level or better yet don't use it at all. Background music for concentration is a very personal matter as many studies have proven.

  • @sandiprijal9521
    @sandiprijal95214 жыл бұрын

    such a beautiful explanation from data demon, do you still remember your day as a beginner?

  • @johannamyllykoski9518
    @johannamyllykoski95183 жыл бұрын

    Thanks so much. This was really helpful and human approach unlike so many others

  • @RProgramming101

    @RProgramming101

    3 жыл бұрын

    You're very welcome!

  • @nurinarifah9091
    @nurinarifah90913 жыл бұрын

    Amazing! Thank you soo much!

  • @bridgettsmith7206
    @bridgettsmith7206 Жыл бұрын

    Thank you for the video. I did not realize that there is an option to import excel without typing code

  • @RProgramming101

    @RProgramming101

    Жыл бұрын

    Amazing! Thank you!

  • @user-el7ho6fp7b
    @user-el7ho6fp7b2 жыл бұрын

    I really appreciate your video, for saving me

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Happy to help! Thanks for the feedback!

  • @user-pu9ll7vd5m
    @user-pu9ll7vd5m3 ай бұрын

    Getting good. Thanks - 😀

  • @malusikwetshube4551
    @malusikwetshube4551 Жыл бұрын

    Thank you so much from South Africa

  • @RProgramming101

    @RProgramming101

    Жыл бұрын

    Most welcome! Glad you liked it!

  • @nerdygirl53
    @nerdygirl53 Жыл бұрын

    thank you so so so much i couldnt figure out how to import a specific sheet

  • @kunalbali810
    @kunalbali8105 жыл бұрын

    Nice demo. There are very limited demo regarding analysis of atmospheric data in NetCDF file and plotting spatial maps in R programming. That would be great if you cover all these as well.

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks for the suggestion Kunal - I will try to do something like that for sure. The first few videos will cover the basics but I'm super keen to start getting stuck into serious data (keep the suggestions coming​)

  • @SirinPage
    @SirinPage4 жыл бұрын

    Thanks/ I am so new about R.

  • @nzengueglainehorphe5115
    @nzengueglainehorphe5115 Жыл бұрын

    thank you for making these videos you are really great

  • @RProgramming101

    @RProgramming101

    11 ай бұрын

    So nice of you Thanks for watching

  • @ojoboagboeje2088
    @ojoboagboeje20882 жыл бұрын

    I am watching in 2022, these videos are very informative and easy to understand. Thank you Dr Greg

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Glad you like them!

  • @satishkumar-ir9wy
    @satishkumar-ir9wy2 жыл бұрын

    Vallah..........that was fantastic

  • @gulizdogan184
    @gulizdogan1845 жыл бұрын

    Hi Greg, Thank you for the video. I have a problem. My excel document has 75 columns and I can only see 51 columns, how can I import whole data or how can I see it on the R.

  • @wisdomedemanyomi5827
    @wisdomedemanyomi5827 Жыл бұрын

    I like this video, very concise and explanatory . I will like you to drop more, Thanks

  • @RProgramming101

    @RProgramming101

    Жыл бұрын

    Thanks for the feedback. Much appreciated. I'm glad that you found it helpful and yes, more videos to come! 😁

  • @lorenapacheco8781
    @lorenapacheco87814 жыл бұрын

    Hi Greg! I am new to R and learning as I go - Thank you for your videos! I successfully imported a csv file into R Studio but want to save the file as a Rdata (is this even the name? sorry if I don't know) file. How can I achieve this? Thanks

  • @hamzaamad3102
    @hamzaamad31022 жыл бұрын

    Hey Martin: Your videos are super useful. I have a question AS I do not have programming bg but I am really loving R. When to use inverted commas and when to not? I always gte confused whether should I use inverted commas or not and it's really bothering me.

  • @AGRONInfoTech
    @AGRONInfoTech4 жыл бұрын

    Nice video. Cool

  • @nicholasfrancis99
    @nicholasfrancis992 жыл бұрын

    Thank you so much! Bless you sir

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    You are very welcome!

  • @DheerajGupta-ez4hz
    @DheerajGupta-ez4hz3 жыл бұрын

    Really helpful video

  • @lauriemauritiusracing200
    @lauriemauritiusracing2005 жыл бұрын

    Very Very Interesting, cheers

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Glad you liked it Laurie - thanks for the feedback.

  • @hasirakoswatta386
    @hasirakoswatta3863 жыл бұрын

    This video helped me alot

  • @RProgramming101

    @RProgramming101

    3 жыл бұрын

    Thanks for the feedback Hasira

  • @ashokjaggaraju1213
    @ashokjaggaraju12132 жыл бұрын

    thankyou it was very useful

  • @RProgramming101

    @RProgramming101

    2 жыл бұрын

    Glad to hear that

  • @ranangahulisani
    @ranangahulisani3 жыл бұрын

    Very helpful

  • @patriciocosta1716
    @patriciocosta17162 жыл бұрын

    Gracias, muy util my util

  • @varunsharma-yv3bc
    @varunsharma-yv3bc4 жыл бұрын

    hello sir please upload more videos on R and i have been following your videos only to study R.

  • @appah2998
    @appah2998 Жыл бұрын

    Hi, I wanna ask you how to plot a csv file, xls , and xlsx files in R. and doing rarefaction curves with diversity index thanks.

  • @celienmalicheff1613
    @celienmalicheff16132 ай бұрын

    Hi! I don't know a thing about R and need to use it for my Masterthesis, so you videos are very helpfull! I just have a question: when I import the excel file, by copying the code and paste it in the upper left frame, I get an error: "Error in View : object 'T1' not found". I did everything the same as you but it's not working. Is there any chance you could help me? Thanks a lot!!

  • @DudeGuyWho
    @DudeGuyWho2 жыл бұрын

    Awesome content! Can you help me understand how to download a multi-sheet xlsx workbook from URL into R? It's only two tabs and I do know how to merge the tabs into a single dataframe once downloaded.

  • @madhuravi6953
    @madhuravi69532 жыл бұрын

    Very informative and helpful. Thank you. Can you please lose the background music on your upcoming videos please?

  • @mn8231
    @mn82314 жыл бұрын

    How did you get friends.xlxs into files before you have imported any Excel-sheet???

  • @mrmoreno369
    @mrmoreno3693 жыл бұрын

    Where can we find the datasets that are used in this video? Please and thank you!

  • @rafiaumar6087
    @rafiaumar60873 жыл бұрын

    Thank you so much......

  • @DanielApalowowa-cp4ed
    @DanielApalowowa-cp4ed5 ай бұрын

    Thank you

  • @bf1255
    @bf12552 жыл бұрын

    I nearly quit grad school, eff man thank you!

  • @christineholland1467
    @christineholland14673 жыл бұрын

    Hi Greg. At 1:24 seconds into your video, you say to find a 'dot' on the lower right-hand side of my hard drive to open the import function. Can you show or be more specific about what that is? I've pressed everything that looks like a dot and cannot get the "View File" "Import Dataset" option. Many thanks!

  • @AnjaliSharma-gf8mu

    @AnjaliSharma-gf8mu

    3 жыл бұрын

    just left click on the file you want to import

  • @aissoumonder3518
    @aissoumonder35182 жыл бұрын

    Thanks for this video, can you tell me how can I import FASTA data into R

  • @jeweljohnson
    @jeweljohnson5 жыл бұрын

    Please make a video on ggplot2

  • @draganmilosevic4986
    @draganmilosevic49865 жыл бұрын

    Dear Greg! First of all, thank you for great tutorials! Because of your's tutorials I started loving R :) secondly, regarding this tutorial, I have done everyrhing as you did and imported my air temperature dataset into R. However, now I have a problem with Time variable in R because it is represented like this: 1899-12-31 00:00:00. In Excel it was just 00:00:00, so R automaticaly added 1899-12-31. How can I remove these dates, (already have the good dates) and just leave hours? I hope you will have time to answer here or do another video on this topic, if you have not done it already. Cheers!

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks for the very interesting question Dragan. I will certainly create a video that deals with this (thanks for the request). I won't be able to answer your question fully here in the comments but keep an eye on the channel and I'll create a video that deals with it. Happy day.

  • @draganmilosevic4986

    @draganmilosevic4986

    5 жыл бұрын

    @@RProgramming101 , thank you Greg! I will keep an eye on the channel for a video. Cheers and enjoy the weekend!

  • @vivekanandinspire4883
    @vivekanandinspire48833 жыл бұрын

    it will be very good Greg, if it will be a little bit slow

  • @zqtang3481
    @zqtang34815 жыл бұрын

    Like it!

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks :)

  • @sunitapradhan3945
    @sunitapradhan3945 Жыл бұрын

    I am having a problem viewing the imported dataset. The message is package ‘readxl’ was built under R version 4.1.3. Could you please advise? Thank you

  • @fahimalamnobel4789
    @fahimalamnobel47894 жыл бұрын

    I want to make an excel file where row have been showing according to my data instead of 1,2,3,4. So how can I do this. I want to make a heatmap of my personal excel data?? Kindly help me in this regard.

  • @lucastrazzaboschi1822
    @lucastrazzaboschi18224 жыл бұрын

    Your videos are so PERFECT, please marry me! Thx a lot!!!

  • @rupeshingle2681
    @rupeshingle26812 жыл бұрын

    best sir

  • @mohamedmahmoud-xr8fu
    @mohamedmahmoud-xr8fu Жыл бұрын

    thanks a lot bro

  • @RProgramming101

    @RProgramming101

    11 ай бұрын

    Always welcome. Thanks for watching!

  • @vincenzo4259
    @vincenzo42592 жыл бұрын

    Thanks

  • @moonisvlogs1984
    @moonisvlogs19844 жыл бұрын

    Please post more videos. These videos are very helpful.

  • @PATRICKCHUAD
    @PATRICKCHUAD2 жыл бұрын

    Great video sir, however, the background is too loud. can it be remove so that we can hear clearly the tutorial? thanks.

  • @dreznik
    @dreznik5 жыл бұрын

    dear dr, let them know while require() is similar to library(), they are not the same. the former issues a warning if the pkg is not found whereas the latter causes the program to stop.

  • @RProgramming101

    @RProgramming101

    5 жыл бұрын

    Thanks very much for these insights Dan (I really appreciate it). I'm relatively new to R myself and so learning as I go. I really appreciate​ your feedback.

  • @aljerlee9264
    @aljerlee92644 жыл бұрын

    am I suppose to create my own excel table?

  • @sharmilasheikyusuf1346
    @sharmilasheikyusuf13463 жыл бұрын

    sir,while importing excel file from hard drive as u said,I m getting error "The procedure entry point EXTPTR_PTR could not be located in the dynamic link library C:\users\documents\R\winlibrary\4.0\Rcpp\libs\x64\ Rcpp.dll." plz,help me to rectify this...as earlier.. Thanks in advance

  • @chionomys
    @chionomys3 жыл бұрын

    MAny thanks

  • @Brainneeds
    @Brainneeds Жыл бұрын

    You killed me every time you said DAATA

  • @lindasturm-flores6752
    @lindasturm-flores67523 жыл бұрын

    Great video! I was trying to do a correlation test and got the message, " 'x' and 'y' must have the same length". What is this telling me?

  • @RProgramming101

    @RProgramming101

    3 жыл бұрын

    the two variables (that you are trying to test) need to have the same number of observations or data points in them). I'll create a video about this.

  • @jacky_23
    @jacky_232 жыл бұрын

    Hi Sir, please make a video of how to import and manipulate data from an xlsb file.

  • @akinsanyajabbar1013
    @akinsanyajabbar101310 ай бұрын

    What are the packages needed to be installed in R

  • @calvaocortes
    @calvaocortes4 жыл бұрын

    Hello friend, I'm from Brazil. Could you give me a hand? I imported in R a txt with 5 rows and 2 columns, I need to format it in R. For example: format this txt in a table with rows, in bold as in excel. I liked the video, I will follow.

  • @dattasriyalla1187
    @dattasriyalla11874 жыл бұрын

    I want to learn more

  • @TelzAll
    @TelzAll Жыл бұрын

    where at the bottom are you getting to pull the data from?

  • @nachomartin2061
    @nachomartin20614 жыл бұрын

    I cannot choose among the excel sheets. Only it appears the default option. What I have to do?

  • @anouarlakhouadri5983
    @anouarlakhouadri5983 Жыл бұрын

    i import my time series data from excel to R studio but the problem is that R consider Years also as variables is it normal ?