The readxl package makes it easy to get data out of Excel and into R from multiple worksheets and clean up the data before importing it (like change the name, skip rows and columns, identify the type of the data, and many more useful functions), thanks to the dedicated work of those behind readxl Hadley Wickham and Jenny Bryan, my former supervisor and mentor!
Thanks for the video, this is great. What about the variable names in row 3? You specified the range as "B3:E11" and the checkbox "first row as names" is checked, but it seems RStudio isn't importing row 3 as names. Is it a bug?
I am transitioning from PhD in biomedical engineering to biomedical data analytics... I have researched for R programming channels extremely... then by chance I fortunately found your channel ! wow !!! Greatest TH-cam channel so far in all ways !
This was soo good. very nicely explained. To evryone who ever is just spending their lots of time in search of a good R video ...This is the one. GO FOR IT!!!!
Yesterday, I've started to gather data from my work, and there was tons of it. I use R usually, but looking at my data I've realized that it'll be a pain to organize my data the way that I can import them to R, so I said "hell with it" and stored my data in multiple Excel sheets. I didn't even wanna bother looking for ways for importing on the internet. And today you uploaded this... Thank you!
I started to learn R and tried so many tutorial videos and manual books. This is THE BEST in so many different ways. Concise but thorough. Thank you very much for your work!!!!
thanks @evry1loveronica for the kind words! it's always great to hear that our videos are making a difference! please share them with your friends and help us reach more people!
Hey! Mak Marin ..yet I really found understanding R difficult but these tutorial are simply explained by you . Appreciating your efforts , keep growing sir and come up with new tutorials for us.
I am a very novice R user and this tutorial was very easy to follow. I had checked out other tutorials and found that the others to be difficult to follow.
I am taking the Georgia Tech Analytics courses, we are using R to do homework and project, but GT does not provide guidance on how to use R. So glad I found you here, one of the most useful videos.
Many of our videos were designed for a few statistical courses as The University of British Columbia, so we likely cover everything you’ll need to know for your courses.
Thank you Sir! The part about the missing values was exactly what I was looking for. Also perfect that you used two different types of missing values and how to deal with them both.
Couldn't find xlsx file with 2nd sheet adding explanation to other variables. All apart from this is great. Thank you for the easy-to-understand materials! Also, your pronunciation is very clear, so I enjoy listening.
at the moment were not sure where that file went, and it doesn't seem to be posted. if we find it we will post it up there, but if you you can practice with any set of data that you have
I am a first time R user and am trying to import a Dataset from Excel. When I try to do so, it prompts me to install packages necessary so I click okay. It begins to download and runs script, but then it clicks out and never downloads. Do you know how I could fix this? I've been searching on the internet, but have found nothing. Thank you.
Has anyone experienced that when running the second script code with LungCapData2, R did not do what it did in the video? I had to find for a way around. Still, it keeps me wondering.
Hi, it's hard to tell from a distance...but the error message seems to suggest that the file you are trying to import is not an excel file (with an extension of .xlsx of .xls)
Hi, when I am importing my excel data in R studio as explained, I am not able to modify the name and other details in Import Options section. Could you please help me know what could be the reason for this?
Hi, i have no idea why that is. if youre using the "import dataset" tab you should be able to right there. we have other videos showing how to import using the "read.table()" command, so you could always try that if the menu is giving you trouble
Hey! Sir can I get reply of the question which I m going to mentioning below. - sir are you working on R software like if I want to learn from scratch to advance R software . Will I be able to get it from your tutorials??
Hi Mike, thank you so much for knowledge dissemination. In my little real-world experience of working with R, I have never felt a need of reading data from Excel files (perhaps, due to the reason that I was not aware of this function). All I have used, and seen other people using, are the functions like read.csv or read.table. In your experience, how often you have been in situations where using read_excel was obligatory or preferred?
Hi, myself, i tend to use "read.table" and those sorts of functions most of the time. but i think being able to directly read Excel files has its place for certain times or certain users. it's not completely necessary./..i tend to work with files saved as ".csv" and just import through the command line...but this definitely helps make R more user friendly and more accessible, especially for those with less coding experience. the short answer is that it is not necessary at all, but a nice feature for certain times or certain individuals.
not sure if this is what you are looking for, but we have a separate video talking about creating/saving scripts... i think this may answer your question... th-cam.com/video/qqz_D1vzS5M/w-d-xo.html
When I import data from excel, my computer shows a message "file nave conversion problem--name too long?". What is the meaning? How can I solve this problem? I just download datafile from statslectures.com/r-scripts-datasets LungCapData.xls
First of all thank you for that kind of useful videos! But as others even me I could not find the second excel sheet.From the website I downloaded again but there is just one excel sheet.Please give us other alternatives.
im trying to find the original file, but can't locate it at the moment...but really, you can try practicing with any data file that you have... if we can track down that file we will get it uploaded asap!
@@marinstatlectures The practice data set is not the same as the dataset in this video. Do you have links containing the dataset of this video? Thank you.
MarinStarsLectures- R Programming & Statistics, I need your help, when I import an excel file it says "is this a valid Excel file? There is no package called 'rland', what should I do?
The readxl package makes it easy to get data out of Excel and into R from multiple worksheets and clean up the data before importing it (like change the name, skip rows and columns, identify the type of the data, and many more useful functions), thanks to the dedicated work of those behind readxl Hadley Wickham and Jenny Bryan, my former supervisor and mentor!
Thanks for the video, this is great. What about the variable names in row 3? You specified the range as "B3:E11" and the checkbox "first row as names" is checked, but it seems RStudio isn't importing row 3 as names. Is it a bug?
Man you made me learn how to directly import excel data, thank you
Sir ,
there is no package called "pillar" ..
What to do when it pops like this ???
I am transitioning from PhD in biomedical engineering to biomedical data analytics... I have researched for R programming channels extremely... then by chance I fortunately found your channel ! wow !!! Greatest TH-cam channel so far in all ways !
wow again: how students can learn from youtube instead from there lectures!! great, thanks :-)
This was soo good. very nicely explained. To evryone who ever is just spending their lots of time in search of a good R video ...This is the one. GO FOR IT!!!!
Yesterday, I've started to gather data from my work, and there was tons of it. I use R usually, but looking at my data I've realized that it'll be a pain to organize my data the way that I can import them to R, so I said "hell with it" and stored my data in multiple Excel sheets.
I didn't even wanna bother looking for ways for importing on the internet.
And today you uploaded this...
Thank you!
I started to learn R and tried so many tutorial videos and manual books. This is THE BEST in so many different ways. Concise but thorough. Thank you very much for your work!!!!
you're welcome :)
your way of explanation makes me crazy about R and enthusiastic to learn more and more. Thank you so much.
R became super easy by listening these lectures
I am a beginner in R, I found your videos are so useful. Thank you so much
If I were know about you 2 years ago, I would have been an R expert just because of u, but it's not too late ever!!! Thanks a lot.👏👏
👍👍👌🙏🙏🙏
great to hear...and it is never too late! we've got a ton of videos, and were hoping to add some more R videos in the coming months...
MarinStatsLectures- R Programming & Statistics
Most welcome
This is better and more useful than graduate school
thanks @evry1loveronica for the kind words! it's always great to hear that our videos are making a difference! please share them with your friends and help us reach more people!
Hey! Mak Marin ..yet I really found understanding R difficult but these tutorial are simply explained by you . Appreciating your efforts , keep growing sir and come up with new tutorials for us.
I am a very novice R user and this tutorial was very easy to follow. I had checked out other tutorials and found that the others to be difficult to follow.
BEST VIDEO EVER AFTER SPENDING A LOT OF TIME WATCHING OTHERS.
You just saved my life with your video, thank you !
I am taking the Georgia Tech Analytics courses, we are using R to do homework and project, but GT does not provide guidance on how to use R.
So glad I found you here, one of the most useful videos.
Many of our videos were designed for a few statistical courses as The University of British Columbia, so we likely cover everything you’ll need to know for your courses.
Thank you very much. I have been struggling to understand R, till i found these simple tutorials, which are AWESOME
you're welcome, glad you're finding them helpful!
I didn't know file importing was an art. I am genuinely impressed. Thank you.
that explanation is clear as sky..thanks man!
Thank you Sir! The part about the missing values was exactly what I was looking for. Also perfect that you used two different types of missing values and how to deal with them both.
Thank you Sir, this video helped me with my first Data Science assessment.
Couldn't find xlsx file with 2nd sheet adding explanation to other variables. All apart from this is great. Thank you for the easy-to-understand materials! Also, your pronunciation is very clear, so I enjoy listening.
did you solve it?Because I could not find as well
@@aygulabdurrahimli1016 not really( I just skipped
@@annas9942 OK.hopefully He will reply
at the moment were not sure where that file went, and it doesn't seem to be posted. if we find it we will post it up there, but if you you can practice with any set of data that you have
Though I haven’t watched or started your series but am so thankful for ur efforts and excited to start right after new year
I am having a problem downloading the datasets from the links provided in the comments section. Any suggestion?
Thanks so much. This is very helpful.
Beautifully explained
Excellent class! Thank you so much for the video!
Beautiful explanation Martin! Thank you for the video.
at 6:27 why did you reimport with lungcap2 ?
when I did it
Error in View : object 'Book1xls1' not found
this came in console
Thank you so much for your videos!! They are very helpful and greatly appreciated.
Excellent tutorial. Thanks a lot.
Could you please advise, I am having an trouble in importing: File
Thank you for video. You had explain everything in simple way
I am a first time R user and am trying to import a Dataset from Excel. When I try to do so, it prompts me to install packages necessary so I click okay. It begins to download and runs script, but then it clicks out and never downloads. Do you know how I could fix this? I've been searching on the internet, but have found nothing. Thank you.
did you figure it out
@@Andre-oj6dz ho Andre how can i import data. I feel stock
i have a sheet having following columns: day, month, year, rainfall value. i want to take sum of each month for each year. how it can b done in R?
When I imported, all my variables came with an $, how do I change them back to normal? All my attempts, they come with it
Is this series only for MAC users?
No, the R commands are the same for Mac and PC. It doesn’t matter which OS you are using
Is there any way to customize what all data R will read as NA, instead of just *** as mentioned in the video?
Thank you!!
How could I import that data as a vector?
I'd like to calculate mean(), sd(), etc
Thank you. very helpful
Sir, why the dataset on your website is difference with your display.? i
1:15 Now i am using .csv file and it doesn't work.
Has anyone experienced that when running the second script code with LungCapData2, R did not do what it did in the video?
I had to find for a way around. Still, it keeps me wondering.
I have this question as well!! Anyone can explain this plz..??
This was a very helpful tutorial and made it very easy to handle excels for me. Thanks a lot!
You are welcome Ajay! Glad you found the video useful :)
Dear sir, will you please upload a complete statistics ply list organized by topics an entire course Thanks
Try mine. Python and R playlists provide step by step detailed tutorials, with downloadable source files.
Hi Mike, when I try to import EXCEL as the way you shown, it's failed. The error shows " is this a valid Excel file?". Why?
Hi, it's hard to tell from a distance...but the error message seems to suggest that the file you are trying to import is not an excel file (with an extension of .xlsx of .xls)
Hey how did this work out I’m having the same problem and I don’t know what to do
@@pineapplesdontgrowontrees4529 I had the same problem, and it turns out I used a ; instead of : . It works now
nice demo
Hi, when I am importing my excel data in R studio as explained, I am not able to modify the name and other details in Import Options section. Could you please help me know what could be the reason for this?
Hi, i have no idea why that is. if youre using the "import dataset" tab you should be able to right there. we have other videos showing how to import using the "read.table()" command, so you could always try that if the menu is giving you trouble
Sir when i click on Import datasets and then click from Excel it says i do not have readxl package installed.please help what should i do
regards
Adi
Hi how do I merge multiple data into 1
R is my fav coding language
great video
Hey! Sir can I get reply of the question which I m going to mentioning below. - sir are you working on R software like if I want to learn from scratch to advance R software . Will I be able to get it from your tutorials??
YOU SAVED ME just wow
Happy to help :)
You are my hero
Not all heros wear capes, right ;)
Hi Mike, thank you so much for knowledge dissemination. In my little real-world experience of working with R, I have never felt a need of reading data from Excel files (perhaps, due to the reason that I was not aware of this function). All I have used, and seen other people using, are the functions like read.csv or read.table. In your experience, how often you have been in situations where using read_excel was obligatory or preferred?
Hi, myself, i tend to use "read.table" and those sorts of functions most of the time. but i think being able to directly read Excel files has its place for certain times or certain users. it's not completely necessary./..i tend to work with files saved as ".csv" and just import through the command line...but this definitely helps make R more user friendly and more accessible, especially for those with less coding experience.
the short answer is that it is not necessary at all, but a nice feature for certain times or certain individuals.
MarinStatsLectures- R Programming & Statistics thank you for this response.
After importing the "code preview" into the console, how do I reuse the file next time? I didn't see you give it a file name.
not sure if this is what you are looking for, but we have a separate video talking about creating/saving scripts... i think this may answer your question... th-cam.com/video/qqz_D1vzS5M/w-d-xo.html
Great job - Thanks a ton guys
WOW, thank you very much
you're welcome :)
When I import data from excel, my computer shows a message "file nave conversion problem--name too long?". What is the meaning? How can I solve this problem? I just download datafile from statslectures.com/r-scripts-datasets LungCapData.xls
First of all thank you for that kind of useful videos! But as others even me I could not find the second excel sheet.From the website I downloaded again but there is just one excel sheet.Please give us other alternatives.
im trying to find the original file, but can't locate it at the moment...but really, you can try practicing with any data file that you have... if we can track down that file we will get it uploaded asap!
The practice data set is no longer available. Is there anyway you could upload it again? Would be greatly appreciated
Hey there, there seems to be a problem with the links. try this link, it should work statslectures.com/r-scripts-datasets
@@marinstatlectures The practice data set is not the same as the dataset in this video. Do you have links containing the dataset of this video? Thank you.
@@marinstatlectures The LungCap and LungCap2 Excel files from there only have one worksheet, while in the video there are two.
Thank you for sharing this video, you really saved my day :)
MarinStarsLectures- R Programming & Statistics, I need your help, when I import an excel file it says "is this a valid Excel file? There is no package called 'rland', what should I do?
sorry, but im not sure on the issue here.
Nice
5:00 code preview copy/paste
EXCELLENT!
Here for Econ 333
ponganlo en 1.5X
CRACK
god i hate ads