Skip to main content

Importing Data in R (Part 1)

Comece O Curso Gratuitamente
11 Videos42 Exercicios

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTreinar 2 ou mais pessoas?Experimente o DataCamp For Business

Loved by learners at thousands of companies

Descrição do Curso

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.

Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.
  1. 1

    Importing data from flat files with utils

    Grátis

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

    Reproduzir Capítulo Agora
    Introduction & read.csv
    50 xp
    read.csv
    100 xp
    stringsAsFactors
    100 xp
    Any changes?
    50 xp
    read.delim & read.table
    50 xp
    read.delim
    100 xp
    read.table
    100 xp
    Arguments
    100 xp
    Column classes
    100 xp
    Final Thoughts
    50 xp
  2. 2

    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.

    Reproduzir Capítulo Agora
    readr: read_csv & read_tsv
    50 xp
    read_csv
    100 xp
    read_tsv
    100 xp
    readr: read_delim
    50 xp
    read_delim
    100 xp
    skip and n_max
    100 xp
    col_types
    100 xp
    col_types with collectors
    100 xp
    data.table: fread
    50 xp
    fread
    100 xp
    fread: more advanced use
    100 xp
    Dedicated classes
    100 xp
  3. 3

    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.

    Reproduzir Capítulo Agora
    readxl (1)
    50 xp
    List the sheets of an Excel file
    100 xp
    Import an Excel sheet
    100 xp
    Reading a workbook
    100 xp
    readxl (2)
    50 xp
    The col_names argument
    100 xp
    The skip argument
    100 xp
    gdata
    50 xp
    Import a local file
    100 xp
    read.xls() wraps around read.table()
    100 xp
    Work that Excel data!
    100 xp
  4. 4

    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!

    Reproduzir Capítulo Agora
    Reading sheets
    50 xp
    Connect to a workbook
    100 xp
    List and read Excel sheets
    100 xp
    Customize readWorksheet
    100 xp
    Adapting sheets
    50 xp
    Add worksheet
    100 xp
    Populate worksheet
    100 xp
    Renaming sheets
    100 xp
    Removing sheets
    100 xp
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Conjuntos De Dados

HotdogsPotatoes (CSV)Potatoes (TSV)Swimming poolsUrban population (XLS)Urban population (XLSX)
Filip Schouwenaars HeadshotFilip Schouwenaars

Data Science Instructor at DataCamp

Veja Mais

O que os outros alunos têm a dizer?

    Cadastre-se mais 13 milhões de alunos e comece Importing Data in R (Part 1) Hoje!

    Create Your Free Account

    GoogleLinkedInFacebook

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.