Jun-23-2019, 08:58 PM
(This post was last modified: Jun-24-2019, 08:37 AM by eddywinch82.)
Thanks for your help snippsat,
This is my current working Code:-
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.
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')] displayFor 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.