In [17]:
import math
import matplotlib.pyplot as plt
def GetRating(positiveVotes, negativeVotes):
totalVotes = positiveVotes + negativeVotes
average = positiveVotes / totalVotes
score = average - (average - 0.5) * 2 ** -math.log10(totalVotes + 1)
return score * 100
# Calculate the rating column using apply()
activision_df['Rating'] = activision_df.apply(lambda row: GetRating(row['positive_ratings'], row['negative_ratings']), axis=1)
# Reset the index
activision_df = activision_df.reset_index(drop=True)
# Set the figure size and DPI
plt.figure(figsize=(10, 6), dpi=100)
# Plot the ratings with custom styling options
plt.bar(activision_df.index, activision_df['Rating'], color='skyblue', edgecolor='black')
# Add labels and title
plt.ylabel('Rating')
plt.title('Game Ratings')
# Set the y-axis limits from 0 to 100
plt.ylim(0, 100)
# Add grid lines
plt.grid(axis='y', linestyle='--')
# Customize tick labels
plt.xticks(fontsize=8)
plt.yticks(fontsize=8)
# Remove the top and right spines
plt.gca().spines['top'].set_visible(False)
plt.gca().spines['right'].set_visible(False)
# Show the plot
plt.show()
C:\Users\tuvsh\AppData\Local\Temp/ipykernel_17184/2189189376.py:11: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy activision_df['Rating'] = activision_df.apply(lambda row: GetRating(row['positive_ratings'], row['negative_ratings']), axis=1)
