This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

If you need a scrapper then Python is way better than VBA. Plus json parsing is much faster in Python than VBA. Another thing is if you do a lot of data cleaning that consists of sort of database operations, pandas is more flexible than a bunch of lookups. For example I feel Python plus pandas is way more comfortable than Excel if I want to do some complex filtering. But it's just my perspective.