Show code
import numpy as np
import pandas as pd
import polars as pl
import duckdb as db
import plotly.express as px
import folium
from folium.plugins import Fullscreen
Mexico’s Airports
Major International Airports
- Mexico City International Airport (MEX)
As the busiest airport in Mexico, Mexico City International Airport serves as a major hub for both domestic and international flights. Located on the outskirts of the city, it offers connections to numerous destinations worldwide.
- Cancun International Airport (CUN)
Situated on the Caribbean coast, Cancún International Airport is a popular gateway for travelers seeking sun, sand, and turquoise waters. It serves as the main airport for the popular resort town of Cancún and the surrounding Riviera Maya region.
- Guadalajara International Airport (GDL)
Located in the second-largest city in Mexico, Guadalajara International Airport is a significant transportation hub, connecting the city to major domestic and international destinations. It is also a gateway to the Tequila region, famous for its production of the iconic Mexican spirit.
Regional Airports
Mexico also has a network of regional airports that serve smaller cities and popular tourist destinations. Some of the notable ones include:
- Puerto Vallarta International Airport (PVR)
Located on the Pacific coast, Puerto Vallarta International Airport is a popular gateway for travelers seeking a more relaxed atmosphere. It serves the coastal resort town of Puerto Vallarta and the surrounding area.
- Los Cabos International Airport (SJD)
Situated on the southern tip of the Baja California peninsula, Los Cabos International Airport is a popular destination for luxury travelers. It serves the resort towns of Cabo San Lucas and San José del Cabo.
- Monterrey International Airport (MTY)
Located in the industrial city of Monterrey, Monterrey International Airport is a significant transportation hub for northern Mexico. It serves as a gateway to the city and the surrounding region.
Facilities and Services
Mexican airports generally offer a range of facilities and services to ensure a comfortable and convenient travel experience. These may include:
- Restaurants and cafes: Offering a variety of cuisines to satisfy different tastes.
- Shopping: Shops selling souvenirs, electronics, and other items.
- Currency exchange: Conveniently located for travelers to exchange foreign currency.
- Luggage storage: For travelers who need to store their luggage temporarily.
- WiFi: Providing internet access for travelers.
Environment settings
Data preparation
Show code
# read table from database
conn = db.connect('my_database.db')Show code
# create dataframe
df = conn.sql('select * from airports').pl()Show code
# close database connection
conn.close()Show code
# select relevant columns
df = df.select('Airport ID','Name','Country','City','Latitude','Longitude','Altitude')Show code
# top 20 countries with most airports
top20 = (
df.group_by(['Country'], maintain_order=True)
.agg(pl.len().alias('Airports'))
.sort('Airports', descending=True)
.head(20)
)World Airports by Country
Show code
table = df.select('Name','Country','City',)Show code
with pl.Config(tbl_rows=30):
print(table)shape: (7_698, 3)
┌─────────────────────────────────┬──────────────────┬─────────────────────┐
│ Name ┆ Country ┆ City │
│ --- ┆ --- ┆ --- │
│ str ┆ str ┆ str │
╞═════════════════════════════════╪══════════════════╪═════════════════════╡
│ Goroka Airport ┆ Papua New Guinea ┆ Goroka │
│ Madang Airport ┆ Papua New Guinea ┆ Madang │
│ Mount Hagen Kagamuga Airport ┆ Papua New Guinea ┆ Mount Hagen │
│ Nadzab Airport ┆ Papua New Guinea ┆ Nadzab │
│ Port Moresby Jacksons Internat… ┆ Papua New Guinea ┆ Port Moresby │
│ Wewak International Airport ┆ Papua New Guinea ┆ Wewak │
│ Narsarsuaq Airport ┆ Greenland ┆ Narssarssuaq │
│ Godthaab / Nuuk Airport ┆ Greenland ┆ Godthaab │
│ Kangerlussuaq Airport ┆ Greenland ┆ Sondrestrom │
│ Thule Air Base ┆ Greenland ┆ Thule │
│ Akureyri Airport ┆ Iceland ┆ Akureyri │
│ Egilsstaðir Airport ┆ Iceland ┆ Egilsstadir │
│ Hornafjörður Airport ┆ Iceland ┆ Hofn │
│ Húsavík Airport ┆ Iceland ┆ Husavik │
│ Ísafjörður Airport ┆ Iceland ┆ Isafjordur │
│ … ┆ … ┆ … │
│ Kalocsa/Foktő Airport ┆ Hungary ┆ Kalocsa/Foktő │
│ Bilogai-Sugapa Airport ┆ Indonesia ┆ Sugapa-Papua Island │
│ Jakkur Aerodrome ┆ India ┆ Bengaluru │
│ Jalal-Abad Airport ┆ Kyrgyzstan ┆ Jalal-Abad │
│ Ramon Airport ┆ Israel ┆ Eilat │
│ Rustaq Airport ┆ Oman ┆ Al Masna'ah │
│ Laguindingan Airport ┆ Philippines ┆ Cagayan de Oro City │
│ Kostomuksha Airport ┆ Russia ┆ Kostomuksha │
│ Privolzhskiy Air Base ┆ Russia ┆ Astrakhan │
│ Kubinka Air Base ┆ Russia ┆ Kubinka │
│ Rogachyovo Air Base ┆ Russia ┆ Belaya │
│ Ulan-Ude East Airport ┆ Russia ┆ Ulan Ude │
│ Krechevitsy Air Base ┆ Russia ┆ Novgorod │
│ Desierto de Atacama Airport ┆ Chile ┆ Copiapo │
│ Melitopol Air Base ┆ Ukraine ┆ Melitopol │
└─────────────────────────────────┴──────────────────┴─────────────────────┘Mexico among the Top 20 Countries with most airports 1
Show code
fig = px.bar(top20, x='Country', y='Airports')
fig.update_traces(marker_color='#7f0000')
fig.update_layout(
template='ggplot2',
width=850,
height=500,
title='Top 20 Countries with Most Airports',
xaxis_tickfont_size=12,
yaxis=dict(
title='Airports',
titlefont_size=16,
tickfont_size=14,
))
fig.show()
NoteInfo
You can hover over the bars on the chart to get further information.
Show code
# convert to pandas
airports = df.to_pandas()Show code
# filter to Mexico subset
airports = airports[airports['Country']=='Mexico'].reset_index()1 Mexico is the 15th country with most airports (counting 84 airports)
Mexico’s Airports Map
Show code
# Mexico airports map
m = folium.Map(
location=[25, -105],
zoom_start=5,
control_scale=False,
)
# Layers
Airports = folium.FeatureGroup(name='<u><b>Airport</b></u>', show=True)
m.add_child(Airports)
#draw marker with symbol you want at base
my_symbol_css_class= """ <style>
.fa-mysymbol3:before {
font-family: Gill Sans;
font-weight: bold;
font-size: 11px;
color: white;
background-color:'';
border-radius: 10px;
white-space: pre;
content: 'P';
}
</style>
"""
# the below is just add above CSS class to folium root map
m.get_root().html.add_child(folium.Element(my_symbol_css_class))
# then we just create marker and specific your css class in icon like below
for i in airports.index:
html=f"""
<p style="font-size: 14px;">Airport: {airports.iloc[i]['Name']}</font></p>
<p style="font-size: 14px;">City: {airports.iloc[i]['City']}</font></p>
"""
iframe = folium.IFrame(html=html, width=280, height=90)
popup = folium.Popup(iframe, max_width=250)
folium.Marker(
location = [airports.iloc[i]['Latitude'], airports.iloc[i]['Longitude']],
icon = folium.Icon(color='darkred', prefix='fa', icon='fa-mysymbol3'),
popup = popup,
tooltip = airports.iloc[i]['Name']
).add_to(Airports)
folium.plugins.Fullscreen().add_to(m)
mMake this Notebook Trusted to load map: File -> Trust Notebook
NoteInfo
You can hover over the icons on the map to get further information and zoom in or out.
Contact
Jesus LM
Economist & Data Scientist