Python vs Excel: Converting Python commands into simple Excel functions

Beppe's Data World 2024-07-25

Views 38

Python,Excel,R etc.....let's be honest, managing different tools it may be mind consuming.
I don't know you, but I ALWAYS have to get back to the basics for remembering inputs and commands while switching from one library to another....imagine when doing it with different tools!
But don't worry, I started to make the first step and I'll show you in brief how to get the same results by using different commands in Python and Excel.

So, let's get it started....once again!

⌛------------Timestamp-------------⌛
00:00 - Intro
01:06 - 1)Python FILTERING data
03:05 - 1)FILTER in Excel
05:30 - 2)Python SORTING data
06:27 - 2)Excel SORT
07:31 - 3)Python GROUPBY + SUM
09:20 - 3)Excel SUMIF
10:59 - 4)Python GROUPBY + SUM (multiple criteria)
12:45 - 4)Excel SUMIF(S)
14:09 - Bonus: How to use the same functions in Excel with TABLES
16:45 - Ending

--------LINKS---------
Github files: https://github.com/beppedataworld/Python-vs-Excel

------------Credits-----------
Music track:
- "80x Deep Synthwave" by SigmaMusicArt: https:// pixabay.com/it/users/sigmamusicart-36860929/

- Brick Neon wall: https://www.freepik.com

Share This Video


Download

  
Report form