Merge/Join .csv (合并csv文件)
import pandas as pd
ratings = pd.read_csv('C:/Users/Can/Desktop/RS Project/ratings.csv')
movies= pd.read_csv('C:/Users/Can/Desktop/RS Project/movies.csv')
ratings.csv: users’ rating of movies
movies.csv: movies description
Merge合并
把两个csv文件合并,显示出每位用户给电影的打分以及电影详情。
data = pd.merge(movies, ratings, on=['movieId']