There is a Pandas dataframe: id title rating 0 Pulp Fiction (1994) 5.0 1 Three Colors: Red (Trois couleurs: Rouge) (1994) 3.5 2 Three Colors: Blue (Trois couleurs: Bleu) (1993) 5.0 3 Underground (1995) 5.0 4 Singin' in the Rain (1952) 3.5 5 Dirty Dancing (1987) 4.0 6 Delicatessen (1991) 3.5 7 Ran (1985) 3.5 8 Seventh Seal, The (Sjunde inseglet, Det) (1957) 5.0 9 Bridge on the River Kwai, The (1957) 4.0 both titles and ratings in this table are not unique, they are duplicated many times both titles and ratings in this table are not unique, they are duplicated many times Write a function that creates a new dataframe with two columns: - In the first column it groups the unique titles of the movies - In the 2nd column displays their average rating
import pandas as pd ratings = pd.read_csv('ratings.csv') filtered_ratings = ratings[['title', 'rating']] filtered_ratings = filtered_ratings.groupby('title').mean() filtered_ratings