Hey! For extracting data from tables in Python, pandas is definitely a solid choice for Excel/CSV files. If you're dealing with messy or nested tables, you might wanna check out `pd.read_html()` for HTML tables—it’s super handy and can handle some complexity.
For PDFs, Camelot is great for structured tables, but if the formatting is all over the place, try PyPDF2 combined with some regex magic. It’s a bit more manual but works for tricky cases.
Also, Tabula is another tool worth looking into for PDFs—it’s not Python-based, but you can export the data and then work with it in Python.
Good luck with your project!
For PDFs, Camelot is great for structured tables, but if the formatting is all over the place, try PyPDF2 combined with some regex magic. It’s a bit more manual but works for tricky cases.
Also, Tabula is another tool worth looking into for PDFs—it’s not Python-based, but you can export the data and then work with it in Python.
Good luck with your project!