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

rape_victim = pd.read_csv('../input/20_Victims_of_rape.csv', na_filter='False')

rape_victim.columns

rape_victim.fillna('')

rape_victim.isnull().sum().sum()

total_rape = rape_victim[rape_victim['Subgroup'] == 'Total Rape Victims']

total_rape.Year = pd.to_datetime(total_rape['Year'], format='%Y').dt.strftime('%Y')
total_rape['Total_Rape_per_Year'] = total_rape.groupby('Year')['Victims_of_Rape_Total'].transform('sum')
plot_total_rape = total_rape.drop_duplicates('Year', keep='first', inplace=False)
plot_total_rape

total_rape