In [ ]:
%matplotlib inline
import pandas as pd

In [ ]:
from IPython.core.display import HTML
css = open('table.css').read() + open('notebook.css').read()
HTML('<style>{}</style>'.format(css))

In [ ]:
ratings = pd.read_csv("ratings.csv", encoding="utf-8")
ratings.head(5)

How many ratings are there in the ratings dataframe?


In [ ]:

How many products have at least one ratings?


In [ ]:

Is there any duplicate ratings? If it is find and list them


In [ ]:

How many users have at least one ratings?


In [ ]:

Find the first rating


In [ ]:

Find the last ratings


In [ ]:

Make timestamp field datetime typed


In [ ]:

Draw bar chart of ratings by year


In [ ]:

Count there ratings by month


In [ ]:

On which days are there most ratings


In [ ]:

Calculate the mean value of ratings


In [ ]:

Calculate the mean values of ratings by userID


In [ ]:

Calculate the mean values of ratings by productID


In [ ]:

Which 5 user have the highest mean rating value?


In [ ]:

Which 5 products have the highest mean rating valye?


In [ ]:

Which product has the lowest mean ratings?


In [ ]:

Which product has the lowest mean ratings?


In [ ]:

How many user are there that have at least one rating for all years?


In [ ]:

How many products are there that have at least one rating for all years?


In [ ]:

What is the ratings average of users


In [ ]:

What is the ratings average of products


In [ ]:

How many ratings are there before 2000?


In [ ]:

How many ratings are there after 2000?


In [ ]:

How many ratings are there after 2000 and before 2015?


In [ ]:

What is the ratings count for years


In [ ]:

What are the mean ratings for each year?


In [ ]:

How many ratings have user that has id A00010181745VTMHSO9TO


In [ ]:

How many ratings have product that has id 0439339987


In [ ]:

How many ratings are there that exactly given in 24.08.2013


In [ ]:

Draw bar chart from count of ratings in ascending order?


In [ ]:

Draw bar chart from percentage of ratings in ascending order?


In [ ]:

What is the percentage of 3.0 ratings


In [ ]:

Which rating value is the most common in dataset?


In [ ]:

Which rating value is the least common in dataset?


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]: