Loading and Manipulating Data Thomas J. Leeper Department of - - PowerPoint PPT Presentation

loading and manipulating data
SMART_READER_LITE
LIVE PREVIEW

Loading and Manipulating Data Thomas J. Leeper Department of - - PowerPoint PPT Presentation

Loading Data Basic Data Summaries Data Manipulation Loading and Manipulating Data Thomas J. Leeper Department of Political Science and Government Aarhus University November 14, 2013 Loading Data Basic Data Summaries Data Manipulation


slide-1
SLIDE 1

Loading Data Basic Data Summaries Data Manipulation

Loading and Manipulating Data

Thomas J. Leeper

Department of Political Science and Government Aarhus University

November 14, 2013

slide-2
SLIDE 2

Loading Data Basic Data Summaries Data Manipulation

slide-3
SLIDE 3

Loading Data Basic Data Summaries Data Manipulation

1

Loading Data

2

Basic Data Summaries

3

Data Manipulation

slide-4
SLIDE 4

Loading Data Basic Data Summaries Data Manipulation

1

Loading Data

2

Basic Data Summaries

3

Data Manipulation

slide-5
SLIDE 5

Loading Data Basic Data Summaries Data Manipulation

Data as Dataframe

Typically use data in a “dataframe” Not restricted to one dataframe at a time Functions to load data all create a dataframe Statistical functions accept vectors or dataframes

slide-6
SLIDE 6

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand dataframe objects: “Dataframe Structure” “Rearranging Dataframes”

slide-7
SLIDE 7

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-8
SLIDE 8

Loading Data Basic Data Summaries Data Manipulation

Loading Data

There’s no “open” button A functions for each file format:

CSV: read.csv TSV: read.delim Stata: read.dta (from foreign) SPSS: read.spss (from foreign)

Almost anything can be loaded

slide-9
SLIDE 9

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand dataframe objects: Do the “Loading Data” Tutorial

slide-10
SLIDE 10

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-11
SLIDE 11

Loading Data Basic Data Summaries Data Manipulation

Summary Statistics

Lots of built-in functions to summarize data One important function: summary

slide-12
SLIDE 12

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand basic data summaries: “Univariate data summaries” “Correlations”

slide-13
SLIDE 13

Loading Data Basic Data Summaries Data Manipulation

Summary Tables

Tabulation is easy with table Creates univariate tables and cross-tables Tables are objects (of class “table”), so we can work with them like any other object

slide-14
SLIDE 14

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand tabulation and cross-tabulation: “Tabulation”

slide-15
SLIDE 15

Loading Data Basic Data Summaries Data Manipulation

Summary Plots

Visualization is one of R’s greatest strengths One important function: plot Many other functions for specific types of plots Basic plots look okay Plots can be made beautiful with a little work

slide-16
SLIDE 16

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand basic plots: “Summary plots” “Plotting colors”

slide-17
SLIDE 17

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-18
SLIDE 18

Loading Data Basic Data Summaries Data Manipulation

1

Loading Data

2

Basic Data Summaries

3

Data Manipulation

slide-19
SLIDE 19

Loading Data Basic Data Summaries Data Manipulation

Recoding vectors

Recoding is all about indexing Several different ways to do it. The car package has a nice function: recode:

  • utvec <- recode(invec, "old1=new1;
  • ld2=new2; else=NA")
slide-20
SLIDE 20

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand recoding: “Vector recoding”

slide-21
SLIDE 21

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-22
SLIDE 22

Loading Data Basic Data Summaries Data Manipulation

Scale Construction

Vectorization makes scaling easy Use the usual operators: + - * / ˆ Convenience functions for sums and means

slide-23
SLIDE 23

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand scale construction: “Basic Scale Construction”

slide-24
SLIDE 24

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-25
SLIDE 25

Loading Data Basic Data Summaries Data Manipulation

Missing Data

R has one missing data value: NA Best to handle missing data during preprocessing

slide-26
SLIDE 26

Loading Data Basic Data Summaries Data Manipulation

Try on your own

Understand Missing Data: “Missing Data” “Handling Missing Data” “Multiple Imputation”

slide-27
SLIDE 27

Loading Data Basic Data Summaries Data Manipulation

Questions so far?

slide-28
SLIDE 28