text_plain_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_csv('/kaggle/input/videogamesales/vgsales.csv')

df.sample(10)

df.isna().sum()

df.Name.value_counts()

df.Genre.value_counts()

df.Year.value_counts()

df.shape

final = df.dropna()
final.shape

NA_Sales = df.groupby(['Name'])['NA_Sales'].sum().sort_values(ascending=False)

EU_Sales = df.groupby(['Name'])['EU_Sales'].sum().sort_values(ascending=False)

JP_Sales = df.groupby(['Name'])['JP_Sales'].sum().sort_values(ascending=False)

Global_Sales = df.groupby(['Name'])['Global_Sales'].sum().sort_values(ascending=False)

Genre_Sales = df.groupby(['Genre'])['Global_Sales'].sum().sort_values(ascending=False)

Genre_Sales = df.groupby(['Genre'])['Global_Sales'].sum().sort_values(ascending=False)

Publisher = df.groupby(['Publisher'])['Global_Sales'].sum().sort_values(ascending=False)
Publisher.head(5)