Skip to content

Instantly share code, notes, and snippets.

@snippsat

snippsat/gist:d6882187b5fdc0b516526f17693b0e38

Created June 17, 2019 15:21
Show Gist options
  • Save snippsat/d6882187b5fdc0b516526f17693b0e38 to your computer and use it in GitHub Desktop.
Save snippsat/d6882187b5fdc0b516526f17693b0e38 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"cells": [
{
"cell_type": "code",
"execution_count": 48,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import requests\n",
"from bs4 import BeautifulSoup\n",
"#from tabulate import tabulate\n",
"\n",
"res = requests.get(\"http://web.archive.org/web/20070701133815/http://www.bbmf.co.uk/september07.html\")\n",
"soup = BeautifulSoup(res.content,'lxml')\n",
"table = soup.find_all('table')[0]\n",
"\n",
"df = pd.read_html(str(table))\n",
"#print( tabulate(df[0], headers='keys', tablefmt='psql') )"
]
},
{
"cell_type": "code",
"execution_count": 49,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Date</th>\n",
" <th>Location</th>\n",
" <th>Lancaster</th>\n",
" <th>Spitfire</th>\n",
" <th>Hurricane</th>\n",
" <th>Dakota</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1</td>\n",
" <td>Fort Nelson</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>Lydd - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>Shackerstone - Display</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>Rye Meadows</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>Alfrick</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2</td>\n",
" <td>Lydd - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>Chart Sutton</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>Gedling</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>Ludford Magna</td>\n",
" <td>L</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>Elvington</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>D</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>Headingly Campus</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>D</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>Darley</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>7</td>\n",
" <td>RAF Wittering</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>RAF Honington</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>RAF Leeming</td>\n",
" <td>NaN</td>\n",
" <td>S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Date Location Lancaster Spitfire Hurricane Dakota\n",
"2 1 Fort Nelson NaN S NaN NaN\n",
"3 NaN Lydd - Display L S H NaN\n",
"4 NaN Shackerstone - Display NaN S NaN NaN\n",
"5 NaN Rye Meadows NaN S NaN NaN\n",
"6 NaN Alfrick NaN S NaN NaN\n",
"7 2 Lydd - Display L S H NaN\n",
"8 NaN Chart Sutton NaN S H NaN\n",
"9 NaN Gedling NaN S H NaN\n",
"10 NaN Ludford Magna L NaN NaN NaN\n",
"11 NaN Elvington NaN NaN NaN D\n",
"12 NaN Headingly Campus NaN NaN NaN D\n",
"13 NaN Darley L S NaN NaN\n",
"14 7 RAF Wittering NaN S NaN NaN\n",
"15 NaN RAF Honington NaN S NaN NaN\n",
"16 NaN RAF Leeming NaN S NaN NaN"
]
},
"execution_count": 49,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Clean up,put index(Date location...) at top,delete 2 first row\n",
"df = df[1]\n",
"df = df.rename(columns=df.iloc[0])\n",
"df = df.iloc[2:]\n",
"df.head(15)"
]
},
{
"cell_type": "code",
"execution_count": 59,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Date</th>\n",
" <th>Location</th>\n",
" <th>Lancaster</th>\n",
" <th>Spitfire</th>\n",
" <th>Hurricane</th>\n",
" <th>Dakota</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>Lydd - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2</td>\n",
" <td>Lydd - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>Duxford - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>Duxford - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>15</td>\n",
" <td>Middle Wallop - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>NaN</td>\n",
" <td>Shoreham - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>NaN</td>\n",
" <td>Chichester</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>NaN</td>\n",
" <td>Shoreham - Display</td>\n",
" <td>L</td>\n",
" <td>S</td>\n",
" <td>H</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Date Location Lancaster Spitfire Hurricane Dakota\n",
"3 NaN Lydd - Display L S H NaN\n",
"7 2 Lydd - Display L S H NaN\n",
"24 NaN Duxford - Display L S H NaN\n",
"29 NaN Duxford - Display L S H NaN\n",
"52 15 Middle Wallop - Display L S H NaN\n",
"53 NaN Shoreham - Display L S H NaN\n",
"56 NaN Chichester L S H NaN\n",
"66 NaN Shoreham - Display L S H NaN"
]
},
"execution_count": 59,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Lydd - Display. And that only, had the Spitfire Hurricane and Dakota booked\n",
"# Here Lydd -- Spitfire Hurricane,there where none where all where booked\n",
"lydd = df[(df['Lancaster'] == \"L\") & (df['Spitfire'] == 'S') & (df['Hurricane'] == 'H')]\n",
"lydd"
]
},
{
"cell_type": "code",
"execution_count": 56,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Lydd - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Lydd - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Ludford Magna</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Darley</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Pleaseley</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Nottingham Castle</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Marham</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Foxland Farm</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Duxford - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Duxford - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Wickenby</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>Odiham</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Guernsey - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>Jersey - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>Middle Wallop - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>Shoreham - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>Smallfield</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>Biggin Hill</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>Chichester</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>Shoreham - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>Thetford</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>Little Casterton</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>Helmswell</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>Lincoln</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>Marham 1X Sqn</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td>Bletchley</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>Lamport</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>Hanley Stoke on Trent</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>Southport - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>Southport - Display</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>Lincolnshire's Lancaster Association Day</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Location\n",
"3 Lydd - Display\n",
"7 Lydd - Display\n",
"10 Ludford Magna\n",
"13 Darley\n",
"20 Pleaseley\n",
"21 Nottingham Castle\n",
"22 Marham\n",
"23 Foxland Farm\n",
"24 Duxford - Display\n",
"29 Duxford - Display\n",
"30 Wickenby\n",
"40 Odiham\n",
"42 Guernsey - Display\n",
"43 Jersey - Display\n",
"52 Middle Wallop - Display\n",
"53 Shoreham - Display\n",
"54 Smallfield\n",
"55 Biggin Hill\n",
"56 Chichester\n",
"66 Shoreham - Display\n",
"70 Thetford\n",
"71 Little Casterton\n",
"78 Helmswell\n",
"82 Lincoln\n",
"83 Marham 1X Sqn\n",
"84 Bletchley\n",
"85 Lamport\n",
"86 Hanley Stoke on Trent\n",
"87 Southport - Display\n",
"88 Southport - Display\n",
"90 Lincolnshire's Lancaster Association Day"
]
},
"execution_count": 56,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Here with \"or\" = | \n",
"lydd = df[(df['Lancaster'] == \"L\") & (df['Spitfire'] == 'S') & (df['Hurricane'] == 'H') | (df['Hurricane'] == 'H')]"
]
},
{
"cell_type": "code",
"execution_count": 83,
"metadata": {},
"outputs": [],
"source": [
"df = df[(df['Location'] != \"\") & (df['Spitfire'] == 'S')]"
]
},
{
"cell_type": "code",
"execution_count": 88,
"metadata": {},
"outputs": [],
"source": [
"df = df.dropna(axis='columns')"
]
},
{
"cell_type": "code",
"execution_count": 91,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location</th>\n",
" <th>Spitfire</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Fort Nelson</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Lydd - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Shackerstone - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Rye Meadows</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Alfrick</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Lydd - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Chart Sutton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Gedling</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Darley</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>RAF Wittering</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>RAF Honington</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>RAF Leeming</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Penistone</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Menwith Hill</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Leuchars Charity Ball - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Duxford - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Faldingworth</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Donington Park</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Cliveden</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Snetterton - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Duxford - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>Cliveden</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>Kemble - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>Donington Park</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>Morecambe - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>King Lynn</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>Norwich County Hall</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>Norwich City Hall</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>Odiham</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>Shawbury</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>RAF Halton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>RAF Wittering</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>RAF Coningsby</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>RAF Leeming</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>RAF Kirkton in Lindsey</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>Middle Wallop - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>Shoreham - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>Chichester</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>Boston</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>Sheringham</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>Costessey</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>Bentley Priory - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>Little Casterton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>Collingham</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>Shoreham - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>Newhaven Fort</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>Staplehurst</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>Weald of Kent</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>Long Sutton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>Sheringham</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>Costessey</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>Norwich Cathedral</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>Boston</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>Shrivenham</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>RAF Scampton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>RAF Digby</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>Hanley Stoke on Trent</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>Southport - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>Southport - Display</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>Flixton</td>\n",
" <td>S</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>65 rows × 2 columns</p>\n",
"</div>"
],
"text/plain": [
" Location Spitfire\n",
"2 Fort Nelson S\n",
"3 Lydd - Display S\n",
"4 Shackerstone - Display S\n",
"5 Rye Meadows S\n",
"6 Alfrick S\n",
"7 Lydd - Display S\n",
"8 Chart Sutton S\n",
"9 Gedling S\n",
"13 Darley S\n",
"14 RAF Wittering S\n",
"15 RAF Honington S\n",
"16 RAF Leeming S\n",
"17 Penistone S\n",
"18 Menwith Hill S\n",
"19 Leuchars Charity Ball - Display S\n",
"24 Duxford - Display S\n",
"25 Faldingworth S\n",
"26 Donington Park S\n",
"27 Cliveden S\n",
"28 Snetterton - Display S\n",
"29 Duxford - Display S\n",
"31 Cliveden S\n",
"32 Kemble - Display S\n",
"33 Donington Park S\n",
"34 Morecambe - Display S\n",
"37 King Lynn S\n",
"38 Norwich County Hall S\n",
"39 Norwich City Hall S\n",
"40 Odiham S\n",
"41 Shawbury S\n",
".. ... ...\n",
"47 RAF Halton S\n",
"48 RAF Wittering S\n",
"49 RAF Coningsby S\n",
"50 RAF Leeming S\n",
"51 RAF Kirkton in Lindsey S\n",
"52 Middle Wallop - Display S\n",
"53 Shoreham - Display S\n",
"56 Chichester S\n",
"57 Boston S\n",
"58 Sheringham S\n",
"59 Costessey S\n",
"61 Bentley Priory - Display S\n",
"62 Little Casterton S\n",
"63 Collingham S\n",
"66 Shoreham - Display S\n",
"67 Newhaven Fort S\n",
"68 Staplehurst S\n",
"69 Weald of Kent S\n",
"72 Long Sutton S\n",
"73 Sheringham S\n",
"74 Costessey S\n",
"75 Norwich Cathedral S\n",
"76 Boston S\n",
"77 Shrivenham S\n",
"80 RAF Scampton S\n",
"81 RAF Digby S\n",
"86 Hanley Stoke on Trent S\n",
"87 Southport - Display S\n",
"88 Southport - Display S\n",
"89 Flixton S\n",
"\n",
"[65 rows x 2 columns]"
]
},
"execution_count": 91,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 93,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location</th>\n",
" <th>Spitfire</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>Boston</td>\n",
" <td>S</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>Boston</td>\n",
" <td>S</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Location Spitfire\n",
"57 Boston S\n",
"76 Boston S"
]
},
"execution_count": 93,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[(df['Location'] == 'Boston') & (df['Spitfire'] == 'S')]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment