by: Oleg.E.Krivosheev@gmail.com
Introduction to Python and Pandas data manipulation. Data exploration and transformation. Basic keywords: python, pandas, seaborn, visualization, matplotlib, bokeh
Today, we're going to talk about what common options are here for doing nice plots. So, you've got the data, you've the code - now time to make it look nice on the paper.
First, visualization in Jupyter notebook start with magic command. IPython and Jupyter were designed to work seamlessly with matplotlib plotting library, and any libraries built on top of matplotlib. Before do any plotting command, you have to set up your matplotlib backend. This is done by executing %matplotlib command. But! This will not import anything and won't execute any Python command. %matplotlib without any arguments will show current default backend.
Inline backed means graphs would be inlined into output cell right below input cell with some graphics related commands
In [1]:
%matplotlib inline
Notebook backend means there could be an interactive graphs embedded into notebook
In [2]:
%matplotlib notebook
%matplotlib without any arguments will show current default backend.
In [3]:
%matplotlib
Using matplotlib backend: nbAgg
Potential backends to play with are %matplotlib qt or %matplotlib gtk
In [4]:
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
import pandas as pd
sns.set_context("paper")
The main topic is data manipulation with Pandas, for example function application, groupby, aggregation and multi-indexes. All along I'll mention handy tricks that you can use for various tasks and demonstrate how we can plot results in different ways using Seaborn (based on matplotlib). Given the data format, special focus is put on time-series data manipulation. We also look at Web-based plotting and map plotting as well.
First, several examples how to plot with matplotlib. Note, that there is a difference you get from %matplotlib notebook vs %matplotlib inline - integractive buttons for zoom, pan, back, save etc. If you're running %matplotlib notebook, you'd either have to call it before each plot, or explicitely make figure, otherwise plot will be overwritten by next plot command.
In [5]:
plt.figure() # do not remove! separate figure per cell
x = np.linspace(0, 3*np.pi, 500)
y = np.sin(x**2)
plt.plot(x, y)
plt.title('A very simple graph')
plt.show()
In [6]:
# %load integral.py
# implement the example graphs/integral from pyx
from pylab import *
from matplotlib.patches import Polygon
def func(x):
return (x-3)*(x-5)*(x-7)+85
plt.figure()
ax = subplot(111)
a, b = 2, 9 # integral area
x = arange(0, 10, 0.01)
y = func(x)
plot(x, y, linewidth=1)
# make the shaded region
ix = arange(a, b, 0.01)
iy = func(ix)
verts = [(a,0)] + list(zip(ix,iy)) + [(b,0)]
poly = Polygon(verts, facecolor='0.8', edgecolor='k')
ax.add_patch(poly)
text(0.5 * (a + b), 30,
r"$\int_a^b f(x)\mathrm{d}x$", horizontalalignment='center',
fontsize=20)
axis([0,10, 0, 180])
figtext(0.9, 0.05, 'x')
figtext(0.1, 0.9, 'y')
ax.set_xticks((a,b))
ax.set_xticklabels(('a','b'))
ax.set_yticks([])
plt.show()
Plotting histograms is quite easy as well. Start with some randomly generated points and bin them into histogram
In [7]:
random_state = np.random.RandomState(19680801)
X = random_state.randn(10000)
fig, ax = plt.subplots()
ax.hist(X, bins = 20, normed = True)
x = np.linspace(-5, 5, 1000)
ax.plot(x, 1 / np.sqrt(2*np.pi) * np.exp(-(x**2)/2), linewidth=4)
ax.set_xticks([])
ax.set_yticks([])
plt.show()
Plotting scatter plot was never being easier
In [8]:
fig, ax = plt.subplots()
for color in ['red', 'green', 'blue']:
n = 750
x, y = rand(2, n)
scale = 200.0 * rand(n)
ax.scatter(x, y, c=color, s=scale, label=color,
alpha=0.3, edgecolors='none')
ax.legend()
ax.grid(True)
plt.show()
Animated example, it is working till it is stopped explicitely
In [9]:
import scipy.stats as ss
from matplotlib.animation import FuncAnimation
class UpdateDist(object):
def __init__(self, ax, prob=0.5):
self.success = 0
self.prob = prob
self.line, = ax.plot([], [], 'k-')
self.x = np.linspace(0, 1, 200)
self.ax = ax
# Set up plot parameters
self.ax.set_xlim(0, 1)
self.ax.set_ylim(0, 15)
self.ax.grid(True)
# This vertical line represents the theoretical value, to
# which the plotted distribution should converge.
self.ax.axvline(prob, linestyle='--', color='black')
def init(self):
self.success = 0
self.line.set_data([], [])
return self.line,
def __call__(self, i):
# This way the plot can continuously run and we just keep
# watching new realizations of the process
if i == 0:
return self.init()
# Choose success based on exceed a threshold with a uniform pick
if np.random.rand(1,) < self.prob:
self.success += 1
y = ss.beta.pdf(self.x, self.success + 1, (i - self.success) + 1)
self.line.set_data(self.x, y)
return self.line,
fig, ax = plt.subplots()
ud = UpdateDist(ax, prob=0.7)
anim = FuncAnimation(fig, ud, frames=np.arange(100), init_func=ud.init,
interval=100, blit=True)
plt.show()
There are lots of way to make statistics related graphs. Lets make box plot and violin plot.
In [10]:
fig, axes = plt.subplots(nrows=1, ncols=2, figsize=(9, 4))
# generate some random test data
all_data = [np.random.normal(0, std, 100) for std in range(6, 10)]
# plot violin plot
axes[0].violinplot(all_data,
showmeans=True,
showmedians=True)
axes[0].set_title('violin plot')
# plot box plot
axes[1].boxplot(all_data)
axes[1].set_title('box plot')
# adding horizontal grid lines
for ax in axes:
ax.yaxis.grid(True)
ax.set_xticks([y+1 for y in range(len(all_data))])
ax.set_xlabel('xlabel')
ax.set_ylabel('ylabel')
# add x-tick labels
plt.setp(axes, xticks=[y+1 for y in range(len(all_data))],
xticklabels=['x1', 'x2', 'x3', 'x4'])
plt.show()
One could draw color maps as well
In [11]:
from matplotlib.colors import BoundaryNorm
from matplotlib.ticker import MaxNLocator
# make these smaller to increase the resolution
dx, dy = 0.05, 0.05
# generate 2 2d grids for the x & y bounds
y, x = np.mgrid[slice(1, 5 + dy, dy),
slice(1, 5 + dx, dx)]
z = np.sin(x)**10 + np.cos(10 + y*x) * np.cos(x)
# x and y are bounds, so z should be the value *inside* those bounds.
# Therefore, remove the last value from the z array.
z = z[:-1, :-1]
levels = MaxNLocator(nbins=15).tick_values(z.min(), z.max())
# pick the desired colormap, sensible levels, and define a normalization
# instance which takes data values and translates those into levels.
cmap = plt.get_cmap('PiYG')
norm = BoundaryNorm(levels, ncolors=cmap.N, clip=True)
fig, (ax0, ax1) = plt.subplots(nrows=2)
im = ax0.pcolormesh(x, y, z, cmap=cmap, norm=norm)
fig.colorbar(im, ax=ax0)
ax0.set_title('pcolormesh with levels')
# contours are *point* based plots, so convert our bound into point
# centers
cf = ax1.contourf(x[:-1, :-1] + dx/2.,
y[:-1, :-1] + dy/2., z, levels=levels,
cmap=cmap)
fig.colorbar(cf, ax=ax1)
ax1.set_title('contourf with levels')
# adjust spacing between subplots so `ax1` title and `ax0` tick labels
# don't overlap
fig.tight_layout()
plt.show()
Pie chart plots, of course
In [12]:
# Compute pie slices
plt.figure()
N = 20
theta = np.linspace(0.0, 2 * np.pi, N, endpoint=False)
radii = 10 * np.random.rand(N)
width = np.pi / 4 * np.random.rand(N)
ax = plt.subplot(111, projection='polar')
bars = ax.bar(theta, radii, width=width, bottom=0.0)
# Use custom colors and opacity
for r, bar in zip(radii, bars):
bar.set_facecolor(plt.cm.viridis(r / 10.))
bar.set_alpha(0.5)
plt.show()
One could use a lot of different styles, like ggplot2 inspired one
In [13]:
plt.style.use('ggplot')
fig, axes = plt.subplots(ncols=2, nrows=2)
ax1, ax2, ax3, ax4 = axes.ravel()
# scatter plot (Note: `plt.scatter` doesn't use default colors)
x, y = np.random.normal(size=(2, 200))
ax1.plot(x, y, 'o')
# sinusoidal lines with colors from default color cycle
L = 2*np.pi
x = np.linspace(0, L)
ncolors = len(plt.rcParams['axes.prop_cycle'])
shift = np.linspace(0, L, ncolors, endpoint=False)
for s in shift:
ax2.plot(x, np.sin(x + s), '-')
ax2.margins(0)
# bar graphs
x = np.arange(5)
y1, y2 = np.random.randint(1, 25, size=(2, 5))
width = 0.25
ax3.bar(x, y1, width)
ax3.bar(x + width, y2, width,
color=list(plt.rcParams['axes.prop_cycle'])[2]['color'])
ax3.set_xticks(x + width)
ax3.set_xticklabels(['a', 'b', 'c', 'd', 'e'])
# circles with colors from default color cycle
for i, color in enumerate(plt.rcParams['axes.prop_cycle']):
xy = np.random.normal(size=2)
ax4.add_patch(plt.Circle(xy, radius=0.3, color=color['color']))
ax4.axis('equal')
ax4.margins(0)
plt.show()
Seaborn is a statistical graphics package built on top of matplotlib. It provides higher level graphics capabilities taylored to the statistics and data manipulation.
First, load flights information into data frame - just read CSV.
In [14]:
hflights = pd.read_csv("hflights.csv")
hflights.head()
Out[14]:
Year
Month
DayofMonth
DayOfWeek
DepTime
ArrTime
UniqueCarrier
FlightNum
TailNum
ActualElapsedTime
...
ArrDelay
DepDelay
Origin
Dest
Distance
TaxiIn
TaxiOut
Cancelled
CancellationCode
Diverted
0
2011
1
1
6
1400.0
1500.0
AA
428
N576AA
60.0
...
-10.0
0.0
IAH
DFW
224
7.0
13.0
0
NaN
0
1
2011
1
2
7
1401.0
1501.0
AA
428
N557AA
60.0
...
-9.0
1.0
IAH
DFW
224
6.0
9.0
0
NaN
0
2
2011
1
3
1
1352.0
1502.0
AA
428
N541AA
70.0
...
-8.0
-8.0
IAH
DFW
224
5.0
17.0
0
NaN
0
3
2011
1
4
2
1403.0
1513.0
AA
428
N403AA
70.0
...
3.0
3.0
IAH
DFW
224
9.0
22.0
0
NaN
0
4
2011
1
5
3
1405.0
1507.0
AA
428
N492AA
62.0
...
-3.0
5.0
IAH
DFW
224
9.0
9.0
0
NaN
0
5 rows × 21 columns
Here one can see the data frame base statistical values.
In [15]:
hflights.describe()
Out[15]:
Year
Month
DayofMonth
DayOfWeek
DepTime
ArrTime
FlightNum
ActualElapsedTime
AirTime
ArrDelay
DepDelay
Distance
TaxiIn
TaxiOut
Cancelled
Diverted
count
227496.0
227496.000000
227496.000000
227496.000000
224591.000000
224430.000000
227496.000000
223874.000000
223874.000000
223874.000000
224591.000000
227496.000000
224430.000000
224549.000000
227496.000000
227496.000000
mean
2011.0
6.513662
15.737446
3.947691
1395.755614
1578.254106
1961.663141
129.323745
108.142335
7.094334
9.444951
787.783245
6.098855
15.091098
0.013068
0.002853
std
0.0
3.417676
8.782705
1.990272
448.322238
472.401715
1430.793403
59.285838
56.555231
30.708516
28.803615
453.680566
3.961069
7.740373
0.113568
0.053335
min
2011.0
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
34.000000
11.000000
-70.000000
-33.000000
79.000000
1.000000
1.000000
0.000000
0.000000
25%
2011.0
4.000000
8.000000
2.000000
1021.000000
1215.000000
855.000000
77.000000
58.000000
-8.000000
-3.000000
376.000000
4.000000
10.000000
0.000000
0.000000
50%
2011.0
7.000000
16.000000
4.000000
1416.000000
1617.000000
1696.000000
128.000000
107.000000
0.000000
0.000000
809.000000
5.000000
14.000000
0.000000
0.000000
75%
2011.0
9.000000
23.000000
6.000000
1801.000000
1953.000000
2755.000000
165.000000
141.000000
11.000000
9.000000
1042.000000
7.000000
18.000000
0.000000
0.000000
max
2011.0
12.000000
31.000000
7.000000
2400.000000
2400.000000
7290.000000
575.000000
549.000000
978.000000
981.000000
3904.000000
165.000000
163.000000
1.000000
1.000000
In [16]:
hflights.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 227496 entries, 0 to 227495
Data columns (total 21 columns):
Year 227496 non-null int64
Month 227496 non-null int64
DayofMonth 227496 non-null int64
DayOfWeek 227496 non-null int64
DepTime 224591 non-null float64
ArrTime 224430 non-null float64
UniqueCarrier 227496 non-null object
FlightNum 227496 non-null int64
TailNum 226701 non-null object
ActualElapsedTime 223874 non-null float64
AirTime 223874 non-null float64
ArrDelay 223874 non-null float64
DepDelay 224591 non-null float64
Origin 227496 non-null object
Dest 227496 non-null object
Distance 227496 non-null int64
TaxiIn 224430 non-null float64
TaxiOut 224549 non-null float64
Cancelled 227496 non-null int64
CancellationCode 2973 non-null object
Diverted 227496 non-null int64
dtypes: float64(8), int64(8), object(5)
memory usage: 36.4+ MB
Any operations on data in Pandas are either done over columns (row index/name fixed, column index is changing) or over rows (columns index is fixed, row index is changing). For that there is quite well-spread through API parameter called axis. To have better mnemonics I usually define two constants.
In [17]:
AXIS_ROW_OP = 0
AXIS_COL_OP = 1
In [18]:
# del hflights['Year'] # or, alternatively, drop column
hflights.drop(['Year'], axis = AXIS_COL_OP, inplace = True, errors = 'ignore')
hflights.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 227496 entries, 0 to 227495
Data columns (total 20 columns):
Month 227496 non-null int64
DayofMonth 227496 non-null int64
DayOfWeek 227496 non-null int64
DepTime 224591 non-null float64
ArrTime 224430 non-null float64
UniqueCarrier 227496 non-null object
FlightNum 227496 non-null int64
TailNum 226701 non-null object
ActualElapsedTime 223874 non-null float64
AirTime 223874 non-null float64
ArrDelay 223874 non-null float64
DepDelay 224591 non-null float64
Origin 227496 non-null object
Dest 227496 non-null object
Distance 227496 non-null int64
TaxiIn 224430 non-null float64
TaxiOut 224549 non-null float64
Cancelled 227496 non-null int64
CancellationCode 2973 non-null object
Diverted 227496 non-null int64
dtypes: float64(8), int64(7), object(5)
memory usage: 34.7+ MB
Now, check if we have any null values
In [19]:
q = hflights.isnull()
q.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 227496 entries, 0 to 227495
Data columns (total 20 columns):
Month 227496 non-null bool
DayofMonth 227496 non-null bool
DayOfWeek 227496 non-null bool
DepTime 227496 non-null bool
ArrTime 227496 non-null bool
UniqueCarrier 227496 non-null bool
FlightNum 227496 non-null bool
TailNum 227496 non-null bool
ActualElapsedTime 227496 non-null bool
AirTime 227496 non-null bool
ArrDelay 227496 non-null bool
DepDelay 227496 non-null bool
Origin 227496 non-null bool
Dest 227496 non-null bool
Distance 227496 non-null bool
TaxiIn 227496 non-null bool
TaxiOut 227496 non-null bool
Cancelled 227496 non-null bool
CancellationCode 227496 non-null bool
Diverted 227496 non-null bool
dtypes: bool(20)
memory usage: 4.3 MB
In [20]:
t = q.any()
print(type(t))
print(t)
<class 'pandas.core.series.Series'>
Month False
DayofMonth False
DayOfWeek False
DepTime True
ArrTime True
UniqueCarrier False
FlightNum False
TailNum True
ActualElapsedTime True
AirTime True
ArrDelay True
DepDelay True
Origin False
Dest False
Distance False
TaxiIn True
TaxiOut True
Cancelled False
CancellationCode True
Diverted False
dtype: bool
In [21]:
l = len(hflights)
# print(l)
c = hflights.count()
# print(c)
print(l - c)
Month 0
DayofMonth 0
DayOfWeek 0
DepTime 2905
ArrTime 3066
UniqueCarrier 0
FlightNum 0
TailNum 795
ActualElapsedTime 3622
AirTime 3622
ArrDelay 3622
DepDelay 2905
Origin 0
Dest 0
Distance 0
TaxiIn 3066
TaxiOut 2947
Cancelled 0
CancellationCode 224523
Diverted 0
dtype: int64
In [22]:
iah = hflights['Origin'] != 'IAH'
hou = hflights['Origin'] != 'HOU'
print(iah.sum(), hou.sum(), iah.sum() + hou.sum())
52299 175197 227496
In [23]:
plt.figure()
sns.pointplot(x='DayofMonth', y='AirTime', data=hflights, hue='DayOfWeek')
sns.plt.show()
There are two airport in the dataset, so we could plot and see how they are different
In [24]:
plt.figure()
sns.pointplot(x='DayofMonth', y='AirTime', data=hflights, hue='Origin')
sns.plt.show()
Plotting for each origin airport airtime vs day of the week
In [25]:
plt.figure()
sns.pointplot(x='DayOfWeek', y='AirTime', data=hflights, hue='Origin')
sns.plt.show()
Overlapping distribution vs histogram
In [26]:
plt.figure()
sns.distplot(hflights["Distance"], bins=30)
sns.plt.show()
C:\Users\kriol\Anaconda3\lib\site-packages\statsmodels\nonparametric\kdetools.py:20: VisibleDeprecationWarning: using a non-integer number instead of an integer will result in an error in the future
y = X[:m/2+1] + np.r_[0,X[m/2+1:],0]*1j
Joint plot - how correlated values are
In [27]:
sns.jointplot(x="ActualElapsedTime", y="Distance", data=hflights)
Out[27]:
<seaborn.axisgrid.JointGrid at 0x1fdda49f2e8>
Groupby in Python/Pandas is the way to group series using key (or set of keys). Basically, it is the first of three step process:
In [28]:
carriers = hflights.groupby(by=["UniqueCarrier"], axis=AXIS_ROW_OP, as_index=False)
print(type(carriers))
print(carriers.groups)
<class 'pandas.core.groupby.DataFrameGroupBy'>
{'DL': Int64Index([ 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425,
6426, 6427,
...
214750, 214751, 214752, 214753, 214754, 214755, 214756, 214757,
214758, 214759],
dtype='int64', length=2641), 'AS': Int64Index([ 273, 274, 275, 276, 277, 278, 279, 280,
281, 282,
...
208687, 208688, 208689, 208690, 208691, 208692, 208693, 208694,
208695, 208696],
dtype='int64', length=365), 'MQ': Int64Index([ 8563, 8564, 8565, 8566, 8567, 8568, 8569, 8570,
8571, 8572,
...
215600, 215601, 215602, 215603, 215604, 215605, 215606, 215607,
215608, 215609],
dtype='int64', length=4648), 'F9': Int64Index([ 8357, 8358, 8359, 8360, 8361, 8362, 8363, 8364,
8365, 8366,
...
215022, 215023, 215024, 215025, 215026, 215027, 215028, 215029,
215030, 215031],
dtype='int64', length=838), 'WN': Int64Index([ 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652,
7653, 7654,
...
227486, 227487, 227488, 227489, 227490, 227491, 227492, 227493,
227494, 227495],
dtype='int64', length=45343), 'XE': Int64Index([ 12135, 12136, 12137, 12138, 12139, 12140, 12141, 12142,
12143, 12144,
...
224559, 224560, 224561, 224562, 224563, 224564, 224565, 224566,
224567, 224568],
dtype='int64', length=73053), 'B6': Int64Index([ 304, 305, 306, 307, 308, 309, 310, 311,
312, 313,
...
208747, 208748, 208749, 208750, 208751, 208752, 208753, 208754,
208755, 208756],
dtype='int64', length=695), 'AA': Int64Index([ 0, 1, 2, 3, 4, 5, 6, 7,
8, 9,
...
208656, 208657, 208658, 208659, 208660, 208661, 208662, 208663,
208664, 208665],
dtype='int64', length=3244), 'OO': Int64Index([ 6537, 6538, 6539, 6540, 6541, 6542, 6543, 6544,
6545, 6546,
...
226146, 226147, 226148, 226149, 226150, 226151, 226152, 226153,
226154, 226155],
dtype='int64', length=16061), 'FL': Int64Index([ 8419, 8420, 8421, 8422, 8423, 8424, 8425, 8426,
8427, 8428,
...
215177, 215178, 215179, 215180, 215181, 215182, 215183, 215184,
215185, 215186],
dtype='int64', length=2139), 'US': Int64Index([ 7337, 7338, 7339, 7340, 7341, 7342, 7343, 7344,
7345, 7346,
...
226754, 226755, 226756, 226757, 226758, 226759, 226760, 226761,
226762, 226763],
dtype='int64', length=4082), 'CO': Int64Index([ 355, 356, 357, 358, 359, 360, 361, 362,
363, 364,
...
214550, 214551, 214552, 214553, 214554, 214555, 214556, 214557,
214558, 214559],
dtype='int64', length=70032), 'EV': Int64Index([ 8251, 8252, 8253, 8254, 8255, 8256, 8257, 8258,
8259, 8260,
...
214957, 214958, 214959, 214960, 214961, 214962, 214963, 214964,
214965, 214966],
dtype='int64', length=2204), 'UA': Int64Index([ 7236, 7237, 7238, 7239, 7240, 7241, 7242, 7243,
7244, 7245,
...
226334, 226335, 226336, 226337, 226338, 226339, 226340, 226341,
226342, 226343],
dtype='int64', length=2072), 'YV': Int64Index([ 33504, 33505, 55503, 55504, 55505, 55506, 55507, 70518,
70519, 70520, 70521, 70522, 70523, 70524, 70525, 70526,
70527, 70528, 70529, 70530, 70531, 70532, 70533, 70534,
70535, 70536, 70537, 70538, 70539, 70540, 70541, 70542,
70543, 70544, 70545, 70546, 70547, 70548, 70549, 70550,
70551, 70552, 70553, 70554, 70555, 70556, 70557, 70558,
70559, 70560, 70561, 70562, 70563, 70564, 70565, 70566,
70567, 70568, 70569, 70570, 89563, 89564, 89565, 89566,
89567, 89568, 89569, 89570, 109025, 109026, 109027, 109028,
129552, 129553, 129554, 129555, 129556, 144280, 144281],
dtype='int64')}
We could look what's inside the groups - by pressing
In [29]:
for name, c in carriers:
print(name, c)
AA Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
0 1 1 6 1400.0 1500.0 AA
1 1 2 7 1401.0 1501.0 AA
2 1 3 1 1352.0 1502.0 AA
3 1 4 2 1403.0 1513.0 AA
4 1 5 3 1405.0 1507.0 AA
5 1 6 4 1359.0 1503.0 AA
6 1 7 5 1359.0 1509.0 AA
7 1 8 6 1355.0 1454.0 AA
8 1 9 7 1443.0 1554.0 AA
9 1 10 1 1443.0 1553.0 AA
10 1 11 2 1429.0 1539.0 AA
11 1 12 3 1419.0 1515.0 AA
12 1 13 4 1358.0 1501.0 AA
13 1 14 5 1357.0 1504.0 AA
14 1 15 6 1359.0 1459.0 AA
15 1 16 7 1359.0 1509.0 AA
16 1 17 1 1530.0 1634.0 AA
17 1 18 2 1408.0 1508.0 AA
18 1 19 3 1356.0 1503.0 AA
19 1 20 4 1507.0 1622.0 AA
20 1 21 5 1357.0 1459.0 AA
21 1 22 6 1355.0 1456.0 AA
22 1 23 7 1356.0 1501.0 AA
23 1 24 1 1356.0 1513.0 AA
24 1 25 2 1352.0 1452.0 AA
25 1 26 3 1353.0 1455.0 AA
26 1 27 4 1356.0 1458.0 AA
27 1 28 5 1359.0 1505.0 AA
28 1 29 6 1355.0 1455.0 AA
29 1 30 7 1359.0 1456.0 AA
... ... ... ... ... ... ...
208636 12 2 5 1033.0 1354.0 AA
208637 12 3 6 1023.0 1350.0 AA
208638 12 4 7 1016.0 1342.0 AA
208639 12 5 1 1013.0 1350.0 AA
208640 12 6 2 1014.0 1329.0 AA
208641 12 7 3 1015.0 1338.0 AA
208642 12 8 4 1013.0 1325.0 AA
208643 12 9 5 1029.0 1345.0 AA
208644 12 10 6 1029.0 1342.0 AA
208645 12 11 7 1016.0 1331.0 AA
208646 12 12 1 1016.0 1329.0 AA
208647 12 13 2 1014.0 1337.0 AA
208648 12 14 3 1027.0 1344.0 AA
208649 12 15 4 1017.0 1339.0 AA
208650 12 16 5 1021.0 1349.0 AA
208651 12 17 6 1025.0 1335.0 AA
208652 12 18 7 1045.0 1353.0 AA
208653 12 19 1 1019.0 1338.0 AA
208654 12 20 2 1023.0 1350.0 AA
208655 12 21 3 1023.0 1346.0 AA
208656 12 22 4 1030.0 1358.0 AA
208657 12 23 5 1028.0 1405.0 AA
208658 12 24 6 1021.0 1345.0 AA
208659 12 25 7 1019.0 1343.0 AA
208660 12 26 1 1011.0 1327.0 AA
208661 12 27 2 1021.0 1333.0 AA
208662 12 28 3 1015.0 1329.0 AA
208663 12 29 4 1023.0 1335.0 AA
208664 12 30 5 1024.0 1334.0 AA
208665 12 31 6 1024.0 1343.0 AA
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
0 428 N576AA 60.0 40.0 -10.0 0.0
1 428 N557AA 60.0 45.0 -9.0 1.0
2 428 N541AA 70.0 48.0 -8.0 -8.0
3 428 N403AA 70.0 39.0 3.0 3.0
4 428 N492AA 62.0 44.0 -3.0 5.0
5 428 N262AA 64.0 45.0 -7.0 -1.0
6 428 N493AA 70.0 43.0 -1.0 -1.0
7 428 N477AA 59.0 40.0 -16.0 -5.0
8 428 N476AA 71.0 41.0 44.0 43.0
9 428 N504AA 70.0 45.0 43.0 43.0
10 428 N565AA 70.0 42.0 29.0 29.0
11 428 N577AA 56.0 41.0 5.0 19.0
12 428 N476AA 63.0 44.0 -9.0 -2.0
13 428 N552AA 67.0 47.0 -6.0 -3.0
14 428 N462AA 60.0 44.0 -11.0 -1.0
15 428 N555AA 70.0 41.0 -1.0 -1.0
16 428 N518AA 64.0 48.0 84.0 90.0
17 428 N507AA 60.0 42.0 -2.0 8.0
18 428 N523AA 67.0 46.0 -7.0 -4.0
19 428 N425AA 75.0 42.0 72.0 67.0
20 428 N251AA 62.0 47.0 -11.0 -3.0
21 428 N551AA 61.0 44.0 -14.0 -5.0
22 428 N479AA 65.0 40.0 -9.0 -4.0
23 428 N531AA 77.0 43.0 3.0 -4.0
24 428 N561AA 60.0 40.0 -18.0 -8.0
25 428 N541AA 62.0 40.0 -15.0 -7.0
26 428 N512AA 62.0 40.0 -12.0 -4.0
27 428 N4UBAA 66.0 46.0 -5.0 -1.0
28 428 N491AA 60.0 46.0 -15.0 -5.0
29 428 N561AA 57.0 39.0 -14.0 -1.0
... ... ... ... ... ... ...
208636 2234 N3CNAA 141.0 113.0 9.0 13.0
208637 2234 N3CLAA 147.0 118.0 5.0 3.0
208638 2234 N3EBAA 146.0 119.0 -3.0 -4.0
208639 2234 N3FMAA 157.0 117.0 5.0 -7.0
208640 2234 N3CSAA 135.0 114.0 -16.0 -6.0
208641 2234 N3GTAA 143.0 113.0 -7.0 -5.0
208642 2234 N3EAAA 132.0 113.0 -20.0 -7.0
208643 2234 N3EMAA 136.0 118.0 0.0 9.0
208644 2234 N3FAAA 133.0 111.0 -3.0 9.0
208645 2234 N3GLAA 135.0 112.0 -14.0 -4.0
208646 2234 N3DWAA 133.0 115.0 -16.0 -4.0
208647 2234 N3FRAA 143.0 120.0 -8.0 -6.0
208648 2234 N3FXAA 137.0 118.0 -1.0 7.0
208649 2234 N3EEAA 142.0 116.0 -6.0 -3.0
208650 2234 N3EHAA 148.0 115.0 4.0 1.0
208651 2234 N3DVAA 130.0 113.0 -10.0 5.0
208652 2234 N3HJAA 128.0 112.0 8.0 25.0
208653 2234 N3BSAA 139.0 115.0 -7.0 -1.0
208654 2234 N3EGAA 147.0 118.0 5.0 3.0
208655 2234 N3GKAA 143.0 118.0 1.0 3.0
208656 2234 N3FLAA 148.0 117.0 13.0 10.0
208657 2234 N3BWAA 157.0 115.0 20.0 8.0
208658 2234 N3CTAA 144.0 119.0 0.0 1.0
208659 2234 N3HNAA 144.0 117.0 -2.0 -1.0
208660 2234 N3HHAA 136.0 112.0 -18.0 -9.0
208661 2234 N3ETAA 132.0 112.0 -12.0 1.0
208662 2234 N3FJAA 134.0 112.0 -16.0 -5.0
208663 2234 N3GSAA 132.0 110.0 -10.0 3.0
208664 2234 N3BAAA 130.0 110.0 -11.0 4.0
208665 2234 N3HNAA 139.0 119.0 -2.0 4.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
0 IAH DFW 224 7.0 13.0 0 NaN
1 IAH DFW 224 6.0 9.0 0 NaN
2 IAH DFW 224 5.0 17.0 0 NaN
3 IAH DFW 224 9.0 22.0 0 NaN
4 IAH DFW 224 9.0 9.0 0 NaN
5 IAH DFW 224 6.0 13.0 0 NaN
6 IAH DFW 224 12.0 15.0 0 NaN
7 IAH DFW 224 7.0 12.0 0 NaN
8 IAH DFW 224 8.0 22.0 0 NaN
9 IAH DFW 224 6.0 19.0 0 NaN
10 IAH DFW 224 8.0 20.0 0 NaN
11 IAH DFW 224 4.0 11.0 0 NaN
12 IAH DFW 224 6.0 13.0 0 NaN
13 IAH DFW 224 5.0 15.0 0 NaN
14 IAH DFW 224 6.0 10.0 0 NaN
15 IAH DFW 224 12.0 17.0 0 NaN
16 IAH DFW 224 8.0 8.0 0 NaN
17 IAH DFW 224 7.0 11.0 0 NaN
18 IAH DFW 224 10.0 11.0 0 NaN
19 IAH DFW 224 9.0 24.0 0 NaN
20 IAH DFW 224 6.0 9.0 0 NaN
21 IAH DFW 224 9.0 8.0 0 NaN
22 IAH DFW 224 7.0 18.0 0 NaN
23 IAH DFW 224 6.0 28.0 0 NaN
24 IAH DFW 224 7.0 13.0 0 NaN
25 IAH DFW 224 8.0 14.0 0 NaN
26 IAH DFW 224 12.0 10.0 0 NaN
27 IAH DFW 224 8.0 12.0 0 NaN
28 IAH DFW 224 7.0 7.0 0 NaN
29 IAH DFW 224 7.0 11.0 0 NaN
... ... ... ... ... ... ... ...
208636 IAH MIA 964 13.0 15.0 0 NaN
208637 IAH MIA 964 9.0 20.0 0 NaN
208638 IAH MIA 964 7.0 20.0 0 NaN
208639 IAH MIA 964 15.0 25.0 0 NaN
208640 IAH MIA 964 6.0 15.0 0 NaN
208641 IAH MIA 964 4.0 26.0 0 NaN
208642 IAH MIA 964 7.0 12.0 0 NaN
208643 IAH MIA 964 5.0 13.0 0 NaN
208644 IAH MIA 964 5.0 17.0 0 NaN
208645 IAH MIA 964 7.0 16.0 0 NaN
208646 IAH MIA 964 6.0 12.0 0 NaN
208647 IAH MIA 964 13.0 10.0 0 NaN
208648 IAH MIA 964 7.0 12.0 0 NaN
208649 IAH MIA 964 6.0 20.0 0 NaN
208650 IAH MIA 964 8.0 25.0 0 NaN
208651 IAH MIA 964 6.0 11.0 0 NaN
208652 IAH MIA 964 4.0 12.0 0 NaN
208653 IAH MIA 964 8.0 16.0 0 NaN
208654 IAH MIA 964 8.0 21.0 0 NaN
208655 IAH MIA 964 10.0 15.0 0 NaN
208656 IAH MIA 964 11.0 20.0 0 NaN
208657 IAH MIA 964 13.0 29.0 0 NaN
208658 IAH MIA 964 11.0 14.0 0 NaN
208659 IAH MIA 964 13.0 14.0 0 NaN
208660 IAH MIA 964 12.0 12.0 0 NaN
208661 IAH MIA 964 8.0 12.0 0 NaN
208662 IAH MIA 964 9.0 13.0 0 NaN
208663 IAH MIA 964 12.0 10.0 0 NaN
208664 IAH MIA 964 9.0 11.0 0 NaN
208665 IAH MIA 964 8.0 12.0 0 NaN
Diverted
0 0
1 0
2 0
3 0
4 0
5 0
6 0
7 0
8 0
9 0
10 0
11 0
12 0
13 0
14 0
15 0
16 0
17 0
18 0
19 0
20 0
21 0
22 0
23 0
24 0
25 0
26 0
27 0
28 0
29 0
... ...
208636 0
208637 0
208638 0
208639 0
208640 0
208641 0
208642 0
208643 0
208644 0
208645 0
208646 0
208647 0
208648 0
208649 0
208650 0
208651 0
208652 0
208653 0
208654 0
208655 0
208656 0
208657 0
208658 0
208659 0
208660 0
208661 0
208662 0
208663 0
208664 0
208665 0
[3244 rows x 20 columns]
AS Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
273 1 1 6 1824.0 2106.0 AS
274 1 2 7 1823.0 2103.0 AS
275 1 3 1 1827.0 2107.0 AS
276 1 4 2 1845.0 2132.0 AS
277 1 5 3 1821.0 2109.0 AS
278 1 6 4 1834.0 2133.0 AS
279 1 7 5 1823.0 2118.0 AS
280 1 8 6 1822.0 2112.0 AS
281 1 9 7 1938.0 2228.0 AS
282 1 10 1 1820.0 2159.0 AS
283 1 11 2 1820.0 12.0 AS
284 1 12 3 1822.0 2129.0 AS
285 1 13 4 1820.0 2113.0 AS
286 1 14 5 1818.0 2114.0 AS
287 1 15 6 1822.0 2131.0 AS
288 1 16 7 1822.0 2138.0 AS
289 1 17 1 1818.0 2149.0 AS
290 1 18 2 1836.0 2130.0 AS
291 1 19 3 1820.0 2102.0 AS
292 1 20 4 1822.0 2135.0 AS
293 1 21 5 1827.0 2136.0 AS
294 1 22 6 1816.0 2100.0 AS
295 1 23 7 1818.0 2104.0 AS
296 1 24 1 1824.0 2109.0 AS
297 1 25 2 1826.0 2101.0 AS
298 1 26 3 1830.0 2115.0 AS
299 1 27 4 1832.0 2110.0 AS
300 1 28 5 1821.0 2052.0 AS
301 1 29 6 1821.0 2042.0 AS
302 1 30 7 1821.0 2128.0 AS
... ... ... ... ... ... ...
208667 12 2 5 1831.0 2107.0 AS
208668 12 3 6 1826.0 2051.0 AS
208669 12 4 7 1834.0 2116.0 AS
208670 12 5 1 1846.0 2130.0 AS
208671 12 6 2 1828.0 2111.0 AS
208672 12 7 3 1835.0 2103.0 AS
208673 12 8 4 1845.0 2115.0 AS
208674 12 9 5 1840.0 2107.0 AS
208675 12 10 6 1826.0 2039.0 AS
208676 12 11 7 1829.0 2103.0 AS
208677 12 12 1 1918.0 2136.0 AS
208678 12 13 2 1827.0 2050.0 AS
208679 12 14 3 1826.0 2055.0 AS
208680 12 15 4 1843.0 2109.0 AS
208681 12 16 5 1825.0 2125.0 AS
208682 12 17 6 1855.0 2125.0 AS
208683 12 18 7 1836.0 2059.0 AS
208684 12 19 1 1836.0 2100.0 AS
208685 12 20 2 1908.0 2145.0 AS
208686 12 21 3 1845.0 2112.0 AS
208687 12 22 4 1845.0 2128.0 AS
208688 12 23 5 1830.0 2111.0 AS
208689 12 24 6 1840.0 2109.0 AS
208690 12 25 7 1842.0 2110.0 AS
208691 12 26 1 1842.0 2142.0 AS
208692 12 27 2 1821.0 2111.0 AS
208693 12 28 3 1823.0 2116.0 AS
208694 12 29 4 1815.0 2123.0 AS
208695 12 30 5 2005.0 2238.0 AS
208696 12 31 6 1843.0 2131.0 AS
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
273 731 N614AS 282.0 255.0 -4.0 -1.0
274 731 N627AS 280.0 257.0 -7.0 -2.0
275 731 N627AS 280.0 260.0 -3.0 2.0
276 731 N618AS 287.0 268.0 22.0 20.0
277 731 N607AS 288.0 273.0 -1.0 -4.0
278 731 N624AS 299.0 278.0 23.0 9.0
279 731 N611AS 295.0 274.0 8.0 -2.0
280 731 N607AS 290.0 269.0 2.0 -3.0
281 731 N609AS 290.0 253.0 78.0 73.0
282 731 N626AS 339.0 315.0 49.0 -5.0
283 731 N626AS NaN NaN NaN -5.0
284 731 N619AS 307.0 284.0 19.0 -3.0
285 731 N627AS 293.0 273.0 3.0 -5.0
286 731 N627AS 296.0 270.0 4.0 -7.0
287 731 N627AS 309.0 287.0 21.0 -3.0
288 731 N627AS 316.0 291.0 28.0 -3.0
289 731 N612AS 331.0 310.0 39.0 -7.0
290 731 N617AS 294.0 276.0 20.0 11.0
291 731 N622AS 282.0 265.0 -8.0 -5.0
292 731 N622AS 313.0 284.0 25.0 -3.0
293 731 N622AS 309.0 288.0 26.0 2.0
294 731 N644AS 284.0 269.0 -10.0 -9.0
295 731 N624AS 286.0 269.0 -6.0 -7.0
296 731 N644AS 285.0 251.0 -1.0 -1.0
297 731 N607AS 275.0 255.0 -9.0 1.0
298 731 N607AS 285.0 255.0 5.0 5.0
299 731 N627AS 278.0 262.0 0.0 7.0
300 731 N627AS 271.0 256.0 -18.0 -4.0
301 731 N627AS 261.0 246.0 -28.0 -4.0
302 731 N627AS 307.0 264.0 18.0 -4.0
... ... ... ... ... ... ...
208667 731 N546AS 276.0 248.0 -15.0 1.0
208668 731 N586AS 265.0 249.0 -31.0 -4.0
208669 731 N558AS 282.0 244.0 -6.0 4.0
208670 731 N560AS 284.0 245.0 8.0 16.0
208671 731 N593AS 283.0 254.0 -11.0 -2.0
208672 731 N559AS 268.0 251.0 -19.0 5.0
208673 731 N553AS 270.0 252.0 -7.0 15.0
208674 731 N586AS 267.0 252.0 -15.0 10.0
208675 731 N306AS 253.0 239.0 -43.0 -4.0
208676 731 N527AS 274.0 255.0 -21.0 -1.0
208677 731 N527AS 258.0 237.0 12.0 48.0
208678 731 N526AS 263.0 238.0 -34.0 -3.0
208679 731 N526AS 269.0 248.0 -29.0 -4.0
208680 731 N586AS 266.0 249.0 -15.0 13.0
208681 731 N586AS 300.0 255.0 1.0 -5.0
208682 731 N528AS 270.0 248.0 1.0 25.0
208683 731 N303AS 263.0 235.0 -25.0 6.0
208684 731 N526AS 264.0 240.0 -24.0 6.0
208685 731 N526AS 277.0 258.0 21.0 38.0
208686 731 N514AS 267.0 249.0 -12.0 15.0
208687 731 N514AS 283.0 252.0 4.0 15.0
208688 731 N514AS 281.0 254.0 -13.0 0.0
208689 731 N548AS 269.0 242.0 -15.0 10.0
208690 731 N594AS 268.0 246.0 -14.0 12.0
208691 731 N560AS 300.0 279.0 18.0 12.0
208692 731 N560AS 290.0 264.0 -13.0 -9.0
208693 731 N560AS 293.0 268.0 -8.0 -7.0
208694 731 N549AS 308.0 286.0 -1.0 -15.0
208695 731 N553AS 273.0 255.0 74.0 95.0
208696 731 N526AS 288.0 272.0 7.0 13.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
273 IAH SEA 1874 7.0 20.0 0 NaN
274 IAH SEA 1874 7.0 16.0 0 NaN
275 IAH SEA 1874 4.0 16.0 0 NaN
276 IAH SEA 1874 8.0 11.0 0 NaN
277 IAH SEA 1874 5.0 10.0 0 NaN
278 IAH SEA 1874 3.0 18.0 0 NaN
279 IAH SEA 1874 7.0 14.0 0 NaN
280 IAH SEA 1874 6.0 15.0 0 NaN
281 IAH SEA 1874 5.0 32.0 0 NaN
282 IAH SEA 1874 4.0 20.0 0 NaN
283 IAH SEA 1874 4.0 18.0 0 NaN
284 IAH SEA 1874 5.0 18.0 0 NaN
285 IAH SEA 1874 5.0 15.0 0 NaN
286 IAH SEA 1874 7.0 19.0 0 NaN
287 IAH SEA 1874 4.0 18.0 0 NaN
288 IAH SEA 1874 5.0 20.0 0 NaN
289 IAH SEA 1874 4.0 17.0 0 NaN
290 IAH SEA 1874 4.0 14.0 0 NaN
291 IAH SEA 1874 7.0 10.0 0 NaN
292 IAH SEA 1874 3.0 26.0 0 NaN
293 IAH SEA 1874 7.0 14.0 0 NaN
294 IAH SEA 1874 4.0 11.0 0 NaN
295 IAH SEA 1874 5.0 12.0 0 NaN
296 IAH SEA 1874 3.0 31.0 0 NaN
297 IAH SEA 1874 4.0 16.0 0 NaN
298 IAH SEA 1874 6.0 24.0 0 NaN
299 IAH SEA 1874 5.0 11.0 0 NaN
300 IAH SEA 1874 3.0 12.0 0 NaN
301 IAH SEA 1874 3.0 12.0 0 NaN
302 IAH SEA 1874 6.0 37.0 0 NaN
... ... ... ... ... ... ... ...
208667 IAH SEA 1874 4.0 24.0 0 NaN
208668 IAH SEA 1874 4.0 12.0 0 NaN
208669 IAH SEA 1874 5.0 33.0 0 NaN
208670 IAH SEA 1874 5.0 34.0 0 NaN
208671 IAH SEA 1874 3.0 26.0 0 NaN
208672 IAH SEA 1874 4.0 13.0 0 NaN
208673 IAH SEA 1874 3.0 15.0 0 NaN
208674 IAH SEA 1874 3.0 12.0 0 NaN
208675 IAH SEA 1874 5.0 9.0 0 NaN
208676 IAH SEA 1874 7.0 12.0 0 NaN
208677 IAH SEA 1874 4.0 17.0 0 NaN
208678 IAH SEA 1874 5.0 20.0 0 NaN
208679 IAH SEA 1874 4.0 17.0 0 NaN
208680 IAH SEA 1874 6.0 11.0 0 NaN
208681 IAH SEA 1874 5.0 40.0 0 NaN
208682 IAH SEA 1874 6.0 16.0 0 NaN
208683 IAH SEA 1874 9.0 19.0 0 NaN
208684 IAH SEA 1874 5.0 19.0 0 NaN
208685 IAH SEA 1874 3.0 16.0 0 NaN
208686 IAH SEA 1874 7.0 11.0 0 NaN
208687 IAH SEA 1874 7.0 24.0 0 NaN
208688 IAH SEA 1874 7.0 20.0 0 NaN
208689 IAH SEA 1874 4.0 23.0 0 NaN
208690 IAH SEA 1874 3.0 19.0 0 NaN
208691 IAH SEA 1874 4.0 17.0 0 NaN
208692 IAH SEA 1874 8.0 18.0 0 NaN
208693 IAH SEA 1874 6.0 19.0 0 NaN
208694 IAH SEA 1874 5.0 17.0 0 NaN
208695 IAH SEA 1874 5.0 13.0 0 NaN
208696 IAH SEA 1874 6.0 10.0 0 NaN
Diverted
273 0
274 0
275 0
276 0
277 0
278 0
279 0
280 0
281 0
282 0
283 1
284 0
285 0
286 0
287 0
288 0
289 0
290 0
291 0
292 0
293 0
294 0
295 0
296 0
297 0
298 0
299 0
300 0
301 0
302 0
... ...
208667 0
208668 0
208669 0
208670 0
208671 0
208672 0
208673 0
208674 0
208675 0
208676 0
208677 0
208678 0
208679 0
208680 0
208681 0
208682 0
208683 0
208684 0
208685 0
208686 0
208687 0
208688 0
208689 0
208690 0
208691 0
208692 0
208693 0
208694 0
208695 0
208696 0
[365 rows x 20 columns]
B6 Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
304 1 1 6 654.0 1124.0 B6
305 1 1 6 1639.0 2110.0 B6
306 1 2 7 703.0 1113.0 B6
307 1 2 7 1604.0 2040.0 B6
308 1 3 1 659.0 1100.0 B6
309 1 3 1 1801.0 2200.0 B6
310 1 4 2 654.0 1103.0 B6
311 1 4 2 1608.0 2034.0 B6
312 1 5 3 700.0 1103.0 B6
313 1 5 3 1544.0 1954.0 B6
314 1 6 4 1532.0 1943.0 B6
315 1 7 5 654.0 1117.0 B6
316 1 7 5 1542.0 1956.0 B6
317 1 8 6 654.0 1058.0 B6
318 1 9 7 653.0 1059.0 B6
319 1 9 7 1618.0 2057.0 B6
320 1 10 1 656.0 1102.0 B6
321 1 10 1 1554.0 2001.0 B6
322 1 11 2 653.0 1053.0 B6
323 1 11 2 NaN NaN B6
324 1 12 3 1532.0 1953.0 B6
325 1 13 4 1522.0 1938.0 B6
326 1 14 5 808.0 1229.0 B6
327 1 14 5 1534.0 2015.0 B6
328 1 15 6 700.0 1114.0 B6
329 1 16 7 652.0 1055.0 B6
330 1 16 7 1551.0 2004.0 B6
331 1 17 1 730.0 1135.0 B6
332 1 17 1 1531.0 1946.0 B6
333 1 18 2 659.0 1102.0 B6
... ... ... ... ... ... ...
208727 12 17 6 641.0 1038.0 B6
208728 12 17 6 1616.0 2033.0 B6
208729 12 18 7 637.0 1050.0 B6
208730 12 18 7 1726.0 2149.0 B6
208731 12 19 1 640.0 1106.0 B6
208732 12 19 1 1543.0 2004.0 B6
208733 12 20 2 647.0 1059.0 B6
208734 12 20 2 1624.0 2044.0 B6
208735 12 21 3 634.0 1039.0 B6
208736 12 21 3 1756.0 2230.0 B6
208737 12 22 4 634.0 1039.0 B6
208738 12 22 4 1640.0 2053.0 B6
208739 12 23 5 633.0 1038.0 B6
208740 12 23 5 1606.0 2015.0 B6
208741 12 24 6 635.0 1035.0 B6
208742 12 24 6 1600.0 2012.0 B6
208743 12 25 7 638.0 1052.0 B6
208744 12 25 7 1608.0 2013.0 B6
208745 12 26 1 633.0 1046.0 B6
208746 12 26 1 1550.0 2002.0 B6
208747 12 27 2 634.0 1040.0 B6
208748 12 27 2 1955.0 39.0 B6
208749 12 28 3 632.0 1047.0 B6
208750 12 28 3 1748.0 2147.0 B6
208751 12 29 4 633.0 1050.0 B6
208752 12 29 4 1541.0 1959.0 B6
208753 12 30 5 634.0 1040.0 B6
208754 12 30 5 1541.0 1957.0 B6
208755 12 31 6 831.0 1251.0 B6
208756 12 31 6 1544.0 2009.0 B6
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
304 620 N324JB 210.0 181.0 5.0 -6.0
305 622 N324JB 211.0 188.0 61.0 54.0
306 620 N324JB 190.0 172.0 -6.0 3.0
307 622 N324JB 216.0 176.0 31.0 19.0
308 620 N229JB 181.0 166.0 -19.0 -1.0
309 622 N206JB 179.0 165.0 111.0 136.0
310 620 N267JB 189.0 168.0 -16.0 -6.0
311 622 N267JB 206.0 175.0 25.0 23.0
312 620 N708JB 183.0 167.0 -14.0 0.0
313 624 N644JB 190.0 166.0 -6.0 9.0
314 624 N641JB 191.0 175.0 -17.0 -3.0
315 620 N641JB 203.0 172.0 0.0 -6.0
316 624 N564JB 194.0 175.0 -4.0 7.0
317 620 N630JB 184.0 162.0 -19.0 -6.0
318 620 N599JB 186.0 163.0 -18.0 -7.0
319 624 N625JB 219.0 196.0 57.0 43.0
320 620 N625JB 186.0 166.0 -15.0 -4.0
321 624 N504JB 187.0 170.0 1.0 19.0
322 620 N504JB 180.0 161.0 -24.0 -7.0
323 624 N537JB NaN NaN NaN NaN
324 624 N504JB 201.0 177.0 -7.0 -3.0
325 624 N597JB 196.0 178.0 -22.0 -13.0
326 620 N597JB 201.0 185.0 72.0 68.0
327 624 N729JB 221.0 189.0 15.0 -1.0
328 620 N503JB 194.0 173.0 -3.0 0.0
329 620 N706JB 183.0 166.0 -22.0 -8.0
330 624 N565JB 193.0 176.0 4.0 16.0
331 620 N523JB 185.0 168.0 18.0 30.0
332 624 N779JB 195.0 173.0 -14.0 -4.0
333 620 N779JB 183.0 162.0 -15.0 -1.0
... ... ... ... ... ... ...
208727 620 N247JB 177.0 162.0 -25.0 1.0
208728 622 N247JB 197.0 170.0 16.0 26.0
208729 620 N324JB 193.0 180.0 -13.0 -3.0
208730 622 N247JB 203.0 184.0 92.0 96.0
208731 620 N247JB 206.0 186.0 3.0 0.0
208732 622 N292JB 201.0 183.0 -13.0 -7.0
208733 620 N292JB 192.0 171.0 -4.0 7.0
208734 622 N306JB 200.0 183.0 27.0 34.0
208735 620 N267JB 185.0 171.0 -24.0 -6.0
208736 622 N316JB 214.0 183.0 133.0 126.0
208737 620 N231JB 185.0 166.0 -24.0 -6.0
208738 622 N306JB 193.0 174.0 36.0 50.0
208739 620 N284JB 185.0 163.0 -25.0 -7.0
208740 622 N273JB 189.0 170.0 -2.0 16.0
208741 620 N323JB 180.0 165.0 -28.0 -5.0
208742 622 N328JB 192.0 170.0 -5.0 10.0
208743 620 N273JB 194.0 170.0 -11.0 -2.0
208744 622 N192JB 185.0 168.0 -4.0 18.0
208745 620 N216JB 193.0 175.0 -17.0 -7.0
208746 622 N216JB 192.0 170.0 -15.0 0.0
208747 620 N339JB 186.0 170.0 -23.0 -6.0
208748 622 N294JB 224.0 175.0 262.0 245.0
208749 620 N231JB 195.0 177.0 -16.0 -8.0
208750 622 N281JB 179.0 168.0 90.0 118.0
208751 620 N274JB 197.0 176.0 -13.0 -7.0
208752 622 N206JB 198.0 183.0 -18.0 -9.0
208753 620 N317JB 186.0 170.0 -23.0 -6.0
208754 622 N296JB 196.0 181.0 -20.0 -9.0
208755 620 N247JB 200.0 175.0 108.0 111.0
208756 622 N323JB 205.0 190.0 -8.0 -6.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
304 HOU JFK 1428 6.0 23.0 0 NaN
305 HOU JFK 1428 12.0 11.0 0 NaN
306 HOU JFK 1428 6.0 12.0 0 NaN
307 HOU JFK 1428 9.0 31.0 0 NaN
308 HOU JFK 1428 3.0 12.0 0 NaN
309 HOU JFK 1428 5.0 9.0 0 NaN
310 HOU JFK 1428 9.0 12.0 0 NaN
311 HOU JFK 1428 8.0 23.0 0 NaN
312 HOU JFK 1428 4.0 12.0 0 NaN
313 HOU JFK 1428 14.0 10.0 0 NaN
314 HOU JFK 1428 7.0 9.0 0 NaN
315 HOU JFK 1428 6.0 25.0 0 NaN
316 HOU JFK 1428 9.0 10.0 0 NaN
317 HOU JFK 1428 9.0 13.0 0 NaN
318 HOU JFK 1428 3.0 20.0 0 NaN
319 HOU JFK 1428 11.0 12.0 0 NaN
320 HOU JFK 1428 4.0 16.0 0 NaN
321 HOU JFK 1428 7.0 10.0 0 NaN
322 HOU JFK 1428 5.0 14.0 0 NaN
323 HOU JFK 1428 NaN NaN 1 B
324 HOU JFK 1428 8.0 16.0 0 NaN
325 HOU JFK 1428 8.0 10.0 0 NaN
326 HOU JFK 1428 7.0 9.0 0 NaN
327 HOU JFK 1428 8.0 24.0 0 NaN
328 HOU JFK 1428 4.0 17.0 0 NaN
329 HOU JFK 1428 4.0 13.0 0 NaN
330 HOU JFK 1428 5.0 12.0 0 NaN
331 HOU JFK 1428 4.0 13.0 0 NaN
332 HOU JFK 1428 7.0 15.0 0 NaN
333 HOU JFK 1428 6.0 15.0 0 NaN
... ... ... ... ... ... ... ...
208727 HOU JFK 1428 4.0 11.0 0 NaN
208728 HOU JFK 1428 16.0 11.0 0 NaN
208729 HOU JFK 1428 4.0 9.0 0 NaN
208730 HOU JFK 1428 7.0 12.0 0 NaN
208731 HOU JFK 1428 9.0 11.0 0 NaN
208732 HOU JFK 1428 6.0 12.0 0 NaN
208733 HOU JFK 1428 4.0 17.0 0 NaN
208734 HOU JFK 1428 6.0 11.0 0 NaN
208735 HOU JFK 1428 5.0 9.0 0 NaN
208736 HOU JFK 1428 8.0 23.0 0 NaN
208737 HOU JFK 1428 6.0 13.0 0 NaN
208738 HOU JFK 1428 7.0 12.0 0 NaN
208739 HOU JFK 1428 5.0 17.0 0 NaN
208740 HOU JFK 1428 8.0 11.0 0 NaN
208741 HOU JFK 1428 5.0 10.0 0 NaN
208742 HOU JFK 1428 8.0 14.0 0 NaN
208743 HOU JFK 1428 9.0 15.0 0 NaN
208744 HOU JFK 1428 6.0 11.0 0 NaN
208745 HOU JFK 1428 5.0 13.0 0 NaN
208746 HOU JFK 1428 10.0 12.0 0 NaN
208747 HOU JFK 1428 6.0 10.0 0 NaN
208748 HOU JFK 1428 6.0 43.0 0 NaN
208749 HOU JFK 1428 4.0 14.0 0 NaN
208750 HOU JFK 1428 3.0 8.0 0 NaN
208751 HOU JFK 1428 4.0 17.0 0 NaN
208752 HOU JFK 1428 7.0 8.0 0 NaN
208753 HOU JFK 1428 4.0 12.0 0 NaN
208754 HOU JFK 1428 5.0 10.0 0 NaN
208755 HOU JFK 1428 5.0 20.0 0 NaN
208756 HOU JFK 1428 4.0 11.0 0 NaN
Diverted
304 0
305 0
306 0
307 0
308 0
309 0
310 0
311 0
312 0
313 0
314 0
315 0
316 0
317 0
318 0
319 0
320 0
321 0
322 0
323 0
324 0
325 0
326 0
327 0
328 0
329 0
330 0
331 0
332 0
333 0
... ...
208727 0
208728 0
208729 0
208730 0
208731 0
208732 0
208733 0
208734 0
208735 0
208736 0
208737 0
208738 0
208739 0
208740 0
208741 0
208742 0
208743 0
208744 0
208745 0
208746 0
208747 0
208748 0
208749 0
208750 0
208751 0
208752 0
208753 0
208754 0
208755 0
208756 0
[695 rows x 20 columns]
CO Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
355 1 31 1 924.0 1413.0 CO
356 1 31 1 1825.0 1925.0 CO
357 1 31 1 1554.0 1650.0 CO
358 1 31 1 1522.0 1632.0 CO
359 1 31 1 1536.0 1635.0 CO
360 1 31 1 1916.0 2103.0 CO
361 1 31 1 747.0 936.0 CO
362 1 31 1 1803.0 1927.0 CO
363 1 31 1 1206.0 1631.0 CO
364 1 31 1 1425.0 1848.0 CO
365 1 31 1 607.0 1022.0 CO
366 1 31 1 1041.0 1449.0 CO
367 1 31 1 728.0 856.0 CO
368 1 31 1 1433.0 1629.0 CO
369 1 31 1 1422.0 1647.0 CO
370 1 31 1 1750.0 1921.0 CO
371 1 31 1 1442.0 1842.0 CO
372 1 31 1 851.0 1052.0 CO
373 1 31 1 1919.0 2231.0 CO
374 1 31 1 1155.0 1324.0 CO
375 1 31 1 726.0 915.0 CO
376 1 31 1 1259.0 1554.0 CO
377 1 31 1 2116.0 2344.0 CO
378 1 31 1 1551.0 2009.0 CO
379 1 31 1 1024.0 1621.0 CO
380 1 31 1 912.0 1138.0 CO
381 1 31 1 1020.0 1421.0 CO
382 1 31 1 916.0 1336.0 CO
383 1 31 1 1301.0 1356.0 CO
384 1 31 1 1554.0 1918.0 CO
... ... ... ... ... ... ...
214530 12 1 4 1042.0 1344.0 CO
214531 12 1 4 1821.0 2224.0 CO
214532 12 1 4 1824.0 2033.0 CO
214533 12 1 4 1908.0 2225.0 CO
214534 12 1 4 1540.0 1804.0 CO
214535 12 1 4 1220.0 1539.0 CO
214536 12 1 4 1432.0 1537.0 CO
214537 12 1 4 1018.0 1126.0 CO
214538 12 1 4 1553.0 2000.0 CO
214539 12 1 4 953.0 1113.0 CO
214540 12 1 4 859.0 1004.0 CO
214541 12 1 4 1739.0 2125.0 CO
214542 12 1 4 1633.0 2008.0 CO
214543 12 1 4 1758.0 1914.0 CO
214544 12 1 4 922.0 1400.0 CO
214545 12 1 4 718.0 845.0 CO
214546 12 1 4 2055.0 2211.0 CO
214547 12 1 4 1338.0 1755.0 CO
214548 12 1 4 1912.0 2233.0 CO
214549 12 1 4 1752.0 2214.0 CO
214550 12 1 4 1805.0 2000.0 CO
214551 12 1 4 2052.0 2255.0 CO
214552 12 1 4 858.0 1055.0 CO
214553 12 1 4 2105.0 2222.0 CO
214554 12 1 4 1147.0 1411.0 CO
214555 12 1 4 932.0 1059.0 CO
214556 12 1 4 858.0 1028.0 CO
214557 12 1 4 1858.0 2323.0 CO
214558 12 1 4 2109.0 2226.0 CO
214559 12 1 4 1537.0 1836.0 CO
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
355 1 N69063 529.0 492.0 23.0 -1.0
356 5 N17245 60.0 42.0 -9.0 0.0
357 6 N77520 56.0 40.0 -5.0 -1.0
358 33 N16647 70.0 42.0 -2.0 -3.0
359 35 N35204 59.0 32.0 7.0 1.0
360 47 N76522 227.0 199.0 2.0 6.0
361 52 N67134 229.0 201.0 5.0 2.0
362 59 N57870 144.0 116.0 15.0 28.0
363 60 N68159 205.0 165.0 -2.0 1.0
364 62 N17126 203.0 163.0 -9.0 0.0
365 89 N76529 195.0 175.0 2.0 7.0
366 106 N66051 188.0 162.0 -26.0 -4.0
367 128 N75436 88.0 49.0 18.0 -2.0
368 137 N73283 236.0 199.0 14.0 5.0
369 146 N57862 145.0 114.0 64.0 77.0
370 150 N34282 211.0 189.0 6.0 15.0
371 158 N13750 180.0 142.0 7.0 -3.0
372 170 N35407 241.0 225.0 -27.0 1.0
373 190 N35260 132.0 107.0 -12.0 -1.0
374 197 N75853 209.0 172.0 3.0 0.0
375 199 N14228 169.0 128.0 8.0 1.0
376 206 N39418 115.0 91.0 -10.0 -1.0
377 209 N24715 268.0 256.0 -15.0 -7.0
378 210 N37408 198.0 166.0 -15.0 1.0
379 212 N53441 237.0 215.0 -4.0 9.0
380 220 N33132 206.0 161.0 32.0 7.0
381 226 N19621 181.0 161.0 2.0 0.0
382 232 N33266 200.0 165.0 -15.0 -4.0
383 241 N14629 55.0 27.0 -2.0 -4.0
384 244 N37274 144.0 121.0 -16.0 9.0
... ... ... ... ... ... ...
214530 1656 N73299 122.0 96.0 -3.0 -3.0
214531 1658 N76523 183.0 167.0 15.0 41.0
214532 1659 N16632 129.0 106.0 -11.0 -7.0
214533 1661 N24633 137.0 89.0 6.0 -2.0
214534 1662 N14250 144.0 118.0 -6.0 10.0
214535 1663 N17620 139.0 119.0 -6.0 0.0
214536 1667 N16632 65.0 42.0 -12.0 -3.0
214537 1675 N16701 68.0 49.0 -13.0 -7.0
214538 1676 N37408 187.0 162.0 -13.0 -2.0
214539 1677 N78866 200.0 173.0 45.0 48.0
214540 1679 N17619 65.0 38.0 -12.0 -11.0
214541 1685 N87531 166.0 147.0 -6.0 -1.0
214542 1688 N29717 155.0 129.0 -7.0 13.0
214543 1689 N37422 196.0 176.0 -9.0 8.0
214544 1690 N39416 218.0 179.0 37.0 27.0
214545 1697 N74856 207.0 172.0 5.0 3.0
214546 1698 N26210 76.0 54.0 -3.0 0.0
214547 1699 N38268 197.0 178.0 8.0 13.0
214548 1704 N76505 141.0 113.0 -2.0 2.0
214549 1706 N79521 202.0 173.0 -14.0 -3.0
214550 1707 N37409 175.0 144.0 10.0 10.0
214551 1712 N57855 243.0 214.0 -12.0 -3.0
214552 1714 N37420 237.0 215.0 -20.0 -2.0
214553 1717 N26215 197.0 177.0 -9.0 5.0
214554 1718 N37273 144.0 121.0 -12.0 2.0
214555 1723 N73259 207.0 185.0 -3.0 2.0
214556 1724 N87531 210.0 191.0 -15.0 -2.0
214557 1732 N24212 205.0 185.0 -6.0 8.0
214558 1737 N57863 197.0 159.0 -10.0 -1.0
214559 1740 N77510 119.0 101.0 -8.0 -3.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
355 IAH HNL 3904 6.0 31.0 0 NaN
356 IAH MSY 305 3.0 15.0 0 NaN
357 IAH SAT 191 2.0 14.0 0 NaN
358 IAH MSY 305 7.0 21.0 0 NaN
359 IAH AUS 140 7.0 20.0 0 NaN
360 IAH LAX 1379 8.0 20.0 0 NaN
361 IAH LAX 1379 11.0 17.0 0 NaN
362 IAH DEN 862 12.0 16.0 0 NaN
363 IAH EWR 1400 29.0 11.0 0 NaN
364 IAH EWR 1400 16.0 24.0 0 NaN
365 IAH EWR 1400 6.0 14.0 0 NaN
366 IAH EWR 1400 8.0 18.0 0 NaN
367 IAH MSY 305 6.0 33.0 0 NaN
368 IAH LAX 1379 10.0 27.0 0 NaN
369 IAH ORD 925 15.0 16.0 0 NaN
370 IAH ONT 1334 5.0 17.0 0 NaN
371 IAH DCA 1208 4.0 34.0 0 NaN
372 IAH SFO 1635 6.0 10.0 0 NaN
373 IAH MIA 964 5.0 20.0 0 NaN
374 IAH LAS 1222 8.0 29.0 0 NaN
375 IAH DEN 862 12.0 29.0 0 NaN
376 IAH TPA 787 4.0 20.0 0 NaN
377 IAH PDX 1825 4.0 8.0 0 NaN
378 IAH EWR 1400 16.0 16.0 0 NaN
379 IAH SJU 2007 6.0 16.0 0 NaN
380 IAH PHX 1009 8.0 37.0 0 NaN
381 IAH BWI 1235 5.0 15.0 0 NaN
382 IAH LGA 1416 4.0 31.0 0 NaN
383 IAH AUS 140 5.0 23.0 0 NaN
384 IAH CLE 1091 5.0 18.0 0 NaN
... ... ... ... ... ... ... ...
214530 IAH TPA 787 7.0 19.0 0 NaN
214531 IAH LGA 1416 5.0 11.0 0 NaN
214532 IAH OMA 781 4.0 19.0 0 NaN
214533 IAH ATL 689 11.0 37.0 0 NaN
214534 IAH ORD 925 9.0 17.0 0 NaN
214535 IAH CLT 912 8.0 12.0 0 NaN
214536 IAH DFW 224 6.0 17.0 0 NaN
214537 IAH MSY 305 5.0 14.0 0 NaN
214538 IAH PHL 1325 7.0 18.0 0 NaN
214539 IAH LAS 1222 15.0 12.0 0 NaN
214540 IAH SAT 191 3.0 24.0 0 NaN
214541 IAH DCA 1208 5.0 14.0 0 NaN
214542 IAH DTW 1075 11.0 15.0 0 NaN
214543 IAH SAN 1303 3.0 17.0 0 NaN
214544 IAH EWR 1400 21.0 18.0 0 NaN
214545 IAH LAS 1222 10.0 25.0 0 NaN
214546 IAH MFE 316 8.0 14.0 0 NaN
214547 IAH LGA 1416 6.0 13.0 0 NaN
214548 IAH MIA 964 5.0 23.0 0 NaN
214549 IAH EWR 1400 10.0 19.0 0 NaN
214550 IAH PHX 1009 9.0 22.0 0 NaN
214551 IAH SFO 1635 16.0 13.0 0 NaN
214552 IAH SMF 1609 5.0 17.0 0 NaN
214553 IAH SAN 1303 3.0 17.0 0 NaN
214554 IAH ORD 925 10.0 13.0 0 NaN
214555 IAH ONT 1334 6.0 16.0 0 NaN
214556 IAH SNA 1346 4.0 15.0 0 NaN
214557 IAH BOS 1597 8.0 12.0 0 NaN
214558 IAH LAS 1222 20.0 18.0 0 NaN
214559 IAH TPA 787 5.0 13.0 0 NaN
Diverted
355 0
356 0
357 0
358 0
359 0
360 0
361 0
362 0
363 0
364 0
365 0
366 0
367 0
368 0
369 0
370 0
371 0
372 0
373 0
374 0
375 0
376 0
377 0
378 0
379 0
380 0
381 0
382 0
383 0
384 0
... ...
214530 0
214531 0
214532 0
214533 0
214534 0
214535 0
214536 0
214537 0
214538 0
214539 0
214540 0
214541 0
214542 0
214543 0
214544 0
214545 0
214546 0
214547 0
214548 0
214549 0
214550 0
214551 0
214552 0
214553 0
214554 0
214555 0
214556 0
214557 0
214558 0
214559 0
[70032 rows x 20 columns]
DL Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
6418 1 1 6 1709.0 2000.0 DL
6419 1 1 6 700.0 1005.0 DL
6420 1 1 6 549.0 846.0 DL
6421 1 1 6 625.0 908.0 DL
6422 1 2 7 657.0 946.0 DL
6423 1 2 7 550.0 841.0 DL
6424 1 2 7 637.0 921.0 DL
6425 1 3 1 1602.0 1850.0 DL
6426 1 3 1 708.0 1006.0 DL
6427 1 3 1 935.0 1242.0 DL
6428 1 3 1 552.0 853.0 DL
6429 1 3 1 627.0 919.0 DL
6430 1 4 2 1610.0 1909.0 DL
6431 1 4 2 1834.0 2134.0 DL
6432 1 4 2 1248.0 1538.0 DL
6433 1 4 2 545.0 856.0 DL
6434 1 4 2 604.0 903.0 DL
6435 1 4 2 1104.0 1401.0 DL
6436 1 4 2 934.0 1225.0 DL
6437 1 4 2 704.0 1016.0 DL
6438 1 5 3 1606.0 1903.0 DL
6439 1 5 3 1810.0 2124.0 DL
6440 1 5 3 1246.0 1554.0 DL
6441 1 5 3 543.0 834.0 DL
6442 1 5 3 602.0 858.0 DL
6443 1 5 3 1056.0 1348.0 DL
6444 1 5 3 933.0 1229.0 DL
6445 1 5 3 657.0 958.0 DL
6446 1 5 3 636.0 918.0 DL
6447 1 6 4 1600.0 1901.0 DL
... ... ... ... ... ... ...
214730 12 27 2 746.0 1049.0 DL
214731 12 27 2 1011.0 1338.0 DL
214732 12 27 2 1457.0 1750.0 DL
214733 12 27 2 1715.0 2017.0 DL
214734 12 27 2 557.0 859.0 DL
214735 12 28 3 1541.0 1830.0 DL
214736 12 28 3 1735.0 2030.0 DL
214737 12 28 3 715.0 1025.0 DL
214738 12 28 3 938.0 1224.0 DL
214739 12 28 3 1330.0 1634.0 DL
214740 12 28 3 1613.0 1858.0 DL
214741 12 28 3 556.0 846.0 DL
214742 12 29 4 1523.0 1822.0 DL
214743 12 29 4 1737.0 2035.0 DL
214744 12 29 4 705.0 1010.0 DL
214745 12 29 4 936.0 1239.0 DL
214746 12 29 4 1326.0 1623.0 DL
214747 12 29 4 1556.0 1849.0 DL
214748 12 29 4 555.0 903.0 DL
214749 12 30 5 1557.0 1845.0 DL
214750 12 30 5 1725.0 2030.0 DL
214751 12 30 5 707.0 1015.0 DL
214752 12 30 5 937.0 1232.0 DL
214753 12 30 5 1326.0 1619.0 DL
214754 12 30 5 1554.0 1849.0 DL
214755 12 30 5 557.0 856.0 DL
214756 12 31 6 1528.0 1812.0 DL
214757 12 31 6 709.0 1005.0 DL
214758 12 31 6 1423.0 1719.0 DL
214759 12 31 6 556.0 853.0 DL
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
6418 8 N760NC 111.0 86.0 59.0 71.0
6419 1012 N929DL 125.0 93.0 -5.0 -2.0
6420 1248 N980DL 117.0 91.0 -11.0 -1.0
6421 2538 N900DE 103.0 85.0 -25.0 -5.0
6422 1012 N992DL 109.0 85.0 -24.0 -5.0
6423 1248 N939DL 111.0 85.0 -16.0 0.0
6424 2538 N950DL 104.0 87.0 -12.0 7.0
6425 8 N902DA 108.0 82.0 -12.0 4.0
6426 1012 N935DL 118.0 91.0 -4.0 6.0
6427 1101 N914DL 127.0 86.0 10.0 5.0
6428 1248 N930DL 121.0 89.0 -4.0 2.0
6429 2538 N904DE 112.0 86.0 -14.0 -3.0
6430 8 N926DL 119.0 94.0 6.0 11.0
6431 54 N969DL 120.0 91.0 20.0 21.0
6432 1204 N940DL 110.0 86.0 -11.0 -1.0
6433 1248 N914DL 131.0 94.0 6.0 0.0
6434 1471 N968DL 119.0 92.0 -2.0 -1.0
6435 1512 N786NC 117.0 88.0 14.0 14.0
6436 1590 N760NC 111.0 84.0 -3.0 5.0
6437 1900 N986DL 132.0 90.0 6.0 4.0
6438 8 N985DL 117.0 83.0 0.0 7.0
6439 54 N915DE 134.0 99.0 10.0 -3.0
6440 1204 N986DL 128.0 85.0 5.0 -3.0
6441 1248 N332NB 111.0 89.0 -13.0 -2.0
6442 1471 N761NC 116.0 92.0 -6.0 -3.0
6443 1512 N782NC 112.0 85.0 1.0 6.0
6444 1590 N774NC 116.0 89.0 1.0 4.0
6445 1900 N980DL 121.0 91.0 -12.0 -3.0
6446 1960 N324NB 162.0 144.0 -12.0 -6.0
6447 8 N974DL 121.0 97.0 -2.0 1.0
... ... ... ... ... ... ...
214730 810 N6701 123.0 98.0 39.0 39.0
214731 1590 N951DL 147.0 106.0 57.0 31.0
214732 1675 N967DL 113.0 87.0 80.0 87.0
214733 1846 N903DE 122.0 100.0 78.0 76.0
214734 2010 N914DE 122.0 100.0 -6.0 -3.0
214735 8 N368NB 109.0 88.0 -3.0 9.0
214736 54 N997DL 115.0 89.0 -6.0 0.0
214737 810 N325US 130.0 85.0 15.0 8.0
214738 1590 N957DL 106.0 86.0 -17.0 -2.0
214739 1675 N993DL 124.0 85.0 4.0 0.0
214740 1846 N973DL 105.0 88.0 -1.0 14.0
214741 2010 N919DE 110.0 88.0 -19.0 -4.0
214742 8 N333NW 119.0 90.0 -11.0 -9.0
214743 54 N985DL 118.0 93.0 4.0 7.0
214744 810 N367NW 125.0 100.0 0.0 -2.0
214745 1590 N984DL 123.0 92.0 -2.0 -4.0
214746 1675 N971DL 117.0 90.0 -7.0 -4.0
214747 1846 N954DL 113.0 94.0 -10.0 -3.0
214748 2010 N919DL 128.0 93.0 -2.0 -5.0
214749 8 N368NB 108.0 87.0 12.0 25.0
214750 54 N921DL 125.0 91.0 -1.0 -5.0
214751 810 N314US 128.0 93.0 5.0 0.0
214752 1590 N985DL 115.0 96.0 -9.0 -3.0
214753 1675 N945DL 113.0 88.0 -11.0 -4.0
214754 1846 N909DL 115.0 92.0 -10.0 -5.0
214755 2010 N968DL 119.0 96.0 -9.0 -3.0
214756 8 N376NW 104.0 90.0 -21.0 -4.0
214757 810 N337NW 116.0 94.0 -5.0 2.0
214758 1590 N914DL 116.0 92.0 278.0 283.0
214759 2010 N987DL 117.0 93.0 -12.0 -4.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
6418 IAH ATL 689 11.0 14.0 0 NaN
6419 IAH ATL 689 15.0 17.0 0 NaN
6420 IAH ATL 689 11.0 15.0 0 NaN
6421 HOU ATL 696 7.0 11.0 0 NaN
6422 IAH ATL 689 12.0 12.0 0 NaN
6423 IAH ATL 689 14.0 12.0 0 NaN
6424 HOU ATL 696 7.0 10.0 0 NaN
6425 IAH ATL 689 12.0 14.0 0 NaN
6426 IAH ATL 689 14.0 13.0 0 NaN
6427 IAH ATL 689 26.0 15.0 0 NaN
6428 IAH ATL 689 21.0 11.0 0 NaN
6429 HOU ATL 696 14.0 12.0 0 NaN
6430 IAH ATL 689 7.0 18.0 0 NaN
6431 IAH ATL 689 18.0 11.0 0 NaN
6432 HOU ATL 696 13.0 11.0 0 NaN
6433 IAH ATL 689 21.0 16.0 0 NaN
6434 HOU ATL 696 17.0 10.0 0 NaN
6435 HOU ATL 696 14.0 15.0 0 NaN
6436 IAH ATL 689 6.0 21.0 0 NaN
6437 IAH ATL 689 14.0 28.0 0 NaN
6438 IAH ATL 689 13.0 21.0 0 NaN
6439 IAH ATL 689 20.0 15.0 0 NaN
6440 HOU ATL 696 16.0 27.0 0 NaN
6441 IAH ATL 689 13.0 9.0 0 NaN
6442 HOU ATL 696 17.0 7.0 0 NaN
6443 HOU ATL 696 11.0 16.0 0 NaN
6444 IAH ATL 689 13.0 14.0 0 NaN
6445 IAH ATL 689 14.0 16.0 0 NaN
6446 IAH MSP 1034 4.0 14.0 0 NaN
6447 IAH ATL 689 7.0 17.0 0 NaN
... ... ... ... ... ... ... ...
214730 IAH ATL 689 7.0 18.0 0 NaN
214731 IAH ATL 689 9.0 32.0 0 NaN
214732 IAH ATL 689 11.0 15.0 0 NaN
214733 HOU ATL 696 14.0 8.0 0 NaN
214734 IAH ATL 689 7.0 15.0 0 NaN
214735 IAH ATL 689 9.0 12.0 0 NaN
214736 IAH ATL 689 13.0 13.0 0 NaN
214737 IAH ATL 689 6.0 39.0 0 NaN
214738 IAH ATL 689 10.0 10.0 0 NaN
214739 IAH ATL 689 6.0 33.0 0 NaN
214740 HOU ATL 696 8.0 9.0 0 NaN
214741 IAH ATL 689 11.0 11.0 0 NaN
214742 IAH ATL 689 6.0 23.0 0 NaN
214743 IAH ATL 689 13.0 12.0 0 NaN
214744 IAH ATL 689 7.0 18.0 0 NaN
214745 IAH ATL 689 15.0 16.0 0 NaN
214746 IAH ATL 689 12.0 15.0 0 NaN
214747 HOU ATL 696 11.0 8.0 0 NaN
214748 IAH ATL 689 8.0 27.0 0 NaN
214749 IAH ATL 689 11.0 10.0 0 NaN
214750 IAH ATL 689 24.0 10.0 0 NaN
214751 IAH ATL 689 18.0 17.0 0 NaN
214752 IAH ATL 689 10.0 9.0 0 NaN
214753 IAH ATL 689 11.0 14.0 0 NaN
214754 HOU ATL 696 9.0 14.0 0 NaN
214755 IAH ATL 689 10.0 13.0 0 NaN
214756 IAH ATL 689 4.0 10.0 0 NaN
214757 IAH ATL 689 11.0 11.0 0 NaN
214758 IAH ATL 689 7.0 17.0 0 NaN
214759 IAH ATL 689 8.0 16.0 0 NaN
Diverted
6418 0
6419 0
6420 0
6421 0
6422 0
6423 0
6424 0
6425 0
6426 0
6427 0
6428 0
6429 0
6430 0
6431 0
6432 0
6433 0
6434 0
6435 0
6436 0
6437 0
6438 0
6439 0
6440 0
6441 0
6442 0
6443 0
6444 0
6445 0
6446 0
6447 0
... ...
214730 0
214731 0
214732 0
214733 0
214734 0
214735 0
214736 0
214737 0
214738 0
214739 0
214740 0
214741 0
214742 0
214743 0
214744 0
214745 0
214746 0
214747 0
214748 0
214749 0
214750 0
214751 0
214752 0
214753 0
214754 0
214755 0
214756 0
214757 0
214758 0
214759 0
[2641 rows x 20 columns]
EV Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
8251 1 8 6 1255.0 1634.0 EV
8252 1 15 6 1248.0 1629.0 EV
8253 1 22 6 1250.0 1635.0 EV
8254 1 29 6 1249.0 1614.0 EV
8255 1 4 2 1311.0 1548.0 EV
8256 1 5 3 2025.0 2304.0 EV
8257 1 6 4 1324.0 1629.0 EV
8258 1 7 5 1235.0 1522.0 EV
8259 1 8 6 1304.0 1545.0 EV
8260 1 9 7 1304.0 1545.0 EV
8261 1 10 1 NaN NaN EV
8262 1 11 2 NaN NaN EV
8263 1 12 3 1349.0 1628.0 EV
8264 1 23 7 1334.0 1621.0 EV
8265 1 22 6 1247.0 1542.0 EV
8266 1 24 1 1742.0 2050.0 EV
8267 1 21 5 1237.0 1526.0 EV
8268 1 20 4 1509.0 1827.0 EV
8269 1 15 6 1250.0 1554.0 EV
8270 1 16 7 1254.0 1547.0 EV
8271 1 14 5 1241.0 1529.0 EV
8272 1 13 4 1339.0 1627.0 EV
8273 1 17 1 1241.0 1538.0 EV
8274 1 19 3 1325.0 1615.0 EV
8275 1 18 2 1258.0 1555.0 EV
8276 1 25 2 1321.0 1635.0 EV
8277 1 26 3 1233.0 1530.0 EV
8278 1 27 4 1245.0 1527.0 EV
8279 1 29 6 1238.0 1532.0 EV
8280 1 30 7 1238.0 1517.0 EV
... ... ... ... ... ... ...
214937 12 6 2 1024.0 1350.0 EV
214938 12 5 1 926.0 1321.0 EV
214939 12 4 7 926.0 1253.0 EV
214940 12 8 4 923.0 1302.0 EV
214941 12 7 3 935.0 1316.0 EV
214942 12 10 6 928.0 1300.0 EV
214943 12 9 5 924.0 1307.0 EV
214944 12 14 3 928.0 1302.0 EV
214945 12 13 2 926.0 1308.0 EV
214946 12 12 1 925.0 1300.0 EV
214947 12 11 7 929.0 1309.0 EV
214948 12 17 6 925.0 1311.0 EV
214949 12 16 5 925.0 1319.0 EV
214950 12 15 4 923.0 1319.0 EV
214951 12 20 2 913.0 1242.0 EV
214952 12 19 1 911.0 1256.0 EV
214953 12 18 7 914.0 1315.0 EV
214954 12 25 7 914.0 1248.0 EV
214955 12 26 1 913.0 1253.0 EV
214956 12 27 2 915.0 1300.0 EV
214957 12 22 4 914.0 1247.0 EV
214958 12 21 3 908.0 1249.0 EV
214959 12 23 5 912.0 1252.0 EV
214960 12 24 6 913.0 1250.0 EV
214961 12 29 4 909.0 1311.0 EV
214962 12 28 3 911.0 1246.0 EV
214963 12 30 5 911.0 1247.0 EV
214964 12 31 6 907.0 1306.0 EV
214965 12 6 2 1250.0 1536.0 EV
214966 12 13 2 1256.0 1512.0 EV
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
8251 4967 N740EV 159.0 134.0 -11.0 0.0
8252 4967 N754EV 161.0 138.0 -16.0 -7.0
8253 4967 N710EV 165.0 148.0 -10.0 -5.0
8254 4967 N317CA 145.0 130.0 -31.0 -6.0
8255 5003 N134EV 97.0 82.0 9.0 31.0
8256 5003 N137EV 99.0 78.0 445.0 465.0
8257 5003 N606LR 125.0 88.0 50.0 44.0
8258 5003 N607LR 107.0 93.0 -17.0 -5.0
8259 5003 N131EV 101.0 82.0 6.0 24.0
8260 5003 N138EV 101.0 82.0 6.0 24.0
8261 5003 N138EV NaN NaN NaN NaN
8262 5003 N137EV NaN NaN NaN NaN
8263 5003 N607LR 99.0 83.0 49.0 69.0
8264 5003 N137EV 107.0 82.0 42.0 54.0
8265 5003 N134EV 115.0 93.0 3.0 7.0
8266 5003 N723EV 128.0 83.0 311.0 302.0
8267 5003 N135EV 109.0 90.0 -13.0 -3.0
8268 5003 N137EV 138.0 91.0 168.0 149.0
8269 5003 N138EV 124.0 88.0 15.0 10.0
8270 5003 N133EV 113.0 89.0 8.0 14.0
8271 5003 N719EV 108.0 92.0 -10.0 1.0
8272 5003 N134EV 108.0 93.0 48.0 59.0
8273 5003 N134EV 117.0 93.0 -1.0 1.0
8274 5003 N131EV 110.0 89.0 36.0 45.0
8275 5003 N137EV 117.0 89.0 16.0 18.0
8276 5003 N133EV 134.0 95.0 56.0 41.0
8277 5003 N135EV 117.0 92.0 -9.0 -7.0
8278 5003 N606LR 102.0 85.0 -12.0 5.0
8279 5003 N135EV 114.0 90.0 -7.0 -2.0
8280 5003 N133EV 99.0 81.0 -22.0 -2.0
... ... ... ... ... ... ...
214937 5386 N132EV 146.0 109.0 36.0 54.0
214938 5386 N132EV 175.0 115.0 7.0 -4.0
214939 5386 N132EV 147.0 127.0 -21.0 -4.0
214940 5386 N131EV 159.0 128.0 -12.0 -7.0
214941 5386 N132EV 161.0 132.0 2.0 5.0
214942 5386 N133EV 152.0 131.0 -14.0 -2.0
214943 5386 N606LR 163.0 132.0 -7.0 -6.0
214944 5386 N134EV 154.0 132.0 -12.0 -2.0
214945 5386 N134EV 162.0 133.0 -6.0 -4.0
214946 5386 N132EV 155.0 131.0 -14.0 -5.0
214947 5386 N132EV 160.0 143.0 -5.0 -1.0
214948 5386 N720EV 166.0 139.0 3.0 10.0
214949 5386 N138EV 174.0 123.0 5.0 -5.0
214950 5386 N133EV 176.0 125.0 5.0 -7.0
214951 5386 N717EV 149.0 126.0 -26.0 -2.0
214952 5386 N720EV 165.0 134.0 -12.0 -4.0
214953 5386 N136EV 181.0 155.0 7.0 -1.0
214954 5386 N606LR 154.0 121.0 -20.0 -1.0
214955 5386 N605QX 160.0 128.0 -15.0 -2.0
214956 5386 N724EV 165.0 141.0 -8.0 0.0
214957 5386 N390CA 153.0 119.0 -21.0 -1.0
214958 5386 N724EV 161.0 125.0 -19.0 -7.0
214959 5386 N724EV 160.0 121.0 -16.0 -3.0
214960 5386 N758EV 157.0 128.0 -18.0 -2.0
214961 5386 N615QX 182.0 143.0 3.0 -6.0
214962 5386 N600QX 155.0 128.0 -22.0 -4.0
214963 5386 N604QX 156.0 133.0 -21.0 -4.0
214964 5386 N718EV 179.0 140.0 -2.0 -8.0
214965 5426 N759EV 166.0 132.0 -16.0 -10.0
214966 5426 N713EV 136.0 124.0 -40.0 -4.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
8251 IAH DTW 1076 6.0 19.0 0 NaN
8252 IAH DTW 1076 8.0 15.0 0 NaN
8253 IAH DTW 1076 7.0 10.0 0 NaN
8254 IAH DTW 1076 8.0 7.0 0 NaN
8255 IAH ATL 689 8.0 7.0 0 NaN
8256 IAH ATL 689 10.0 11.0 0 NaN
8257 IAH ATL 689 24.0 13.0 0 NaN
8258 IAH ATL 689 6.0 8.0 0 NaN
8259 IAH ATL 689 6.0 13.0 0 NaN
8260 IAH ATL 689 10.0 9.0 0 NaN
8261 IAH ATL 689 NaN NaN 1 A
8262 IAH ATL 689 NaN NaN 1 A
8263 IAH ATL 689 9.0 7.0 0 NaN
8264 IAH ATL 689 7.0 18.0 0 NaN
8265 IAH ATL 689 13.0 9.0 0 NaN
8266 IAH ATL 689 15.0 30.0 0 NaN
8267 IAH ATL 689 10.0 9.0 0 NaN
8268 IAH ATL 689 8.0 39.0 0 NaN
8269 IAH ATL 689 26.0 10.0 0 NaN
8270 IAH ATL 689 9.0 15.0 0 NaN
8271 IAH ATL 689 6.0 10.0 0 NaN
8272 IAH ATL 689 4.0 11.0 0 NaN
8273 IAH ATL 689 14.0 10.0 0 NaN
8274 IAH ATL 689 6.0 15.0 0 NaN
8275 IAH ATL 689 12.0 16.0 0 NaN
8276 IAH ATL 689 12.0 27.0 0 NaN
8277 IAH ATL 689 17.0 8.0 0 NaN
8278 IAH ATL 689 9.0 8.0 0 NaN
8279 IAH ATL 689 5.0 19.0 0 NaN
8280 IAH ATL 689 10.0 8.0 0 NaN
... ... ... ... ... ... ... ...
214937 IAH DTW 1075 12.0 25.0 0 NaN
214938 IAH DTW 1075 6.0 54.0 0 NaN
214939 IAH DTW 1075 8.0 12.0 0 NaN
214940 IAH DTW 1075 10.0 21.0 0 NaN
214941 IAH DTW 1075 9.0 20.0 0 NaN
214942 IAH DTW 1075 9.0 12.0 0 NaN
214943 IAH DTW 1075 10.0 21.0 0 NaN
214944 IAH DTW 1075 8.0 14.0 0 NaN
214945 IAH DTW 1075 7.0 22.0 0 NaN
214946 IAH DTW 1075 6.0 18.0 0 NaN
214947 IAH DTW 1075 4.0 13.0 0 NaN
214948 IAH DTW 1075 8.0 19.0 0 NaN
214949 IAH DTW 1075 8.0 43.0 0 NaN
214950 IAH DTW 1075 13.0 38.0 0 NaN
214951 IAH DTW 1075 5.0 18.0 0 NaN
214952 IAH DTW 1075 8.0 23.0 0 NaN
214953 IAH DTW 1075 10.0 16.0 0 NaN
214954 IAH DTW 1075 8.0 25.0 0 NaN
214955 IAH DTW 1075 9.0 23.0 0 NaN
214956 IAH DTW 1075 8.0 16.0 0 NaN
214957 IAH DTW 1075 11.0 23.0 0 NaN
214958 IAH DTW 1075 8.0 28.0 0 NaN
214959 IAH DTW 1075 14.0 25.0 0 NaN
214960 IAH DTW 1075 8.0 21.0 0 NaN
214961 IAH DTW 1075 10.0 29.0 0 NaN
214962 IAH DTW 1075 10.0 17.0 0 NaN
214963 IAH DTW 1075 8.0 15.0 0 NaN
214964 IAH DTW 1075 10.0 29.0 0 NaN
214965 IAH MSP 1034 9.0 25.0 0 NaN
214966 IAH MSP 1034 3.0 9.0 0 NaN
Diverted
8251 0
8252 0
8253 0
8254 0
8255 0
8256 0
8257 0
8258 0
8259 0
8260 0
8261 0
8262 0
8263 0
8264 0
8265 0
8266 0
8267 0
8268 0
8269 0
8270 0
8271 0
8272 0
8273 0
8274 0
8275 0
8276 0
8277 0
8278 0
8279 0
8280 0
... ...
214937 0
214938 0
214939 0
214940 0
214941 0
214942 0
214943 0
214944 0
214945 0
214946 0
214947 0
214948 0
214949 0
214950 0
214951 0
214952 0
214953 0
214954 0
214955 0
214956 0
214957 0
214958 0
214959 0
214960 0
214961 0
214962 0
214963 0
214964 0
214965 0
214966 0
[2204 rows x 20 columns]
F9 Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
8357 1 1 6 1614.0 1735.0 F9
8358 1 1 6 1904.0 2031.0 F9
8359 1 1 6 610.0 743.0 F9
8360 1 2 7 1619.0 1742.0 F9
8361 1 2 7 618.0 745.0 F9
8362 1 3 1 2004.0 2128.0 F9
8363 1 3 1 646.0 806.0 F9
8364 1 3 1 1610.0 1734.0 F9
8365 1 4 2 628.0 755.0 F9
8366 1 4 2 1937.0 2108.0 F9
8367 1 4 2 1557.0 1713.0 F9
8368 1 5 3 1553.0 1733.0 F9
8369 1 5 3 615.0 744.0 F9
8370 1 6 4 1544.0 1727.0 F9
8371 1 7 5 1552.0 1735.0 F9
8372 1 7 5 613.0 754.0 F9
8373 1 8 6 612.0 742.0 F9
8374 1 8 6 1543.0 1714.0 F9
8375 1 9 7 1704.0 1834.0 F9
8376 1 9 7 608.0 723.0 F9
8377 1 10 1 1635.0 1803.0 F9
8378 1 11 2 1544.0 1728.0 F9
8379 1 11 2 609.0 749.0 F9
8380 1 12 3 1547.0 1717.0 F9
8381 1 12 3 610.0 737.0 F9
8382 1 13 4 1546.0 1718.0 F9
8383 1 14 5 1646.0 1804.0 F9
8384 1 14 5 712.0 833.0 F9
8385 1 15 6 609.0 734.0 F9
8386 1 15 6 1559.0 1726.0 F9
... ... ... ... ... ... ...
215002 12 18 7 1222.0 1343.0 F9
215003 12 18 7 600.0 729.0 F9
215004 12 19 1 1253.0 1411.0 F9
215005 12 19 1 604.0 719.0 F9
215006 12 20 2 1257.0 1414.0 F9
215007 12 20 2 1947.0 2059.0 F9
215008 12 20 2 624.0 754.0 F9
215009 12 21 3 2108.0 2226.0 F9
215010 12 21 3 1224.0 1339.0 F9
215011 12 21 3 601.0 724.0 F9
215012 12 22 4 1451.0 1609.0 F9
215013 12 22 4 600.0 724.0 F9
215014 12 23 5 1902.0 2027.0 F9
215015 12 23 5 1238.0 1358.0 F9
215016 12 23 5 600.0 746.0 F9
215017 12 25 7 1856.0 2010.0 F9
215018 12 25 7 1221.0 1338.0 F9
215019 12 26 1 1231.0 1355.0 F9
215020 12 26 1 611.0 735.0 F9
215021 12 27 2 610.0 747.0 F9
215022 12 27 2 1219.0 1346.0 F9
215023 12 27 2 1849.0 2028.0 F9
215024 12 28 3 609.0 742.0 F9
215025 12 28 3 1217.0 1340.0 F9
215026 12 28 3 1857.0 2028.0 F9
215027 12 29 4 1215.0 1346.0 F9
215028 12 29 4 601.0 734.0 F9
215029 12 30 5 1231.0 1407.0 F9
215030 12 30 5 1858.0 2029.0 F9
215031 12 30 5 605.0 740.0 F9
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
8357 145 N805FR 141.0 122.0 25.0 25.0
8358 147 N902FR 147.0 131.0 -4.0 -6.0
8359 143 N926FR 153.0 123.0 2.0 -5.0
8360 145 N803FR 143.0 124.0 32.0 30.0
8361 143 N928FR 147.0 127.0 4.0 3.0
8362 147 N914FR 144.0 127.0 53.0 54.0
8363 143 N921FR 140.0 124.0 25.0 31.0
8364 145 N947FR 144.0 128.0 24.0 21.0
8365 143 N908FR 147.0 126.0 14.0 13.0
8366 147 N923FR 151.0 127.0 33.0 27.0
8367 145 N926FR 136.0 123.0 3.0 8.0
8368 376 N921FR 160.0 136.0 23.0 4.0
8369 143 N931FR 149.0 132.0 8.0 0.0
8370 376 N925FR 163.0 147.0 17.0 -5.0
8371 376 N922FR 163.0 138.0 25.0 3.0
8372 143 N931FR 161.0 142.0 18.0 -2.0
8373 143 N932FR 150.0 130.0 6.0 -3.0
8374 376 N941FR 151.0 126.0 4.0 -6.0
8375 376 N923FR 150.0 131.0 84.0 75.0
8376 143 N936FR 135.0 116.0 -13.0 -7.0
8377 376 N942FR 148.0 134.0 53.0 46.0
8378 376 N914FR 164.0 142.0 18.0 -5.0
8379 143 N948FR 160.0 141.0 13.0 -6.0
8380 376 N927FR 150.0 131.0 7.0 -2.0
8381 143 N933FR 147.0 132.0 1.0 -5.0
8382 376 N940FR 152.0 132.0 8.0 -3.0
8383 376 N925FR 138.0 123.0 54.0 57.0
8384 143 N943FR 141.0 129.0 57.0 57.0
8385 143 N921FR 145.0 128.0 -2.0 -6.0
8386 376 N927FR 147.0 130.0 16.0 10.0
... ... ... ... ... ... ...
215002 145 N908FR 141.0 123.0 -4.0 -3.0
215003 579 N937FR 149.0 123.0 2.0 -5.0
215004 145 N923FR 138.0 114.0 24.0 28.0
215005 579 N938FR 135.0 118.0 -8.0 -1.0
215006 145 N918FR 137.0 114.0 27.0 32.0
215007 147 N930FR 132.0 117.0 33.0 48.0
215008 579 N931FR 150.0 120.0 27.0 19.0
215009 147 N905FR 138.0 117.0 120.0 129.0
215010 145 N912FR 135.0 115.0 -8.0 -1.0
215011 579 N919FR 143.0 120.0 -3.0 -4.0
215012 145 N920FR 138.0 120.0 142.0 146.0
215013 579 N923FR 144.0 122.0 -3.0 -5.0
215014 147 N920FR 145.0 127.0 1.0 3.0
215015 145 N938FR 140.0 124.0 11.0 13.0
215016 579 N939FR 166.0 128.0 19.0 -5.0
215017 147 N803FR 134.0 118.0 -16.0 -3.0
215018 145 N919FR 137.0 119.0 -9.0 -4.0
215019 145 N904FR 144.0 123.0 8.0 6.0
215020 579 N925FR 144.0 117.0 8.0 6.0
215021 579 N905FR 157.0 135.0 20.0 5.0
215022 145 N926FR 147.0 132.0 -1.0 -6.0
215023 147 N948FR 159.0 132.0 2.0 -10.0
215024 579 N902FR 153.0 127.0 15.0 4.0
215025 145 N932FR 143.0 127.0 -7.0 -8.0
215026 147 N943FR 151.0 135.0 2.0 -2.0
215027 145 N914FR 151.0 134.0 -1.0 -10.0
215028 579 N921FR 153.0 129.0 7.0 -4.0
215029 145 N906FR 156.0 140.0 20.0 6.0
215030 147 N925FR 151.0 137.0 3.0 -1.0
215031 579 N934FR 155.0 140.0 13.0 0.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
8357 HOU DEN 883 8.0 11.0 0 NaN
8358 HOU DEN 883 8.0 8.0 0 NaN
8359 HOU DEN 883 16.0 14.0 0 NaN
8360 HOU DEN 883 6.0 13.0 0 NaN
8361 HOU DEN 883 10.0 10.0 0 NaN
8362 HOU DEN 883 9.0 8.0 0 NaN
8363 HOU DEN 883 8.0 8.0 0 NaN
8364 HOU DEN 883 6.0 10.0 0 NaN
8365 HOU DEN 883 9.0 12.0 0 NaN
8366 HOU DEN 883 6.0 18.0 0 NaN
8367 HOU DEN 883 4.0 9.0 0 NaN
8368 HOU DEN 883 12.0 12.0 0 NaN
8369 HOU DEN 883 9.0 8.0 0 NaN
8370 HOU DEN 883 7.0 9.0 0 NaN
8371 HOU DEN 883 6.0 19.0 0 NaN
8372 HOU DEN 883 6.0 13.0 0 NaN
8373 HOU DEN 883 11.0 9.0 0 NaN
8374 HOU DEN 883 9.0 16.0 0 NaN
8375 HOU DEN 883 9.0 10.0 0 NaN
8376 HOU DEN 883 8.0 11.0 0 NaN
8377 HOU DEN 883 7.0 7.0 0 NaN
8378 HOU DEN 883 7.0 15.0 0 NaN
8379 HOU DEN 883 9.0 10.0 0 NaN
8380 HOU DEN 883 7.0 12.0 0 NaN
8381 HOU DEN 883 5.0 10.0 0 NaN
8382 HOU DEN 883 6.0 14.0 0 NaN
8383 HOU DEN 883 6.0 9.0 0 NaN
8384 HOU DEN 883 4.0 8.0 0 NaN
8385 HOU DEN 883 10.0 7.0 0 NaN
8386 HOU DEN 883 7.0 10.0 0 NaN
... ... ... ... ... ... ... ...
215002 HOU DEN 883 8.0 10.0 0 NaN
215003 HOU DEN 883 9.0 17.0 0 NaN
215004 HOU DEN 883 17.0 7.0 0 NaN
215005 HOU DEN 883 7.0 10.0 0 NaN
215006 HOU DEN 883 8.0 15.0 0 NaN
215007 HOU DEN 883 6.0 9.0 0 NaN
215008 HOU DEN 883 13.0 17.0 0 NaN
215009 HOU DEN 883 8.0 13.0 0 NaN
215010 HOU DEN 883 11.0 9.0 0 NaN
215011 HOU DEN 883 10.0 13.0 0 NaN
215012 HOU DEN 883 8.0 10.0 0 NaN
215013 HOU DEN 883 9.0 13.0 0 NaN
215014 HOU DEN 883 8.0 10.0 0 NaN
215015 HOU DEN 883 7.0 9.0 0 NaN
215016 HOU DEN 883 26.0 12.0 0 NaN
215017 HOU DEN 883 6.0 10.0 0 NaN
215018 HOU DEN 883 8.0 10.0 0 NaN
215019 HOU DEN 883 7.0 14.0 0 NaN
215020 HOU DEN 883 13.0 14.0 0 NaN
215021 HOU DEN 883 8.0 14.0 0 NaN
215022 HOU DEN 883 5.0 10.0 0 NaN
215023 HOU DEN 883 8.0 19.0 0 NaN
215024 HOU DEN 883 12.0 14.0 0 NaN
215025 HOU DEN 883 8.0 8.0 0 NaN
215026 HOU DEN 883 8.0 8.0 0 NaN
215027 HOU DEN 883 8.0 9.0 0 NaN
215028 HOU DEN 883 9.0 15.0 0 NaN
215029 HOU DEN 883 5.0 11.0 0 NaN
215030 HOU DEN 883 8.0 6.0 0 NaN
215031 HOU DEN 883 11.0 4.0 0 NaN
Diverted
8357 0
8358 0
8359 0
8360 0
8361 0
8362 0
8363 0
8364 0
8365 0
8366 0
8367 0
8368 0
8369 0
8370 0
8371 0
8372 0
8373 0
8374 0
8375 0
8376 0
8377 0
8378 0
8379 0
8380 0
8381 0
8382 0
8383 0
8384 0
8385 0
8386 0
... ...
215002 0
215003 0
215004 0
215005 0
215006 0
215007 0
215008 0
215009 0
215010 0
215011 0
215012 0
215013 0
215014 0
215015 0
215016 0
215017 0
215018 0
215019 0
215020 0
215021 0
215022 0
215023 0
215024 0
215025 0
215026 0
215027 0
215028 0
215029 0
215030 0
215031 0
[838 rows x 20 columns]
FL Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
8419 1 1 6 759.0 1046.0 FL
8420 1 1 6 NaN NaN FL
8421 1 1 6 1812.0 2057.0 FL
8422 1 1 6 1938.0 2220.0 FL
8423 1 2 7 603.0 859.0 FL
8424 1 2 7 1211.0 1453.0 FL
8425 1 2 7 1732.0 2020.0 FL
8426 1 2 7 1844.0 2134.0 FL
8427 1 3 1 605.0 916.0 FL
8428 1 3 1 1059.0 1337.0 FL
8429 1 3 1 1209.0 1449.0 FL
8430 1 3 1 1720.0 2009.0 FL
8431 1 3 1 1841.0 2118.0 FL
8432 1 4 2 605.0 905.0 FL
8433 1 4 2 1047.0 1331.0 FL
8434 1 4 2 1245.0 1537.0 FL
8435 1 4 2 1729.0 2014.0 FL
8436 1 4 2 1911.0 2154.0 FL
8437 1 5 3 604.0 902.0 FL
8438 1 5 3 1100.0 1342.0 FL
8439 1 5 3 1247.0 1537.0 FL
8440 1 5 3 1800.0 2055.0 FL
8441 1 5 3 1853.0 2142.0 FL
8442 1 6 4 604.0 917.0 FL
8443 1 6 4 1036.0 1331.0 FL
8444 1 6 4 1243.0 1534.0 FL
8445 1 6 4 1739.0 2031.0 FL
8446 1 6 4 1847.0 2139.0 FL
8447 1 7 5 605.0 853.0 FL
8448 1 7 5 1034.0 1317.0 FL
... ... ... ... ... ... ...
215157 12 27 2 644.0 937.0 FL
215158 12 27 2 1150.0 1455.0 FL
215159 12 27 2 1409.0 1659.0 FL
215160 12 27 2 1449.0 1750.0 FL
215161 12 27 2 1848.0 2202.0 FL
215162 12 27 2 1958.0 2243.0 FL
215163 12 28 3 628.0 920.0 FL
215164 12 28 3 1031.0 1314.0 FL
215165 12 28 3 1216.0 1458.0 FL
215166 12 28 3 1323.0 1604.0 FL
215167 12 28 3 1724.0 2010.0 FL
215168 12 28 3 1842.0 2124.0 FL
215169 12 29 4 625.0 926.0 FL
215170 12 29 4 1025.0 1316.0 FL
215171 12 29 4 1217.0 1511.0 FL
215172 12 29 4 1313.0 1602.0 FL
215173 12 29 4 1722.0 2013.0 FL
215174 12 29 4 1843.0 2134.0 FL
215175 12 30 5 623.0 916.0 FL
215176 12 30 5 1024.0 1311.0 FL
215177 12 30 5 1217.0 1506.0 FL
215178 12 30 5 1315.0 1600.0 FL
215179 12 30 5 1721.0 2007.0 FL
215180 12 30 5 1846.0 2137.0 FL
215181 12 31 6 623.0 921.0 FL
215182 12 31 6 1157.0 1444.0 FL
215183 12 31 6 1215.0 1456.0 FL
215184 12 31 6 1313.0 1559.0 FL
215185 12 31 6 1720.0 2002.0 FL
215186 12 31 6 1839.0 2120.0 FL
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
8419 290 N955AT 107.0 88.0 101.0 114.0
8420 298 N169AT NaN NaN NaN NaN
8421 292 N968AT 105.0 83.0 43.0 50.0
8422 296 N936AT 102.0 81.0 45.0 56.0
8423 290 N910AT 116.0 87.0 -6.0 -2.0
8424 286 N974AT 102.0 85.0 -12.0 -2.0
8425 292 N919AT 108.0 86.0 6.0 10.0
8426 296 N921AT 110.0 86.0 -1.0 2.0
8427 290 N896AT 131.0 88.0 11.0 0.0
8428 298 N279AT 98.0 84.0 -9.0 5.0
8429 286 N943AT 100.0 85.0 -16.0 -4.0
8430 292 N603AT 109.0 86.0 -5.0 -2.0
8431 296 N975AT 97.0 85.0 -17.0 -1.0
8432 290 N995AT 120.0 89.0 -5.0 -5.0
8433 298 N954AT 104.0 87.0 4.0 9.0
8434 286 N960AT 112.0 88.0 -4.0 -5.0
8435 292 N974AT 105.0 90.0 -4.0 2.0
8436 296 N986AT 103.0 89.0 19.0 23.0
8437 290 N970AT 118.0 95.0 -8.0 -6.0
8438 298 N603AT 102.0 86.0 15.0 22.0
8439 286 N972AT 110.0 89.0 -4.0 -3.0
8440 292 N975AT 115.0 96.0 37.0 33.0
8441 296 N993AT 109.0 85.0 7.0 5.0
8442 290 N925AT 133.0 103.0 7.0 -6.0
8443 298 N992AT 115.0 93.0 4.0 -2.0
8444 286 N963AT 111.0 93.0 -7.0 -7.0
8445 292 N990AT 112.0 90.0 13.0 12.0
8446 296 N971AT 112.0 93.0 4.0 -1.0
8447 290 N894AT 108.0 93.0 -17.0 -5.0
8448 298 N948AT 103.0 89.0 -10.0 -4.0
... ... ... ... ... ... ...
215157 290 N940AT 113.0 91.0 15.0 14.0
215158 298 N957AT 125.0 104.0 92.0 79.0
215159 286 N958AT 110.0 95.0 111.0 109.0
215160 294 N997AT 121.0 93.0 100.0 91.0
215161 292 N608AT 134.0 110.0 105.0 83.0
215162 296 N997AT 105.0 92.0 68.0 70.0
215163 290 N961AT 112.0 88.0 -2.0 -2.0
215164 298 N920AT 103.0 89.0 -9.0 0.0
215165 286 N946AT 102.0 86.0 -10.0 -4.0
215166 294 N970AT 101.0 86.0 -6.0 5.0
215167 292 N978AT 106.0 86.0 -7.0 -1.0
215168 296 N970AT 102.0 87.0 -11.0 -6.0
215169 290 N608AT 121.0 97.0 4.0 -5.0
215170 298 N993AT 111.0 95.0 -7.0 -6.0
215171 286 N899AT 114.0 94.0 3.0 -3.0
215172 294 N974AT 109.0 92.0 -8.0 -5.0
215173 292 N990AT 111.0 91.0 -4.0 -3.0
215174 296 N974AT 111.0 94.0 -1.0 -5.0
215175 290 N977AT 113.0 97.0 -6.0 -7.0
215176 298 N975AT 107.0 90.0 -12.0 -7.0
215177 286 N925AT 109.0 94.0 -2.0 -3.0
215178 294 N893AT 105.0 90.0 -10.0 -3.0
215179 292 N990AT 106.0 88.0 -10.0 -4.0
215180 296 N893AT 111.0 97.0 2.0 -2.0
215181 290 N968AT 118.0 93.0 -1.0 -7.0
215182 298 N989AT 107.0 93.0 81.0 86.0
215183 286 N967AT 101.0 91.0 -12.0 -5.0
215184 294 N919AT 106.0 90.0 -11.0 -5.0
215185 292 N980AT 102.0 90.0 -15.0 -5.0
215186 296 N919AT 101.0 88.0 -15.0 -9.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
8419 HOU ATL 696 11.0 8.0 0 NaN
8420 HOU ATL 696 NaN NaN 1 A
8421 HOU ATL 696 14.0 8.0 0 NaN
8422 HOU ATL 696 9.0 12.0 0 NaN
8423 HOU ATL 696 19.0 10.0 0 NaN
8424 HOU ATL 696 8.0 9.0 0 NaN
8425 HOU ATL 696 12.0 10.0 0 NaN
8426 HOU ATL 696 15.0 9.0 0 NaN
8427 HOU ATL 696 36.0 7.0 0 NaN
8428 HOU ATL 696 5.0 9.0 0 NaN
8429 HOU ATL 696 8.0 7.0 0 NaN
8430 HOU ATL 696 12.0 11.0 0 NaN
8431 HOU ATL 696 5.0 7.0 0 NaN
8432 HOU ATL 696 18.0 13.0 0 NaN
8433 HOU ATL 696 7.0 10.0 0 NaN
8434 HOU ATL 696 13.0 11.0 0 NaN
8435 HOU ATL 696 7.0 8.0 0 NaN
8436 HOU ATL 696 7.0 7.0 0 NaN
8437 HOU ATL 696 16.0 7.0 0 NaN
8438 HOU ATL 696 5.0 11.0 0 NaN
8439 HOU ATL 696 12.0 9.0 0 NaN
8440 HOU ATL 696 13.0 6.0 0 NaN
8441 HOU ATL 696 16.0 8.0 0 NaN
8442 HOU ATL 696 15.0 15.0 0 NaN
8443 HOU ATL 696 8.0 14.0 0 NaN
8444 HOU ATL 696 7.0 11.0 0 NaN
8445 HOU ATL 696 10.0 12.0 0 NaN
8446 HOU ATL 696 10.0 9.0 0 NaN
8447 HOU ATL 696 6.0 9.0 0 NaN
8448 HOU ATL 696 6.0 8.0 0 NaN
... ... ... ... ... ... ... ...
215157 HOU ATL 696 5.0 17.0 0 NaN
215158 HOU ATL 696 7.0 14.0 0 NaN
215159 HOU ATL 696 7.0 8.0 0 NaN
215160 HOU ATL 696 12.0 16.0 0 NaN
215161 HOU ATL 696 9.0 15.0 0 NaN
215162 HOU ATL 696 7.0 6.0 0 NaN
215163 HOU ATL 696 12.0 12.0 0 NaN
215164 HOU ATL 696 5.0 9.0 0 NaN
215165 HOU ATL 696 9.0 7.0 0 NaN
215166 HOU ATL 696 7.0 8.0 0 NaN
215167 HOU ATL 696 13.0 7.0 0 NaN
215168 HOU ATL 696 8.0 7.0 0 NaN
215169 HOU ATL 696 9.0 15.0 0 NaN
215170 HOU ATL 696 7.0 9.0 0 NaN
215171 HOU ATL 696 12.0 8.0 0 NaN
215172 HOU ATL 696 8.0 9.0 0 NaN
215173 HOU ATL 696 13.0 7.0 0 NaN
215174 HOU ATL 696 7.0 10.0 0 NaN
215175 HOU ATL 696 8.0 8.0 0 NaN
215176 HOU ATL 696 6.0 11.0 0 NaN
215177 HOU ATL 696 5.0 10.0 0 NaN
215178 HOU ATL 696 9.0 6.0 0 NaN
215179 HOU ATL 696 11.0 7.0 0 NaN
215180 HOU ATL 696 7.0 7.0 0 NaN
215181 HOU ATL 696 10.0 15.0 0 NaN
215182 HOU ATL 696 4.0 10.0 0 NaN
215183 HOU ATL 696 4.0 6.0 0 NaN
215184 HOU ATL 696 6.0 10.0 0 NaN
215185 HOU ATL 696 5.0 7.0 0 NaN
215186 HOU ATL 696 5.0 8.0 0 NaN
Diverted
8419 0
8420 0
8421 0
8422 0
8423 0
8424 0
8425 0
8426 0
8427 0
8428 0
8429 0
8430 0
8431 0
8432 0
8433 0
8434 0
8435 0
8436 0
8437 0
8438 0
8439 0
8440 0
8441 0
8442 0
8443 0
8444 0
8445 0
8446 0
8447 0
8448 0
... ...
215157 0
215158 0
215159 0
215160 0
215161 0
215162 0
215163 0
215164 0
215165 0
215166 0
215167 0
215168 0
215169 0
215170 0
215171 0
215172 0
215173 0
215174 0
215175 0
215176 0
215177 0
215178 0
215179 0
215180 0
215181 0
215182 0
215183 0
215184 0
215185 0
215186 0
[2139 rows x 20 columns]
MQ Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
8563 1 1 6 1820.0 1921.0 MQ
8564 1 2 7 1825.0 1938.0 MQ
8565 1 3 1 1822.0 1930.0 MQ
8566 1 4 2 1846.0 1948.0 MQ
8567 1 5 3 1826.0 1937.0 MQ
8568 1 6 4 1820.0 1931.0 MQ
8569 1 7 5 1821.0 1926.0 MQ
8570 1 8 6 1852.0 2005.0 MQ
8571 1 9 7 1822.0 1951.0 MQ
8572 1 10 1 1855.0 2003.0 MQ
8573 1 11 2 1822.0 1930.0 MQ
8574 1 12 3 1819.0 1935.0 MQ
8575 1 13 4 1825.0 1943.0 MQ
8576 1 14 5 1838.0 1945.0 MQ
8577 1 15 6 1819.0 1927.0 MQ
8578 1 16 7 1847.0 1950.0 MQ
8579 1 17 1 1824.0 1930.0 MQ
8580 1 18 2 1821.0 1933.0 MQ
8581 1 19 3 1830.0 1934.0 MQ
8582 1 20 4 1905.0 2017.0 MQ
8583 1 21 5 1836.0 1941.0 MQ
8584 1 22 6 1819.0 1923.0 MQ
8585 1 23 7 1839.0 1945.0 MQ
8586 1 24 1 1819.0 1932.0 MQ
8587 1 25 2 1816.0 1928.0 MQ
8588 1 26 3 1832.0 1933.0 MQ
8589 1 27 4 1918.0 2024.0 MQ
8590 1 28 5 1814.0 1943.0 MQ
8591 1 29 6 1836.0 1939.0 MQ
8592 1 30 7 1834.0 1938.0 MQ
... ... ... ... ... ... ...
215580 12 2 5 704.0 937.0 MQ
215581 12 3 6 659.0 934.0 MQ
215582 12 4 7 702.0 917.0 MQ
215583 12 5 1 706.0 959.0 MQ
215584 12 6 2 702.0 906.0 MQ
215585 12 7 3 710.0 929.0 MQ
215586 12 8 4 702.0 916.0 MQ
215587 12 9 5 708.0 912.0 MQ
215588 12 10 6 703.0 926.0 MQ
215589 12 11 7 702.0 921.0 MQ
215590 12 12 1 704.0 917.0 MQ
215591 12 13 2 659.0 918.0 MQ
215592 12 14 3 730.0 1010.0 MQ
215593 12 15 4 709.0 927.0 MQ
215594 12 16 5 705.0 926.0 MQ
215595 12 17 6 707.0 1033.0 MQ
215596 12 18 7 709.0 956.0 MQ
215597 12 19 1 705.0 916.0 MQ
215598 12 20 2 703.0 915.0 MQ
215599 12 21 3 710.0 926.0 MQ
215600 12 22 4 713.0 924.0 MQ
215601 12 23 5 704.0 914.0 MQ
215602 12 24 6 703.0 916.0 MQ
215603 12 25 7 707.0 914.0 MQ
215604 12 26 1 706.0 942.0 MQ
215605 12 27 2 745.0 1004.0 MQ
215606 12 28 3 727.0 1001.0 MQ
215607 12 29 4 709.0 945.0 MQ
215608 12 30 5 703.0 933.0 MQ
215609 12 31 6 706.0 921.0 MQ
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
8563 2870 N682MQ 61.0 43.0 -14.0 -5.0
8564 2870 N655MQ 73.0 46.0 3.0 0.0
8565 2870 N905MQ 68.0 45.0 -5.0 -3.0
8566 2870 N942MQ 62.0 42.0 13.0 21.0
8567 2870 N683MQ 71.0 45.0 2.0 1.0
8568 2870 N668MQ 71.0 48.0 -4.0 -5.0
8569 2870 N603MQ 65.0 45.0 -9.0 -4.0
8570 2870 N632MQ 73.0 48.0 30.0 27.0
8571 2870 N825MQ 89.0 51.0 16.0 -3.0
8572 2870 N609MQ 68.0 46.0 28.0 30.0
8573 2870 N694MQ 68.0 47.0 -5.0 -3.0
8574 2870 N667MQ 76.0 42.0 0.0 -6.0
8575 2870 N644MQ 78.0 47.0 8.0 0.0
8576 2870 N624MQ 67.0 52.0 10.0 13.0
8577 2870 N615MQ 68.0 53.0 -8.0 -6.0
8578 2870 N621MQ 63.0 46.0 15.0 22.0
8579 2870 N620MQ 66.0 52.0 -5.0 -1.0
8580 2870 N656MQ 72.0 49.0 -2.0 -4.0
8581 2870 N667MQ 64.0 48.0 -1.0 5.0
8582 2870 N682MQ 72.0 44.0 42.0 40.0
8583 2870 N629MQ 65.0 50.0 6.0 11.0
8584 2870 N683MQ 64.0 51.0 -12.0 -6.0
8585 2870 N656MQ 66.0 46.0 10.0 14.0
8586 2870 N609MQ 73.0 45.0 -3.0 -6.0
8587 2870 N612MQ 72.0 46.0 -7.0 -9.0
8588 2870 N941MQ 61.0 44.0 -2.0 7.0
8589 2870 N682MQ 66.0 48.0 49.0 53.0
8590 2870 N928MQ 89.0 48.0 8.0 -11.0
8591 2870 N676MQ 63.0 45.0 4.0 11.0
8592 2870 N609MQ 64.0 46.0 3.0 9.0
... ... ... ... ... ... ...
215580 3859 N8EGMQ 153.0 126.0 -3.0 -6.0
215581 3859 N521MQ 155.0 111.0 -6.0 -11.0
215582 3859 N500MQ 135.0 116.0 -23.0 -8.0
215583 3859 N3AEMQ 173.0 102.0 19.0 -4.0
215584 3859 N512MQ 124.0 103.0 -34.0 -8.0
215585 3859 N528MQ 139.0 121.0 -11.0 0.0
215586 3859 N526MQ 134.0 116.0 -24.0 -8.0
215587 3859 N523MQ 124.0 110.0 -28.0 -2.0
215588 3859 N514MQ 143.0 117.0 -14.0 -7.0
215589 3859 N546MQ 139.0 123.0 -19.0 -8.0
215590 3859 N542MQ 133.0 120.0 -23.0 -6.0
215591 3859 N537MQ 139.0 114.0 -22.0 -11.0
215592 3859 N542MQ 160.0 116.0 30.0 20.0
215593 3859 N539MQ 138.0 115.0 -13.0 -1.0
215594 3859 N519MQ 141.0 115.0 -14.0 -5.0
215595 3859 N9EAMQ 206.0 127.0 53.0 -3.0
215596 3859 N515MQ 167.0 126.0 16.0 -1.0
215597 3859 N539MQ 131.0 108.0 -24.0 -5.0
215598 3859 N508MQ 132.0 111.0 -25.0 -7.0
215599 3859 N3AEMQ 136.0 120.0 -14.0 0.0
215600 3859 N522MQ 131.0 116.0 -16.0 3.0
215601 3859 N6EAMQ 130.0 109.0 -26.0 -6.0
215602 3859 N508MQ 133.0 109.0 -24.0 -7.0
215603 3859 N504MQ 127.0 111.0 -26.0 -3.0
215604 3859 N523MQ 156.0 110.0 2.0 -4.0
215605 3859 N8EGMQ 139.0 120.0 24.0 35.0
215606 3859 N505MQ 154.0 120.0 21.0 17.0
215607 3859 N534MQ 156.0 124.0 5.0 -1.0
215608 3859 N543MQ 150.0 123.0 -7.0 -7.0
215609 3859 N6EAMQ 135.0 119.0 -19.0 -4.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
8563 HOU DFW 247 9.0 9.0 0 NaN
8564 HOU DFW 247 15.0 12.0 0 NaN
8565 HOU DFW 247 13.0 10.0 0 NaN
8566 HOU DFW 247 9.0 11.0 0 NaN
8567 HOU DFW 247 8.0 18.0 0 NaN
8568 HOU DFW 247 14.0 9.0 0 NaN
8569 HOU DFW 247 9.0 11.0 0 NaN
8570 HOU DFW 247 14.0 11.0 0 NaN
8571 HOU DFW 247 19.0 19.0 0 NaN
8572 HOU DFW 247 13.0 9.0 0 NaN
8573 HOU DFW 247 13.0 8.0 0 NaN
8574 HOU DFW 247 22.0 12.0 0 NaN
8575 HOU DFW 247 12.0 19.0 0 NaN
8576 HOU DFW 247 4.0 11.0 0 NaN
8577 HOU DFW 247 5.0 10.0 0 NaN
8578 HOU DFW 247 6.0 11.0 0 NaN
8579 HOU DFW 247 5.0 9.0 0 NaN
8580 HOU DFW 247 9.0 14.0 0 NaN
8581 HOU DFW 247 5.0 11.0 0 NaN
8582 HOU DFW 247 10.0 18.0 0 NaN
8583 HOU DFW 247 4.0 11.0 0 NaN
8584 HOU DFW 247 6.0 7.0 0 NaN
8585 HOU DFW 247 12.0 8.0 0 NaN
8586 HOU DFW 247 18.0 10.0 0 NaN
8587 HOU DFW 247 13.0 13.0 0 NaN
8588 HOU DFW 247 5.0 12.0 0 NaN
8589 HOU DFW 247 7.0 11.0 0 NaN
8590 HOU DFW 247 6.0 35.0 0 NaN
8591 HOU DFW 247 8.0 10.0 0 NaN
8592 HOU DFW 247 5.0 13.0 0 NaN
... ... ... ... ... ... ... ...
215580 IAH ORD 925 18.0 9.0 0 NaN
215581 IAH ORD 925 34.0 10.0 0 NaN
215582 IAH ORD 925 6.0 13.0 0 NaN
215583 IAH ORD 925 52.0 19.0 0 NaN
215584 IAH ORD 925 4.0 17.0 0 NaN
215585 IAH ORD 925 6.0 12.0 0 NaN
215586 IAH ORD 925 5.0 13.0 0 NaN
215587 IAH ORD 925 5.0 9.0 0 NaN
215588 IAH ORD 925 14.0 12.0 0 NaN
215589 IAH ORD 925 6.0 10.0 0 NaN
215590 IAH ORD 925 6.0 7.0 0 NaN
215591 IAH ORD 925 8.0 17.0 0 NaN
215592 IAH ORD 925 6.0 38.0 0 NaN
215593 IAH ORD 925 6.0 17.0 0 NaN
215594 IAH ORD 925 6.0 20.0 0 NaN
215595 IAH ORD 925 70.0 9.0 0 NaN
215596 IAH ORD 925 23.0 18.0 0 NaN
215597 IAH ORD 925 8.0 15.0 0 NaN
215598 IAH ORD 925 9.0 12.0 0 NaN
215599 IAH ORD 925 6.0 10.0 0 NaN
215600 IAH ORD 925 5.0 10.0 0 NaN
215601 IAH ORD 925 7.0 14.0 0 NaN
215602 IAH ORD 925 14.0 10.0 0 NaN
215603 IAH ORD 925 9.0 7.0 0 NaN
215604 IAH ORD 925 33.0 13.0 0 NaN
215605 IAH ORD 925 3.0 16.0 0 NaN
215606 IAH ORD 925 10.0 24.0 0 NaN
215607 IAH ORD 925 10.0 22.0 0 NaN
215608 IAH ORD 925 13.0 14.0 0 NaN
215609 IAH ORD 925 4.0 12.0 0 NaN
Diverted
8563 0
8564 0
8565 0
8566 0
8567 0
8568 0
8569 0
8570 0
8571 0
8572 0
8573 0
8574 0
8575 0
8576 0
8577 0
8578 0
8579 0
8580 0
8581 0
8582 0
8583 0
8584 0
8585 0
8586 0
8587 0
8588 0
8589 0
8590 0
8591 0
8592 0
... ...
215580 0
215581 0
215582 0
215583 0
215584 0
215585 0
215586 0
215587 0
215588 0
215589 0
215590 0
215591 0
215592 0
215593 0
215594 0
215595 0
215596 0
215597 0
215598 0
215599 0
215600 0
215601 0
215602 0
215603 0
215604 0
215605 0
215606 0
215607 0
215608 0
215609 0
[4648 rows x 20 columns]
OO Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
6537 1 5 3 1830.0 2058.0 OO
6538 1 1 6 1844.0 2050.0 OO
6539 1 6 4 2036.0 2225.0 OO
6540 1 3 1 1836.0 2107.0 OO
6541 1 2 7 1829.0 2052.0 OO
6542 1 27 4 1920.0 2111.0 OO
6543 1 28 5 2009.0 2159.0 OO
6544 1 26 3 1831.0 2035.0 OO
6545 1 30 7 1841.0 2058.0 OO
6546 1 24 1 1833.0 2047.0 OO
6547 1 13 4 1821.0 2029.0 OO
6548 1 14 5 1831.0 2025.0 OO
6549 1 16 7 1827.0 2049.0 OO
6550 1 17 1 1812.0 2051.0 OO
6551 1 12 3 1825.0 2035.0 OO
6552 1 31 1 1827.0 2035.0 OO
6553 1 9 7 1930.0 2155.0 OO
6554 1 7 5 1825.0 2027.0 OO
6555 1 10 1 1838.0 2056.0 OO
6556 1 20 4 1818.0 2044.0 OO
6557 1 21 5 1839.0 2102.0 OO
6558 1 19 3 1910.0 2115.0 OO
6559 1 23 7 1834.0 2041.0 OO
6560 1 6 4 630.0 1150.0 OO
6561 1 4 2 646.0 855.0 OO
6562 1 27 4 629.0 833.0 OO
6563 1 28 5 624.0 828.0 OO
6564 1 25 2 623.0 830.0 OO
6565 1 26 3 643.0 852.0 OO
6566 1 29 6 624.0 828.0 OO
... ... ... ... ... ... ...
226126 12 21 3 1140.0 1324.0 OO
226127 12 29 4 1455.0 1623.0 OO
226128 12 23 5 1211.0 1350.0 OO
226129 12 22 4 1159.0 1340.0 OO
226130 12 28 3 1221.0 1348.0 OO
226131 12 24 6 549.0 802.0 OO
226132 12 31 6 548.0 819.0 OO
226133 12 18 7 550.0 815.0 OO
226134 12 14 3 623.0 856.0 OO
226135 12 3 6 556.0 809.0 OO
226136 12 25 7 548.0 807.0 OO
226137 12 7 3 610.0 851.0 OO
226138 12 10 6 559.0 816.0 OO
226139 12 15 4 2030.0 12.0 OO
226140 12 24 6 1902.0 2244.0 OO
226141 12 18 7 1857.0 2254.0 OO
226142 12 16 5 1900.0 2257.0 OO
226143 12 20 2 1859.0 2252.0 OO
226144 12 25 7 1856.0 2237.0 OO
226145 12 21 3 1905.0 2308.0 OO
226146 12 19 1 1857.0 2244.0 OO
226147 12 17 6 1900.0 2244.0 OO
226148 12 23 5 1856.0 2228.0 OO
226149 12 22 4 1906.0 2247.0 OO
226150 12 28 3 1906.0 2250.0 OO
226151 12 27 2 1858.0 2252.0 OO
226152 12 30 5 1930.0 2321.0 OO
226153 12 26 1 1926.0 2324.0 OO
226154 12 29 4 2130.0 106.0 OO
226155 12 31 6 1902.0 2253.0 OO
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
6537 4455 N803SK 208.0 183.0 13.0 5.0
6538 4455 N609SK 186.0 167.0 -4.0 10.0
6539 4455 N807SK 169.0 156.0 100.0 131.0
6540 4455 N817SK 211.0 171.0 13.0 2.0
6541 4455 N803SK 203.0 175.0 -2.0 -5.0
6542 4455 N807SK 171.0 154.0 26.0 55.0
6543 4455 N806SK 170.0 154.0 74.0 104.0
6544 4455 N809SK 184.0 165.0 -10.0 6.0
6545 4455 N804SK 197.0 166.0 13.0 16.0
6546 4455 N802SK 194.0 163.0 2.0 8.0
6547 4455 N821SK 188.0 166.0 -16.0 -4.0
6548 4455 N805SK 174.0 158.0 -20.0 6.0
6549 4455 N809SK 202.0 182.0 4.0 2.0
6550 4455 N812SK 219.0 200.0 6.0 -13.0
6551 4455 N824SK 190.0 170.0 -10.0 0.0
6552 4455 N806SK 188.0 168.0 -10.0 2.0
6553 4455 N805SK 205.0 172.0 70.0 65.0
6554 4455 N806SK 182.0 163.0 -18.0 0.0
6555 4455 N823SK 198.0 187.0 11.0 13.0
6556 4455 N815SK 206.0 179.0 -1.0 -7.0
6557 4455 N800SK 203.0 187.0 17.0 14.0
6558 4455 N815SK 185.0 162.0 30.0 45.0
6559 4455 N810SK 187.0 168.0 -4.0 9.0
6560 4461 N802SK NaN NaN NaN 0.0
6561 4461 N800SK 189.0 162.0 -6.0 16.0
6562 4461 N803SK 184.0 160.0 -28.0 -1.0
6563 4461 N806SK 184.0 167.0 -33.0 -6.0
6564 4461 N805SK 187.0 165.0 -31.0 -7.0
6565 4461 N821SK 189.0 166.0 -9.0 13.0
6566 4461 N814SK 184.0 161.0 -33.0 -6.0
... ... ... ... ... ... ...
226126 5440 N715SK 164.0 148.0 -15.0 -5.0
226127 5440 N728SK 148.0 130.0 164.0 190.0
226128 5440 N770SK 159.0 141.0 11.0 26.0
226129 5440 N787SK 161.0 135.0 1.0 14.0
226130 5440 N730SK 147.0 133.0 9.0 36.0
226131 5559 N768SK 133.0 111.0 -27.0 -1.0
226132 5559 N719SK 151.0 127.0 -10.0 -2.0
226133 5607 N702SK 145.0 126.0 -14.0 0.0
226134 5607 N772SK 153.0 128.0 18.0 17.0
226135 5607 N784SK 133.0 111.0 -24.0 -5.0
226136 5607 N708SK 139.0 111.0 -22.0 -2.0
226137 5607 N756SK 161.0 129.0 13.0 4.0
226138 5607 N703SK 137.0 122.0 -17.0 -2.0
226139 6278 N797SK 162.0 143.0 84.0 90.0
226140 6278 N727SK 162.0 137.0 -4.0 2.0
226141 6278 N740SK 177.0 151.0 6.0 -3.0
226142 6278 N773SK 177.0 138.0 9.0 0.0
226143 6278 N791SK 173.0 145.0 4.0 -1.0
226144 6278 N786SK 161.0 140.0 -11.0 -4.0
226145 6278 N788SK 183.0 145.0 20.0 5.0
226146 6278 N718SK 167.0 148.0 -4.0 -3.0
226147 6278 N760SK 164.0 145.0 -4.0 0.0
226148 6278 N789SK 152.0 133.0 -20.0 -4.0
226149 6278 N716SK 161.0 135.0 -1.0 6.0
226150 6278 N709SK 164.0 143.0 2.0 6.0
226151 6278 N795SK 174.0 148.0 4.0 -2.0
226152 6278 N758SK 171.0 146.0 33.0 30.0
226153 6278 N738SK 178.0 144.0 36.0 26.0
226154 6278 N753SK 156.0 134.0 138.0 150.0
226155 6278 N726SK 171.0 150.0 5.0 2.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
6537 IAH SLC 1195 14.0 11.0 0 NaN
6538 IAH SLC 1195 5.0 14.0 0 NaN
6539 IAH SLC 1195 4.0 9.0 0 NaN
6540 IAH SLC 1195 10.0 30.0 0 NaN
6541 IAH SLC 1195 11.0 17.0 0 NaN
6542 IAH SLC 1195 4.0 13.0 0 NaN
6543 IAH SLC 1195 6.0 10.0 0 NaN
6544 IAH SLC 1195 8.0 11.0 0 NaN
6545 IAH SLC 1195 6.0 25.0 0 NaN
6546 IAH SLC 1195 5.0 26.0 0 NaN
6547 IAH SLC 1195 4.0 18.0 0 NaN
6548 IAH SLC 1195 5.0 11.0 0 NaN
6549 IAH SLC 1195 4.0 16.0 0 NaN
6550 IAH SLC 1195 5.0 14.0 0 NaN
6551 IAH SLC 1195 4.0 16.0 0 NaN
6552 IAH SLC 1195 6.0 14.0 0 NaN
6553 IAH SLC 1195 9.0 24.0 0 NaN
6554 IAH SLC 1195 6.0 13.0 0 NaN
6555 IAH SLC 1195 3.0 8.0 0 NaN
6556 IAH SLC 1195 6.0 21.0 0 NaN
6557 IAH SLC 1195 6.0 10.0 0 NaN
6558 IAH SLC 1195 4.0 19.0 0 NaN
6559 IAH SLC 1195 7.0 12.0 0 NaN
6560 IAH SLC 1195 7.0 10.0 0 NaN
6561 IAH SLC 1195 18.0 9.0 0 NaN
6562 IAH SLC 1195 13.0 11.0 0 NaN
6563 IAH SLC 1195 4.0 13.0 0 NaN
6564 IAH SLC 1195 9.0 13.0 0 NaN
6565 IAH SLC 1195 13.0 10.0 0 NaN
6566 IAH SLC 1195 5.0 18.0 0 NaN
... ... ... ... ... ... ... ...
226126 IAH ASE 913 5.0 11.0 0 NaN
226127 IAH ASE 913 2.0 16.0 0 NaN
226128 IAH ASE 913 4.0 14.0 0 NaN
226129 IAH ASE 913 3.0 23.0 0 NaN
226130 IAH ASE 913 3.0 11.0 0 NaN
226131 IAH ORD 925 8.0 14.0 0 NaN
226132 IAH ORD 925 5.0 19.0 0 NaN
226133 IAH ORD 925 8.0 11.0 0 NaN
226134 IAH ORD 925 8.0 17.0 0 NaN
226135 IAH ORD 925 8.0 14.0 0 NaN
226136 IAH ORD 925 13.0 15.0 0 NaN
226137 IAH ORD 925 5.0 27.0 0 NaN
226138 IAH ORD 925 4.0 11.0 0 NaN
226139 IAH IAD 1190 5.0 14.0 0 NaN
226140 IAH IAD 1190 3.0 22.0 0 NaN
226141 IAH IAD 1190 10.0 16.0 0 NaN
226142 IAH IAD 1190 8.0 31.0 0 NaN
226143 IAH IAD 1190 6.0 22.0 0 NaN
226144 IAH IAD 1190 6.0 15.0 0 NaN
226145 IAH IAD 1190 8.0 30.0 0 NaN
226146 IAH IAD 1190 4.0 15.0 0 NaN
226147 IAH IAD 1190 6.0 13.0 0 NaN
226148 IAH IAD 1190 9.0 10.0 0 NaN
226149 IAH IAD 1190 8.0 18.0 0 NaN
226150 IAH IAD 1190 5.0 16.0 0 NaN
226151 IAH IAD 1190 6.0 20.0 0 NaN
226152 IAH IAD 1190 3.0 22.0 0 NaN
226153 IAH IAD 1190 10.0 24.0 0 NaN
226154 IAH IAD 1190 5.0 17.0 0 NaN
226155 IAH IAD 1190 6.0 15.0 0 NaN
Diverted
6537 0
6538 0
6539 0
6540 0
6541 0
6542 0
6543 0
6544 0
6545 0
6546 0
6547 0
6548 0
6549 0
6550 0
6551 0
6552 0
6553 0
6554 0
6555 0
6556 0
6557 0
6558 0
6559 0
6560 1
6561 0
6562 0
6563 0
6564 0
6565 0
6566 0
... ...
226126 0
226127 0
226128 0
226129 0
226130 0
226131 0
226132 0
226133 0
226134 0
226135 0
226136 0
226137 0
226138 0
226139 0
226140 0
226141 0
226142 0
226143 0
226144 0
226145 0
226146 0
226147 0
226148 0
226149 0
226150 0
226151 0
226152 0
226153 0
226154 0
226155 0
[16061 rows x 20 columns]
UA Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
7236 1 1 6 616.0 838.0 UA
7237 1 2 7 615.0 826.0 UA
7238 1 3 1 615.0 836.0 UA
7239 1 5 3 921.0 1141.0 UA
7240 1 6 4 845.0 1124.0 UA
7241 1 7 5 845.0 1112.0 UA
7242 1 8 6 840.0 1107.0 UA
7243 1 9 7 833.0 1045.0 UA
7244 1 10 1 848.0 1108.0 UA
7245 1 11 2 846.0 1114.0 UA
7246 1 12 3 904.0 1121.0 UA
7247 1 13 4 855.0 1127.0 UA
7248 1 14 5 844.0 1116.0 UA
7249 1 15 6 845.0 1119.0 UA
7250 1 16 7 828.0 1037.0 UA
7251 1 17 1 911.0 1152.0 UA
7252 1 18 2 1105.0 1327.0 UA
7253 1 19 3 847.0 1111.0 UA
7254 1 20 4 844.0 1052.0 UA
7255 1 21 5 845.0 1104.0 UA
7256 1 22 6 841.0 1122.0 UA
7257 1 23 7 834.0 1053.0 UA
7258 1 24 1 902.0 1136.0 UA
7259 1 25 2 850.0 1114.0 UA
7260 1 26 3 847.0 1116.0 UA
7261 1 27 4 847.0 1116.0 UA
7262 1 28 5 852.0 1147.0 UA
7263 1 29 6 902.0 1124.0 UA
7264 1 30 7 832.0 1048.0 UA
7265 1 31 1 848.0 1102.0 UA
... ... ... ... ... ... ...
226314 12 9 5 859.0 1111.0 UA
226315 12 10 6 845.0 1100.0 UA
226316 12 11 7 843.0 1101.0 UA
226317 12 12 1 900.0 1110.0 UA
226318 12 13 2 900.0 1102.0 UA
226319 12 14 3 857.0 1130.0 UA
226320 12 15 4 928.0 1144.0 UA
226321 12 16 5 908.0 1129.0 UA
226322 12 17 6 922.0 1111.0 UA
226323 12 18 7 904.0 1101.0 UA
226324 12 19 1 919.0 1106.0 UA
226325 12 20 2 901.0 1057.0 UA
226326 12 21 3 859.0 1111.0 UA
226327 12 23 5 920.0 1132.0 UA
226328 12 24 6 902.0 1109.0 UA
226329 12 25 7 905.0 1101.0 UA
226330 12 26 1 925.0 1132.0 UA
226331 12 27 2 NaN NaN UA
226332 12 28 3 906.0 1125.0 UA
226333 12 29 4 941.0 1152.0 UA
226334 12 30 5 925.0 1142.0 UA
226335 12 31 6 905.0 1108.0 UA
226336 12 19 1 1308.0 1418.0 UA
226337 12 15 4 1318.0 1443.0 UA
226338 12 16 5 1257.0 1432.0 UA
226339 12 27 2 1303.0 1437.0 UA
226340 12 28 3 1258.0 1414.0 UA
226341 12 29 4 1311.0 1443.0 UA
226342 12 30 5 1300.0 1436.0 UA
226343 12 26 1 607.0 728.0 UA
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
7236 101 N493UA 262.0 239.0 -3.0 0.0
7237 101 N811UA 251.0 233.0 -14.0 0.0
7238 101 N477UA 261.0 233.0 -2.0 0.0
7239 104 N836UA 140.0 120.0 17.0 30.0
7240 104 N817UA 159.0 136.0 0.0 -6.0
7241 104 N843UA 147.0 131.0 -12.0 -6.0
7242 104 N843UA 147.0 130.0 -10.0 -5.0
7243 104 N478UA 132.0 115.0 -24.0 -2.0
7244 104 N829UA 140.0 118.0 -16.0 -3.0
7245 104 N451UA 148.0 119.0 -10.0 -5.0
7246 104 N415UA 137.0 122.0 -3.0 13.0
7247 104 N479UA 152.0 133.0 3.0 4.0
7248 104 N841UA 152.0 135.0 -8.0 -7.0
7249 104 N841UA 154.0 134.0 2.0 0.0
7250 104 N479UA 129.0 113.0 -32.0 -7.0
7251 104 N479UA 161.0 140.0 28.0 20.0
7252 104 N408UA 142.0 123.0 123.0 134.0
7253 104 N480UA 144.0 123.0 -13.0 -4.0
7254 104 N480UA 128.0 113.0 -32.0 -7.0
7255 104 N485UA 139.0 123.0 -20.0 -6.0
7256 104 N474UA 161.0 143.0 5.0 -4.0
7257 104 N477UA 139.0 118.0 -16.0 -1.0
7258 104 N436UA 154.0 122.0 12.0 11.0
7259 104 N474UA 144.0 124.0 -10.0 -1.0
7260 104 N469UA 149.0 131.0 -8.0 -4.0
7261 104 N470UA 149.0 133.0 -8.0 -4.0
7262 104 N814UA 175.0 146.0 23.0 1.0
7263 104 N489UA 142.0 125.0 7.0 17.0
7264 104 N465UA 136.0 116.0 -21.0 -3.0
7265 104 N817UA 134.0 114.0 -22.0 -3.0
... ... ... ... ... ... ...
226314 855 N671UA 252.0 219.0 -7.0 2.0
226315 855 N527UA 255.0 230.0 -10.0 0.0
226316 855 N672UA 258.0 237.0 -9.0 -2.0
226317 855 N670UA 250.0 217.0 -8.0 3.0
226318 855 N674UA 242.0 214.0 -16.0 3.0
226319 855 N677UA 273.0 214.0 12.0 0.0
226320 855 N673UA 256.0 234.0 12.0 23.0
226321 855 N669UA 261.0 218.0 -3.0 3.0
226322 855 N677UA 229.0 204.0 -21.0 17.0
226323 855 N667UA 237.0 213.0 -31.0 -1.0
226324 855 N676UA 227.0 205.0 -26.0 14.0
226325 855 N674UA 236.0 210.0 -35.0 -4.0
226326 855 N664UA 252.0 222.0 -21.0 -6.0
226327 855 N677UA 252.0 213.0 0.0 15.0
226328 855 N672UA 247.0 202.0 -23.0 -3.0
226329 855 N668UA 236.0 206.0 -31.0 0.0
226330 855 N673UA 247.0 215.0 0.0 20.0
226331 855 NaN NaN NaN NaN NaN
226332 855 N669UA 259.0 222.0 -7.0 1.0
226333 855 N664UA 251.0 225.0 20.0 36.0
226334 855 N539UA 257.0 226.0 10.0 20.0
226335 855 N665UA 243.0 213.0 -24.0 0.0
226336 963 N526UA 130.0 107.0 -20.0 3.0
226337 971 N530UA 145.0 113.0 10.0 18.0
226338 971 N570UA 155.0 125.0 -1.0 -3.0
226339 971 N563UA 154.0 124.0 4.0 3.0
226340 971 N515UA 136.0 117.0 -19.0 -2.0
226341 971 N558UA 152.0 127.0 10.0 11.0
226342 971 N573UA 156.0 132.0 3.0 0.0
226343 978 N572UA 141.0 117.0 -12.0 7.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
7236 IAH SFO 1635 8.0 15.0 0 NaN
7237 IAH SFO 1635 5.0 13.0 0 NaN
7238 IAH SFO 1635 15.0 13.0 0 NaN
7239 IAH ORD 925 5.0 15.0 0 NaN
7240 IAH ORD 925 11.0 12.0 0 NaN
7241 IAH ORD 925 5.0 11.0 0 NaN
7242 IAH ORD 925 7.0 10.0 0 NaN
7243 IAH ORD 925 5.0 12.0 0 NaN
7244 IAH ORD 925 9.0 13.0 0 NaN
7245 IAH ORD 925 5.0 24.0 0 NaN
7246 IAH ORD 925 5.0 10.0 0 NaN
7247 IAH ORD 925 4.0 15.0 0 NaN
7248 IAH ORD 925 5.0 12.0 0 NaN
7249 IAH ORD 925 6.0 14.0 0 NaN
7250 IAH ORD 925 4.0 12.0 0 NaN
7251 IAH ORD 925 7.0 14.0 0 NaN
7252 IAH ORD 925 5.0 14.0 0 NaN
7253 IAH ORD 925 5.0 16.0 0 NaN
7254 IAH ORD 925 3.0 12.0 0 NaN
7255 IAH ORD 925 4.0 12.0 0 NaN
7256 IAH ORD 925 7.0 11.0 0 NaN
7257 IAH ORD 925 10.0 11.0 0 NaN
7258 IAH ORD 925 2.0 30.0 0 NaN
7259 IAH ORD 925 5.0 15.0 0 NaN
7260 IAH ORD 925 8.0 10.0 0 NaN
7261 IAH ORD 925 3.0 13.0 0 NaN
7262 IAH ORD 925 6.0 23.0 0 NaN
7263 IAH ORD 925 4.0 13.0 0 NaN
7264 IAH ORD 925 8.0 12.0 0 NaN
7265 IAH ORD 925 8.0 12.0 0 NaN
... ... ... ... ... ... ... ...
226314 IAH SFO 1635 12.0 21.0 0 NaN
226315 IAH SFO 1635 8.0 17.0 0 NaN
226316 IAH SFO 1635 4.0 17.0 0 NaN
226317 IAH SFO 1635 16.0 17.0 0 NaN
226318 IAH SFO 1635 11.0 17.0 0 NaN
226319 IAH SFO 1635 41.0 18.0 0 NaN
226320 IAH SFO 1635 4.0 18.0 0 NaN
226321 IAH SFO 1635 5.0 38.0 0 NaN
226322 IAH SFO 1635 10.0 15.0 0 NaN
226323 IAH SFO 1635 8.0 16.0 0 NaN
226324 IAH SFO 1635 9.0 13.0 0 NaN
226325 IAH SFO 1635 7.0 19.0 0 NaN
226326 IAH SFO 1635 12.0 18.0 0 NaN
226327 IAH SFO 1635 4.0 35.0 0 NaN
226328 IAH SFO 1635 19.0 26.0 0 NaN
226329 IAH SFO 1635 5.0 25.0 0 NaN
226330 IAH SFO 1635 6.0 26.0 0 NaN
226331 IAH SFO 1635 NaN NaN 1 A
226332 IAH SFO 1635 12.0 25.0 0 NaN
226333 IAH SFO 1635 4.0 22.0 0 NaN
226334 IAH SFO 1635 8.0 23.0 0 NaN
226335 IAH SFO 1635 7.0 23.0 0 NaN
226336 IAH DEN 862 5.0 18.0 0 NaN
226337 IAH DEN 862 8.0 24.0 0 NaN
226338 IAH DEN 862 7.0 23.0 0 NaN
226339 IAH DEN 862 9.0 21.0 0 NaN
226340 IAH DEN 862 4.0 15.0 0 NaN
226341 IAH DEN 862 9.0 16.0 0 NaN
226342 IAH DEN 862 7.0 17.0 0 NaN
226343 IAH DEN 862 9.0 15.0 0 NaN
Diverted
7236 0
7237 0
7238 0
7239 0
7240 0
7241 0
7242 0
7243 0
7244 0
7245 0
7246 0
7247 0
7248 0
7249 0
7250 0
7251 0
7252 0
7253 0
7254 0
7255 0
7256 0
7257 0
7258 0
7259 0
7260 0
7261 0
7262 0
7263 0
7264 0
7265 0
... ...
226314 0
226315 0
226316 0
226317 0
226318 0
226319 0
226320 0
226321 0
226322 0
226323 0
226324 0
226325 0
226326 0
226327 0
226328 0
226329 0
226330 0
226331 0
226332 0
226333 0
226334 0
226335 0
226336 0
226337 0
226338 0
226339 0
226340 0
226341 0
226342 0
226343 0
[2072 rows x 20 columns]
US Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
7337 1 1 6 1454.0 1653.0 US
7338 1 1 6 1756.0 2000.0 US
7339 1 1 6 559.0 758.0 US
7340 1 1 6 2038.0 2236.0 US
7341 1 1 6 801.0 1013.0 US
7342 1 1 6 1011.0 1348.0 US
7343 1 1 6 1200.0 1522.0 US
7344 1 1 6 835.0 1217.0 US
7345 1 1 6 1855.0 2201.0 US
7346 1 1 6 1541.0 1906.0 US
7347 1 2 7 1453.0 1650.0 US
7348 1 2 7 1800.0 1951.0 US
7349 1 2 7 556.0 756.0 US
7350 1 2 7 2041.0 2228.0 US
7351 1 2 7 755.0 955.0 US
7352 1 2 7 842.0 1152.0 US
7353 1 2 7 1009.0 1308.0 US
7354 1 2 7 702.0 1027.0 US
7355 1 2 7 1741.0 2053.0 US
7356 1 2 7 1536.0 1844.0 US
7357 1 2 7 1204.0 1509.0 US
7358 1 3 1 1510.0 1654.0 US
7359 1 3 1 1755.0 1943.0 US
7360 1 3 1 555.0 749.0 US
7361 1 3 1 2041.0 2228.0 US
7362 1 3 1 800.0 1019.0 US
7363 1 3 1 851.0 1212.0 US
7364 1 3 1 1026.0 1334.0 US
7365 1 3 1 733.0 1042.0 US
7366 1 3 1 1201.0 1508.0 US
... ... ... ... ... ... ...
226734 12 29 4 655.0 1027.0 US
226735 12 29 4 1533.0 1854.0 US
226736 12 30 5 1758.0 1939.0 US
226737 12 30 5 2056.0 2318.0 US
226738 12 30 5 NaN NaN US
226739 12 30 5 1750.0 1925.0 US
226740 12 30 5 811.0 1016.0 US
226741 12 30 5 839.0 1202.0 US
226742 12 30 5 1025.0 1344.0 US
226743 12 30 5 509.0 841.0 US
226744 12 30 5 1738.0 2053.0 US
226745 12 30 5 1202.0 1521.0 US
226746 12 30 5 621.0 1009.0 US
226747 12 30 5 1303.0 1701.0 US
226748 12 30 5 1750.0 2143.0 US
226749 12 30 5 658.0 1009.0 US
226750 12 30 5 1535.0 1852.0 US
226751 12 31 6 1805.0 1942.0 US
226752 12 31 6 1455.0 1638.0 US
226753 12 31 6 601.0 737.0 US
226754 12 31 6 801.0 1016.0 US
226755 12 31 6 840.0 1213.0 US
226756 12 31 6 509.0 827.0 US
226757 12 31 6 1736.0 2051.0 US
226758 12 31 6 1155.0 1507.0 US
226759 12 31 6 608.0 1016.0 US
226760 12 31 6 1304.0 1721.0 US
226761 12 31 6 655.0 1020.0 US
226762 12 31 6 1020.0 1337.0 US
226763 12 31 6 1536.0 1853.0 US
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
7337 138 N807AW 179.0 154.0 1.0 -6.0
7338 247 N835AW 184.0 159.0 1.0 -4.0
7339 270 N313AW 179.0 156.0 6.0 -1.0
7340 278 N316AW 178.0 160.0 -4.0 -7.0
7341 343 N305AW 192.0 151.0 2.0 -4.0
7342 1015 N452UW 157.0 121.0 11.0 -4.0
7343 1768 N435US 142.0 115.0 -13.0 -10.0
7344 1817 N516AU 162.0 125.0 8.0 -10.0
7345 1944 N442US 126.0 108.0 67.0 85.0
7346 1978 N427US 145.0 121.0 -2.0 1.0
7347 138 N816AW 177.0 153.0 -2.0 -7.0
7348 247 N812AW 171.0 149.0 -8.0 0.0
7349 270 N303AW 180.0 166.0 4.0 -4.0
7350 278 N332AW 167.0 149.0 -12.0 -4.0
7351 343 N155AW 180.0 161.0 -16.0 -10.0
7352 990 N426US 130.0 111.0 -17.0 -3.0
7353 1015 N574US 119.0 104.0 -29.0 -6.0
7354 1696 N516AU 145.0 123.0 -7.0 -8.0
7355 1944 N417US 132.0 109.0 -1.0 11.0
7356 1978 N459UW 128.0 109.0 -24.0 -4.0
7357 1992 N529AU 125.0 106.0 -26.0 -6.0
7358 138 N801AW 164.0 150.0 2.0 10.0
7359 247 N826AW 168.0 152.0 -16.0 -5.0
7360 270 N156AW 174.0 156.0 -3.0 -5.0
7361 278 N316AW 167.0 151.0 -12.0 -4.0
7362 343 N154AW 199.0 156.0 8.0 -5.0
7363 990 N409US 141.0 114.0 -2.0 1.0
7364 1015 N422US 128.0 115.0 -3.0 11.0
7365 1696 N455UW 129.0 110.0 8.0 23.0
7366 1697 N434US 127.0 108.0 -27.0 -9.0
... ... ... ... ... ... ...
226734 1924 N574US 152.0 131.0 2.0 -5.0
226735 1978 N449US 141.0 117.0 -11.0 -6.0
226736 247 N813AW 161.0 138.0 -21.0 -2.0
226737 278 N676AW 202.0 137.0 23.0 -4.0
226738 403 NaN NaN NaN NaN NaN
226739 623 N805AW 155.0 139.0 156.0 175.0
226740 654 N604AW 185.0 143.0 -3.0 1.0
226741 846 N409US 143.0 116.0 -3.0 -1.0
226742 1170 N433US 139.0 122.0 -2.0 0.0
226743 1616 N454UW 152.0 125.0 1.0 -6.0
226744 1679 N529AU 135.0 116.0 -12.0 -2.0
226745 1702 N425US 139.0 115.0 -1.0 2.0
226746 1820 N956UW 168.0 157.0 -27.0 -4.0
226747 1824 N954UW 178.0 160.0 -20.0 -7.0
226748 1828 N953UW 173.0 160.0 -23.0 -5.0
226749 1924 N435US 131.0 114.0 -16.0 -2.0
226750 1978 N419US 137.0 116.0 -13.0 -4.0
226751 247 N834AW 157.0 141.0 -18.0 5.0
226752 340 N818AW 163.0 140.0 -11.0 0.0
226753 403 N663AW 156.0 138.0 -15.0 1.0
226754 654 N624AW 195.0 141.0 -3.0 -9.0
226755 1188 N531AU 153.0 121.0 8.0 0.0
226756 1616 N420US 138.0 121.0 -13.0 -6.0
226757 1679 N430US 135.0 118.0 -14.0 -4.0
226758 1702 N417US 132.0 114.0 -15.0 -5.0
226759 1820 N948UW 188.0 163.0 -10.0 -7.0
226760 1824 N950UW 197.0 184.0 0.0 -6.0
226761 1924 N452UW 145.0 119.0 -5.0 -5.0
226762 1972 N451UW 137.0 117.0 -9.0 -5.0
226763 1978 N441US 137.0 117.0 -12.0 -3.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
7337 IAH PHX 1009 3.0 22.0 0 NaN
7338 IAH PHX 1009 9.0 16.0 0 NaN
7339 IAH PHX 1009 7.0 16.0 0 NaN
7340 IAH PHX 1009 4.0 14.0 0 NaN
7341 IAH PHX 1009 24.0 17.0 0 NaN
7342 IAH CLT 913 11.0 25.0 0 NaN
7343 IAH CLT 913 8.0 19.0 0 NaN
7344 IAH CLT 913 21.0 16.0 0 NaN
7345 IAH CLT 913 6.0 12.0 0 NaN
7346 IAH CLT 913 9.0 15.0 0 NaN
7347 IAH PHX 1009 10.0 14.0 0 NaN
7348 IAH PHX 1009 8.0 14.0 0 NaN
7349 IAH PHX 1009 3.0 11.0 0 NaN
7350 IAH PHX 1009 4.0 14.0 0 NaN
7351 IAH PHX 1009 7.0 12.0 0 NaN
7352 IAH CLT 913 8.0 11.0 0 NaN
7353 IAH CLT 913 7.0 8.0 0 NaN
7354 IAH CLT 913 9.0 13.0 0 NaN
7355 IAH CLT 913 9.0 14.0 0 NaN
7356 IAH CLT 913 7.0 12.0 0 NaN
7357 IAH CLT 913 6.0 13.0 0 NaN
7358 IAH PHX 1009 5.0 9.0 0 NaN
7359 IAH PHX 1009 5.0 11.0 0 NaN
7360 IAH PHX 1009 4.0 14.0 0 NaN
7361 IAH PHX 1009 5.0 11.0 0 NaN
7362 IAH PHX 1009 18.0 25.0 0 NaN
7363 IAH CLT 913 7.0 20.0 0 NaN
7364 IAH CLT 913 4.0 9.0 0 NaN
7365 IAH CLT 913 7.0 12.0 0 NaN
7366 IAH CLT 913 12.0 7.0 0 NaN
... ... ... ... ... ... ... ...
226734 IAH CLT 912 5.0 16.0 0 NaN
226735 IAH CLT 912 12.0 12.0 0 NaN
226736 IAH PHX 1009 8.0 15.0 0 NaN
226737 IAH PHX 1009 11.0 54.0 0 NaN
226738 IAH PHX 1009 NaN NaN 1 A
226739 IAH PHX 1009 4.0 12.0 0 NaN
226740 IAH PHX 1009 22.0 20.0 0 NaN
226741 IAH CLT 912 15.0 12.0 0 NaN
226742 IAH CLT 912 4.0 13.0 0 NaN
226743 IAH CLT 912 10.0 17.0 0 NaN
226744 IAH CLT 912 8.0 11.0 0 NaN
226745 IAH CLT 912 10.0 14.0 0 NaN
226746 IAH PHL 1325 1.0 10.0 0 NaN
226747 IAH PHL 1325 5.0 13.0 0 NaN
226748 IAH PHL 1325 4.0 9.0 0 NaN
226749 IAH CLT 912 7.0 10.0 0 NaN
226750 IAH CLT 912 9.0 12.0 0 NaN
226751 IAH PHX 1009 3.0 13.0 0 NaN
226752 IAH PHX 1009 7.0 16.0 0 NaN
226753 IAH PHX 1009 3.0 15.0 0 NaN
226754 IAH PHX 1009 35.0 19.0 0 NaN
226755 IAH CLT 912 22.0 10.0 0 NaN
226756 IAH CLT 912 5.0 12.0 0 NaN
226757 IAH CLT 912 5.0 12.0 0 NaN
226758 IAH CLT 912 8.0 10.0 0 NaN
226759 IAH PHL 1325 7.0 18.0 0 NaN
226760 IAH PHL 1325 3.0 10.0 0 NaN
226761 IAH CLT 912 16.0 10.0 0 NaN
226762 IAH CLT 912 7.0 13.0 0 NaN
226763 IAH CLT 912 9.0 11.0 0 NaN
Diverted
7337 0
7338 0
7339 0
7340 0
7341 0
7342 0
7343 0
7344 0
7345 0
7346 0
7347 0
7348 0
7349 0
7350 0
7351 0
7352 0
7353 0
7354 0
7355 0
7356 0
7357 0
7358 0
7359 0
7360 0
7361 0
7362 0
7363 0
7364 0
7365 0
7366 0
... ...
226734 0
226735 0
226736 0
226737 0
226738 0
226739 0
226740 0
226741 0
226742 0
226743 0
226744 0
226745 0
226746 0
226747 0
226748 0
226749 0
226750 0
226751 0
226752 0
226753 0
226754 0
226755 0
226756 0
226757 0
226758 0
226759 0
226760 0
226761 0
226762 0
226763 0
[4082 rows x 20 columns]
WN Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
7645 1 1 6 1903.0 2017.0 WN
7646 1 1 6 856.0 956.0 WN
7647 1 1 6 1545.0 1625.0 WN
7648 1 1 6 2005.0 2053.0 WN
7649 1 1 6 954.0 1034.0 WN
7650 1 1 6 935.0 1053.0 WN
7651 1 1 6 2004.0 2121.0 WN
7652 1 1 6 1419.0 1553.0 WN
7653 1 1 6 1232.0 1402.0 WN
7654 1 1 6 1534.0 1902.0 WN
7655 1 1 6 728.0 1112.0 WN
7656 1 1 6 1613.0 1659.0 WN
7657 1 1 6 1940.0 2028.0 WN
7658 1 1 6 928.0 1017.0 WN
7659 1 1 6 1004.0 1052.0 WN
7660 1 1 6 1108.0 1157.0 WN
7661 1 1 6 1139.0 1235.0 WN
7662 1 1 6 1158.0 1248.0 WN
7663 1 1 6 1518.0 1614.0 WN
7664 1 1 6 1607.0 1656.0 WN
7665 1 1 6 1730.0 1820.0 WN
7666 1 1 6 1339.0 1423.0 WN
7667 1 1 6 1257.0 1353.0 WN
7668 1 1 6 1829.0 1916.0 WN
7669 1 1 6 1900.0 1953.0 WN
7670 1 1 6 1546.0 1716.0 WN
7671 1 1 6 1130.0 1245.0 WN
7672 1 1 6 1739.0 1857.0 WN
7673 1 1 6 730.0 946.0 WN
7674 1 1 6 1815.0 1938.0 WN
... ... ... ... ... ... ...
227466 12 6 2 752.0 857.0 WN
227467 12 6 2 651.0 746.0 WN
227468 12 6 2 1728.0 1932.0 WN
227469 12 6 2 1115.0 1315.0 WN
227470 12 6 2 1753.0 1911.0 WN
227471 12 6 2 1222.0 1335.0 WN
227472 12 6 2 836.0 946.0 WN
227473 12 6 2 1352.0 1749.0 WN
227474 12 6 2 1850.0 2046.0 WN
227475 12 6 2 707.0 903.0 WN
227476 12 6 2 1335.0 1528.0 WN
227477 12 6 2 1005.0 1158.0 WN
227478 12 6 2 1723.0 1845.0 WN
227479 12 6 2 1139.0 1304.0 WN
227480 12 6 2 2023.0 2109.0 WN
227481 12 6 2 1542.0 1637.0 WN
227482 12 6 2 1728.0 1825.0 WN
227483 12 6 2 1252.0 1349.0 WN
227484 12 6 2 857.0 955.0 WN
227485 12 6 2 1939.0 2119.0 WN
227486 12 6 2 556.0 745.0 WN
227487 12 6 2 1026.0 1208.0 WN
227488 12 6 2 1611.0 1746.0 WN
227489 12 6 2 758.0 1051.0 WN
227490 12 6 2 1307.0 1600.0 WN
227491 12 6 2 1818.0 2111.0 WN
227492 12 6 2 2047.0 2334.0 WN
227493 12 6 2 912.0 1031.0 WN
227494 12 6 2 656.0 812.0 WN
227495 12 6 2 1600.0 1713.0 WN
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
7645 1266 N732SW 134.0 112.0 47.0 48.0
7646 1689 N727SW 120.0 110.0 -9.0 6.0
7647 1024 N521SW 40.0 30.0 5.0 15.0
7648 2430 N649SW 48.0 31.0 43.0 40.0
7649 3013 N318SW 40.0 29.0 -11.0 -6.0
7650 1038 N355SW 78.0 68.0 -7.0 5.0
7651 2345 N432WN 77.0 68.0 21.0 34.0
7652 1454 N364SW 94.0 78.0 38.0 49.0
7653 2360 N665WN 90.0 77.0 -18.0 -3.0
7654 1593 N437WN 148.0 134.0 2.0 24.0
7655 1890 N936WN 164.0 140.0 -3.0 3.0
7656 473 N334SW 46.0 36.0 44.0 48.0
7657 2127 N765SW 48.0 37.0 33.0 35.0
7658 14 N357SW 49.0 39.0 -13.0 -2.0
7659 16 N363SW 48.0 38.0 -8.0 4.0
7660 20 N600WN 49.0 40.0 2.0 8.0
7661 22 N504SW 56.0 40.0 10.0 9.0
7662 24 N368SW 50.0 39.0 -7.0 -2.0
7663 36 N626SW 56.0 38.0 14.0 18.0
7664 40 N222WN 49.0 41.0 -4.0 7.0
7665 44 N346SW 50.0 40.0 25.0 30.0
7666 275 N947WN 44.0 37.0 -2.0 9.0
7667 865 N931WN 56.0 40.0 -7.0 -3.0
7668 920 N334SW 47.0 39.0 16.0 29.0
7669 976 N907WN 53.0 41.0 23.0 30.0
7670 670 N625SW 150.0 132.0 16.0 21.0
7671 832 N249WN 135.0 123.0 -10.0 5.0
7672 2088 N211WN 138.0 125.0 -3.0 14.0
7673 2277 N780SW 196.0 122.0 41.0 0.0
7674 39 N290WN 83.0 73.0 28.0 35.0
... ... ... ... ... ... ...
227466 1628 N435WN 65.0 50.0 2.0 -3.0
227467 2534 N232WN 55.0 43.0 -9.0 -4.0
227468 902 N724SW 244.0 231.0 7.0 23.0
227469 1167 N455WN 240.0 225.0 -15.0 5.0
227470 513 N362SW 78.0 59.0 31.0 33.0
227471 581 N646SW 73.0 61.0 -10.0 -3.0
227472 1223 N394SW 70.0 58.0 -9.0 1.0
227473 3085 N510SW 177.0 163.0 59.0 72.0
227474 39 N754SW 176.0 157.0 71.0 70.0
227475 424 N769SW 176.0 162.0 -2.0 -3.0
227476 1098 N448WN 173.0 159.0 18.0 20.0
227477 1403 N430WN 173.0 163.0 13.0 15.0
227478 33 N698SW 202.0 192.0 70.0 78.0
227479 1212 N226WN 205.0 193.0 -6.0 -1.0
227480 207 N354SW 46.0 38.0 29.0 43.0
227481 405 N617SW 55.0 43.0 12.0 12.0
227482 628 N389SW 57.0 39.0 5.0 3.0
227483 994 N713SW 57.0 43.0 9.0 7.0
227484 1231 N284WN 58.0 44.0 0.0 -3.0
227485 124 N522SW 100.0 81.0 14.0 39.0
227486 280 N728SW 109.0 87.0 -10.0 -4.0
227487 782 N476WN 102.0 86.0 -12.0 1.0
227488 1050 N655WN 95.0 83.0 -9.0 16.0
227489 201 N903WN 113.0 100.0 -4.0 -2.0
227490 471 N632SW 113.0 98.0 0.0 7.0
227491 1191 N284WN 113.0 97.0 -9.0 8.0
227492 1674 N366SW 107.0 94.0 4.0 7.0
227493 127 N777QC 79.0 61.0 -4.0 -3.0
227494 621 N727SW 76.0 64.0 -13.0 -4.0
227495 1597 N745SW 73.0 59.0 -12.0 0.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
7645 HOU ABQ 759 14.0 8.0 0 NaN
7646 HOU ABQ 759 3.0 7.0 0 NaN
7647 HOU AUS 148 4.0 6.0 0 NaN
7648 HOU AUS 148 4.0 13.0 0 NaN
7649 HOU AUS 148 4.0 7.0 0 NaN
7650 HOU BHM 570 2.0 8.0 0 NaN
7651 HOU BHM 570 2.0 7.0 0 NaN
7652 HOU BNA 670 5.0 11.0 0 NaN
7653 HOU BNA 670 5.0 8.0 0 NaN
7654 HOU BWI 1246 5.0 9.0 0 NaN
7655 HOU BWI 1246 16.0 8.0 0 NaN
7656 HOU CRP 187 4.0 6.0 0 NaN
7657 HOU CRP 187 4.0 7.0 0 NaN
7658 HOU DAL 239 3.0 7.0 0 NaN
7659 HOU DAL 239 2.0 8.0 0 NaN
7660 HOU DAL 239 2.0 7.0 0 NaN
7661 HOU DAL 239 5.0 11.0 0 NaN
7662 HOU DAL 239 3.0 8.0 0 NaN
7663 HOU DAL 239 5.0 13.0 0 NaN
7664 HOU DAL 239 2.0 6.0 0 NaN
7665 HOU DAL 239 3.0 7.0 0 NaN
7666 HOU DAL 239 2.0 5.0 0 NaN
7667 HOU DAL 239 10.0 6.0 0 NaN
7668 HOU DAL 239 2.0 6.0 0 NaN
7669 HOU DAL 239 6.0 6.0 0 NaN
7670 HOU DEN 883 8.0 10.0 0 NaN
7671 HOU DEN 883 5.0 7.0 0 NaN
7672 HOU DEN 883 6.0 7.0 0 NaN
7673 HOU DEN 883 65.0 9.0 0 NaN
7674 HOU ECP 570 3.0 7.0 0 NaN
... ... ... ... ... ... ... ...
227466 HOU MSY 302 4.0 11.0 0 NaN
227467 HOU MSY 302 5.0 7.0 0 NaN
227468 HOU OAK 1642 5.0 8.0 0 NaN
227469 HOU OAK 1642 6.0 9.0 0 NaN
227470 HOU OKC 419 4.0 15.0 0 NaN
227471 HOU OKC 419 3.0 9.0 0 NaN
227472 HOU OKC 419 4.0 8.0 0 NaN
227473 HOU PHL 1336 5.0 9.0 0 NaN
227474 HOU PHX 1020 4.0 15.0 0 NaN
227475 HOU PHX 1020 4.0 10.0 0 NaN
227476 HOU PHX 1020 4.0 10.0 0 NaN
227477 HOU PHX 1020 3.0 7.0 0 NaN
227478 HOU SAN 1313 3.0 7.0 0 NaN
227479 HOU SAN 1313 2.0 10.0 0 NaN
227480 HOU SAT 192 4.0 4.0 0 NaN
227481 HOU SAT 192 4.0 8.0 0 NaN
227482 HOU SAT 192 4.0 14.0 0 NaN
227483 HOU SAT 192 5.0 9.0 0 NaN
227484 HOU SAT 192 5.0 9.0 0 NaN
227485 HOU STL 687 4.0 15.0 0 NaN
227486 HOU STL 687 13.0 9.0 0 NaN
227487 HOU STL 687 4.0 12.0 0 NaN
227488 HOU STL 687 3.0 9.0 0 NaN
227489 HOU TPA 781 3.0 10.0 0 NaN
227490 HOU TPA 781 5.0 10.0 0 NaN
227491 HOU TPA 781 5.0 11.0 0 NaN
227492 HOU TPA 781 4.0 9.0 0 NaN
227493 HOU TUL 453 4.0 14.0 0 NaN
227494 HOU TUL 453 3.0 9.0 0 NaN
227495 HOU TUL 453 3.0 11.0 0 NaN
Diverted
7645 0
7646 0
7647 0
7648 0
7649 0
7650 0
7651 0
7652 0
7653 0
7654 0
7655 0
7656 0
7657 0
7658 0
7659 0
7660 0
7661 0
7662 0
7663 0
7664 0
7665 0
7666 0
7667 0
7668 0
7669 0
7670 0
7671 0
7672 0
7673 0
7674 0
... ...
227466 0
227467 0
227468 0
227469 0
227470 0
227471 0
227472 0
227473 0
227474 0
227475 0
227476 0
227477 0
227478 0
227479 0
227480 0
227481 0
227482 0
227483 0
227484 0
227485 0
227486 0
227487 0
227488 0
227489 0
227490 0
227491 0
227492 0
227493 0
227494 0
227495 0
[45343 rows x 20 columns]
XE Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
12135 1 31 1 1623.0 1913.0 XE
12136 1 31 1 1325.0 1644.0 XE
12137 1 31 1 2110.0 2203.0 XE
12138 1 31 1 1511.0 1824.0 XE
12139 1 31 1 714.0 907.0 XE
12140 1 31 1 1101.0 1353.0 XE
12141 1 31 1 723.0 1056.0 XE
12142 1 31 1 1024.0 1314.0 XE
12143 1 31 1 1055.0 1338.0 XE
12144 1 31 1 1933.0 2106.0 XE
12145 1 31 1 1739.0 2058.0 XE
12146 1 31 1 1317.0 1453.0 XE
12147 1 31 1 1857.0 2233.0 XE
12148 1 31 1 1925.0 2230.0 XE
12149 1 31 1 811.0 1014.0 XE
12150 1 31 1 905.0 1005.0 XE
12151 1 31 1 1935.0 2247.0 XE
12152 1 31 1 1038.0 1344.0 XE
12153 1 31 1 1322.0 1656.0 XE
12154 1 31 1 1525.0 1646.0 XE
12155 1 31 1 902.0 1037.0 XE
12156 1 31 1 1136.0 1300.0 XE
12157 1 31 1 1203.0 1317.0 XE
12158 1 31 1 1424.0 1553.0 XE
12159 1 31 1 1340.0 1715.0 XE
12160 1 31 1 1706.0 1959.0 XE
12161 1 31 1 2115.0 2218.0 XE
12162 1 31 1 724.0 838.0 XE
12163 1 31 1 1649.0 1808.0 XE
12164 1 31 1 1921.0 2258.0 XE
... ... ... ... ... ... ...
224539 12 16 5 1013.0 1148.0 XE
224540 12 15 4 950.0 1123.0 XE
224541 12 18 7 953.0 1116.0 XE
224542 12 19 1 956.0 1108.0 XE
224543 12 17 6 942.0 1116.0 XE
224544 12 29 4 1206.0 1341.0 XE
224545 12 28 3 944.0 1110.0 XE
224546 12 27 2 953.0 1125.0 XE
224547 12 26 1 948.0 1118.0 XE
224548 12 25 7 957.0 1121.0 XE
224549 12 24 6 1035.0 1156.0 XE
224550 12 22 4 1024.0 1155.0 XE
224551 12 23 5 1533.0 1703.0 XE
224552 12 21 3 959.0 1125.0 XE
224553 12 20 2 957.0 1125.0 XE
224554 12 30 5 949.0 1120.0 XE
224555 12 11 7 949.0 1116.0 XE
224556 12 10 6 1001.0 1128.0 XE
224557 12 12 1 1016.0 1143.0 XE
224558 12 14 3 954.0 1113.0 XE
224559 12 13 2 1037.0 1150.0 XE
224560 12 4 7 946.0 1056.0 XE
224561 12 3 6 959.0 1123.0 XE
224562 12 1 4 952.0 1121.0 XE
224563 12 2 5 1043.0 1201.0 XE
224564 12 8 4 959.0 1124.0 XE
224565 12 9 5 1003.0 1126.0 XE
224566 12 5 1 1000.0 1135.0 XE
224567 12 6 2 1000.0 1136.0 XE
224568 12 7 3 1011.0 1137.0 XE
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
12135 2008 N11184 110.0 91.0 -15.0 -7.0
12136 2010 N13992 139.0 100.0 7.0 -8.0
12137 2024 N13949 53.0 36.0 -8.0 0.0
12138 2025 N11140 NaN NaN NaN 1.0
12139 2026 N11191 113.0 93.0 -16.0 -6.0
12140 2029 N14952 112.0 91.0 12.0 21.0
12141 2035 N12160 153.0 137.0 -5.0 3.0
12142 2036 N34111 110.0 90.0 -9.0 -1.0
12143 2041 N14105 163.0 144.0 8.0 -10.0
12144 2042 N12201 93.0 79.0 -3.0 3.0
12145 2044 N15572 139.0 120.0 12.0 9.0
12146 2048 N13935 96.0 59.0 10.0 -3.0
12147 2050 N16149 156.0 139.0 -1.0 -2.0
12148 2055 N26141 125.0 105.0 -13.0 -5.0
12149 2056 N14916 123.0 93.0 5.0 -3.0
12150 2058 N21154 60.0 41.0 -11.0 -5.0
12151 2060 N48901 132.0 102.0 -16.0 -10.0
12152 2064 N14972 126.0 102.0 20.0 23.0
12153 2066 N18114 154.0 127.0 11.0 -3.0
12154 2069 N14925 81.0 59.0 9.0 1.0
12155 2079 N11539 95.0 69.0 8.0 2.0
12156 2082 N41104 144.0 121.0 19.0 11.0
12157 2083 N14925 74.0 57.0 19.0 18.0
12158 2097 N11119 149.0 126.0 18.0 9.0
12159 2105 N18120 155.0 127.0 50.0 45.0
12160 2122 N14116 173.0 146.0 81.0 76.0
12161 2131 N18982 63.0 42.0 -1.0 -5.0
12162 2132 N13936 74.0 53.0 -13.0 -6.0
12163 2162 N13929 79.0 65.0 -5.0 -1.0
12164 2171 N24103 157.0 137.0 3.0 6.0
... ... ... ... ... ... ...
224539 5890 N11150 155.0 120.0 11.0 20.0
224540 5890 N13161 153.0 115.0 -14.0 -3.0
224541 5906 N17115 143.0 122.0 -21.0 0.0
224542 5906 N11181 132.0 111.0 -29.0 3.0
224543 5906 N14125 154.0 128.0 -13.0 -3.0
224544 5906 N11192 155.0 126.0 124.0 133.0
224545 5906 N16178 146.0 128.0 -27.0 -9.0
224546 5906 N14158 152.0 133.0 -12.0 0.0
224547 5906 N17138 150.0 122.0 -19.0 -5.0
224548 5906 N24103 144.0 115.0 -16.0 4.0
224549 5906 N14168 141.0 118.0 32.0 50.0
224550 5906 N24103 151.0 117.0 18.0 31.0
224551 5906 N12160 150.0 121.0 326.0 340.0
224552 5906 N12175 146.0 123.0 -12.0 6.0
224553 5906 N14148 148.0 120.0 -12.0 4.0
224554 5906 N18101 151.0 133.0 -17.0 -4.0
224555 6105 N11192 147.0 124.0 -21.0 -8.0
224556 6105 N14186 147.0 123.0 -9.0 4.0
224557 6105 N25134 147.0 126.0 3.0 16.0
224558 6105 N12135 139.0 117.0 -27.0 -6.0
224559 6105 N14173 133.0 114.0 10.0 37.0
224560 6105 N23139 130.0 112.0 -41.0 -11.0
224561 6105 N14186 144.0 122.0 -14.0 2.0
224562 6105 N18101 149.0 131.0 -19.0 -8.0
224563 6105 N13969 138.0 117.0 21.0 43.0
224564 6105 N13118 145.0 122.0 -16.0 -1.0
224565 6105 N12160 143.0 124.0 -14.0 3.0
224566 6105 N16151 155.0 117.0 -5.0 0.0
224567 6105 N14143 156.0 127.0 -4.0 0.0
224568 6105 N12157 146.0 126.0 -3.0 11.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
12135 IAH JAX 817 4.0 15.0 0 NaN
12136 IAH SDF 788 4.0 35.0 0 NaN
12137 IAH BTR 253 6.0 11.0 0 NaN
12138 IAH ABQ 744 5.0 23.0 0 NaN
12139 IAH STL 668 6.0 14.0 0 NaN
12140 IAH ATL 689 8.0 13.0 0 NaN
12141 IAH PIT 1117 8.0 8.0 0 NaN
12142 IAH JAX 817 5.0 15.0 0 NaN
12143 IAH MKE 984 5.0 14.0 0 NaN
12144 IAH BHM 562 3.0 11.0 0 NaN
12145 IAH CLT 913 7.0 12.0 0 NaN
12146 IAH OKC 395 3.0 34.0 0 NaN
12147 IAH RIC 1157 5.0 12.0 0 NaN
12148 IAH CLT 913 5.0 15.0 0 NaN
12149 IAH MCI 643 5.0 25.0 0 NaN
12150 IAH CRP 201 3.0 16.0 0 NaN
12151 IAH CVG 871 7.0 23.0 0 NaN
12152 IAH IND 845 5.0 19.0 0 NaN
12153 IAH PBI 956 5.0 22.0 0 NaN
12154 IAH LRD 301 3.0 19.0 0 NaN
12155 IAH MAF 429 6.0 20.0 0 NaN
12156 IAH ABQ 744 4.0 19.0 0 NaN
12157 IAH MFE 316 5.0 12.0 0 NaN
12158 IAH COS 809 6.0 17.0 0 NaN
12159 IAH GRR 1042 3.0 25.0 0 NaN
12160 IAH MSP 1034 8.0 19.0 0 NaN
12161 IAH CRP 201 4.0 17.0 0 NaN
12162 IAH LIT 374 5.0 16.0 0 NaN
12163 IAH TUL 429 5.0 9.0 0 NaN
12164 IAH ORF 1201 4.0 16.0 0 NaN
... ... ... ... ... ... ... ...
224539 IAH DEN 862 5.0 30.0 0 NaN
224540 IAH DEN 862 9.0 29.0 0 NaN
224541 IAH DEN 862 7.0 14.0 0 NaN
224542 IAH DEN 862 9.0 12.0 0 NaN
224543 IAH DEN 862 9.0 17.0 0 NaN
224544 IAH DEN 862 10.0 19.0 0 NaN
224545 IAH DEN 862 7.0 11.0 0 NaN
224546 IAH DEN 862 8.0 11.0 0 NaN
224547 IAH DEN 862 7.0 21.0 0 NaN
224548 IAH DEN 862 7.0 22.0 0 NaN
224549 IAH DEN 862 9.0 14.0 0 NaN
224550 IAH DEN 862 7.0 27.0 0 NaN
224551 IAH DEN 862 12.0 17.0 0 NaN
224552 IAH DEN 862 9.0 14.0 0 NaN
224553 IAH DEN 862 8.0 20.0 0 NaN
224554 IAH DEN 862 7.0 11.0 0 NaN
224555 IAH DEN 862 11.0 12.0 0 NaN
224556 IAH DEN 862 8.0 16.0 0 NaN
224557 IAH DEN 862 7.0 14.0 0 NaN
224558 IAH DEN 862 8.0 14.0 0 NaN
224559 IAH DEN 862 9.0 10.0 0 NaN
224560 IAH DEN 862 8.0 10.0 0 NaN
224561 IAH DEN 862 11.0 11.0 0 NaN
224562 IAH DEN 862 6.0 12.0 0 NaN
224563 IAH DEN 862 8.0 13.0 0 NaN
224564 IAH DEN 862 8.0 15.0 0 NaN
224565 IAH DEN 862 8.0 11.0 0 NaN
224566 IAH DEN 862 9.0 29.0 0 NaN
224567 IAH DEN 862 9.0 20.0 0 NaN
224568 IAH DEN 862 7.0 13.0 0 NaN
Diverted
12135 0
12136 0
12137 0
12138 1
12139 0
12140 0
12141 0
12142 0
12143 0
12144 0
12145 0
12146 0
12147 0
12148 0
12149 0
12150 0
12151 0
12152 0
12153 0
12154 0
12155 0
12156 0
12157 0
12158 0
12159 0
12160 0
12161 0
12162 0
12163 0
12164 0
... ...
224539 0
224540 0
224541 0
224542 0
224543 0
224544 0
224545 0
224546 0
224547 0
224548 0
224549 0
224550 0
224551 0
224552 0
224553 0
224554 0
224555 0
224556 0
224557 0
224558 0
224559 0
224560 0
224561 0
224562 0
224563 0
224564 0
224565 0
224566 0
224567 0
224568 0
[73053 rows x 20 columns]
YV Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier \
33504 2 19 6 1004.0 1355.0 YV
33505 2 26 6 1001.0 1335.0 YV
55503 3 5 6 1002.0 1358.0 YV
55504 3 12 6 1009.0 1357.0 YV
55505 3 19 6 1008.0 1350.0 YV
55506 3 19 6 1453.0 1541.0 YV
55507 3 26 6 1039.0 1418.0 YV
70518 4 2 6 1006.0 1356.0 YV
70519 4 5 2 520.0 840.0 YV
70520 4 5 2 1413.0 1739.0 YV
70521 4 6 3 520.0 838.0 YV
70522 4 6 3 1328.0 1648.0 YV
70523 4 7 4 520.0 830.0 YV
70524 4 7 4 1327.0 1654.0 YV
70525 4 8 5 515.0 834.0 YV
70526 4 8 5 1358.0 1715.0 YV
70527 4 9 6 515.0 855.0 YV
70528 4 9 6 1322.0 1700.0 YV
70529 4 10 7 520.0 837.0 YV
70530 4 10 7 1329.0 1645.0 YV
70531 4 11 1 520.0 840.0 YV
70532 4 11 1 1333.0 1719.0 YV
70533 4 12 2 515.0 851.0 YV
70534 4 12 2 1400.0 1730.0 YV
70535 4 13 3 516.0 834.0 YV
70536 4 13 3 1330.0 1700.0 YV
70537 4 14 4 515.0 824.0 YV
70538 4 14 4 1330.0 1644.0 YV
70539 4 15 5 518.0 835.0 YV
70540 4 15 5 1410.0 1726.0 YV
... ... ... ... ... ... ...
70560 4 25 1 1341.0 1806.0 YV
70561 4 26 2 520.0 850.0 YV
70562 4 26 2 1330.0 1700.0 YV
70563 4 27 3 519.0 844.0 YV
70564 4 27 3 1351.0 1727.0 YV
70565 4 28 4 515.0 833.0 YV
70566 4 28 4 1342.0 1701.0 YV
70567 4 29 5 517.0 829.0 YV
70568 4 29 5 1330.0 1648.0 YV
70569 4 30 6 529.0 842.0 YV
70570 4 30 6 1416.0 1733.0 YV
89563 5 1 7 520.0 843.0 YV
89564 5 1 7 1331.0 1657.0 YV
89565 5 2 1 520.0 840.0 YV
89566 5 2 1 1327.0 1716.0 YV
89567 5 8 7 1519.0 1858.0 YV
89568 5 15 7 NaN NaN YV
89569 5 22 7 1524.0 1846.0 YV
89570 5 29 7 1524.0 1900.0 YV
109025 6 5 7 1516.0 1937.0 YV
109026 6 12 7 1525.0 1920.0 YV
109027 6 19 7 1518.0 1845.0 YV
109028 6 26 7 1516.0 1847.0 YV
129552 7 3 7 1520.0 1855.0 YV
129553 7 10 7 1514.0 1849.0 YV
129554 7 17 7 1523.0 1857.0 YV
129555 7 24 7 1520.0 1855.0 YV
129556 7 31 7 1519.0 1933.0 YV
144280 8 7 7 1522.0 1859.0 YV
144281 8 14 7 1516.0 1925.0 YV
FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay \
33504 7290 N508MJ 171.0 144.0 -12.0 -6.0
33505 7290 N521LR 154.0 134.0 -32.0 -9.0
55503 7231 N501MJ 176.0 142.0 -9.0 -8.0
55504 7240 N521LR 168.0 148.0 -10.0 -1.0
55505 7240 N518LR 162.0 141.0 -17.0 -2.0
55506 2699 N907FJ 168.0 150.0 -13.0 -7.0
55507 7240 N512MJ 159.0 138.0 11.0 29.0
70518 7240 N513MJ 170.0 148.0 -11.0 -4.0
70519 2780 N918FJ 140.0 119.0 -6.0 0.0
70520 2782 N934FJ 146.0 113.0 45.0 43.0
70521 2780 N942LR 138.0 115.0 -8.0 0.0
70522 2782 N910FJ 140.0 113.0 -6.0 -2.0
70523 2780 N935LR 130.0 113.0 -16.0 0.0
70524 2782 N919FJ 147.0 120.0 0.0 -3.0
70525 2780 N911FJ 139.0 119.0 -12.0 -5.0
70526 2782 N921FJ 137.0 117.0 21.0 28.0
70527 2780 N926LR 160.0 127.0 9.0 -5.0
70528 2782 N911FJ 158.0 120.0 6.0 -8.0
70529 2780 N921FJ 137.0 117.0 -9.0 0.0
70530 2782 N911FJ 136.0 120.0 -9.0 -1.0
70531 2780 N922FJ 140.0 120.0 -6.0 0.0
70532 2782 N956LR 166.0 113.0 25.0 3.0
70533 2780 N926LR 156.0 130.0 5.0 -5.0
70534 2782 N922FJ 150.0 115.0 36.0 30.0
70535 2780 N921FJ 138.0 119.0 -12.0 -4.0
70536 2782 N924FJ 150.0 113.0 6.0 0.0
70537 2780 N924FJ 129.0 109.0 -22.0 -5.0
70538 2782 N916FJ 134.0 109.0 -10.0 0.0
70539 2780 N921FJ 137.0 114.0 -11.0 -2.0
70540 2782 N916FJ 136.0 117.0 32.0 40.0
... ... ... ... ... ... ...
70560 2782 N929LR 205.0 115.0 72.0 11.0
70561 2780 N927LR 150.0 127.0 4.0 0.0
70562 2782 N920FJ 150.0 119.0 6.0 0.0
70563 2780 N921FJ 145.0 124.0 -2.0 -1.0
70564 2782 N912FJ 156.0 121.0 33.0 21.0
70565 2780 N942LR 138.0 115.0 -13.0 -5.0
70566 2782 N935LR 139.0 113.0 7.0 12.0
70567 2780 N922FJ 132.0 109.0 -17.0 -3.0
70568 2782 N913FJ 138.0 110.0 -6.0 0.0
70569 2780 N924FJ 133.0 116.0 -4.0 9.0
70570 2782 N918FJ 137.0 115.0 39.0 46.0
89563 2780 N921FJ 143.0 118.0 -3.0 0.0
89564 2782 N925FJ 146.0 118.0 3.0 1.0
89565 2780 N938LR 140.0 119.0 -6.0 0.0
89566 2782 N927LR 169.0 126.0 22.0 -3.0
89567 2636 N913FJ 159.0 115.0 4.0 -11.0
89568 2636 N933LR NaN NaN NaN NaN
89569 2636 N919FJ 142.0 116.0 -8.0 -6.0
89570 2636 N918FJ 156.0 125.0 6.0 -6.0
109025 2636 N922FJ 201.0 115.0 42.0 -9.0
109026 2636 N912FJ 175.0 123.0 25.0 0.0
109027 2636 N932LR 147.0 113.0 -10.0 -7.0
109028 2636 N932LR 151.0 129.0 -8.0 -9.0
129552 2636 N918FJ 155.0 124.0 0.0 -5.0
129553 2636 N904FJ 155.0 126.0 -6.0 -11.0
129554 2636 N914FJ 154.0 132.0 2.0 -2.0
129555 2636 N929LR 155.0 129.0 0.0 -5.0
129556 2636 N927LR 194.0 132.0 38.0 -6.0
144280 2636 N908FJ 157.0 126.0 4.0 -3.0
144281 2636 N938LR 189.0 129.0 30.0 -9.0
Origin Dest Distance TaxiIn TaxiOut Cancelled CancellationCode \
33504 IAH IAD 1190 14.0 13.0 0 NaN
33505 IAH IAD 1190 4.0 16.0 0 NaN
55503 IAH IAD 1190 4.0 30.0 0 NaN
55504 IAH IAD 1190 4.0 16.0 0 NaN
55505 IAH IAD 1190 6.0 15.0 0 NaN
55506 IAH PHX 1009 9.0 9.0 0 NaN
55507 IAH IAD 1190 4.0 17.0 0 NaN
70518 IAH IAD 1190 5.0 17.0 0 NaN
70519 IAH CLT 913 11.0 10.0 0 NaN
70520 IAH CLT 913 9.0 24.0 0 NaN
70521 IAH CLT 913 14.0 9.0 0 NaN
70522 IAH CLT 913 14.0 13.0 0 NaN
70523 IAH CLT 913 12.0 5.0 0 NaN
70524 IAH CLT 913 13.0 14.0 0 NaN
70525 IAH CLT 913 9.0 11.0 0 NaN
70526 IAH CLT 913 10.0 10.0 0 NaN
70527 IAH CLT 913 15.0 18.0 0 NaN
70528 IAH CLT 913 17.0 21.0 0 NaN
70529 IAH CLT 913 11.0 9.0 0 NaN
70530 IAH CLT 913 12.0 4.0 0 NaN
70531 IAH CLT 913 8.0 12.0 0 NaN
70532 IAH CLT 913 16.0 37.0 0 NaN
70533 IAH CLT 913 13.0 13.0 0 NaN
70534 IAH CLT 913 13.0 22.0 0 NaN
70535 IAH CLT 913 8.0 11.0 0 NaN
70536 IAH CLT 913 14.0 23.0 0 NaN
70537 IAH CLT 913 12.0 8.0 0 NaN
70538 IAH CLT 913 11.0 14.0 0 NaN
70539 IAH CLT 913 14.0 9.0 0 NaN
70540 IAH CLT 913 5.0 14.0 0 NaN
... ... ... ... ... ... ... ...
70560 IAH CLT 913 11.0 79.0 0 NaN
70561 IAH CLT 913 12.0 11.0 0 NaN
70562 IAH CLT 913 15.0 16.0 0 NaN
70563 IAH CLT 913 9.0 12.0 0 NaN
70564 IAH CLT 913 15.0 20.0 0 NaN
70565 IAH CLT 913 12.0 11.0 0 NaN
70566 IAH CLT 913 11.0 15.0 0 NaN
70567 IAH CLT 913 11.0 12.0 0 NaN
70568 IAH CLT 913 10.0 18.0 0 NaN
70569 IAH CLT 913 9.0 8.0 0 NaN
70570 IAH CLT 913 9.0 13.0 0 NaN
89563 IAH CLT 913 14.0 11.0 0 NaN
89564 IAH CLT 913 12.0 16.0 0 NaN
89565 IAH CLT 913 10.0 11.0 0 NaN
89566 IAH CLT 913 10.0 33.0 0 NaN
89567 IAH CLT 913 31.0 13.0 0 NaN
89568 IAH CLT 913 NaN NaN 1 A
89569 IAH CLT 913 15.0 11.0 0 NaN
89570 IAH CLT 913 17.0 14.0 0 NaN
109025 IAH CLT 913 77.0 9.0 0 NaN
109026 IAH CLT 913 42.0 10.0 0 NaN
109027 IAH CLT 913 24.0 10.0 0 NaN
109028 IAH CLT 913 9.0 13.0 0 NaN
129552 IAH CLT 912 14.0 17.0 0 NaN
129553 IAH CLT 912 14.0 15.0 0 NaN
129554 IAH CLT 912 8.0 14.0 0 NaN
129555 IAH CLT 912 10.0 16.0 0 NaN
129556 IAH CLT 912 23.0 39.0 0 NaN
144280 IAH CLT 912 19.0 12.0 0 NaN
144281 IAH CLT 912 5.0 55.0 0 NaN
Diverted
33504 0
33505 0
55503 0
55504 0
55505 0
55506 0
55507 0
70518 0
70519 0
70520 0
70521 0
70522 0
70523 0
70524 0
70525 0
70526 0
70527 0
70528 0
70529 0
70530 0
70531 0
70532 0
70533 0
70534 0
70535 0
70536 0
70537 0
70538 0
70539 0
70540 0
... ...
70560 0
70561 0
70562 0
70563 0
70564 0
70565 0
70566 0
70567 0
70568 0
70569 0
70570 0
89563 0
89564 0
89565 0
89566 0
89567 0
89568 0
89569 0
89570 0
109025 0
109026 0
109027 0
109028 0
129552 0
129553 0
129554 0
129555 0
129556 0
144280 0
144281 0
[79 rows x 20 columns]
In [30]:
d = carriers.aggregate(np.mean).sort_values(by="Distance")
print(d)
UniqueCarrier Month DayofMonth DayOfWeek DepTime ArrTime \
0 AA 6.546239 15.737361 3.969482 1229.524168 1416.174309
13 XE 6.365762 15.715439 3.961891 1412.498791 1587.701899
12 WN 6.532607 15.723044 3.844011 1386.275053 1508.048862
8 MQ 6.788296 15.749785 3.914372 1301.158105 1459.362951
7 FL 6.704067 15.823282 3.861150 1272.943841 1540.832782
4 DL 6.342295 15.861795 3.941310 1121.073049 1422.411244
5 EV 6.832123 15.706443 3.928766 1181.844892 1453.776941
9 OO 6.954673 15.948447 3.989664 1422.620670 1606.302603
6 F9 6.608592 15.885442 3.877088 1178.482593 1311.695913
14 YV 4.379747 16.278481 4.772152 1051.987179 1391.320513
11 US 6.907153 15.815287 3.993631 1153.791037 1412.724950
3 CO 6.491632 15.703307 3.990619 1435.984000 1648.280519
10 UA 6.869208 15.853764 3.995174 1199.157689 1424.113837
2 B6 6.669065 15.798561 3.945324 1109.787297 1534.426883
1 AS 6.526027 15.720548 4.005479 1841.342466 2092.654795
FlightNum ActualElapsedTime AirTime ArrDelay DepDelay \
0 1375.543157 92.768722 69.652612 0.891756 6.390144
13 3036.420448 103.860302 83.222146 8.186524 7.713728
12 1046.461482 100.045918 86.731341 7.587143 13.488241
8 3458.577022 116.232682 93.839476 7.152975 11.071745
7 359.525479 111.994315 92.706300 1.853624 4.716376
4 1194.460810 126.490544 97.801235 6.084137 9.370627
5 5237.963249 127.306931 103.656766 7.256954 12.482193
9 3453.567524 137.080540 113.410684 8.693492 8.885482
6 294.662291 143.173077 125.341346 7.668269 5.093637
14 3148.683544 151.384615 121.935897 4.012821 1.538462
11 1068.175404 158.006203 133.856328 -0.630769 1.622926
3 1126.061900 170.924063 145.457873 6.098698 9.261313
10 537.018340 183.449582 157.406296 10.462863 12.918707
2 621.294964 205.442793 183.985141 9.858841 13.320532
1 731.000000 276.969780 254.184066 3.192308 3.712329
Distance TaxiIn TaxiOut Cancelled Diverted
0 483.821208 8.032349 15.083516 0.018496 0.001850
13 589.032565 5.202643 15.442631 0.015496 0.003450
12 606.621794 4.541163 8.779948 0.015504 0.002294
8 650.530981 9.068026 13.352681 0.029045 0.001936
7 685.406265 9.414265 9.926852 0.009818 0.003273
4 723.283226 12.683481 16.036168 0.015903 0.003029
5 775.681488 8.993412 14.652726 0.034483 0.003176
9 819.727850 5.828384 17.844673 0.013947 0.003487
6 882.741050 7.591346 10.240096 0.007160 0.000000
14 938.670886 12.884615 16.564103 0.012658 0.000000
11 981.467663 8.929812 15.219718 0.011269 0.001470
3 1098.054946 7.110732 18.364798 0.006783 0.002627
10 1177.838803 8.281649 17.754661 0.016409 0.002413
2 1428.000000 6.939439 14.521418 0.025899 0.005755
1 1874.000000 5.550685 17.232877 0.000000 0.002740
Time to plot something fron group by - distance by a carrier
In [31]:
plt.figure()
plt.bar(range(d.shape[0]), d["Distance"])
plt.show()
There are packages that uses Javascript libraries from Python to do Web/in browser plotting. Two most used ones are D3.js and Bokeh. D3.js more taylored to call from Javascript, while Bokeh is more python oriented. Some examples how to use Bokeh
In [32]:
from bokeh.io import output_notebook
from bokeh.charts import Bar, show
from bokeh.layouts import row, column
from bokeh.models import BoxSelectTool, LassoSelectTool, Spacer
from bokeh.plotting import figure, show
In [33]:
N = 4000
x = np.random.random(size=N)*100
y = np.random.random(size=N)*100
r = np.random.random(size=N)*1.4
colors = ['#%02x%02x%02x' % (int(r), int(g), 150) for r, g in zip(np.floor(50 + 2*x), np.floor(50 + 2*y))]
output_notebook()
p = figure()
p.circle(x, y, radius=r, fill_color=colors, fill_alpha=0.6, line_color=None)
show(p)
Example how to make barplot in Bokeh
In [49]:
from bokeh.plotting import figure, show, output_file
# generate some synthetic time series for six different categories
cats = list("abcdef")
yy = np.random.randn(2000)
g = np.random.choice(cats, 2000)
for i, l in enumerate(cats):
yy[g == l] += i // 2
df = pd.DataFrame(dict(score=yy, group=g))
# find the quartiles and IQR for each category
groups = df.groupby('group')
q1 = groups.quantile(q=0.25)
q2 = groups.quantile(q=0.5)
q3 = groups.quantile(q=0.75)
iqr = q3 - q1
upper = q3 + 1.5*iqr
lower = q1 - 1.5*iqr
# find the outliers for each category
def outliers(group):
cat = group.name
return group[(group.score > upper.loc[cat]['score']) | (group.score < lower.loc[cat]['score'])]['score']
out = groups.apply(outliers).dropna()
# prepare outlier data for plotting, we need coordinates for every outlier.
if not out.empty:
outx = []
outy = []
for cat in cats:
# only add outliers if they exist
if not out.loc[cat].empty:
for value in out[cat]:
outx.append(cat)
outy.append(value)
p = figure(tools="save", background_fill_color="#EFE8E2", title="", x_range=cats)
# if no outliers, shrink lengths of stems to be no longer than the minimums or maximums
qmin = groups.quantile(q=0.00)
qmax = groups.quantile(q=1.00)
upper.score = [min([x,y]) for (x,y) in zip(list(qmax.loc[:,'score']),upper.score)]
lower.score = [max([x,y]) for (x,y) in zip(list(qmin.loc[:,'score']),lower.score)]
# stems
p.segment(cats, upper.score, cats, q3.score, line_color="black")
p.segment(cats, lower.score, cats, q1.score, line_color="black")
# boxes
p.vbar(cats, 0.7, q2.score, q3.score, fill_color="#E08E79", line_color="black")
p.vbar(cats, 0.7, q1.score, q2.score, fill_color="#3B8686", line_color="black")
# whiskers (almost-0 height rects simpler than segments)
p.rect(cats, lower.score, 0.2, 0.01, line_color="black")
p.rect(cats, upper.score, 0.2, 0.01, line_color="black")
# outliers
if not out.empty:
p.circle(outx, outy, size=6, color="#F38630", fill_alpha=0.6)
p.xgrid.grid_line_color = None
p.ygrid.grid_line_color = "white"
p.grid.grid_line_width = 2
p.xaxis.major_label_text_font_size="12pt"
# output_file("boxplot.html", title="boxplot.py example")
output_notebook()
show(p)
Now plotting again hflights - distance distribution
Interesting subset fo plots when we have to overlay statistical or other data over some maps - say, map of US or map of the World. REquires longitude/latitude information.
In [35]:
airports = pd.read_csv("airports.csv")
airports.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 46235 entries, 0 to 46234
Data columns (total 13 columns):
ident 46235 non-null object
type 46235 non-null object
name 46235 non-null object
latitude_deg 46235 non-null float64
longitude_deg 46235 non-null float64
elevation_ft 42603 non-null float64
continent 21174 non-null object
iso_country 46012 non-null object
iso_region 46235 non-null object
municipality 41329 non-null object
gps_code 39950 non-null object
iata_code 8410 non-null object
local_code 25931 non-null object
dtypes: float64(3), object(10)
memory usage: 4.6+ MB
Lets add to out flights data frame information about airport positions
In [36]:
l = len(hflights['Month'])
print(l)
hflights.info()
227496
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 227496 entries, 0 to 227495
Data columns (total 20 columns):
Month 227496 non-null int64
DayofMonth 227496 non-null int64
DayOfWeek 227496 non-null int64
DepTime 224591 non-null float64
ArrTime 224430 non-null float64
UniqueCarrier 227496 non-null object
FlightNum 227496 non-null int64
TailNum 226701 non-null object
ActualElapsedTime 223874 non-null float64
AirTime 223874 non-null float64
ArrDelay 223874 non-null float64
DepDelay 224591 non-null float64
Origin 227496 non-null object
Dest 227496 non-null object
Distance 227496 non-null int64
TaxiIn 224430 non-null float64
TaxiOut 224549 non-null float64
Cancelled 227496 non-null int64
CancellationCode 2973 non-null object
Diverted 227496 non-null int64
dtypes: float64(8), int64(7), object(5)
memory usage: 34.7+ MB
Add columns to flights data frame with destination airport latitude/longitude
In [37]:
la = np.zeros(l)
lo = np.zeros(l)
ll = len(airports['ident'])
dst = {}
for k in range(0, ll):
if k % 1024 == 0:
print(k)
r = airports.iloc[k]
dst[r['iata_code']] = (r['latitude_deg'], r['longitude_deg'])
print('=========================================')
for i in range(0, l):
if i % 1024 == 0:
print(i)
la[i], lo[i] = dst[hflights.iloc[i]['Dest']]
0
1024
2048
3072
4096
5120
6144
7168
8192
9216
10240
11264
12288
13312
14336
15360
16384
17408
18432
19456
20480
21504
22528
23552
24576
25600
26624
27648
28672
29696
30720
31744
32768
33792
34816
35840
36864
37888
38912
39936
40960
41984
43008
44032
45056
46080
=========================================
0
1024
2048
3072
4096
5120
6144
7168
8192
9216
10240
11264
12288
13312
14336
15360
16384
17408
18432
19456
20480
21504
22528
23552
24576
25600
26624
27648
28672
29696
30720
31744
32768
33792
34816
35840
36864
37888
38912
39936
40960
41984
43008
44032
45056
46080
47104
48128
49152
50176
51200
52224
53248
54272
55296
56320
57344
58368
59392
60416
61440
62464
63488
64512
65536
66560
67584
68608
69632
70656
71680
72704
73728
74752
75776
76800
77824
78848
79872
80896
81920
82944
83968
84992
86016
87040
88064
89088
90112
91136
92160
93184
94208
95232
96256
97280
98304
99328
100352
101376
102400
103424
104448
105472
106496
107520
108544
109568
110592
111616
112640
113664
114688
115712
116736
117760
118784
119808
120832
121856
122880
123904
124928
125952
126976
128000
129024
130048
131072
132096
133120
134144
135168
136192
137216
138240
139264
140288
141312
142336
143360
144384
145408
146432
147456
148480
149504
150528
151552
152576
153600
154624
155648
156672
157696
158720
159744
160768
161792
162816
163840
164864
165888
166912
167936
168960
169984
171008
172032
173056
174080
175104
176128
177152
178176
179200
180224
181248
182272
183296
184320
185344
186368
187392
188416
189440
190464
191488
192512
193536
194560
195584
196608
197632
198656
199680
200704
201728
202752
203776
204800
205824
206848
207872
208896
209920
210944
211968
212992
214016
215040
216064
217088
218112
219136
220160
221184
222208
223232
224256
225280
226304
227328
In [38]:
hflights = hflights.assign(Lat = la)
hflights = hflights.assign(Lng = lo)
hflights.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 227496 entries, 0 to 227495
Data columns (total 22 columns):
Month 227496 non-null int64
DayofMonth 227496 non-null int64
DayOfWeek 227496 non-null int64
DepTime 224591 non-null float64
ArrTime 224430 non-null float64
UniqueCarrier 227496 non-null object
FlightNum 227496 non-null int64
TailNum 226701 non-null object
ActualElapsedTime 223874 non-null float64
AirTime 223874 non-null float64
ArrDelay 223874 non-null float64
DepDelay 224591 non-null float64
Origin 227496 non-null object
Dest 227496 non-null object
Distance 227496 non-null int64
TaxiIn 224430 non-null float64
TaxiOut 224549 non-null float64
Cancelled 227496 non-null int64
CancellationCode 2973 non-null object
Diverted 227496 non-null int64
Lat 227496 non-null float64
Lng 227496 non-null float64
dtypes: float64(10), int64(7), object(5)
memory usage: 38.2+ MB
And plot it all using Basemap from mpl_toolkits
In [39]:
from mpl_toolkits.basemap import Basemap
Plot all airports
In [40]:
plt.figure()
m = Basemap(projection='merc',llcrnrlat=-80,urcrnrlat=80,llcrnrlon=-180,urcrnrlon=180,lat_ts=20,resolution='c')
m.drawcoastlines()
m.drawmapboundary()
# Convert latitude and longitude to x and y coordinates
x, y = m(list(airports["longitude_deg"].astype(float)), list(airports["latitude_deg"].astype(float)))
# Use matplotlib to draw the points onto the map.
m.scatter(x,y,1,marker='o',color='red')
# Show the plot.
plt.show()
Group by and aggregate flights dataset by destination airport
In [41]:
udest = hflights.groupby(by=["Dest"], axis=AXIS_ROW_OP, as_index=False)
ud = udest.aggregate(np.mean).sort_values(by="Distance")
ud.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 116 entries, 14 to 48
Data columns (total 18 columns):
Dest 116 non-null object
Month 116 non-null float64
DayofMonth 116 non-null float64
DayOfWeek 116 non-null float64
DepTime 116 non-null float64
ArrTime 116 non-null float64
FlightNum 116 non-null float64
ActualElapsedTime 116 non-null float64
AirTime 116 non-null float64
ArrDelay 116 non-null float64
DepDelay 116 non-null float64
Distance 116 non-null float64
TaxiIn 116 non-null float64
TaxiOut 116 non-null float64
Cancelled 116 non-null float64
Diverted 116 non-null float64
Lat 116 non-null float64
Lng 116 non-null float64
dtypes: float64(17), object(1)
memory usage: 17.2+ KB
And plot it
In [42]:
plt.figure()
m = Basemap(llcrnrlon=-119,llcrnrlat=22,urcrnrlon=-64,urcrnrlat=49, projection='lcc',lat_1=33,lat_2=45,lon_0=-95)
m.drawcoastlines()
m.drawmapboundary()
# Convert latitude and longitude to x and y coordinates
x, y = m(list(ud["Lng"].astype(float)), list(ud["Lat"].astype(float)))
# Use matplotlib to draw the points onto the map.
m.scatter(x,y,1,marker='o',color='red')
# Show the plot.
plt.show()
Plot lines for routes connecting origin airport and destination airport
In [47]:
plt.figure()
# create polar stereographic Basemap instance.
m = Basemap(llcrnrlon=-119,llcrnrlat=22,urcrnrlon=-64,urcrnrlat=49, lat_0=35.0, projection='stere',lat_1=33,lat_2=45,lon_0=-95,resolution='l')
# draw coastlines, state and country boundaries, edge of map.
m.drawcoastlines()
m.drawstates()
m.drawcountries()
source_lat = 29.9843998
source_lng = -95.34140015
for name, row in ud.iterrows():
try:
# using dst again
# print(row)
# Get the source and dest airports.
dest_lat = row["Lat"]
dest_lng = row["Lng"]
# Don't draw overly long routes.
if abs(source_lng - dest_lng) < 90:
# Draw a great circle between source and dest airports.
m.drawgreatcircle(source_lng, source_lat, dest_lng, dest_lat, linewidth=1, color='b')
except (ValueError, IndexError):
pass
# Show the map.
plt.show()
Content source: Oleg-Krivosheev/Python_Pandas_Visual
Similar notebooks: