derekbanas/pandas-tutorial

This is the cheat sheet Jupyter Notebook I made for my Pandas Learn in One Video Tutorial. I basically condensed the Pandas API down into this one cheat sheet with hundreds of examples. I hope you find it useful.

pandas-tutorial's Issues

Issue with the "# Get the product with the highest profit" section

Hi Derek,
Really like your videos! I think I noticed an error in this one.

for the line:
# Get the product with the highest profit
cs_df[['Profit','Product ID']].max(axis=0)

I think this is actually returning the max of each row, not the product with the highest profit. If you look at the product ID of the system with the highest output the answer should actually be GT13-0024.The profit of the answer Q526FA is only 143.09.

A way I found to get the correct answer is
cs_df[cs_df['Profit'] == cs_df['Profit'].max()][['Profit','Product ID']]
Again thanks for the videos, they are really helpfull!