Excel vs. Python with Pandas - 5 Transformations You Need to Know | Python Tutorial 

Thank you

Thanks

My pleasure

Thats a great outlook. Excel is powerful but in combination with other tools you just build your skill set with what you can do with data

i can add it to my list

That would be a good comparison!

Thanks!

You’re probably right as I’m not an excel enthusiast now a day. What I’m also trying to teach people is excel is a contained eco system that is difficult to scale in the field of data science. Also there is a high dependency on the laptop you are using. Python is far more scalable, connects with 1000s libraries to do analytics and can be run on a remote machine so users aren’t limited by their device. Python also connects to backend, front end development in additional to the analytical capabilities. All three which scale and connect well with python as a language. Excel again is more self contained for analysis with the tools and ecosystem provided by Microsoft

@@SATSifaction Love the perspective you provide! I've loved my python journey so far and am learning day to day. Thanks for your words and your videos, they've helped immensely

Your are some how right, MS is doing a good job with Excel +PowerBI etc. But in many, many ways they can't compete with Python: say scalability, automation posibilities etc.

@Oscar Martinez you’ve got to look into automation tools in Excel, you’re missing out. There’s data wrangling in Python and there’s Power Query, Power Pivot, Dax, M Code etc in Excel/Power BI. Just had a conversation w someone about this. Both Excel AND Power BI have the capability to connect to ANY data source, clean, trim, prep data in any way you’d like. Steps are automatically documented (aka stored procedures) and have things refresh at designated intervals (automation) for further analysis. Where Power BI goes beyond the capabilities of excel is: >interactivity< (w drill throughs on visualizations, excel don’t do that well), >row level security< on reports you furnish and finally the ability to see already developed reports on >any devicedifferent< data warehouses, websites (web scraping as it’s known) you want to analyze over time, prep your data (one time) and you’re good to move straight to the analyzing after hitting refresh every other week/month/day/etc. You can make canned reports and disseminate however you please. I will say I still have much to learn on python, it’s super popular and used in pretty much all FANG companies so I’m leaning that way pretty hard. It’s my NFL (new found love)

One of the frustrating things about power query/Pivot is that you have M and DAX, two totally different languages, not joined up thinking on the part of MS.

In 7:59 he says about scientific notation, which in this case is your 'e' issue. Just add that code and it will fix it

You drop or replace Nan values

The default is average

@@SATSifaction and how to change it to other aggregation?

Thanks for the feedback. Will definitely do so in future.

@@SATSifaction Thanks, another idea is if you could reduce the space that Jupyter wastes at the top of the screen. These two things should open your videos to the mobile audience.