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

Loading Data Basic Data Summaries Data Manipulation Loading Data 1 2 Basic Data Summaries Data Manipulation 3

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

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand dataframe objects: “Dataframe Structure” “Rearranging Dataframes”

Loading Data Basic Data Summaries Data Manipulation Questions so far?

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

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand dataframe objects: Do the “Loading Data” Tutorial

Loading Data Basic Data Summaries Data Manipulation Summary Statistics Lots of built-in functions to summarize data One important function: summary

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand basic data summaries: “Univariate data summaries” “Correlations”

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

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand tabulation and cross-tabulation: “Tabulation”

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

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand basic plots: “Summary plots” “Plotting colors”

Loading Data Basic Data Summaries Data Manipulation Loading Data 1 2 Basic Data Summaries Data Manipulation 3

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 : outvec <- recode(invec, "old1=new1; old2=new2; else=NA")

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand recoding: “Vector recoding”

Loading Data Basic Data Summaries Data Manipulation Scale Construction Vectorization makes scaling easy Use the usual operators: + - * / ˆ Convenience functions for sums and means

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand scale construction: “Basic Scale Construction”

Loading Data Basic Data Summaries Data Manipulation Missing Data R has one missing data value: NA Best to handle missing data during preprocessing

Loading Data Basic Data Summaries Data Manipulation Try on your own Understand Missing Data: “Missing Data” “Handling Missing Data” “Multiple Imputation”

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

Reconciling the Payroll Ledger June 18, 2019 Basics of Manipulating Data Reconciliation

Presentation is loading The Latency Problem 100 ms Average : 9,3s Loading -1% Revenue The

Handling Missingness Manipulating Time Series Data in R: Case Studies Missingness > citydata

Hash tables Most data structures that were going to see are about storing and manipulating data

How to use Dates & Times with pandas Manipulating Time Series Data in Python Date & Time

DBMS Data Loading: An Analysis on Modern Hardware Adam Dziedzic, Manos Karpathiotakis* , Ioannis

Rearranging and manipulating data Dr. Nomie Becker Dr. Sonja Grath Special thanks to : Dr.

Advanced Features of xts Manipulating Time Series Data in R: Case Studies Finding Endpoints

Select Index Components & Import Data Manipulating Time Series Data in Python Market

Compare Time Series Growth Rates Manipulating Time Series Data in Python Comparing Stock

Loading data into x ts object FOR E C ASTIN G P R OD U C T D E MAN D IN R Aric LaBarr , Ph . D

The Loading Spinner AKA, the throbber Why do we have loading spinners? Purpose: tells the

Rolling Window Functions with Pandas Manipulating Time Series Data in Python Window Functions in

D3 Tutorial Data Binding and Loading Edit by Jiayi Xu and Han-Wei Shen, The Ohio State University

LOADING & HANDLING OF ROLLED CELLULOSE HOW DOES IT DIFFER FROM LOADING & HANDLING OF

Documentation Training Import Wizard and Loading Data Joo Oliveira, Jos Maria Lima, Snia

Data-loading (for ML applications) using TDFs Stefan Wunsch stefan.wunsch@cern.ch 2018-02-22 1

Using Cafana to do DUNE-prism fit - Weve been using Cafana for fits so far to demonstrate the

Combined Loading 1 Lecture 6 ME EN 372 Andrew Ning aning@byu.edu Outline Bar with Combined

Welcome! Please Sit with Someone Surprising 1

EuCARD Magnet R & D prepared by Attilio Milanese CERN LARP Collaboration Meeting 15 1-3

branch (branch_name, branch_city, assets) customer (customer_name, customer_street,

CDBG - Economic Development Revolving Loan Fund Updates Sar Sara Bu a Buschman an, Di ,

Widening Participations Winners & Losers Will Cooling University of Leicester, Senior

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

Reconciling the Payroll Ledger June 18, 2019 Basics of Manipulating Data Reconciliation

Presentation is loading The Latency Problem 100 ms Average : 9,3s Loading -1% Revenue The

Handling Missingness Manipulating Time Series Data in R: Case Studies Missingness &gt; citydata

Hash tables Most data structures that were going to see are about storing and manipulating data

How to use Dates &amp; Times with pandas Manipulating Time Series Data in Python Date &amp; Time

DBMS Data Loading: An Analysis on Modern Hardware Adam Dziedzic, Manos Karpathiotakis* , Ioannis

Rearranging and manipulating data Dr. Nomie Becker Dr. Sonja Grath Special thanks to : Dr.

Advanced Features of xts Manipulating Time Series Data in R: Case Studies Finding Endpoints

Select Index Components &amp; Import Data Manipulating Time Series Data in Python Market

Compare Time Series Growth Rates Manipulating Time Series Data in Python Comparing Stock

Loading data into x ts object FOR E C ASTIN G P R OD U C T D E MAN D IN R Aric LaBarr , Ph . D

The Loading Spinner AKA, the throbber Why do we have loading spinners? Purpose: tells the

Rolling Window Functions with Pandas Manipulating Time Series Data in Python Window Functions in

D3 Tutorial Data Binding and Loading Edit by Jiayi Xu and Han-Wei Shen, The Ohio State University

LOADING &amp; HANDLING OF ROLLED CELLULOSE HOW DOES IT DIFFER FROM LOADING &amp; HANDLING OF

Documentation Training Import Wizard and Loading Data Joo Oliveira, Jos Maria Lima, Snia

Data-loading (for ML applications) using TDFs Stefan Wunsch stefan.wunsch@cern.ch 2018-02-22 1

Using Cafana to do DUNE-prism fit - Weve been using Cafana for fits so far to demonstrate the

Combined Loading 1 Lecture 6 ME EN 372 Andrew Ning aning@byu.edu Outline Bar with Combined

Welcome! Please Sit with Someone Surprising 1

EuCARD Magnet R &amp; D prepared by Attilio Milanese CERN LARP Collaboration Meeting 15 1-3

branch (branch_name, branch_city, assets) customer (customer_name, customer_street,

CDBG - Economic Development Revolving Loan Fund Updates Sar Sara Bu a Buschman an, Di ,

Widening Participations Winners &amp; Losers Will Cooling University of Leicester, Senior

Handling Missingness Manipulating Time Series Data in R: Case Studies Missingness > citydata

How to use Dates & Times with pandas Manipulating Time Series Data in Python Date & Time

Select Index Components & Import Data Manipulating Time Series Data in Python Market

LOADING & HANDLING OF ROLLED CELLULOSE HOW DOES IT DIFFER FROM LOADING & HANDLING OF

EuCARD Magnet R & D prepared by Attilio Milanese CERN LARP Collaboration Meeting 15 1-3

Widening Participations Winners & Losers Will Cooling University of Leicester, Senior