Question: Using the 2 0 1 9 - 2 0 2 2 Queensland Household Travel Survey ( HTS ) data provided in this course, perform the
Using the Queensland Household Travel Survey HTS data provided in this course, perform the following tasks with Python to analyse the mode split by gender in the Sunshine Coast region. Refer to Week Tutorial and ICT slides for guidance.
Specifically, we are interested in calculating the number of trips by gender and transport mode based on the HTS data.
Load the five main HTS survey data files into seperate Pandas DataFrames.
Convert all column names and string data to lowercase to ensure ease of access and consistency.
Merge the 'trip' DataFrame with the 'household' DataFrame to associate each trip with its household's Local Government Area LGA
Merge the resulting DataFrame with the 'person' DataFrame to link each trip with the trip maker's gender sex information.
Filter this merged DataFrame to identify the number of bicycle trips made by males in the Sunshine Coast region.
Print this value.
What is the number of bicycle trips made by males in the Sunshine Coast region?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
