반응형
[공공데이터] 세계 주요 공항 코드
■ 관련 데이터
| City | Country | Airport Name | IATA Code |
| New York | USA | John F. Kennedy International Airport | JFK |
| Los Angeles | USA | Los Angeles International Airport | LAX |
| Tokyo | Japan | Tokyo International Airport | HND |
| London | UK | Heathrow Airport | LHR |
| Paris | France | Charles de Gaulle Airport | CDG |
| Dubai | UAE | Dubai International Airport | DXB |
| Singapore | Singapore | Changi Airport | SIN |
| Sydney | Australia | Sydney Kingsford Smith Airport | SYD |
| Beijing | China | Beijing Capital International Airport | PEK |
| Hong Kong | China | Hong Kong International Airport | HKG |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
| Amsterdam | Netherlands | Amsterdam Schiphol Airport | AMS |
| Bangkok | Thailand | Suvarnabhumi Airport | BKK |
| Toronto | Canada | Toronto Pearson International Airport | YYZ |
| Frankfurt | Germany | Frankfurt am Main Airport | FRA |
| Seoul | South Korea | Incheon International Airport | ICN |
| Istanbul | Turkey | Istanbul Airport | IST |
| Madrid | Spain | Adolfo Suárez Madrid-Barajas Airport | MAD |
| Rome | Italy | Leonardo da Vinci-Fiumicino Airport | FCO |
| Mexico City | Mexico | Benito Juárez International Airport | MEX |
| Moscow | Russia | Sheremetyevo International Airport | SVO |
Data
import pandas as pd
# Recreate the sample data and extend to make 100 unique entries as the previous state was reset
data = [
{"City": "New York", "Country": "USA", "Airport Name": "John F. Kennedy International Airport", "IATA Code": "JFK"},
{"City": "Los Angeles", "Country": "USA", "Airport Name": "Los Angeles International Airport", "IATA Code": "LAX"},
{"City": "Tokyo", "Country": "Japan", "Airport Name": "Tokyo International Airport", "IATA Code": "HND"},
{"City": "London", "Country": "UK", "Airport Name": "Heathrow Airport", "IATA Code": "LHR"},
{"City": "Paris", "Country": "France", "Airport Name": "Charles de Gaulle Airport", "IATA Code": "CDG"},
{"City": "Dubai", "Country": "UAE", "Airport Name": "Dubai International Airport", "IATA Code": "DXB"},
{"City": "Singapore", "Country": "Singapore", "Airport Name": "Changi Airport", "IATA Code": "SIN"},
{"City": "Sydney", "Country": "Australia", "Airport Name": "Sydney Kingsford Smith Airport", "IATA Code": "SYD"},
{"City": "Beijing", "Country": "China", "Airport Name": "Beijing Capital International Airport", "IATA Code": "PEK"},
{"City": "Hong Kong", "Country": "China", "Airport Name": "Hong Kong International Airport", "IATA Code": "HKG"},
]
additional_entries = [
{"City": "Amsterdam", "Country": "Netherlands", "Airport Name": "Amsterdam Schiphol Airport", "IATA Code": "AMS"},
{"City": "Bangkok", "Country": "Thailand", "Airport Name": "Suvarnabhumi Airport", "IATA Code": "BKK"},
{"City": "Toronto", "Country": "Canada", "Airport Name": "Toronto Pearson International Airport", "IATA Code": "YYZ"},
{"City": "Frankfurt", "Country": "Germany", "Airport Name": "Frankfurt am Main Airport", "IATA Code": "FRA"},
{"City": "Seoul", "Country": "South Korea", "Airport Name": "Incheon International Airport", "IATA Code": "ICN"},
{"City": "Istanbul", "Country": "Turkey", "Airport Name": "Istanbul Airport", "IATA Code": "IST"},
{"City": "Madrid", "Country": "Spain", "Airport Name": "Adolfo Suárez Madrid-Barajas Airport", "IATA Code": "MAD"},
{"City": "Rome", "Country": "Italy", "Airport Name": "Leonardo da Vinci-Fiumicino Airport", "IATA Code": "FCO"},
{"City": "Mexico City", "Country": "Mexico", "Airport Name": "Benito Juárez International Airport", "IATA Code": "MEX"},
{"City": "Moscow", "Country": "Russia", "Airport Name": "Sheremetyevo International Airport", "IATA Code": "SVO"},
] * 9 # Repeat entries to ensure we have enough data
# Combine and truncate to exactly 100 entries
data.extend(additional_entries)
df_full = pd.DataFrame(data).drop_duplicates(subset="IATA Code", keep="first").head(100)
# Save to an Excel file with search functionality (xlsm format for macro support)
final_excel_file_path = '/mnt/data/airport_data_final_unique.xlsm'
df_full.to_excel(final_excel_file_path, index=False, sheet_name="Airports")
final_excel_file_path
■ 관련 자료
airport_data_100.xlsx
0.01MB
airport_data_final_unique.xlsm
0.01MB
airport_data_100_with_search.xlsm
0.01MB
■ 링크
원본 자료의 관련 링크는 아래와 같다.
https://link.coupang.com/a/bY9wBy
미니소화기 파이렉스 FIREX 스프레이식 소화기 가정용 휴대용 차량용 최신제품 당일발송 - 소화기
현재 별점 4.7점, 리뷰 139개를 가진 미니소화기 파이렉스 FIREX 스프레이식 소화기 가정용 휴대용 차량용 최신제품 당일발송! 지금 쿠팡에서 더 저렴하고 다양한 소화기/거치대 제품들을 확인해보
www.coupang.com
https://link.coupang.com/a/bXy1hr
LG전자 시네빔 HU710PB 2024신모델 큐브 4K 빔프로젝터 Qube - 빔/프로젝터 | 쿠팡
쿠팡에서 4.9 구매하고 더 많은 혜택을 받으세요! 지금 할인중인 다른 15 제품도 바로 쿠팡에서 확인할 수 있습니다.
www.coupang.com
"이 포스팅은 쿠팡 파트너스 활동의 일환으로, 이에 따른 일정액의 수수료를 제공받습니다."
■ 기준 날짜
2024.11.1
반응형
'공공 데이터' 카테고리의 다른 글
| [공공데이터] 인천광역시 인천도시경관아카이브 위원회 명단 (2) | 2024.12.02 |
|---|---|
| [공공데이터] 경상남도 밀양시 식품운반업 현황 (0) | 2024.12.02 |
| [공공데이터] 인천광역시 남동구 공공체육시설 현황 (2) | 2024.12.01 |
| [공공데이터] 서울교통공사 연혁 (1) | 2024.12.01 |
| [공공데이터] 전북특별자치도 전주시 아동복지시설 (1) | 2024.11.29 |