From the course: R for Excel Users
Join today to access over 24,700 courses taught by industry experts.
Moving data from Excel to R - R Tutorial
From the course: R for Excel Users
Moving data from Excel to R
- [Narrator] You may recall this worksheet from another lesson. It contains this list of height and weight values and it's stored with the other exercise files for this course. What I want to show you here is how to export this data from Excel into R by means of a CSV or comma separated values file. That way you can compare the analysis returned by R directly with those returned by Excel. The functions that support these processes are part of the standard download and installation of the R application. R has other functions, ones that don't rely on CSV files, that you can use to move data from Excel into R and into R from Excel. These functions belong to the DescTools package and they include Excel get range and Excel view. However, the steps you need to take to download and install these functions into R can be quirky. When they're working, the functions can be convenient and intuitive. So if you have them and you're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
