Urban Commute Mobility, Traffic Delays, and Sustainable Transit Perception Survey Dataset
Description
Overview: This dataset contains 2,127 structured survey responses examining daily urban commuting habits, traffic delay durations, primary travel annoyances, peak-hour safety and comfort perceptions, critical route bottlenecks, and commuter willingness to shift toward sustainable transit modes. The data supports statistical analysis and machine learning applications in urban mobility, transport planning, and commuter behavior modeling. Data Collection & Preprocessing: Raw survey records were extracted from a 22-page tabular document, reconstructed using coordinate-based layout parsing to separate concatenated text fields, standardized to UTF-8 CSV format, and validated for data integrity. The cleaned dataset contains 2,127 complete records across 8 variables with 0 missing or null values. Dataset Schema & Variables (8 Columns): 1. Timestamp: Date and time of survey response submission (10/09/2026 to 10/10/2026). 2. Primary Commute Mode: Categorical variable indicating daily travel mode (Hybrid / Combination of multiple modes, Rideshare / Cab / Auto-rickshaw, Walking or Cycling, Public Transit, Personal Vehicle). 3. Average Daily Time Lost to Delays: Categorical time interval lost to traffic jams or signal delays (Rarely experience delays, Less than 15 minutes, 15 - 30 minutes, 30 - 60 minutes, More than 1 hour per day). 4. Single Biggest Travel Annoyance: Primary source of commuter frustration (High transport/fuel costs and parking hassles, Unpredictable traffic bottlenecks, Poor road conditions, Overcrowded transit, Lack of safe pedestrian/cycle lanes). 5. Peak-Hour Safety & Comfort Rating: Quantitative ordinal rating from 1 (Least Safe/Comfortable) to 5 (Most Safe/Comfortable) [Mean = 2.98, Median = 3.0, SD = 1.42]. 6. Unsafe or Frustrating Route Hotspot: Specific urban intersection, station, or road bottleneck identified by respondents (City Center Metro station exit, Station Square underpass, Outer Ring Road slip road, Central Bus Stand junction, MG Road flyover intersection, North Avenue bottleneck, Main Campus Gate signal, Market Street pedestrian crossing). 7. Desired Improvement for Sustainable Transit Switch: Key policy or infrastructure improvement needed to encourage switching to bus, train, cycling, or walking. 8. Daily Impact of Delayed Commute: Reported effect of commute delays on the respondent's day (Financial strain, Increased physical fatigue or mental stress, Reduced personal/free time, Lower productivity at school/work, Little to no impact). Files Included: - Urban_Commute_Survey_Cleaned_Dataset.csv: Complete cleaned tabular dataset (2,127 rows x 8 columns). - Urban_Commute_Survey_Charts_and_Graphs_v2.zip: Archive containing 10 high-resolution (300 DPI) statistical visualizations, including variable distribution bar charts, bivariate cross-tabulation heatmaps, and an executive summary dashboard.
Files
Steps to reproduce
1. Data Collection: A structured questionnaire comprising 7 core urban mobility questions (covering primary commute mode, daily delay duration, biggest travel annoyance, peak-hour safety rating on a 1-5 scale, unsafe route bottlenecks, desired sustainable transit improvements, and daily commute impact) was administered to urban commuters, yielding 2,127 timestamped responses. 2. Data Extraction & Cleaning: Raw tabular records from the survey export (Aiml IA Dataset.pdf) were parsed in Python using coordinate-based text extraction (pypdf / pandas) to accurately separate adjacent column boundaries and multi-line headers. 3. Standardization & Validation: Unicode en-dashes in time-interval strings were normalized to standard ASCII hyphens, safety ratings were cast to integer types (1 to 5), and the dataset was validated to ensure 0 missing or null values across all 2,127 rows and 8 columns before exporting to UTF-8 CSV format (Urban_Commute_Survey_Cleaned_Dataset.csv). 4. Statistical Visualization: Using Python (matplotlib and seaborn), 10 high-resolution (300 DPI) visualizations—including univariate frequency/percentage bar charts, bivariate cross-tabulation heatmaps, and a 4-panel executive summary dashboard—were generated and packaged into Urban_Commute_Survey_Charts_and_Graphs_v2.zip.
Institutions
- Bharati Vidyapeeth Deemed UniversityMaharashtra, Pune