YouTube Channel Recommendations for people who like Derrick Sherrill (Click a channel's button below to go to their page on Channel Galaxy and find more new YouTube suggestions)
About Derrick Sherrill
None
Recent Videos from Derrick Sherrill
Level Up Python Pandas GroupBy | Five Minute Python Scripts | Subscriber Request
Thanks for your suggestions keep them coming!!
0:00 introduction
0:12 viewing the data
0:59 reading in data
1:59 groupby
4:24 writing new workbook
5:17 Conditional Index
Data used in this video:
https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/Python%20Pandas/Level%20Up%20Grou… Python Pandas Tutorial ( Basics ) - Start Replacing Excel for Python 2021 Series
In this one we'll take a look at how we can start using pandas to do simple tasks
Spreadsheet to work alongside me -- https://www.kaggle.com/tunguz/gold-prices?select=monthly_csv.csv
Kite helps fund the channel, thanks for checking them out and supporting me -- https://www.kite.com/get-kite/?utm… Replace Excel If Function with Python Pandas
Simple conditional logic in excel can get very complex whenever you start having multiple conditionals. With only one line to include your conditionals, or having to write VBA, Excel isn't as user friendly for these operations.
Sample Data
https://github.com/Derrick-Sherrill/DerrickSherrill.com/bl…
Channel Galaxy 
