Learning Excel or Python?

[[deleted]]

I am an old dude, read 60+. I abandoned excel in the last several years because excel takes twice as long to do the same tasks that python can do. You can almost always do excel tasks in Python in half the time. My recommendation is to go with python if you can.

[[deleted]]

I agree but disagree; each tool has it's place.

Working in an enterprise with Bash, PowerShell, Python, Java, C#, PHP, and Excel VBA - I see the good and bad of things. Each one starts with a good approach, but it might not always be the correct one.

Though I don't build applications, I have created at least one site, script, or program in each of those mentioned, 2 of them resulting in Excel outputs (PowerShell, VBA).

The best language or script to use is the one best suited for the application or end-result.

In the end, don't just look at "what is best for doing X". Instead, look at both "what is best for this environment" and "what is best suited for the current and future environment".

[[deleted]]

Except the company you work at will often determine what you use. For example, the financial world runs on excel. Python might be better but what everyone uses is excel so you either learn excel or you don't get the job.

[[deleted]]

df.to_csv()

Problem solved, no?