Get my FREE cheat sheets for R programming and statistics (including transcripts of these lessons) here: www.learnmore365.com/pages/membership-r-programming-data-visualization-and-research-methods
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!
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.
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!
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.
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.
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!
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!
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
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
Рік тому
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.
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.
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.
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
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!
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!!
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
When I try to change character to date for one my columns, I keep getting an error message ‘Attempt to open less than one data in OneIndex’. I don’t understand the error message, what can I do??
Thanks for this tutorial. I have an Excel file with multiple sheets, lets say sheets A & B, Sheet B is a continuation of A in rows i.e if sheet A ends at row 1000, sheet B row 1 is in actual fact row 1001 of Sheet A How do I import such sheets or file in R and get the interface to read the data accurately joiNnING sheet B underneath of sheet A
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.
Hi there! I'm going through a very rare (and unsolved) problem: When I create a .Rmd file and try to knit to HTML, PDF or Word, this error message appears: Error: 127:27: unexpected input 126: Sys.setenv(R_LIBS_USER= 127: file.path(†^ Ejecución interrumpida ¿What can I do with this mess?
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.
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.
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)
he says in the video you can ask it to skip 1 row (or 2 rows, however many you need to skip). I think this is the answer to your question...but as it is 2 months later perhaps you have figured it out! :)
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.
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
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?
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.
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.
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.
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
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!
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.
Get my FREE cheat sheets for R programming and statistics (including transcripts of these lessons) here: www.learnmore365.com/pages/membership-r-programming-data-visualization-and-research-methods
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!
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.
Same here but i going to start my journey please i need your advice if possible.....
Reading files is honestly my point of breakdown. I felt like such an idiot until I discovered this channel!!
What major are y'all?
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".
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!
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.
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.
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!
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!
it's 2024 ... and your videos are far better than most paid courses out there 🔥 Subscribed 👋
glad you like them - thanks for the comment
Lol very surprising to hear a South African accent on UA-cam. The work you've done here is insane. Thanks Greg!!
Wow, thanks! Much appreciated !!
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.
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
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
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.
You should be proud of yourself. You are GREAT. Love all your videos.
That's a very kind thing to say Miliard - thanks (much appreciated)
Got to love R programming!! :)
Thanks to you, I love it too
Is it possible to recap using the latest R Version 4.0.4?
Its truly amazing. I had zero knowledge on this.
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.
I am grateful for this amazing R program series, you are a great help, Thank you
You're very welcome!
And STILL the number 1 R Studio video on UA-cam!!!!
Wow Ray - what a nice thing to say (thanks!!)
This was INCREDIBLY HELPFUL. Thank you so so much! ☺
Glad it was helpful! Thanks for watching 😁
You’re an AMAZING EDUCATOR!!! A lot of professors and teachers can learn how to teach from you!
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.
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
Bruh.... you are literally a lifesaver!!!
You are a genius sir , making complex things simple 🙏
I like this video, very concise and explanatory . I will like you to drop more, Thanks
Thanks for the feedback. Much appreciated. I'm glad that you found it helpful and yes, more videos to come! 😁
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!
sanny triutami y su
Rubí nrirvitgiiiv o al ro que Orión ose de de embarque en
Que no Fe
It is a very perfect way to teach! THANKS!
Much appreciated Setareh !!
*Love the extra touch of turning yourself into a sketch in the intro. +500 xp video edition
Thanks so much. This was really helpful and human approach unlike so many others
You're very welcome!
your videos are simple and descriptive, keep up the good work.
Thanks so much for the videos. I'm looking forward to learning more R from you!
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.
Thank you-such a helpful video! Direct instructions!
Thank you for the kind feedback!
Thank you for the video. I did not realize that there is an option to import excel without typing code
Amazing! Thank you!
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!
just left click on the file you want to import
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!!
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.
very informative and educative. Thank you master Greg.
Thank you so much for the wonderful and concise tutorial!
Glad you enjoyed it! Please send suggestions for future videos Tori
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
I am watching in 2022, these videos are very informative and easy to understand.
Thank you Dr Greg
Glad you like them!
How did you get friends.xlxs into files before you have imported any Excel-sheet???
loving my Journey into R
where at the bottom are you getting to pull the data from?
thank you for making these videos you are really great
So nice of you Thanks for watching
I really appreciate your video, for saving me
Happy to help! Thanks for the feedback!
So helpful! Thank you, sir. Please post more videos.
Thank you! It was extremely useful for me!
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 ?
Where do I download the dataset, you are using?
When I try to change character to date for one my columns, I keep getting an error message ‘Attempt to open less than one data in OneIndex’. I don’t understand the error message, what can I do??
What is it that I can do on R that I can't do on Excel? I know there must be a lot of things, but what are they?
What are the packages needed to be installed in R
I cannot choose among the excel sheets. Only it appears the default option. What I have to do?
Thanks for this tutorial. I have an Excel file with multiple sheets, lets say sheets A & B, Sheet B is a continuation of A in rows i.e if sheet A ends at row 1000, sheet B row 1 is in actual fact row 1001 of Sheet A
How do I import such sheets or file in R and get the interface to read the data accurately joiNnING sheet B underneath of sheet A
A great video, helped me a lot, thank you so much
This was so helpful! Thank you so much!
hey man im having problems with m doing this . could you help me?
Thank you so much from South Africa
Most welcome! Glad you liked it!
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.
It didn't paste a code when i clicked the code preview icon so i clicked import and then when im trying to use view it gives error
Vallah..........that was fantastic
Hi there! I'm going through a very rare (and unsolved) problem: When I create a .Rmd file and try to knit to HTML, PDF or Word, this error message appears:
Error: 127:27: unexpected input
126: Sys.setenv(R_LIBS_USER=
127: file.path(â€
^
Ejecución interrumpida
¿What can I do with this mess?
This is awesome. A little bit advice, it will be really good if you also include R package called `unpivotr`
Where can we find the datasets that are used in this video? Please and thank you!
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.
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.
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)
Thanks a lot, can't wait for more :)
Thanks Eduart. More to come soon 😁
thank you so so so much i couldnt figure out how to import a specific sheet
Getting good. Thanks - 😀
what if my data has an empty row after the first row.. how can I get rid of it without deleting it from my Excel file?..
he says in the video you can ask it to skip 1 row (or 2 rows, however many you need to skip). I think this is the answer to your question...but as it is 2 months later perhaps you have figured it out! :)
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.
Nice video.
Cool
My excel has a range of A1:H541910 but it says it’s an error😢 what should I do ?😭
am I suppose to create my own excel table?
Can't locate the friends.cvs dataset. Please provide that.
thankyou it was very useful
Glad to hear that
This video helped me alot
Thanks for the feedback Hasira
in the latest version of R (4.2.2) there is no readxl library, only readxlsb, which is for binary files in Excel
does this affects running codes? bcz it doesn't work
Very informative and helpful. Thank you. Can you please lose the background music on your upcoming videos please?
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
Great video sir, however, the background is too loud. can it be remove so that we can hear clearly the tutorial? thanks.
Thank you so much! Bless you sir
You are very welcome!
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?
It says (could not find function "packageVersion")
Also, what is a parsing error?
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.
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.
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.
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
Really helpful video
Very Very Interesting, cheers
Glad you liked it Laurie - thanks for the feedback.
Thanks for this video, can you tell me how can I import FASTA data into R
such a beautiful explanation from data demon, do you still remember your day as a beginner?
Amazing! Thank you soo much!
thank you so much for the videos.
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!
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.
@@RProgramming101 , thank you Greg! I will keep an eye on the channel for a video. Cheers and enjoy the weekend!
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?
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.
Hi Sir, please make a video of how to import and manipulate data from an xlsb file.
Why no one is showing a video of how to bring the datasheet into R console
Please post more videos. These videos are very helpful.
Thanks/ I am so new about R.
hello sir please upload more videos on R and i have been following your videos only to study R.
Tell me sir?
How to import data from url