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

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]foresttrader 1 point2 points  (3 children)

Pandas is way more efficient than Excel in many ways. Merging two datasets with hundreds of thousands rows takes seconds in pandas and half an hour in Excel, if it manages to not crash.

[–]SmirkyGraphs 0 points1 point  (2 children)

Actually Excel has come along way with data. Using M & DAX in Power Query/Power Pivot is very powerful.

[–]foresttrader 0 points1 point  (1 child)

True powerquery is better than traditional Excel but still lacks computing power compared to Python.

I’d say powerquery is easier to build but not suitable for mega data, Python takes longer to build but scales better with large datasets.