import pandas as pd
import numpy as np
num_info=pd.read_csv("D:/test/fandango_scores.csv")
num_info.head(1)
FILM | RottenTomatoes | RottenTomatoes_User | Metacritic | Metacritic_User | IMDB | Fandango_Stars | Fandango_Ratingvalue | RT_norm | RT_user_norm | … | IMDB_norm | RT_norm_round | RT_user_norm_round | Metacritic_norm_round | Metacritic_user_norm_round | IMDB_norm_round | Metacritic_user_vote_count | IMDB_user_vote_count | Fandango_votes | Fandango_Difference | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Avengers: Age of Ultron (2015) | 74 | 86 | 66 | 7.1 | 7.8 | 5.0 | 4.5 | 3.7 | 4.3 | … | 3.9 | 3.5 | 4.5 | 3.5 | 3.5 | 4.0 | 1330 | 271107 | 14846 | 0.5 |
1 rows × 22 columns
import matplotlib.pyplot as plt
from numpy import arange
cols=["Fandango_Ratingvalue","RT_user_norm","IMDB_norm","Fandango_Stars"]
fim_info=num_info[cols]
bar_height = fim_info.ix[0,cols].values #取出对应的列值
bar_position = arange(4)+0.75
print (bar_height)
print (bar_position)
[ 4.5 4.3 3.9 5. ]
[ 0.75 1.75 2.75 3.75]
fig,ax=plt.subplots()
ax.bar(bar_position,bar_height,0.5) #0.5代表条形图有多粗
plt.show()
fig,ax=plt.subplots()
tick_position=range(1,5)
ax.bar(bar_position,bar_height,0.5) #0.5代表条形图有多粗,如果执行ax.hbar可以得到一种横着的图,其余不变
ax.set_xticks(tick_position) #指定x轴的范围
ax.set_xticklabels(cols,rotation=90) #指定x轴每个值的标签,并旋转90度
ax.set_xlabel("Rating Source")
ax.set_ylabel("Average Rating")
ax.set_title("film user rating")
plt.show()
fig,ax=plt.subplots()
ax.scatter(fim_info["Fandango_Ratingvalue"],fim_info["IMDB_norm"])
plt.show()
fig=plt.figure(figsize=(5,10))
ax1=fig.add_subplot(2,1,1)
ax2=fig.add_subplot(2,1,2)
ax1.scatter(fim_info["Fandango_Ratingvalue"],fim_info["IMDB_norm"])
ax2.scatter(fim_info["RT_user_norm"],fim_info["Fandango_Stars"])
plt.show()