from IPython.display import HTML
import requests
HTML(requests.get("https://git.io/fh5WI").text)

Python and Jupyter for Programmers

Part 4: Analyzing Data with Pandas

1. Working with Pandas DataFrames

Pandas is one of the most popular Python libraries used for data analysis.

import pandas as pd

Here is a link to a csv file with data about airports around the world:


https://git.io/fhdpp

Read a csv file with airport data:

df = pd.read_csv("https://git.io/fhdpp")
df

Select a column:

df['elevation_ft']

0           11.0
1         3435.0
2          450.0
3          820.0
4          237.0
5         1100.0
6         3810.0
7         3038.0
8           87.0
9         3350.0
10        4830.0
11          53.0
12          25.0
13          35.0
14         700.0
15         957.0
16          43.0
17        2064.0
18        3359.0
19         600.0
20         840.0
21         634.0
22         820.0
23        1100.0
24        1265.0
25          15.0
26         600.0
27          12.0
28          45.0
29         588.0
          ...   
55003        NaN
55004      706.0
55005       80.0
55006      568.0
55007      984.0
55008      548.0
55009        NaN
55010      457.0
55011     8530.0
55012        NaN
55013      262.0
55014        NaN
55015      760.0
55016        NaN
55017      791.0
55018    12816.0
55019      883.0
55020     1836.0
55021      477.0
55022      459.0
55023     1240.0
55024      107.0
55025     1200.0
55026      198.0
55027      624.0
55028        0.0
55029        NaN
55030       40.0
55031       11.0
55032      338.0
Name: elevation_ft, Length: 55033, dtype: float64

Select several columns:

df[['type', 'name', 'id']]

Select a range of rows:

df[10:20]

Select one row:

df.iloc[10]

id                         6529
ident                      00CO
type                     closed
name                 Cass Field
latitude_deg            40.6222
longitude_deg          -104.344
elevation_ft               4830
continent                   NaN
iso_country                  US
iso_region                US-CO
municipality         Briggsdale
scheduled_service            no
gps_code                    NaN
iata_code                   NaN
local_code                  NaN
home_link                   NaN
wikipedia_link              NaN
keywords                   00CO
Name: 10, dtype: object

Summary of the elevation column:

df['elevation_ft'].describe()

count    48042.000000
mean      1240.580221
std       1602.009446
min      -1266.000000
25%        205.000000
50%        718.000000
75%       1496.750000
max      22000.000000
Name: elevation_ft, dtype: float64

df['elevation_ft'].min()

-1266.0

Find the row number with the smallest elevation:

min_row = df['elevation_ft'].idxmin()
min_row

31877

df.iloc[min_row]

id                                                               4421
ident                                                            LLMZ
type                                                   medium_airport
name                                              Bar Yehuda Airfield
latitude_deg                                                  31.3282
longitude_deg                                                 35.3886
elevation_ft                                                    -1266
continent                                                          AS
iso_country                                                        IL
iso_region                                                       IL-D
municipality                                                   Masada
scheduled_service                                                  no
gps_code                                                         LLMZ
iata_code                                                         MTZ
local_code                                                        NaN
home_link                                                         NaN
wikipedia_link       http://en.wikipedia.org/wiki/Bar_Yehuda_Airfield
keywords                                              Masada Airfield
Name: 31877, dtype: object

Find all airports with elevation below -100 ft:

df['elevation_ft'] < -100

0        False
1        False
2        False
3        False
4        False
5        False
6        False
7        False
8        False
9        False
10       False
11       False
12       False
13       False
14       False
15       False
16       False
17       False
18       False
19       False
20       False
21       False
22       False
23       False
24       False
25       False
26       False
27       False
28       False
29       False
         ...  
55003    False
55004    False
55005    False
55006    False
55007    False
55008    False
55009    False
55010    False
55011    False
55012    False
55013    False
55014    False
55015    False
55016    False
55017    False
55018    False
55019    False
55020    False
55021    False
55022    False
55023    False
55024    False
55025    False
55026    False
55027    False
55028    False
55029    False
55030    False
55031    False
55032    False
Name: elevation_ft, Length: 55033, dtype: bool

df[df['elevation_ft'] < -100]

Add a new column with elevations in meters:

df['elevation_meters'] = df['elevation_ft']/3.28
df

Count the number of airports of each type:

df['type'].value_counts()

small_airport     33965
heliport          11276
medium_airport     4547
closed             3581
seaplane_base      1015
large_airport       626
balloonport          23
Name: type, dtype: int64

go top

2. Plotting Airport Locations

Goal: Use Bokeh to plot locations of all airports.

import bokeh.plotting as bk
bk.output_notebook() # show plots in the notebook

w = 750
h = 400

p = bk.figure(plot_width=w, plot_height=h)
p.circle(df["longitude_deg"], df["latitude_deg"], size=2, color='red', alpha = 0.1)
bk.show(p)

Background map:

from bokeh.tile_providers import CARTODBPOSITRON_RETINA as world_map

left = -20_000_000
right = 20_000_000
top = 1_000_000
bottom = -1_000_000

p = bk.figure(plot_width=w, 
              plot_height=h,  
              x_range=(left, right), 
              y_range=(top,bottom))

p.add_tile(world_map)
bk.show(p)

From latitude and longitude to Mercator coordinates

Note:

The data gives airport coordinates in terms of longitude and latitude.
The map uses the Mercator coordinates $(x, y)$.
In order to plot airports on the map we need to recalculate their coordinates:

