ftse.py

# import the panda module - install https://pandas.pydata.org/docs/getting_started/install.html#installing-from-pypi
import pandas as pd

# read the webpage into python
url = r'https://en.wikipedia.org/wiki/FTSE_100_Index?fbclid=IwAR2V6kJA4d6mNqJaouVZ3ule6nuV4YS8tKtJutW98M_wmtQblHtcZOgmmVI'

tables = pd.read_html(url) # Returns list of all tables on page

ftse = (tables[2]) # the third table in the webpage (zero indexed lists in python)
print(ftse) # check we have the data

# save csv to path_or_buf - Change to location
ftse.to_csv(path_or_buf="/home/jon/Desktop/ftse.csv", index=False) 
print("finished")