python 数据分析案例——电影评分分析

import pandas as pd

pd.options.display.max_rows=100
unames = ['user_id', 'gender', 'age', 'occupation', 'zip']
users=pd.read_table('D://01//users.dat',sep='::',header=None,names=unames,engine='python')
users
rnames = ['user_id', 'movie_id', 'rating', 'timestamp']
ratings = pd.read_table('D://01//ratings.dat', sep='::',
                        header=None, names=rnames)
ratings
mnames = ['movie_id', 'title', 'genres']
movies = pd.read_table('D://01//movies.dat', sep='::',
                       header=None, names=mnames)
users[:5]
ratings[:5]
movies[:5]


data=pd.merge(pd.merge(ratings,users),movies)
data
data.iloc[0]
mean_ratings=data.pivot_table('rating',index='title',
                                columns='gender',