Hoppa till huvudinnehållet

Kurs

Introduction to Importing Data in R

GrundläggandeKunskapsnivå

Uppdaterad 2026-03

In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.

Starta kursen gratis

RData Preparation

3 tim

10 videor

37 Övningar

3,150 XP

200K+

Intyg om genomförande

Omtyckt av lärande på tusentals företag

Utbildar du ett team?

Prova för företag

Kursbeskrivning

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.

Förkunskapskrav

Introduction to R

1

Importing data from flat files with utils

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

Reading from a path

read.delim & read.table

Assigning column names

Column classes

Final Thoughts

2

readr & data.table

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

readr: read_delim

skip and n_max

col_types with collectors

data.table: fread

fread: more advanced use

Dedicated classes

3

Importing Excel data

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.

List the sheets of an Excel file

Import an Excel sheet

Reading a workbook

The col_names argument

The skip argument

4

Reproducible Excel work with XLConnect

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

Introduction to Importing Data in R

Kurs
slutförd

Tjäna ett prestationsbevis

Lägg till det här beviset i din LinkedIn-profil, ditt CV eller din meritförteckning
Dela det i sociala medier och i din medarbetarutvärderingRegistrera dig nu

Gå med 19 miljoner lärande och börja Introduction to Importing Data in R idag!

Utveckla dina datakunskaper med DataCamp för mobilen

Gör framsteg när du är på språng med våra mobila kurser och dagliga 5-minuters kodningsutmaningar.