Importing Data in R (Part 1)
In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.
- 3 hours
- 11 Videos
- 42 Exercises
- 68,056 Participants
- 3,550 XP
Create Your Free Account
By continuing you accept the Terms of Use and Privacy Policy, that your data will be stored outside of the EU, and that you are 16 years or older.
Course Description
Importing data into R to start your analyses—it should be the easiest step. Unfortunately, this is almost never the case. Data come in all sorts of formats, ranging from CSV and text files and statistical software files to databases and HTML data. Knowing which approach to use is key to getting started with the actual analysis.
In this course, you will get started with learning how to read CSV and text files in R. You will then cover the readr and data.table packages to easily and efficiently import flat file data. After that you will learn how to read XLS files in R using readxl and gdata.
In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.
Course Outline
-
1
Importing data from flat files with utils
FreeLots of data comes in the form of flat files: simple tabular text files. Learn how to import all common formats of flat file data with base R functions.
-
Importing Excel data
Excel is a very widely used data analysis tool. If you prefer to do your analyses in R, though, you'll need an understanding of importing CSV data into R. This chapter will show you how to use readxl and gdata to do so.
-
readr & data.table
Next to base R, there are also dedicated packages to easily and efficiently import flat file data. We'll talk about two such packages: readr and data.table.
-
Reproducible Excel work with XLConnect
Next to importing data from Excel, you can take things one step further with XLConnect. Learn all about it and bridge the gap between R and Excel!
-
1
Importing data from flat files with utils
FreeLots of data comes in the form of flat files: simple tabular text files. Learn how to import all common formats of flat file data with base R functions.
-
readr & data.table
Next to base R, there are also dedicated packages to easily and efficiently import flat file data. We'll talk about two such packages: readr and data.table.
-
Importing Excel data
Excel is a very widely used data analysis tool. If you prefer to do your analyses in R, though, you'll need an understanding of importing CSV data into R. This chapter will show you how to use readxl and gdata to do so.
-
Reproducible Excel work with XLConnect
Next to importing data from Excel, you can take things one step further with XLConnect. Learn all about it and bridge the gap between R and Excel!
Filip Schouwenaars
Data Science Instructor at DataCamp
Filip is the passionate developer behind several of DataCamp's interactive courses, covering both R and Python. Under the motto 'Eat your own dog food', he has used the techniques DataCamp teaches its students to perform data analysis for DataCamp. Filip holds degrees in Electrical Engineering and Artificial Intelligence.
See MoreCourse Instructor
Filip Schouwenaars
Data Science Instructor at DataCamp
Filip is the passionate developer behind several of DataCamp's interactive courses, covering both R and Python. Under the motto 'Eat your own dog food', he has used the techniques DataCamp teaches its students to perform data analysis for DataCamp. Filip holds degrees in Electrical Engineering and Artificial Intelligence.
See MoreJoin over 3,300,000 others learning to leverage the power of data with DataCamp!
Start Course For Free