In this notebook we prepare a data object with the table used in Páez, Antonio. "Mapping travelers’ attitudes: does space matter?." Journal of Transport Geography 26 (2013): 117-125.
Clear environment:
rm(list = ls())
Load packages used in the notebook:
library(readxl) library(tidyverse) #library(MASS) #library(reshape2) #library(plyr) #library(kableExtra) #library(gridExtra)
Load dataframe:
mc_attitudes <- read_excel("input-data-files/Individual+DA Data+Built Environment.xls")
Select and pre-process variables:
mc_attitudes <- mc_attitudes %>% transmute(id = ID, choice = factor(MODE, levels = c( "Car", "HSR","Walk")), LAT, LONG, license = factor(case_when(License == "YES" ~ "Yes", License == "NO" ~ "No")), vehicle = factor(case_when(Vehicle == "YES" ~ "Yes", Vehicle == "NO" ~ "No")), gender = factor(case_when(Gender == "FEMALE" ~ "Woman", Gender == "MALE" ~ "Man")), age = Age, visa = factor(case_when(Visa == "CANADIAN" ~ "Domestic", Visa == "INTERNATIONAL" ~ "International")), living_arrangements = factor(case_when(Living == 1 ~ "With family/relatives", Living == 3 ~ "By myself", Living == 4 ~ "Off-campus shared accommodations")), level = factor(case_when(Level == 1 ~ "UG I", Level == 2 ~ "UG II", Level == 3 ~ "UG III", Level == 4 ~ "UG IV", Level == 5 ~ "UG V", Level == 6 ~ "Masters", Level == 7 ~ "PhD", Level == 8 ~ "Other", Level == 9 ~ "Other")), Active_Neighborhood = factor(ACTIVE_NEIGHBORHOOD, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), Community = factor(COMMUNITY, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), Neighbors = factor(NEIGHBORS, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), Safe_Walk= factor(SAFE_WALK, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), Shops_Important = factor(SHOPS_IMPORTANT, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), Travel_Alone = factor(TRAVEL_ALONE, levels = c("STRONGLY DISAGREE", "DISAGREE", "NEUTRAL", "AGREE", "STRONGLY AGREE"), ordered = TRUE), DAUID, Rate_Couple_Child = RateCoupleChild, Rate_SW_Child = RateFemLone, Rate_SM_Child = RateMaleLone, Mean_Children = AvgChild, Rate_Non_Canadian = RateNonCanadian, Median_HH_Income = MedIncome, Mean_HH_Income = MHI, Rate_Unemployment = UnempRate, Rate_1yr_Move = RateMob1Mover, Rate_5yr_Move = RateMob5Mover, Rate_Public = RatePublic, Rate_Walk = RateWalk, Rate_Cycle = RateCycle, AREA = AREA_SQKM, LUM, SIDEWALK_DENSITY = SIDEWALK_D, STREET_DENSITY = STREET_DEN, INTERSECTION_DENSITY = INTER_DENS, SF_P_RATIO, EMPLOYMENT_DENSITY = EMPLOY_DEN, POPULATION_DENSITY = POP_DENSIT)
Scale income variables:
mc_attitudes <- mc_attitudes %>% mutate(Median_HH_Income = Median_HH_Income/10000, Mean_HH_Income = Mean_HH_Income/10000)
Scale density variables:
mc_attitudes <- mc_attitudes %>% mutate(EMPLOYMENT_DENSITY = EMPLOYMENT_DENSITY/10000, POPULATION_DENSITY = POPULATION_DENSITY/10000)
Save data:
usethis::use_data(mc_attitudes, overwrite = TRUE)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.