$$ \left\{ \begin{align} x \ \ = & \ \ \frac{R\cdot \pi}{180}\cdot {\text{longitude}} \\[2mm] y \ \ = & \ \ R\cdot \log\left(\tan \left({\frac{360}{\pi}}\cdot{\text{latitude}} + \frac{\pi}{4} \right) \right) \end{align} \right. $$ $ R =$ radius of the Earth = 6,378,137 meters.

import numpy as np

R = 6378137

def lon2x(lon):
    x = R*(np.pi/180)*lon
    return x

def lat2y(lat):
    y = R*np.log(np.tan((np.pi/360.0)*lat + np.pi/4.0))
    return y

Add new columns to the dataframe with Mercator coordinates of airports:

df['x'] = lon2x(df["longitude_deg"])
df['y'] = lat2y(df["latitude_deg"])
df

Plot airports on the map:

from bokeh.tile_providers import CARTODBPOSITRON_RETINA as world_map

p = bk.figure(plot_width=w, 
              plot_height=h,   
              x_axis_type="mercator", 
              y_axis_type="mercator",
              x_range=(left, right), 
              y_range=(top, bottom))

p.add_tile(world_map)
p.circle(df["x"], df["y"], radius=400, color = "red", alpha=0.5)

bk.show(p)

from bokeh.models import HoverTool, OpenURL, TapTool


myhover = HoverTool(tooltips= [('Name: ', '@name'), 
                               ('Type: ', '@type'), 
                               ("Wikipedia: ", "@wikipedia_link")])

TOOLS = ['crosshair', 'wheel_zoom', 'box_zoom', 'reset', 'box_select', 'pan', myhover, 'tap']


#get Buffalo airport data
buf = df[df['name'].str.contains("Buffalo Niagara")].iloc[0]
#get coordinates of the Buffalo airport
buf_x = buf['x']
buf_y = buf['y']

radius = 50000

p = bk.figure(plot_width=750, 
              plot_height=500,
              x_axis_type="mercator", 
              y_axis_type="mercator",
              x_range=(buf_x - radius, buf_x + radius), 
              y_range=(buf_y - radius, buf_y + radius), 
              #x_range=(-8_800_000, -8_750_000), 
              #y_range=(5_250_000, 5_350_000), 
              tools=TOOLS)

taptool = p.select(type=TapTool)
url = "@wikipedia_link"
taptool.callback = OpenURL(url=url)

p.add_tile(world_map)
p.circle(x='x', y='y', radius=600, source = df, color='red', alpha=0.5, hover_color='blue', hover_alpha=0.2)
bk.show(p)

Save the plot to an HTML file:

bk.output_file('plot.html')
bk.save(p)

'/Users/bb/Desktop/CDSE Workshop/plot.html'

☆ ☆ ☆ The End ☆ ☆ ☆

Thank you

</div>

	id	ident	type	name	latitude_deg	longitude_deg	elevation_ft	continent	iso_country	iso_region	municipality	scheduled_service	gps_code	iata_code	local_code	home_link	wikipedia_link	keywords
0	6523	00A	heliport	Total Rf Heliport	40.070801	-74.933601	11.0	NaN	US	US-PA	Bensalem	no	00A	NaN	00A	NaN	NaN	NaN
1	323361	00AA	small_airport	Aero B Ranch Airport	38.704022	-101.473911	3435.0	NaN	US	US-KS	Leoti	no	00AA	NaN	00AA	NaN	NaN	NaN
2	6524	00AK	small_airport	Lowell Field	59.949200	-151.695999	450.0	NaN	US	US-AK	Anchor Point	no	00AK	NaN	00AK	NaN	NaN	NaN
3	6525	00AL	small_airport	Epps Airpark	34.864799	-86.770302	820.0	NaN	US	US-AL	Harvest	no	00AL	NaN	00AL	NaN	NaN	NaN
4	6526	00AR	closed	Newport Hospital & Clinic Heliport	35.608700	-91.254898	237.0	NaN	US	US-AR	Newport	no	NaN	NaN	NaN	NaN	NaN	00AR
5	322127	00AS	small_airport	Fulton Airport	34.942803	-97.818019	1100.0	NaN	US	US-OK	Alex	no	00AS	NaN	00AS	NaN	NaN	NaN
6	6527	00AZ	small_airport	Cordes Airport	34.305599	-112.165001	3810.0	NaN	US	US-AZ	Cordes	no	00AZ	NaN	00AZ	NaN	NaN	NaN
7	6528	00CA	small_airport	Goldstone /Gts/ Airport	35.350498	-116.888000	3038.0	NaN	US	US-CA	Barstow	no	00CA	NaN	00CA	NaN	NaN	NaN
8	324424	00CL	small_airport	Williams Ag Airport	39.427188	-121.763427	87.0	NaN	US	US-CA	Biggs	no	00CL	NaN	00CL	NaN	NaN	NaN
9	322658	00CN	heliport	Kitchen Creek Helibase Heliport	32.727374	-116.459742	3350.0	NaN	US	US-CA	Pine Valley	no	00CN	NaN	00CN	NaN	NaN	NaN
10	6529	00CO	closed	Cass Field	40.622202	-104.344002	4830.0	NaN	US	US-CO	Briggsdale	no	NaN	NaN	NaN	NaN	NaN	00CO
11	6531	00FA	small_airport	Grass Patch Airport	28.645500	-82.219002	53.0	NaN	US	US-FL	Bushnell	no	00FA	NaN	00FA	NaN	NaN	NaN
12	6532	00FD	heliport	Ringhaver Heliport	28.846600	-82.345398	25.0	NaN	US	US-FL	Riverview	no	00FD	NaN	00FD	NaN	NaN	NaN
13	6533	00FL	small_airport	River Oak Airport	27.230900	-80.969200	35.0	NaN	US	US-FL	Okeechobee	no	00FL	NaN	00FL	NaN	NaN	NaN
14	6534	00GA	small_airport	Lt World Airport	33.767502	-84.068298	700.0	NaN	US	US-GA	Lithonia	no	00GA	NaN	00GA	NaN	NaN	NaN
15	6535	00GE	heliport	Caffrey Heliport	33.884201	-84.733902	957.0	NaN	US	US-GA	Hiram	no	00GE	NaN	00GE	NaN	NaN	NaN
16	6536	00HI	heliport	Kaupulehu Heliport	19.832715	-155.980233	43.0	NaN	US	US-HI	Kailua/Kona	no	00HI	NaN	00HI	NaN	NaN	NaN
17	6537	00ID	small_airport	Delta Shores Airport	48.145302	-116.213997	2064.0	NaN	US	US-ID	Clark Fork	no	00ID	NaN	00ID	NaN	NaN	NaN
18	322581	00IG	small_airport	Goltl Airport	39.724028	-101.395994	3359.0	NaN	US	US-KS	McDonald	no	00IG	NaN	00IG	NaN	NaN	NaN
19	6538	00II	heliport	Bailey Generation Station Heliport	41.644501	-87.122803	600.0	NaN	US	US-IN	Chesterton	no	00II	NaN	00II	NaN	NaN	NaN
20	6539	00IL	small_airport	Hammer Airport	41.978401	-89.560402	840.0	NaN	US	US-IL	Polo	no	00IL	NaN	00IL	NaN	NaN	NaN
21	6540	00IN	heliport	St Mary Medical Center Heliport	41.511398	-87.260597	634.0	NaN	US	US-IN	Hobart	no	00IN	NaN	00IN	NaN	NaN	NaN
22	6541	00IS	small_airport	Hayenga's Cant Find Farms Airport	40.025600	-89.122902	820.0	NaN	US	US-IL	Kings	no	00IS	NaN	00IS	NaN	NaN	NaN
23	6542	00KS	small_airport	Hayden Farm Airport	38.727798	-94.930496	1100.0	NaN	US	US-KS	Gardner	no	00KS	NaN	00KS	NaN	NaN	NaN
24	6543	00KY	small_airport	Robbins Roost Airport	37.409401	-84.619698	1265.0	NaN	US	US-KY	Stanford	no	00KY	NaN	00KY	NaN	NaN	NaN
25	45437	00LA	heliport	Shell Chemical East Site Heliport	30.191944	-90.980833	15.0	NaN	US	US-LA	Gonzales	no	00LA	NaN	00LA	NaN	NaN	NaN
26	6544	00LL	heliport	Ac & R Components Heliport	39.665298	-89.705597	600.0	NaN	US	US-IL	Chatham	no	00LL	NaN	00LL	NaN	NaN	NaN
27	6545	00LS	small_airport	Lejeune Airport	30.136299	-92.429398	12.0	NaN	US	US-LA	Esterwood	no	00LS	NaN	00LS	NaN	NaN	NaN
28	6546	00MD	small_airport	Slater Field	38.757099	-75.753799	45.0	NaN	US	US-MD	Federalsburg	no	00MD	NaN	00MD	NaN	NaN	NaN
29	6547	00MI	heliport	Dow Chemical Heliport	43.949402	-86.416702	588.0	NaN	US	US-MI	Ludington	no	00MI	NaN	00MI	NaN	NaN	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
55003	30646	ZYAS	medium_airport	Anshan Air Base	41.105301	122.853996	NaN	AS	CN	CN-21	Anshan	yes	ZYAS	AOG	NaN	NaN	https://en.wikipedia.org/wiki/Anshan_Teng%27ao...	NaN
55004	27237	ZYCC	medium_airport	Longjia Airport	43.996201	125.684998	706.0	AS	CN	CN-22	Changchun	yes	ZYCC	CGQ	NaN	NaN	http://en.wikipedia.org/wiki/Changchun_Longjia...	NaN
55005	300858	ZYCH	medium_airport	Changhai Airport	39.266667	122.666944	80.0	AS	CN	CN-21	Changhai	no	ZYCH	CNI	NaN	NaN	http://en.wikipedia.org/wiki/Changhai_Airport	NaN
55006	30827	ZYCY	medium_airport	Chaoyang Airport	41.538101	120.434998	568.0	AS	CN	CN-21	Chaoyang	yes	ZYCY	CHG	NaN	NaN	https://en.wikipedia.org/wiki/Chaoyang_Airport	NaN
55007	327349	ZYDU	medium_airport	Wudalianchi Dedu Airport	48.445000	126.133000	984.0	AS	CN	CN-23	Wudalianchi	yes	ZYDU	DTU	NaN	NaN	https://en.wikipedia.org/wiki/Wudalianchi_Dedu...	NaN
55008	324338	ZYFX	small_airport	Fuxin Airport	42.069014	121.718122	548.0	AS	CN	CN-21	Fuxin	no	ZYFX	NaN	NaN	NaN	NaN	NaN
55009	313994	ZYFY	medium_airport	Dongji Aiport	48.199494	134.366447	NaN	AS	CN	CN-23	Fuyuan	yes	ZYFY	FYJ	NaN	NaN	https://en.wikipedia.org/wiki/Fuyuan_Dongji_Ai...	NaN
55010	27238	ZYHB	large_airport	Taiping Airport	45.623402	126.250000	457.0	AS	CN	CN-23	Harbin	yes	ZYHB	HRB	NaN	NaN	http://en.wikipedia.org/wiki/Harbin_Taiping_In...	NaN
55011	31576	ZYHE	medium_airport	Heihe Airport	50.171621	127.308884	8530.0	AS	CN	CN-23	Heihe	yes	ZYHE	HEK	NaN	NaN	http://en.wikipedia.org/wiki/Heihe_Airport	NaN
55012	31701	ZYJL	small_airport	Jilin Airport	44.002201	126.396004	NaN	AS	CN	CN-22	Jilin	no	ZYJL	JIL	NaN	NaN	https://en.wikipedia.org/wiki/Jilin_Ertaizi_Ai...	NaN
55013	27239	ZYJM	medium_airport	Jiamusi Airport	46.843399	130.464996	262.0	AS	CN	CN-23	Jiamusi	yes	ZYJM	JMU	NaN	NaN	http://en.wikipedia.org/wiki/Jiamusi_Airport	NaN
55014	327450	ZYJS	medium_airport	Jiansanjiang Airport	47.110000	132.660278	NaN	AS	CN	CN-23	Jiansanjiang	yes	ZYJS	JSJ	NaN	NaN	https://en.wikipedia.org/wiki/Jiansanjiang_Air...	NaN
55015	313337	ZYJX	medium_airport	Jixi Xingkaihu Airport	45.293000	131.193000	760.0	AS	CN	CN-23	Jixi	yes	ZYJX	JXA	NaN	NaN	http://en.wikipedia.org/wiki/Jixi_Xingkaihu_Ai...	NaN
55016	31706	ZYJZ	medium_airport	Jinzhou Airport	41.101398	121.061997	NaN	AS	CN	CN-21	Jinzhou	yes	ZYJZ	JNZ	NaN	NaN	http://en.wikipedia.org/wiki/Jinzhou_Airport	Xiaolingzi Air Base
55017	307012	ZYLD	medium_airport	Lindu Airport	47.752056	129.019125	791.0	AS	CN	CN-23	Yichun	yes	ZYLD	LDS	NaN	NaN	http://en.wikipedia.org/wiki/Yichun_Lindu_Airport	Yichun Shi Airport
55018	300516	ZYLS	medium_airport	Yushu Batang Airport	32.836389	97.036389	12816.0	AS	CN	CN-63	Yushu	no	ZYLS	YUS	NaN	NaN	http://en.wikipedia.org/wiki/Yushu_Batang_Airport	NaN
55019	27240	ZYMD	medium_airport	Mudanjiang Hailang International Airport	44.524101	129.569000	883.0	AS	CN	CN-23	Mudanjiang	yes	ZYMD	MDG	NaN	NaN	http://en.wikipedia.org/wiki/Mudanjiang_Airport	Mudanjiang
55020	301193	ZYMH	medium_airport	Gu-Lian Airport	52.912778	122.430000	1836.0	AS	CN	CN-23	Mohe	yes	ZYMH	OHE	NaN	NaN	http://en.wikipedia.org/wiki/Mohe_Gulian_Airport	NaN
55021	27241	ZYQQ	medium_airport	Qiqihar Sanjiazi Airport	47.239601	123.917999	477.0	AS	CN	CN-23	Qiqihar	yes	ZYQQ	NDG	NaN	NaN	http://en.wikipedia.org/wiki/Qiqihar_Airport	NaN
55022	327451	ZYSQ	medium_airport	Songyuan Chaganhu Airport	44.938114	124.550178	459.0	AS	CN	CN-22	Qian Gorlos Mongol Autonomous County	yes	ZYSQ	YSQ	NaN	NaN	https://en.wikipedia.org/wiki/Songyuan_Chaganh...	NaN
55023	307017	ZYTH	small_airport	Tahe Airport	52.224444	124.720222	1240.0	AS	CN	CN-23	Tahe	no	ZYTH	NaN	NaN	NaN	NaN	NaN
55024	27242	ZYTL	large_airport	Zhoushuizi Airport	38.965698	121.539001	107.0	AS	CN	CN-21	Dalian	yes	ZYTL	DLC	NaN	NaN	http://en.wikipedia.org/wiki/Dalian_Zhoushuizi...	Dalian Air Base
55025	307013	ZYTN	medium_airport	Tonghua Sanyuanpu Airport	42.253889	125.703333	1200.0	AS	CN	CN-22	Tonghua	yes	ZYTN	TNH	NaN	NaN	http://en.wikipedia.org/wiki/Tonghua_Sanyuanpu...	Tonghua Liuhe Airport
55026	27243	ZYTX	large_airport	Taoxian Airport	41.639801	123.483002	198.0	AS	CN	CN-21	Shenyang	yes	ZYTX	SHE	NaN	NaN	http://en.wikipedia.org/wiki/Shenyang_Taoxian_...	NaN
55027	27244	ZYYJ	medium_airport	Yanji Chaoyangchuan Airport	42.882801	129.451004	624.0	AS	CN	CN-22	Yanji	yes	ZYYJ	YNJ	NaN	NaN	http://en.wikipedia.org/wiki/Yanji_Chaoyangchu...	NaN
55028	317861	ZYYK	medium_airport	Yingkou Lanqi Airport	40.542524	122.358600	0.0	AS	CN	CN-21	Yingkou	yes	ZYYK	YKH	NaN	NaN	https://en.wikipedia.org/wiki/Yingkou_Lanqi_Ai...	NaN
55029	32753	ZYYY	medium_airport	Shenyang Dongta Airport	41.784401	123.496002	NaN	AS	CN	CN-21	Shenyang	no	ZYYY	NaN	NaN	NaN	NaN	NaN
55030	46378	ZZ-0001	heliport	Sealand Helipad	51.894444	1.482500	40.0	EU	GB	GB-ENG	Sealand	no	NaN	NaN	NaN	http://www.sealandgov.org/	http://en.wikipedia.org/wiki/Principality_of_S...	Roughs Tower Helipad
55031	307326	ZZ-0002	small_airport	Glorioso Islands Airstrip	-11.584278	47.296389	11.0	AF	TF	TF-U-A	Grande Glorieuse	no	NaN	NaN	NaN	NaN	NaN	NaN
55032	313629	ZZZZ	small_airport	Satsuma Iōjima Airport	30.784722	130.270556	338.0	AS	JP	JP-46	Mishima-Mura	no	RJX7	NaN	NaN	NaN	http://wikimapia.org/6705190/Satsuma-Iwo-jima-...	SATSUMA,IWOJIMA,RJX7

	id	ident	type	name	latitude_deg	longitude_deg	elevation_ft	continent	iso_country	iso_region	municipality	scheduled_service	gps_code	iata_code	local_code	home_link	wikipedia_link	keywords
26265	19422	KBWC	small_airport	Brawley Municipal Airport	32.992901	-115.516998	-128.0	NaN	US	US-CA	Brawley	no	KBWC	BWC	BWC	NaN	http://en.wikipedia.org/wiki/Brawley_Municipal...	NaN
26388	19514	KCLR	small_airport	Cliff Hatfield Memorial Airport	33.131500	-115.521004	-182.0	NaN	US	US-CA	Calipatria	no	KCLR	CLR	CLR	NaN	http://en.wikipedia.org/wiki/Cliff_Hatfield_Me...	NaN
27731	20283	KL06	small_airport	Furnace Creek Airport	36.463799	-116.880997	-210.0	NaN	US	US-CA	Death Valley National Park	no	NaN	DTH	L06	NaN	http://en.wikipedia.org/wiki/Furnace_Creek_Air...	NaN
30138	21222	KTRM	medium_airport	Jacqueline Cochran Regional Airport	33.626701	-116.160004	-115.0	NaN	US	US-CA	Palm Springs	no	KTRM	TRM	TRM	http://www.rcjcra.com/	http://en.wikipedia.org/wiki/Jacqueline_Cochra...	Thermal Airport, Desert Resorts Regional Airpo...
31862	4416	LLEY	small_airport	Ein Yahav Airfield	30.621700	35.203300	-164.0	AS	IL	IL-D	Sapir	no	LLEY	EIY	NaN	NaN	http://en.wikipedia.org/wiki/Ein_Yahav_Airfield	Sapir Airfield
31877	4421	LLMZ	medium_airport	Bar Yehuda Airfield	31.328199	35.388599	-1266.0	AS	IL	IL-D	Masada	no	LLMZ	MTZ	NaN	NaN	http://en.wikipedia.org/wiki/Bar_Yehuda_Airfield	Masada Airfield

	id	ident	type	name	latitude_deg	longitude_deg	elevation_ft	continent	iso_country	iso_region	municipality	scheduled_service	gps_code	iata_code	local_code	home_link	wikipedia_link	keywords	elevation_meters
0	6523	00A	heliport	Total Rf Heliport	40.070801	-74.933601	11.0	NaN	US	US-PA	Bensalem	no	00A	NaN	00A	NaN	NaN	NaN	3.353659
1	323361	00AA	small_airport	Aero B Ranch Airport	38.704022	-101.473911	3435.0	NaN	US	US-KS	Leoti	no	00AA	NaN	00AA	NaN	NaN	NaN	1047.256098
2	6524	00AK	small_airport	Lowell Field	59.949200	-151.695999	450.0	NaN	US	US-AK	Anchor Point	no	00AK	NaN	00AK	NaN	NaN	NaN	137.195122
3	6525	00AL	small_airport	Epps Airpark	34.864799	-86.770302	820.0	NaN	US	US-AL	Harvest	no	00AL	NaN	00AL	NaN	NaN	NaN	250.000000
4	6526	00AR	closed	Newport Hospital & Clinic Heliport	35.608700	-91.254898	237.0	NaN	US	US-AR	Newport	no	NaN	NaN	NaN	NaN	NaN	00AR	72.256098
5	322127	00AS	small_airport	Fulton Airport	34.942803	-97.818019	1100.0	NaN	US	US-OK	Alex	no	00AS	NaN	00AS	NaN	NaN	NaN	335.365854
6	6527	00AZ	small_airport	Cordes Airport	34.305599	-112.165001	3810.0	NaN	US	US-AZ	Cordes	no	00AZ	NaN	00AZ	NaN	NaN	NaN	1161.585366
7	6528	00CA	small_airport	Goldstone /Gts/ Airport	35.350498	-116.888000	3038.0	NaN	US	US-CA	Barstow	no	00CA	NaN	00CA	NaN	NaN	NaN	926.219512
8	324424	00CL	small_airport	Williams Ag Airport	39.427188	-121.763427	87.0	NaN	US	US-CA	Biggs	no	00CL	NaN	00CL	NaN	NaN	NaN	26.524390
9	322658	00CN	heliport	Kitchen Creek Helibase Heliport	32.727374	-116.459742	3350.0	NaN	US	US-CA	Pine Valley	no	00CN	NaN	00CN	NaN	NaN	NaN	1021.341463
10	6529	00CO	closed	Cass Field	40.622202	-104.344002	4830.0	NaN	US	US-CO	Briggsdale	no	NaN	NaN	NaN	NaN	NaN	00CO	1472.560976
11	6531	00FA	small_airport	Grass Patch Airport	28.645500	-82.219002	53.0	NaN	US	US-FL	Bushnell	no	00FA	NaN	00FA	NaN	NaN	NaN	16.158537
12	6532	00FD	heliport	Ringhaver Heliport	28.846600	-82.345398	25.0	NaN	US	US-FL	Riverview	no	00FD	NaN	00FD	NaN	NaN	NaN	7.621951
13	6533	00FL	small_airport	River Oak Airport	27.230900	-80.969200	35.0	NaN	US	US-FL	Okeechobee	no	00FL	NaN	00FL	NaN	NaN	NaN	10.670732
14	6534	00GA	small_airport	Lt World Airport	33.767502	-84.068298	700.0	NaN	US	US-GA	Lithonia	no	00GA	NaN	00GA	NaN	NaN	NaN	213.414634
15	6535	00GE	heliport	Caffrey Heliport	33.884201	-84.733902	957.0	NaN	US	US-GA	Hiram	no	00GE	NaN	00GE	NaN	NaN	NaN	291.768293
16	6536	00HI	heliport	Kaupulehu Heliport	19.832715	-155.980233	43.0	NaN	US	US-HI	Kailua/Kona	no	00HI	NaN	00HI	NaN	NaN	NaN	13.109756
17	6537	00ID	small_airport	Delta Shores Airport	48.145302	-116.213997	2064.0	NaN	US	US-ID	Clark Fork	no	00ID	NaN	00ID	NaN	NaN	NaN	629.268293
18	322581	00IG	small_airport	Goltl Airport	39.724028	-101.395994	3359.0	NaN	US	US-KS	McDonald	no	00IG	NaN	00IG	NaN	NaN	NaN	1024.085366
19	6538	00II	heliport	Bailey Generation Station Heliport	41.644501	-87.122803	600.0	NaN	US	US-IN	Chesterton	no	00II	NaN	00II	NaN	NaN	NaN	182.926829
20	6539	00IL	small_airport	Hammer Airport	41.978401	-89.560402	840.0	NaN	US	US-IL	Polo	no	00IL	NaN	00IL	NaN	NaN	NaN	256.097561
21	6540	00IN	heliport	St Mary Medical Center Heliport	41.511398	-87.260597	634.0	NaN	US	US-IN	Hobart	no	00IN	NaN	00IN	NaN	NaN	NaN	193.292683
22	6541	00IS	small_airport	Hayenga's Cant Find Farms Airport	40.025600	-89.122902	820.0	NaN	US	US-IL	Kings	no	00IS	NaN	00IS	NaN	NaN	NaN	250.000000
23	6542	00KS	small_airport	Hayden Farm Airport	38.727798	-94.930496	1100.0	NaN	US	US-KS	Gardner	no	00KS	NaN	00KS	NaN	NaN	NaN	335.365854
24	6543	00KY	small_airport	Robbins Roost Airport	37.409401	-84.619698	1265.0	NaN	US	US-KY	Stanford	no	00KY	NaN	00KY	NaN	NaN	NaN	385.670732
25	45437	00LA	heliport	Shell Chemical East Site Heliport	30.191944	-90.980833	15.0	NaN	US	US-LA	Gonzales	no	00LA	NaN	00LA	NaN	NaN	NaN	4.573171
26	6544	00LL	heliport	Ac & R Components Heliport	39.665298	-89.705597	600.0	NaN	US	US-IL	Chatham	no	00LL	NaN	00LL	NaN	NaN	NaN	182.926829
27	6545	00LS	small_airport	Lejeune Airport	30.136299	-92.429398	12.0	NaN	US	US-LA	Esterwood	no	00LS	NaN	00LS	NaN	NaN	NaN	3.658537
28	6546	00MD	small_airport	Slater Field	38.757099	-75.753799	45.0	NaN	US	US-MD	Federalsburg	no	00MD	NaN	00MD	NaN	NaN	NaN	13.719512
29	6547	00MI	heliport	Dow Chemical Heliport	43.949402	-86.416702	588.0	NaN	US	US-MI	Ludington	no	00MI	NaN	00MI	NaN	NaN	NaN	179.268293
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
55003	30646	ZYAS	medium_airport	Anshan Air Base	41.105301	122.853996	NaN	AS	CN	CN-21	Anshan	yes	ZYAS	AOG	NaN	NaN	https://en.wikipedia.org/wiki/Anshan_Teng%27ao...	NaN	NaN
55004	27237	ZYCC	medium_airport	Longjia Airport	43.996201	125.684998	706.0	AS	CN	CN-22	Changchun	yes	ZYCC	CGQ	NaN	NaN	http://en.wikipedia.org/wiki/Changchun_Longjia...	NaN	215.243902
55005	300858	ZYCH	medium_airport	Changhai Airport	39.266667	122.666944	80.0	AS	CN	CN-21	Changhai	no	ZYCH	CNI	NaN	NaN	http://en.wikipedia.org/wiki/Changhai_Airport	NaN	24.390244
55006	30827	ZYCY	medium_airport	Chaoyang Airport	41.538101	120.434998	568.0	AS	CN	CN-21	Chaoyang	yes	ZYCY	CHG	NaN	NaN	https://en.wikipedia.org/wiki/Chaoyang_Airport	NaN	173.170732
55007	327349	ZYDU	medium_airport	Wudalianchi Dedu Airport	48.445000	126.133000	984.0	AS	CN	CN-23	Wudalianchi	yes	ZYDU	DTU	NaN	NaN	https://en.wikipedia.org/wiki/Wudalianchi_Dedu...	NaN	300.000000
55008	324338	ZYFX	small_airport	Fuxin Airport	42.069014	121.718122	548.0	AS	CN	CN-21	Fuxin	no	ZYFX	NaN	NaN	NaN	NaN	NaN	167.073171
55009	313994	ZYFY	medium_airport	Dongji Aiport	48.199494	134.366447	NaN	AS	CN	CN-23	Fuyuan	yes	ZYFY	FYJ	NaN	NaN	https://en.wikipedia.org/wiki/Fuyuan_Dongji_Ai...	NaN	NaN
55010	27238	ZYHB	large_airport	Taiping Airport	45.623402	126.250000	457.0	AS	CN	CN-23	Harbin	yes	ZYHB	HRB	NaN	NaN	http://en.wikipedia.org/wiki/Harbin_Taiping_In...	NaN	139.329268
55011	31576	ZYHE	medium_airport	Heihe Airport	50.171621	127.308884	8530.0	AS	CN	CN-23	Heihe	yes	ZYHE	HEK	NaN	NaN	http://en.wikipedia.org/wiki/Heihe_Airport	NaN	2600.609756
55012	31701	ZYJL	small_airport	Jilin Airport	44.002201	126.396004	NaN	AS	CN	CN-22	Jilin	no	ZYJL	JIL	NaN	NaN	https://en.wikipedia.org/wiki/Jilin_Ertaizi_Ai...	NaN	NaN
55013	27239	ZYJM	medium_airport	Jiamusi Airport	46.843399	130.464996	262.0	AS	CN	CN-23	Jiamusi	yes	ZYJM	JMU	NaN	NaN	http://en.wikipedia.org/wiki/Jiamusi_Airport	NaN	79.878049
55014	327450	ZYJS	medium_airport	Jiansanjiang Airport	47.110000	132.660278	NaN	AS	CN	CN-23	Jiansanjiang	yes	ZYJS	JSJ	NaN	NaN	https://en.wikipedia.org/wiki/Jiansanjiang_Air...	NaN	NaN
55015	313337	ZYJX	medium_airport	Jixi Xingkaihu Airport	45.293000	131.193000	760.0	AS	CN	CN-23	Jixi	yes	ZYJX	JXA	NaN	NaN	http://en.wikipedia.org/wiki/Jixi_Xingkaihu_Ai...	NaN	231.707317
55016	31706	ZYJZ	medium_airport	Jinzhou Airport	41.101398	121.061997	NaN	AS	CN	CN-21	Jinzhou	yes	ZYJZ	JNZ	NaN	NaN	http://en.wikipedia.org/wiki/Jinzhou_Airport	Xiaolingzi Air Base	NaN
55017	307012	ZYLD	medium_airport	Lindu Airport	47.752056	129.019125	791.0	AS	CN	CN-23	Yichun	yes	ZYLD	LDS	NaN	NaN	http://en.wikipedia.org/wiki/Yichun_Lindu_Airport	Yichun Shi Airport	241.158537
55018	300516	ZYLS	medium_airport	Yushu Batang Airport	32.836389	97.036389	12816.0	AS	CN	CN-63	Yushu	no	ZYLS	YUS	NaN	NaN	http://en.wikipedia.org/wiki/Yushu_Batang_Airport	NaN	3907.317073
55019	27240	ZYMD	medium_airport	Mudanjiang Hailang International Airport	44.524101	129.569000	883.0	AS	CN	CN-23	Mudanjiang	yes	ZYMD	MDG	NaN	NaN	http://en.wikipedia.org/wiki/Mudanjiang_Airport	Mudanjiang	269.207317
55020	301193	ZYMH	medium_airport	Gu-Lian Airport	52.912778	122.430000	1836.0	AS	CN	CN-23	Mohe	yes	ZYMH	OHE	NaN	NaN	http://en.wikipedia.org/wiki/Mohe_Gulian_Airport	NaN	559.756098
55021	27241	ZYQQ	medium_airport	Qiqihar Sanjiazi Airport	47.239601	123.917999	477.0	AS	CN	CN-23	Qiqihar	yes	ZYQQ	NDG	NaN	NaN	http://en.wikipedia.org/wiki/Qiqihar_Airport	NaN	145.426829
55022	327451	ZYSQ	medium_airport	Songyuan Chaganhu Airport	44.938114	124.550178	459.0	AS	CN	CN-22	Qian Gorlos Mongol Autonomous County	yes	ZYSQ	YSQ	NaN	NaN	https://en.wikipedia.org/wiki/Songyuan_Chaganh...	NaN	139.939024
55023	307017	ZYTH	small_airport	Tahe Airport	52.224444	124.720222	1240.0	AS	CN	CN-23	Tahe	no	ZYTH	NaN	NaN	NaN	NaN	NaN	378.048780
55024	27242	ZYTL	large_airport	Zhoushuizi Airport	38.965698	121.539001	107.0	AS	CN	CN-21	Dalian	yes	ZYTL	DLC	NaN	NaN	http://en.wikipedia.org/wiki/Dalian_Zhoushuizi...	Dalian Air Base	32.621951
55025	307013	ZYTN	medium_airport	Tonghua Sanyuanpu Airport	42.253889	125.703333	1200.0	AS	CN	CN-22	Tonghua	yes	ZYTN	TNH	NaN	NaN	http://en.wikipedia.org/wiki/Tonghua_Sanyuanpu...	Tonghua Liuhe Airport	365.853659
55026	27243	ZYTX	large_airport	Taoxian Airport	41.639801	123.483002	198.0	AS	CN	CN-21	Shenyang	yes	ZYTX	SHE	NaN	NaN	http://en.wikipedia.org/wiki/Shenyang_Taoxian_...	NaN	60.365854
55027	27244	ZYYJ	medium_airport	Yanji Chaoyangchuan Airport	42.882801	129.451004	624.0	AS	CN	CN-22	Yanji	yes	ZYYJ	YNJ	NaN	NaN	http://en.wikipedia.org/wiki/Yanji_Chaoyangchu...	NaN	190.243902
55028	317861	ZYYK	medium_airport	Yingkou Lanqi Airport	40.542524	122.358600	0.0	AS	CN	CN-21	Yingkou	yes	ZYYK	YKH	NaN	NaN	https://en.wikipedia.org/wiki/Yingkou_Lanqi_Ai...	NaN	0.000000
55029	32753	ZYYY	medium_airport	Shenyang Dongta Airport	41.784401	123.496002	NaN	AS	CN	CN-21	Shenyang	no	ZYYY	NaN	NaN	NaN	NaN	NaN	NaN
55030	46378	ZZ-0001	heliport	Sealand Helipad	51.894444	1.482500	40.0	EU	GB	GB-ENG	Sealand	no	NaN	NaN	NaN	http://www.sealandgov.org/	http://en.wikipedia.org/wiki/Principality_of_S...	Roughs Tower Helipad	12.195122
55031	307326	ZZ-0002	small_airport	Glorioso Islands Airstrip	-11.584278	47.296389	11.0	AF	TF	TF-U-A	Grande Glorieuse	no	NaN	NaN	NaN	NaN	NaN	NaN	3.353659
55032	313629	ZZZZ	small_airport	Satsuma Iōjima Airport	30.784722	130.270556	338.0	AS	JP	JP-46	Mishima-Mura	no	RJX7	NaN	NaN	NaN	http://wikimapia.org/6705190/Satsuma-Iwo-jima-...	SATSUMA,IWOJIMA,RJX7	103.048780

	id	ident	type	name	latitude_deg	longitude_deg	elevation_ft	continent	iso_country	iso_region	municipality	scheduled_service	gps_code	iata_code	local_code	home_link	wikipedia_link	keywords	x	y
0	6523	00A	heliport	Total Rf Heliport	40.070801	-74.933601	11.0	NaN	US	US-PA	Bensalem	no	00A	NaN	00A	NaN	NaN	NaN	-8.341570e+06	4.876236e+06
1	323361	00AA	small_airport	Aero B Ranch Airport	38.704022	-101.473911	3435.0	NaN	US	US-KS	Leoti	no	00AA	NaN	00AA	NaN	NaN	NaN	-1.129602e+07	4.679364e+06
2	6524	00AK	small_airport	Lowell Field	59.949200	-151.695999	450.0	NaN	US	US-AK	Anchor Point	no	00AK	NaN	00AK	NaN	NaN	NaN	-1.688672e+07	8.388436e+06
3	6525	00AL	small_airport	Epps Airpark	34.864799	-86.770302	820.0	NaN	US	US-AL	Harvest	no	00AL	NaN	00AL	NaN	NaN	NaN	-9.659226e+06	4.145523e+06
4	6526	00AR	closed	Newport Hospital & Clinic Heliport	35.608700	-91.254898	237.0	NaN	US	US-AR	Newport	no	NaN	NaN	NaN	NaN	NaN	00AR	-1.015845e+07	4.246912e+06
5	322127	00AS	small_airport	Fulton Airport	34.942803	-97.818019	1100.0	NaN	US	US-OK	Alex	no	00AS	NaN	00AS	NaN	NaN	NaN	-1.088905e+07	4.156111e+06
6	6527	00AZ	small_airport	Cordes Airport	34.305599	-112.165001	3810.0	NaN	US	US-AZ	Cordes	no	00AZ	NaN	00AZ	NaN	NaN	NaN	-1.248615e+07	4.069911e+06
7	6528	00CA	small_airport	Goldstone /Gts/ Airport	35.350498	-116.888000	3038.0	NaN	US	US-CA	Barstow	no	00CA	NaN	00CA	NaN	NaN	NaN	-1.301191e+07	4.211615e+06
8	324424	00CL	small_airport	Williams Ag Airport	39.427188	-121.763427	87.0	NaN	US	US-CA	Biggs	no	00CL	NaN	00CL	NaN	NaN	NaN	-1.355464e+07	4.783049e+06
9	322658	00CN	heliport	Kitchen Creek Helibase Heliport	32.727374	-116.459742	3350.0	NaN	US	US-CA	Pine Valley	no	00CN	NaN	00CN	NaN	NaN	NaN	-1.296424e+07	3.859173e+06
10	6529	00CO	closed	Cass Field	40.622202	-104.344002	4830.0	NaN	US	US-CO	Briggsdale	no	NaN	NaN	NaN	NaN	NaN	00CO	-1.161552e+07	4.956775e+06
11	6531	00FA	small_airport	Grass Patch Airport	28.645500	-82.219002	53.0	NaN	US	US-FL	Bushnell	no	00FA	NaN	00FA	NaN	NaN	NaN	-9.152577e+06	3.330603e+06
12	6532	00FD	heliport	Ringhaver Heliport	28.846600	-82.345398	25.0	NaN	US	US-FL	Riverview	no	00FD	NaN	00FD	NaN	NaN	NaN	-9.166648e+06	3.356136e+06
13	6533	00FL	small_airport	River Oak Airport	27.230900	-80.969200	35.0	NaN	US	US-FL	Okeechobee	no	00FL	NaN	00FL	NaN	NaN	NaN	-9.013450e+06	3.152349e+06
14	6534	00GA	small_airport	Lt World Airport	33.767502	-84.068298	700.0	NaN	US	US-GA	Lithonia	no	00GA	NaN	00GA	NaN	NaN	NaN	-9.358440e+06	3.997626e+06
15	6535	00GE	heliport	Caffrey Heliport	33.884201	-84.733902	957.0	NaN	US	US-GA	Hiram	no	00GE	NaN	00GE	NaN	NaN	NaN	-9.432535e+06	4.013264e+06
16	6536	00HI	heliport	Kaupulehu Heliport	19.832715	-155.980233	43.0	NaN	US	US-HI	Kailua/Kona	no	00HI	NaN	00HI	NaN	NaN	NaN	-1.736364e+07	2.253224e+06
17	6537	00ID	small_airport	Delta Shores Airport	48.145302	-116.213997	2064.0	NaN	US	US-ID	Clark Fork	no	00ID	NaN	00ID	NaN	NaN	NaN	-1.293688e+07	6.131062e+06
18	322581	00IG	small_airport	Goltl Airport	39.724028	-101.395994	3359.0	NaN	US	US-KS	McDonald	no	00IG	NaN	00IG	NaN	NaN	NaN	-1.128735e+07	4.825919e+06
19	6538	00II	heliport	Bailey Generation Station Heliport	41.644501	-87.122803	600.0	NaN	US	US-IN	Chesterton	no	00II	NaN	00II	NaN	NaN	NaN	-9.698466e+06	5.107875e+06
20	6539	00IL	small_airport	Hammer Airport	41.978401	-89.560402	840.0	NaN	US	US-IL	Polo	no	00IL	NaN	00IL	NaN	NaN	NaN	-9.969818e+06	5.157745e+06
21	6540	00IN	heliport	St Mary Medical Center Heliport	41.511398	-87.260597	634.0	NaN	US	US-IN	Hobart	no	00IN	NaN	00IN	NaN	NaN	NaN	-9.713805e+06	5.088068e+06
22	6541	00IS	small_airport	Hayenga's Cant Find Farms Airport	40.025600	-89.122902	820.0	NaN	US	US-IL	Kings	no	00IS	NaN	00IS	NaN	NaN	NaN	-9.921116e+06	4.869663e+06
23	6542	00KS	small_airport	Hayden Farm Airport	38.727798	-94.930496	1100.0	NaN	US	US-KS	Gardner	no	00KS	NaN	00KS	NaN	NaN	NaN	-1.056761e+07	4.682756e+06
24	6543	00KY	small_airport	Robbins Roost Airport	37.409401	-84.619698	1265.0	NaN	US	US-KY	Stanford	no	00KY	NaN	00KY	NaN	NaN	NaN	-9.419822e+06	4.496327e+06
25	45437	00LA	heliport	Shell Chemical East Site Heliport	30.191944	-90.980833	15.0	NaN	US	US-LA	Gonzales	no	00LA	NaN	00LA	NaN	NaN	NaN	-1.012794e+07	3.528246e+06
26	6544	00LL	heliport	Ac & R Components Heliport	39.665298	-89.705597	600.0	NaN	US	US-IL	Chatham	no	00LL	NaN	00LL	NaN	NaN	NaN	-9.985981e+06	4.817423e+06
27	6545	00LS	small_airport	Lejeune Airport	30.136299	-92.429398	12.0	NaN	US	US-LA	Esterwood	no	00LS	NaN	00LS	NaN	NaN	NaN	-1.028919e+07	3.521082e+06
28	6546	00MD	small_airport	Slater Field	38.757099	-75.753799	45.0	NaN	US	US-MD	Federalsburg	no	00MD	NaN	00MD	NaN	NaN	NaN	-8.432874e+06	4.686938e+06
29	6547	00MI	heliport	Dow Chemical Heliport	43.949402	-86.416702	588.0	NaN	US	US-MI	Ludington	no	00MI	NaN	00MI	NaN	NaN	NaN	-9.619863e+06	5.457615e+06
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
55003	30646	ZYAS	medium_airport	Anshan Air Base	41.105301	122.853996	NaN	AS	CN	CN-21	Anshan	yes	ZYAS	AOG	NaN	NaN	https://en.wikipedia.org/wiki/Anshan_Teng%27ao...	NaN	1.367604e+07	5.027886e+06
55004	27237	ZYCC	medium_airport	Longjia Airport	43.996201	125.684998	706.0	AS	CN	CN-22	Changchun	yes	ZYCC	CGQ	NaN	NaN	http://en.wikipedia.org/wiki/Changchun_Longjia...	NaN	1.399119e+07	5.464854e+06
55005	300858	ZYCH	medium_airport	Changhai Airport	39.266667	122.666944	80.0	AS	CN	CN-21	Changhai	no	ZYCH	CNI	NaN	NaN	http://en.wikipedia.org/wiki/Changhai_Airport	NaN	1.365522e+07	4.759942e+06
55006	30827	ZYCY	medium_airport	Chaoyang Airport	41.538101	120.434998	568.0	AS	CN	CN-21	Chaoyang	yes	ZYCY	CHG	NaN	NaN	https://en.wikipedia.org/wiki/Chaoyang_Airport	NaN	1.340676e+07	5.092038e+06
55007	327349	ZYDU	medium_airport	Wudalianchi Dedu Airport	48.445000	126.133000	984.0	AS	CN	CN-23	Wudalianchi	yes	ZYDU	DTU	NaN	NaN	https://en.wikipedia.org/wiki/Wudalianchi_Dedu...	NaN	1.404106e+07	6.181209e+06
55008	324338	ZYFX	small_airport	Fuxin Airport	42.069014	121.718122	548.0	AS	CN	CN-21	Fuxin	no	ZYFX	NaN	NaN	NaN	NaN	NaN	1.354960e+07	5.171323e+06
55009	313994	ZYFY	medium_airport	Dongji Aiport	48.199494	134.366447	NaN	AS	CN	CN-23	Fuyuan	yes	ZYFY	FYJ	NaN	NaN	https://en.wikipedia.org/wiki/Fuyuan_Dongji_Ai...	NaN	1.495760e+07	6.140108e+06
55010	27238	ZYHB	large_airport	Taiping Airport	45.623402	126.250000	457.0	AS	CN	CN-23	Harbin	yes	ZYHB	HRB	NaN	NaN	http://en.wikipedia.org/wiki/Harbin_Taiping_In...	NaN	1.405409e+07	5.720203e+06
55011	31576	ZYHE	medium_airport	Heihe Airport	50.171621	127.308884	8530.0	AS	CN	CN-23	Heihe	yes	ZYHE	HEK	NaN	NaN	http://en.wikipedia.org/wiki/Heihe_Airport	NaN	1.417196e+07	6.476051e+06
55012	31701	ZYJL	small_airport	Jilin Airport	44.002201	126.396004	NaN	AS	CN	CN-22	Jilin	no	ZYJL	JIL	NaN	NaN	https://en.wikipedia.org/wiki/Jilin_Ertaizi_Ai...	NaN	1.407034e+07	5.465783e+06
55013	27239	ZYJM	medium_airport	Jiamusi Airport	46.843399	130.464996	262.0	AS	CN	CN-23	Jiamusi	yes	ZYJM	JMU	NaN	NaN	http://en.wikipedia.org/wiki/Jiamusi_Airport	NaN	1.452330e+07	5.916550e+06
55014	327450	ZYJS	medium_airport	Jiansanjiang Airport	47.110000	132.660278	NaN	AS	CN	CN-23	Jiansanjiang	yes	ZYJS	JSJ	NaN	NaN	https://en.wikipedia.org/wiki/Jiansanjiang_Air...	NaN	1.476767e+07	5.960047e+06
55015	313337	ZYJX	medium_airport	Jixi Xingkaihu Airport	45.293000	131.193000	760.0	AS	CN	CN-23	Jixi	yes	ZYJX	JXA	NaN	NaN	http://en.wikipedia.org/wiki/Jixi_Xingkaihu_Ai...	NaN	1.460434e+07	5.667767e+06
55016	31706	ZYJZ	medium_airport	Jinzhou Airport	41.101398	121.061997	NaN	AS	CN	CN-21	Jinzhou	yes	ZYJZ	JNZ	NaN	NaN	http://en.wikipedia.org/wiki/Jinzhou_Airport	Xiaolingzi Air Base	1.347656e+07	5.027309e+06
55017	307012	ZYLD	medium_airport	Lindu Airport	47.752056	129.019125	791.0	AS	CN	CN-23	Yichun	yes	ZYLD	LDS	NaN	NaN	http://en.wikipedia.org/wiki/Yichun_Lindu_Airport	Yichun Shi Airport	1.436234e+07	6.065704e+06
55018	300516	ZYLS	medium_airport	Yushu Batang Airport	32.836389	97.036389	12816.0	AS	CN	CN-63	Yushu	no	ZYLS	YUS	NaN	NaN	http://en.wikipedia.org/wiki/Yushu_Batang_Airport	NaN	1.080204e+07	3.873607e+06
55019	27240	ZYMD	medium_airport	Mudanjiang Hailang International Airport	44.524101	129.569000	883.0	AS	CN	CN-23	Mudanjiang	yes	ZYMD	MDG	NaN	NaN	http://en.wikipedia.org/wiki/Mudanjiang_Airport	Mudanjiang	1.442356e+07	5.546910e+06
55020	301193	ZYMH	medium_airport	Gu-Lian Airport	52.912778	122.430000	1836.0	AS	CN	CN-23	Mohe	yes	ZYMH	OHE	NaN	NaN	http://en.wikipedia.org/wiki/Mohe_Gulian_Airport	NaN	1.362885e+07	6.966880e+06
55021	27241	ZYQQ	medium_airport	Qiqihar Sanjiazi Airport	47.239601	123.917999	477.0	AS	CN	CN-23	Qiqihar	yes	ZYQQ	NDG	NaN	NaN	http://en.wikipedia.org/wiki/Qiqihar_Airport	NaN	1.379449e+07	5.981271e+06
55022	327451	ZYSQ	medium_airport	Songyuan Chaganhu Airport	44.938114	124.550178	459.0	AS	CN	CN-22	Qian Gorlos Mongol Autonomous County	yes	ZYSQ	YSQ	NaN	NaN	https://en.wikipedia.org/wiki/Songyuan_Chaganh...	NaN	1.386486e+07	5.611784e+06
55023	307017	ZYTH	small_airport	Tahe Airport	52.224444	124.720222	1240.0	AS	CN	CN-23	Tahe	no	ZYTH	NaN	NaN	NaN	NaN	NaN	1.388379e+07	6.840810e+06
55024	27242	ZYTL	large_airport	Zhoushuizi Airport	38.965698	121.539001	107.0	AS	CN	CN-21	Dalian	yes	ZYTL	DLC	NaN	NaN	http://en.wikipedia.org/wiki/Dalian_Zhoushuizi...	Dalian Air Base	1.352966e+07	4.716759e+06
55025	307013	ZYTN	medium_airport	Tonghua Sanyuanpu Airport	42.253889	125.703333	1200.0	AS	CN	CN-22	Tonghua	yes	ZYTN	TNH	NaN	NaN	http://en.wikipedia.org/wiki/Tonghua_Sanyuanpu...	Tonghua Liuhe Airport	1.399323e+07	5.199087e+06
55026	27243	ZYTX	large_airport	Taoxian Airport	41.639801	123.483002	198.0	AS	CN	CN-21	Shenyang	yes	ZYTX	SHE	NaN	NaN	http://en.wikipedia.org/wiki/Shenyang_Taoxian_...	NaN	1.374606e+07	5.107175e+06
55027	27244	ZYYJ	medium_airport	Yanji Chaoyangchuan Airport	42.882801	129.451004	624.0	AS	CN	CN-22	Yanji	yes	ZYYJ	YNJ	NaN	NaN	http://en.wikipedia.org/wiki/Yanji_Chaoyangchu...	NaN	1.441042e+07	5.294150e+06
55028	317861	ZYYK	medium_airport	Yingkou Lanqi Airport	40.542524	122.358600	0.0	AS	CN	CN-21	Yingkou	yes	ZYYK	YKH	NaN	NaN	https://en.wikipedia.org/wiki/Yingkou_Lanqi_Ai...	NaN	1.362090e+07	4.945096e+06
55029	32753	ZYYY	medium_airport	Shenyang Dongta Airport	41.784401	123.496002	NaN	AS	CN	CN-21	Shenyang	no	ZYYY	NaN	NaN	NaN	NaN	NaN	1.374751e+07	5.128738e+06
55030	46378	ZZ-0001	heliport	Sealand Helipad	51.894444	1.482500	40.0	EU	GB	GB-ENG	Sealand	no	NaN	NaN	NaN	http://www.sealandgov.org/	http://en.wikipedia.org/wiki/Principality_of_S...	Roughs Tower Helipad	1.650311e+05	6.781062e+06
55031	307326	ZZ-0002	small_airport	Glorioso Islands Airstrip	-11.584278	47.296389	11.0	AF	TF	TF-U-A	Grande Glorieuse	no	NaN	NaN	NaN	NaN	NaN	NaN	5.265010e+06	-1.298433e+06
55032	313629	ZZZZ	small_airport	Satsuma Iōjima Airport	30.784722	130.270556	338.0	AS	JP	JP-46	Mishima-Mura	no	RJX7	NaN	NaN	NaN	http://wikimapia.org/6705190/Satsuma-Iwo-jima-...	SATSUMA,IWOJIMA,RJX7	1.450165e+07	3.604823e+06