Many thanks snippsat for your help,
Also for the original and new Python Code, I would also like Dakota with Hurricane, display appearances to show,
I typed the following modification to the Code, aiming to achieve this :-
(df['Spitfire'].str.contains('S', na=True))
for the Original Code, with 'X' in place of the 'S', for the latest Python Code Version.
Now the Dakota with Hurricane Display booking, i.e. in this case for Worthing - Display, that Data Displays, as does the Dakota Spitfire and Hurricane, and Dakota with Spitfire Display Bookings. But also the Solo Dakota Display bookings, which I don't want to display. What do I type to enable, that when Dakota = 'D' or 'X' (in the new Code), and 'Spitfire' = 'NaN' and 'Hurricane' = 'NaN', that Row is not displayed ?
I have almost managed, to sort out what I need to, this is the new code, for the 2004 Url :-
import pandas as pd
import requests
from bs4 import BeautifulSoup
res = requests.get("http://web.archive.org/web/20041020000138/http://www.raf.mod.uk/bbmf/displaydates.html")
soup = BeautifulSoup(res.content,'lxml')
table = soup.find_all('table', align="CENTER")[0]
df = pd.read_html(str(table))
df = df[0]
df = df.rename(columns=df.iloc[0])
df = df.iloc[2:]
df.head(15)
display = df[(df['Location'].str.contains('[a-zA-Z]')) & (df['Dakota'].str.contains('X')) & (df['Spitfire'].str.contains('X', na=True)) & (df['Lancaster'] != 'X')]
display
Any help would be appreciated
Regards
Eddie