Yo! I’ve been down this rabbit hole before lol. For *how to extract data from a table in python*, pandas is king for Excel/CSV, but for HTML, BeautifulSoup is good but kinda slow for big tables. Try `lxml` with pandas—it’s faster and cleaner.
For PDFs, Camelot is my go-to, but it struggles with super messy tables. If that’s the case, I’d recommend PDFPlumber—it’s more flexible and can handle weird layouts better.
Also, if you’re dealing with nested tables, you might need to write some custom logic to parse them. It’s a pain, but sometimes there’s no way around it.
For PDFs, Camelot is my go-to, but it struggles with super messy tables. If that’s the case, I’d recommend PDFPlumber—it’s more flexible and can handle weird layouts better.
Also, if you’re dealing with nested tables, you might need to write some custom logic to parse them. It’s a pain, but sometimes there’s no way around it.