In [0]:

    

import pandas as pd


    

In [0]:

    

import io


    

In [0]:

    

import requests


    

In [0]:

    

import os


    

In [0]:

    

from google.colab import files


    

In [268]:

    

uploaded = files.upload()


    

    






     
     

      Upload widget is only available when the cell has been executed in the
      current browser session. Please rerun this cell to enable.
      
       






    




Saving AppleStore.csv to AppleStore (1).csv

In [0]:

    

file = uploaded['AppleStore.csv']


    

In [0]:

    

def readAppleStoreApi(filename, path_to_save):
  data = pd.read_csv(io.BytesIO(filename))
  data.sort_values(["rating_count_tot"], axis=0, ascending=False, inplace=True)
  data = data.loc[ (data['prime_genre'] == "Music") | (data['prime_genre'] == "Book") | (data['prime_genre'] == "News")]
  data = data[['id','track_name', 'rating_count_tot','size_bytes', 'price', 'prime_genre']]
  data = data.nlargest(10, ['rating_count_tot'])
  data.columns = [['id','track_name', 'n_citacoes','size_bytes', 'price', 'prime_genre']]
  return data.to_csv (os.path.join(path_to_save,r'apple_store.csv'), index = None, header=True)


    

In [0]:

    

result_cvs = readAppleStoreApi(file, '/')