Cacher is the code snippet organizer for pro developers

# note: these are methods of finding specific data from tables
# What was the highest scoring movie in 1996?

data[data['year'] == 1996].sort_values(by='rating', ascending=False).head()

# In what year was the highest rated movie of all time made?

data[data['rating'] == data['rating'].max()]
​
# What five movies have the most votes ever?

data.sort_values(by='votes', ascending=False).head()​

# What year in the 1960s had the highest average movie rating?

data[(data['year'] >= 1960) & (data['year'] <= 1970)].groupby(data['year'])['rating'].me