- Options selected: {'Country': 'UK', 'Report type': 'Sales and stock', 'Product subgroup': 'All product subgroups', 'Product': 'All products', 'View': 'TPNB – Total sales', 'Time period': 'Last full week (Wk 08)'}
- ValueError: No tables found
- File <command-2177609803612567>, line 48
- 46 soup = BeautifulSoup(response.text, 'html.parser')
- 47 table = soup.find('table')
- ---> 48 df = pd.read_html(str(table))[0]
- 49 # Construct file name based on selected options
- 50 file_name = f"{country}_{report_type}_{product}_{view}_{time_period}.xlsx"
- File /databricks/python/lib/python3.11/site-packages/pandas/io/html.py:613, in _BeautifulSoupHtml5LibFrameParser._parse_tables(self, doc, match, attrs)
- 610 tables = doc.find_all(element_name, attrs=attrs)
- 612 if not tables:
- --> 613 raise ValueError("No tables found")
- 615 result = []
- 616 unique_tables = set()
[text] b
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
Editor
You can edit this paste and save as new: