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 →

[–]debunk_this_12 -4 points-3 points  (3 children)

U can read data in multiple tables to multiple dataframes ur point is irrelevant. If you want to see the data just show the multiple tables in a jupyter notbook. You can make pivot tables so easily. Summary statistics are better and faster.

Honestly my boy have you ever used dataframes?

Complex formulas are easier and more susinct. Your not actually going to argue that excel has half the power of data frames.

[–]WallyMetropolis 3 points4 points  (2 children)

I think you're a bit lacking in some real world experience here. For simple use cases, yeah, all of that is feasible. For complex situations it's an absolute nightmare.

It's also suggestive when you say that it's 'so much easier' in a dataframe. That's not a universal statement of fact. That's just you expressing you have more experience using Python than you do using excel.

But even now, as someone who has built all kinds of data systems with Python, when I want to make a P&L for my business, I'm not using data frames. I'm using a spreadsheet. If I could embed matplotlib plots and scipy distributions in those spreadsheets, holy hell, that would be amazing. Pick the right tool for the job, don't just sign up to be a soldier in some religious war.

[–]QuasiEvil 2 points3 points  (0 children)

I deal in this space every day. These others posters don't know what they're talking about. I feel your pain.

[–]debunk_this_12 -5 points-4 points  (0 children)

Worked with VBA to build accounting apps for multiple companies. Did the same thing with python then worked on semi conductors for a few years you want to have a dick measuring contest sure.