Wow, thanks so much, everyone! This is super helpful. I’ve been playing around with PDFPlumber based on your suggestions, and it’s way better than PyPDF2 for my messy tables. Still figuring out the nested HTML tables, but I’ll give `lxml` a shot—didn’t even know about that one!
Quick follow-up: anyone have tips on handling tables with merged cells in Excel? Pandas seems to struggle with those, and I’m not sure how to clean them up.
Thanks again, y’all are lifesavers!
Quick follow-up: anyone have tips on handling tables with merged cells in Excel? Pandas seems to struggle with those, and I’m not sure how to clean them up.
Thanks again, y’all are lifesavers!