I have a data frame representing IMDb ratings of a selection of tv shows with the following columns:
date, ep_no, episode, show_title, season, rating
I need to select the lowest rated episode of each show, but I am having trouble displaying all of the columns I want.
I can successfully select the correct data using:
df.groupby('show_title')['rating'].min()
But this only displays the show title and the rating of the lowest rated episode for that show.
I need it to display: show_title, ep_no, episode, rating
I have tried various tweaks to the code, from the simple to the complex, but I guess I'm just not experienced enough to crack this particular puzzle right now.
Any ideas?