This repository contains our team's Python project, which explores and analyzes a comprehensive world airport dataset. We aim to uncover trends, patterns, and insights related to airport locations, passenger traffic, and infrastructure worldwide through data cleaning, manipulation, and visualization.
Dataset Focus: The project uses the International Airports Dataset, offering a comprehensive overview of global airports.
Dataset Highlights The following CSV files were used in our analysis 1. airports.csv 2. countries.csv 3. navaids.csv 4. regions.csv 5. runways.csv
Data Dictionary:
- id: Unique identifier for each airport.
- ident: Airport’s identifier code (often an ICAO or IATA code).
- type: Type of airport (e.g., "heliport," "small_airport," "medium_airport").
- name: Full name of the airport.
- latitude_deg: Latitude coordinate of the airport in degrees.
- longitude_deg: Longitude coordinate of the airport in degrees.
- elevation_ft: Elevation of the airport above sea level, in feet.
- continent: Continent code where the airport is located.
- iso_country: ISO country code of the airport’s location.
- iso_region: ISO region code (state/province).
- municipality: Primary city or town served by the airport.
- scheduled_service: Indicates if the airport offers scheduled airline services ("yes" or "no").
- gps_code: GPS code (typically matching the ICAO code).
- iata_code: IATA code for the airport.
- local_code: Local code representing the airport. 16-18. Unnamed columns: Extra columns without descriptions or content.
- Unnamed: 0: Unlabeled unique identifier.
- code: Country code in ISO format.
- name: Country name.
- continent: Continent code for the country.
- id: Unique identifier for each runway.
- airport_ref: ID reference to the associated airport.
- airport_ident: Airport identifier where the runway is located.
- length_ft: Runway length in feet.
- width_ft: Runway width in feet.
- surface: Runway surface type (e.g., asphalt, grass).
- lighted: Indicates if the runway is lighted (1 for yes, 0 for no).
- closed: Indicates if the runway is closed (1 for yes, 0 for no).
- le_ident: Identifier for the runway end.
- id: Unique identifier for each navigational aid.
- filename: Name associated with the navigational aid.
- ident: Identifier code for the navigational aid.
- name: Name of the navigational aid.
- type: Type of navigational aid (e.g., NDB, DME).
- frequency_khz: Frequency of the navigational aid in kHz.
- latitude_deg: Latitude of the navigational aid in degrees.
- longitude_deg: Longitude of the navigational aid in degrees.
- elevation_ft: Elevation above sea level in feet.
- iso_country: Country code where the navigational aid is located.
- magnetic_variation_deg: Magnetic variation at the location, in degrees.
- usageType: Type of usage (e.g., LO for low-level usage).
- power: Power level of the navigational aid.
- associated_airport: Identifier of the associated airport.