Trying to Tabulate Information from an Aircraft Website Link(s)

[eddywinch82]

Thanks for your help snippsat,

This is my current working Code:-

import pandas as pd
import requests
from bs4 import BeautifulSoup

res = requests.get("http://web.archive.org/web/20070701133815/http://www.bbmf.co.uk/june07.html")
soup = BeautifulSoup(res.content,'lxml')
table = soup.find_all('table')[0]

df = pd.read_html(str(table))
df = df[1]
df = df.rename(columns=df.iloc[0])
df = df.iloc[2:]
df.head(15)

display = df[(df['Location'].str.contains('- Display')) & (df['Dakota'].str.contains('D')) & (df['Spitfire'].str.contains('S')) & (df['Lancaster'] != 'L')]     
display 

For the 2004 BBMF Schedule, The Url is the Following :-

http://web.archive.org/web/2004102000013...dates.html

But the format is different, to the previous BBMF Year Schedules. Can you look at the Webpage, and suggest to me, what I need to change in my Code, to enable the same type of data, to be presented as in those Schedules ? Your help is much appreciated.

---