From the course: R Essential Training: Wrangling and Visualizing Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Importing data from a spreadsheet
From the course: R Essential Training: Wrangling and Visualizing Data
Importing data from a spreadsheet
- [Instructor] R's built in datasets are a great way to get started exploring R and seeing what you can do with it, but when it comes time to do actual analysis, you're going to want to bring in your own data. And usually the easiest way to do that is to import a spreadsheet. Spreadsheets are the universal data containers. Billions of datasets in the rows and columns of a spreadsheet. And they're very easy to import in R as long as you have what's called tidy data and that means each column is a variable, each row is an observation. And there's no funny business like merged cells or comments or formulas in there. If you do that, you've got a few different options on how you can import things into R. To do that I'm going to start by loading up the packages including rio which stands for R input output and it's a way of importing data and exporting. Now I'm going to import a dataset here that is from the exercise…
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.