Quantitative Methods of Analysis in Transportation

Materials to be used at the MQAT course

Includes

• R script to prepare the databases
• R scripts for a "follow-me" classes
• db on IMOB trips AML 2018 (see INE 2018)
• db of AML administrative boundaries and areas at freguesia level (DICOFRE), from CAOP 2022 (see DGTerritório/CAOP)
• db of socio-demographic statistics from Census 2021 for the AML at BGRI level (see INE Census 2021 for other downloads)
  • includes this variables

For classes and home assignments

Introduction to R

• Script of R basics - R_Basics.R
• Database of IMOB trips at municipal level: TRIPSmode_mun.Rds

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()

Linear Regression

Variables included in MODEL database:

• Origin_dicofre16 - Code of Freguesias as set by INE after 2016 (Distrito + Concelho + Freguesia)
• Total - number of trips with origin in Origin_dicofre16
• Walk - number of walking trips with origin in Origin_dicofre16
• Bike - number of bike trips with origin in Origin_dicofre16
• Car - number of car trips with origin in Origin_dicofre16. Includes taxi and motorcycle.
• PTransit - number of Public Transit trips with origin in Origin_dicofre16
• Other - number of other trips (truck, van, tractor, aviation) with origin in Origin_dicofre16
• Distance - average trip distance (km) with origin in Origin_dicofre16
• Duration - average trip duration (minutes) with origin in Origin_dicofre16
• Car_perc - percentage of car trips with origin in Origin_dicofre16
• N_INDIVIDUOS - number of residents in Origin_dicofre16 (Censos 2021)
• Male_perc - percentage of male residents in Origin_dicofre16 (Censos 2021)
• IncomeHH - average household income in Origin_dicofre16
• Nvehicles - average number of car/motorcycle vehicles in the household in Origin_dicofre16
• DrivingLic - percentage of car driving licence holders in Origin_dicofre16
• CarParkFree_Work - percentage of respondents with free car parking at the work location, in Origin_dicofre16
• PTpass - percentage of public transit monthly pass holders in Origin_dicofre16
• internal - binary variable (factor). "Yes": internal trips in that freguesia (Origin_dicofre16), "No": external trips from that freguesia
• Lisboa - binary variable (factor). "Yes": the freguesia is part of Lisbon municipality, "No": otherwise
• Area_km2 - area of in Origin_dicofre16, in km2

Factor and Cluster Analysis

• R script for Exploratory Factor Analysis
• R script for Cluster Analysis