I need to read with python the table from this URL, filtering the historical data from 2015 to 2021. When you open the URL data is from 2022 to 2022, so I need to make a filter for bringing the years that i need.
https://web.bevsa.com.uy/CurvasVectorPrecios/CurvasIndices/Historico.aspx?I=CUI
I have tried to use requests like this:
import requests
url = 'https://web.bevsa.com.uy/CurvasVectorPrecios/CurvasIndices/Historico.aspx?I=CUI'
html = requests.get(url).content
df_list = pd.read_html(html)
But it brings this error: ImportError: lxml not found, please install it
If someone know how can i get the table with python, i will appreciate it a lot!