image_output_3.png image_output_2.png image_output_1.png
import pandas as pd

nRecords = 200000
snRecords = 1000
maindf = pd.read_csv('../input/database.csv')

maindf.drop(['Year', 'Month', 'Incident', 'City', 'Agency Name', 'Agency Type', 'Record Source', 'Agency Name'], axis=1, inplace=True)
df = maindf[maindf['Record ID'] < nRecords]
sdf = df[(maindf['Record ID'] < snRecords) & df['Victim Count'] > 0]