read.csv
The utils package, which is automatically loaded in your R session on startup, can import CSV files with the read.csv() function.
In this exercise, you'll be working with swimming_pools.csv (view); it contains data on swimming pools in Brisbane, Australia. The file contains the column names in the first row. It uses a comma to separate values within rows.
Type dir() in the console to list the files in your working directory. You'll see that it contains swimming_pools.csv, so you can start straight away.
This is a part of the course
“Introduction to Importing Data in R”
Exercise instructions
- Use
read.csv()to import"swimming_pools.csv", which is located in the current directory, as a data frame with the namepools. - Print the structure of
poolsusingstr().
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import swimming_pools.csv: pools
pools <- ___
# Print the structure of pools
___This exercise is part of the course
Introduction to Importing Data in R
In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.
A lot of data comes in the form of flat files: simple tabular text files. Learn how to import the common formats of flat file data with base R functions.
Exercise 1: Introduction & read.csvExercise 2: read.csvExercise 3: Reading from a pathExercise 4: read.delim & read.tableExercise 5: read.delimExercise 6: Assigning column namesExercise 7: Column classesExercise 8: read.tableExercise 9: Final ThoughtsWhat is DataCamp?
Learn the data skills you need online at your own pace—from non-coding essentials to data science and machine learning.