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.

Introduction & read.csv

read.csv

Reading from a path

read.delim & read.table

read.delim

Assigning column names

Column classes

read.table

Final Thoughts

Importing data from flat files with utils

In addition to base R, there are dedicated packages to easily and efficiently import flat file data. We'll talk about two such packages: readr and data.table.

readr: read_csv & read_tsv

read_csv

read_tsv

readr: read_delim

read_delim

skip and n_max

col_types

col_types with collectors

data.table: fread

fread

fread: more advanced use

Dedicated classes

readr & data.table

Excel is a widely used data analysis tool. If you prefer to do your analyses in R, though, you'll need an understanding of how to import  .csv data into R. This chapter will show you how to use readxl to do so.

readxl (1)

List the sheets of an Excel file

Import an Excel sheet

Reading a workbook

readxl (2)

The col_names argument

The skip argument

Importing Excel data

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

Reading sheets

Connect to a workbook

List and read Excel sheets

Customize readWorksheet

Adapting sheets

Add worksheet

Populate worksheet

Renaming sheets

Removing sheets

Reproducible Excel work with XLConnect

Hotdogs

Potatoes (CSV)

Potatoes (TSV)

Swimming pools

Urban population (XLS)

Urban population (XLSX)

Importing data into R should be the easiest step in your analysis. Unfortunately, that is almost never the case. Data can come in many formats, ranging from .csv and text files, to 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’ll start by 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.

Introduction to R

Learn to read .xls, .csv, and text files in R using readxl and gdata, before learning how to use readr and data.table packages to import flat file data.

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.

Associate Data Scientist in R

Datenimport/-bereinigung  in R

Instructor, DataCamp

Overview

readr

CSV files

TSV files

Wrapping in utils and readr

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_1477/subtitles/course_1477_89d8588b344b4f3ceaed0b07b1506e17.vtt

readr & data.table - readr: read_csv & read_tsv

readr: read_csv & read_tsv

Create Your Free Account