

In [ ]:

    
%matplotlib inline
from collections import Counter

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 [ ]:

    
video_games = pd.read_json("videogames.json")
video_games.head(5)

How many video games are there?



In [ ]:

Which 5 brand have more video games?



In [ ]:

Is there a video game that has no title? If there is, count of untitled video games



In [ ]:

Remove video games which has no title?



In [ ]:



In [ ]:

How many categories are there in video_games dataframe?



In [ ]:

Find the number of video games by per category



In [ ]:

Which is the most expensive video game?



In [ ]:

Which is the cheapest video game?



In [ ]:

Find all games which has "Age Of" in titles (case insensitive way)



In [ ]:

Calculate the averate price



In [ ]:

All prices are given in dollar and convert it to euro ( let's say 1 dollar is 0.85 euro)



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]: