text_plain_output_1.png
import pandas as pd

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

data = pd.read_csv('/kaggle/input/videogamesales/vgsales.csv', index_col='Rank')

data.shape

data.dtypes

data.isnull().sum()

duplicate_rows_data = data[data.duplicated()]

data.drop_duplicates()

JAPAN_data = data.sort_values(by=['JP_Sales', 'Genre'], ascending=False)

JAPAN_data = JAPAN_data.reset_index()

JAPAN_data.drop(['Rank', 'Name', 'Platform', 'Year', 'Publisher', 'Global_Sales'], axis=1)