text_html_output_1.png
from sklearn.utils import shuffle

import numpy as np

import pandas as pd

data_file = '../input/Amazon_Unlocked_Mobile.csv'
data = pd.read_csv(data_file)

data_df = pd.DataFrame(data)

data_df = shuffle(data_df)

data_df = data_df.dropna()

info = pd.pivot_table(data_df, index=['Brand Name'], values=['Rating', 'Review Votes'], columns=[], aggfunc=[np.sum, np.mean], fill_value=0)
info = info.sort_values(by=('sum', 'Rating'), ascending=False)
info.head(10)