When Excel Fails: Python to the Rescue
Vložit
- čas přidán 8. 07. 2024
- When Excel fails you, it's Python to the rescue and this short sharp tutorial is no exception. In today's episode, we take a step back to the basics of:
- What to do when working with data with over 1 million rows
- The best place to install Python from
- How to load a large CSV with Python
- How to overcome common errors
- How to count all records in a DataFrame using pandas
- How to count values in a Pandas series
and all in under 7mins!
Anaconda install - www.anaconda.com/products/ind...
Look who's back!
Adam, I'm going to watch this video in detail later.. I saw you posted this and just wanted to quickly say thank you for all the help you've been to me in my Python journey. Love your content my man!
"comes with batteries included"...I love this quote, going to use it every time now
I would love to claim it as my own but I actually borrowed that one from PythonAnywhere! www.pythonanywhere.com/batteries_included/
Omg a new video!! ♥
You are back, with amazing stuff again!!! Welcome!! Try not to disappear so much.
Finally a new video!!!
Where have you been? I have been looking forward to your videos. They have been the best that Ive found for learning Python. Please keep making more.
"I clicked it again i shouldn't have done that...." SUBBED FOR LIFE!
nice to see you back! Awesome tutorial!
Thanks for the new video. !
Thnaks Brother..
Truly loving all of your content. Thank you
Very useful! Looking forward to the rest of the series with this data set. I was actually just doing something similar on a data set in excel where I wanted to add size groupings to companies - i.e., if company A has 5 employees, their group would be "1-10" and if company B has 18 employees, their group would be "10-20" etc. I'd be interested to see you walk through something like that with Python and Pandas. Thanks!
Hi Matt, thanks for the comment and GREAT example use case. Let me put together a tutorial vid on that very example. Stay tuned!
Matt, as promised video is up! Let me know how you go and if you have any more questions!
@@MakeDataUseful Super helpful - this is exactly what I was looking for! I especially appreciated the dual approach with Python and Pandas. I like the Pandas approach as it seems like it's a bit easier to change the bins after the fact if you wanted to. Thank you again for this and all the rest of your videos - looking forward to seeing what's next!
loving the videos... delighted I stumbled across your channel and already implementing some of the techniques in work
Thank you for the positive feedback Eve, much appreciated!
Exactly to the point, thanks
Thanks for the video :)
Very helpful!
Welcome back, Knime equivalent coming up :)
Great to hear Vadim! Looking forward to it!
Awesome vid. Clear, quick, concise and to the point. But you also manage to cover all the bases (as with the possible error strategies). No one else isa doing this so you have to keep going lol. Subbed (already, sorry can't add to your total but you'll get there), liked and thanks a lot.
OMG...long time no seen.
_When excel does not excel...._