import pandas as pd
from pandas import Series
fandango = pd.read_csv('fandango_score_comparison.csv')
rt_critics = Series(fandango['RottenTomatoes'].values, index=fandango['FILM'])print(rt_critics[0:3])
rt_users = Series(fandango['RottenTomatoes_User'].values, index=fandango['FILM'])print(rt_users[0:3])
rt_mean =(rt_critics + rt_users)/2print(rt_mean[0:3])
set_index
import pandas as pd
from pandas import Series
fandango = pd.read_csv('fandango_score_comparison.csv')# set_index 使用一个或多个现有列设置DataFrame索引(行标签)。默认情况下,生成一个新对象。# drop : boolean, default True 删除要用作新索引的列
fandango_films = fandango.set_index('FILM', drop=False)print(fandango_films[0:3])
当选择多个行时,返回一个DataFrame, 但当选择单个行时,返回的是一个Series对象
import pandas as pd
fandango = pd.read_csv('fandango_score_comparison.csv')
fandango_films = fandango.set_index('FILM', drop=False)# 使用括号表示法或loc[]进行切片
sub_films = fandango_films["Avengers: Age of Ultron (2015)":"Ant-Man (2015)"]print(sub_films)print(type(sub_films))print("----------------------------------------------------")
sub_films = fandango_films.loc["Avengers: Age of Ultron (2015)":"Ant-Man (2015)"]print(sub_films)print(type(sub_films))print("----------------------------------------------------")# 查找特定的 movie
film = fandango_films.loc['Kumiko, The Treasure Hunter (2015)']print(type(film))print("----------------------------------------------------")# 查找特定的 movie 列表
movies =['Kumiko, The Treasure Hunter (2015)','Do You Believe? (2015)']print(fandango_films.loc[movies])print(type(fandango_films.loc[movies]))# 当选择多个行时,返回一个DataFrame,# 但当选择单个行时,返回的是一个Series对象