Importing/Reading Excel data into R using RStudio (readxl) | R Tutorial 1.5b | MarinStatsLectures

[@marinstatlectures]

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!

[@furaosentu]

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?

[@atatekeli9295]

Man you made me learn how to directly import excel data, thank you

[@amirthaganesh6030]

Sir , there is no package called "pillar" .. What to do when it pops like this ???

[@mouhamaadibrahim]

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 KZbin channel so far in all ways !

[@bettinathek6484]

wow again: how students can learn from youtube instead from there lectures!! great, thanks :-)

[@lanternofthegreen]

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!

[@rashmisingh2854]

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

[@sachiko8266]

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

[@marinstatlectures]

you're welcome :)

[@jeetendrapratap6645]

R became super easy by listening these lectures

[@maheenmuhammadsali7254]

I am a beginner in R, I found your videos are so useful. Thank you so much

[@mahamoussa5712]

your way of explanation makes me crazy about R and enthusiastic to learn more and more. Thank you so much.

[@evry1loveronica]

This is better and more useful than graduate school

[@marinstatlectures]

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!

[@sb-hf7tw]

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.👏👏 👍👍👌🙏🙏🙏

[@marinstatlectures]

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

[@sb-hf7tw]

MarinStatsLectures- R Programming & Statistics Most welcome

[@khrystynakurta6494]

You just saved my life with your video, thank you !

[@thetruthcomeshere9005]

BEST VIDEO EVER AFTER SPENDING A LOT OF TIME WATCHING OTHERS.

[@arwent2543]

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.

[@marinstatlectures]

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.

[@yvonnemadegwa967]

Thank you very much. I have been struggling to understand R, till i found these simple tutorials, which are AWESOME

[@marinstatlectures]

you're welcome, glad you're finding them helpful!

[@stillhungryy]

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.

[@QuantNerdCT]

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.

[@evrenyilmaz4]

I didn't know file importing was an art. I am genuinely impressed. Thank you.

[@mehmett4535]

that explanation is clear as sky..thanks man!

[@BietielWoldemichel]

I am having a problem downloading the datasets from the links provided in the comments section. Any suggestion?

[@jerrykane5540]

Thank you Sir, this video helped me with my first Data Science assessment.

[@martinusmoretti729]

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.

[@annas9942]

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.

[@aygulabdurrahimli1016]

did you solve it?Because I could not find as well

[@annas9942]

@@aygulabdurrahimli1016 not really( I just skipped

[@aygulabdurrahimli1016]

@@annas9942 OK.hopefully He will reply

[@marinstatlectures]

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

[@resilientprogrammer8466]

Thanks so much. This is very helpful.

[@mmughal]

Though I haven’t watched or started your series but am so thankful for ur efforts and excited to start right after new year

[@romerootavio368]

Excellent class! Thank you so much for the video!

[@vishnujatav6329]

Beautifully explained

[@shirinisabekova5504]

Beautiful explanation Martin! Thank you for the video.

[@brittanydipiazza4004]

Thank you so much for your videos!! They are very helpful and greatly appreciated.

[@muhammedhadedy4570]

Excellent tutorial. Thanks a lot.

[@AbhishekMadankar]

at 6:27 why did you reimport with lungcap2 ?

[@AbhishekMadankar]

when I did it Error in View : object 'Book1xls1' not found this came in console

[@navneetsinha451]

Is this series only for MAC users?

[@marinstatlectures]

No, the R commands are the same for Mac and PC. It doesn’t matter which OS you are using

[@negusuworku2375]

Thank you. very helpful

[@shirinisabekova5504]

Could you please advise, I am having an trouble in importing: File

[@tareq8109]

1:15 Now i am using .csv file and it doesn't work.

[@bhalchandrapatil7480]

Thank you for video. You had explain everything in simple way

[@carlyauerbach1117]

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.

[@Andre-oj6dz]

did you figure it out

[@lucyonwuatuegwu4056]

@@Andre-oj6dz ho Andre how can i import data. I feel stock

[@nahuel3256]

How could I import that data as a vector? I'd like to calculate mean(), sd(), etc

[@fahmibilal]

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?

[@wilrivera2987]

R is my fav coding language

[@bharatrawlley6434]

Is there any way to customize what all data R will read as NA, instead of just *** as mentioned in the video? Thank you!!

[@JustSomeoneAtYtb]

When I imported, all my variables came with an $, how do I change them back to normal? All my attempts, they come with it

[@ghayastv7032]

Dear sir, will you please upload a complete statistics ply list organized by topics an entire course Thanks

[@easydatascience2508]

Try mine. Python and R playlists provide step by step detailed tutorials, with downloadable source files.

[@ivywen728]

Sir, why the dataset on your website is difference with your display.? i

[@davidsaeteros773]

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.

[@mangnoa]

I have this question as well!! Anyone can explain this plz..??

[@DnyaneshwarPanchaldsp]

nice demo

[@AjayBhardwaj-p5l]

This was a very helpful tutorial and made it very easy to handle excels for me. Thanks a lot!

[@marinstatlectures]

You are welcome Ajay! Glad you found the video useful :)

[@adolphmajeremane8513]

Hi how do I merge multiple data into 1

[@stillhungryy]

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

[@nilousarraf369]

great video

[@googledude5649]

Great job - Thanks a ton guys

[@mjduan2449]

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?

[@marinstatlectures]

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)

[@pineapplesdontgrowontrees4529]

Hey how did this work out I’m having the same problem and I don’t know what to do

[@aliceherrlin4604]

@@pineapplesdontgrowontrees4529 I had the same problem, and it turns out I used a ; instead of : . It works now

[@gokcemakarc9192]

YOU SAVED ME just wow

[@marinstatlectures]

Happy to help :)

[@adityachandra5287]

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

[@mateamot912]

WOW, thank you very much

[@marinstatlectures]

you're welcome :)

[@prabpharm07]

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?

[@marinstatlectures]

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.

[@prabpharm07]

MarinStatsLectures- R Programming & Statistics thank you for this response.

[@dshruti022]

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?

[@marinstatlectures]

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

[@ioannisstefanidis9406]

You are my hero

[@marinstatlectures]

Not all heros wear capes, right ;)

[@groundrail]

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.

[@marinstatlectures]

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... kzbin.info/www/bejne/p6LdkHdnq9-Ga68

[@aygulabdurrahimli1016]

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.

[@marinstatlectures]

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!

[@CntrlAltUniverse]

5:00 code preview copy/paste

[@katrisenila9644]

Thank you for sharing this video, you really saved my day :)

[@masonbuzzell]

The practice data set is no longer available. Is there anyway you could upload it again? Would be greatly appreciated

[@marinstatlectures]

Hey there, there seems to be a problem with the links. try this link, it should work statslectures.com/r-scripts-datasets

[@yinanxue8653]

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

[@RichardThomas341]

@@marinstatlectures The LungCap and LungCap2 Excel files from there only have one worksheet, while in the video there are two.

[@SujinPark-h4w]

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

[@tanushreenagar3116]

Nice

[@nept4ne]

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?

[@marinstatlectures]

sorry, but im not sure on the issue here.

[@jjct111]

Here for Econ 333

[@dasrotrad]

EXCELLENT!

[@claraleidenberger3350]

ponganlo en 1.5X

[@mrsnapple5827]

god i hate ads

[@domenicapincay8313]

CRACK