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

How to Import/copy/read Excel data into R using RStudio and the readxl package:

▶︎ With the readxl package in RStudio you can easily import both xlsx and xls files into R from a local file or a url
▶︎ With this RStudio feature you can easily rename your dataset before importing data into R
▶︎ You can change column data types when importing data into R
▶︎ Using RStudio to import Excel data, you can choose which Excel worksheet to import to R
▶︎ In addition, you will be able to decide which rows of your Excel file to read into R and skip the first X rows
▶︎ We will also be able to limit the number of rows imported into R
▶︎ readxl package in RStudio will let you skip columns of data when importing Excel data in R
▶︎ There is also an option to deal with the missing values in your excel data file and select NA identifiers when importing data into R

▶︎▶︎ Download the Lungcap dataset here:

▶︎▶︎Watch More:

This video is a tutorial for programming in R Statistical Software for beginners, using RStudio.

Follow MarinStatsLectures

Our Team:
Content Creator: Mike Marin (B.Sc., MSc.) Senior Instructor at UBC.
Producer and Creative Manager: Ladan Hamadani (B.Sc., BA., MPH)

This #RTutorial is created by #marinstatslectures to support the statistics courses (SPPH400 #IntroductoryStatistics and SPPH500 Generalized Linear Models in Biostatistics) at The University of British Columbia (UBC) although we make all videos available to the everyone everywhere for free!

Thanks for watching! Have fun and remember that statistics is almost as beautiful as a unicorn!

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

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

[bettinathek]

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!

[sachiko]

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

[mahamoussa]

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

[rashmisingh]

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

[maheenmuhammadsali]

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

[arwent]

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.

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

[martinusmoretti]

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.

[khrystynakurta]

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

[sb-hftw]

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

[evrenyilmaz]

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

[yvonnemadegwa]

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

[annas]

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.

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

[evryloveronica]

This is better and more useful than graduate school

[jeetendrapratap]

R became super easy by listening these lectures

[jerrykane]

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