Data Modeling

Transcript

1. VISUALIZING CRIME IN INDIA Information Visualization II Week 1
2. Data Model Tables on Case Incidances - Under state & Year wise - Under crime & Year wise - Under crime & District wise for 2012 - Under state and & Categorized as Women, Children, Jeveniles Typical Columns - States : Andhra Pradesh, Karnataka - Districts : Visakhapatnam, Siang, Bellary, Kolar - Years : 2007 - 2012 - Crime : Murder, Rape, Dacoity, Riots - Classifications : Women, Children, Juveniles Sources MOPSI 2012 report by NCRB
7. Architecture - CSV for data - Python and Pandas for calculations and filtering - D3 for drawing Visualization - Overview (as in Print format) - Explore occurance of crime acrosss districts - Analyse trends across states (year wise) - Hint the user on, how safe a particular place is ?