My First Data Science Project¶
Helicopter Escapes!¶
We begin by importing some helper functions.
In [1]:
from helper import *
In [2]:
url = 'https://en.wikipedia.org/wiki/List_of_helicopter_prison_escapes'
Get the Data¶
Now, let's get the data from the List of helicopter prison escapes Wikipedia article.
In [3]:
data = data_from_url(url)
In [4]:
for index, row in enumerate(data):
if index <= 3:
print(row)
Let's print the first three rows
In [5]:
index = 0
In [6]:
for row in data:
last_index = len(data) + 1
data[index] = row[0:-1]
index += 1
In [7]:
for index, row in enumerate(data):
if index <= 5:
print(row)
In [8]:
for row in data:
row[0] = fetch_year(row[0])
In [9]:
for index, row in enumerate(data):
if index <= 5:
print(row)
In [11]:
min_year = min(data, key=lambda x: x[0])[0]
max_year = max(data, key=lambda x: x[0])[0]
In [12]:
years = []
for y in range(min_year, max_year + 1):
years.append(y)
In [14]:
attempts_per_year = []
In [15]:
for year in years:
attempts_per_year.append([year, 0])
In [16]:
print(attempts_per_year)
In [17]:
for row in data:
for ya in attempts_per_year:
y = ya[0]
if row[0] == y:
ya[1] += 1
print(attempts_per_year)
2009, 2007, 2001, 1986
In [18]:
%matplotlib inline
barplot(attempts_per_year)
In [19]:
countries_frequency = df["Country"].value_counts()
In [20]:
print_pretty_table(countries_frequency)
In [ ]: