Quantitative Methods of Analysis in Transportation

Materials to be used at the MQAT course

Website and E-book

This repository complements the materials available at:

• Website
• E-book

These are not official materials of the course, but they can be used as complementary resources.

Content

• R scripts to prepare the databases
• R scripts for "hand-on" R programming classes
• Database on IMOB trips AML 2018 (refer to INE 2018)
• Database of AML administrative boundaries and areas at freguesia level (DICOFRE), from CAOP 2022 (refer to DGTerritório/CAOP)
• Database of socio-demographic statistics from Census 2021 for the AML at BGRI level (refer to INE Census 2021 for other downloads), including these variables

Download R and RStudio

Instructions for installing R and RStudio.

For classes and home assignments

Introduction to R

• R script for R_Basics.R
• Database of IMOB trips at municipal level: TRIPSmode_mun.Rds

Exploratory Data Analysis

• R script for Exploratory Data Analysis
• Database of IMOB trips at a district level (Freguesias): IMOBmodel.Rds

Multiple Linear Regression

• R script for Multiple Linear Regression
• Database of IMOB trips at a district level: IMOBmodel.Rds

Exploratory Factor Analysis

• R script for Exploratory Factor Analysis
• Database of Residential location satisfaction in the Lisbon metropolitan are: example_fact.sav.

Cluster Analysis

• R script for Cluster Analysis
• Database of international airports: Data_Aeroports_Clustersv1

GIS for Transportation

• R scripts and results for the QGIS exercises in R
• Data used, under geo folder

Other materials

• Getting Started with Data in R

• A gentle introduction to tidy statistics in R (video)

• Work with data, Tidy your data, Report reproducibility (tutorials)

• Intro to R basics (free online course)

• Data Frames in R (free online course with video)

• CheatSheet of Data transformation with dplyr: pay attention to filter(), select(), distinct(), arrange(), mutate(), group_by() & summarize(), left_join()

• CheatSheet of Data transformation with tidyr: pay attention to pivot_longer(), pivot_wider()