1. Analyzed the US Mass Shootings data for the past 50 years from the US.
2. Tried to see trends of the mass shootings in all these years.
3. Tried finding the corelations of various attributes.
4. Visualizations available at : https://public.tableau.com/profile/tejbir.singh.bhatia#!/vizhome/USAmassshootings/Finaldashboard
5. Skillset used : (i) Data analysis- Pandas for python, Jupyter notebook, iPython notebook, excel (ii) Visualization- Tableau, Pandas

• There is a timeline on the tableau dashboard (https://us-east-1.online.tableau.com/t/tejbirsworkspace/views/USMassshootings/Finaldashboard?:embed=y&:showAppBanner=false&:showShareOptions=true&:display_count=no&:showVizHome=no#3) that gives us the number of injured and killed people over the years. It is clearly seen that from 2010 onwards, there is a significant rise in the number of people affected by these activities. The deadliest years have been 2015 with 226 and 2014 with 193 reported dead people.

• Visualized mass shootings on US map- https://us-east-1.online.tableau.com/#/site/tejbirsworkspace/views/USMassshootings/Locationwisefatalities?:iid=10

From the map we can see that the states on east coast generally seem to be more affected by such attacks

• For the known values of gender and race, there is no real correlation. The most interesting correlation coefficient is 0.19 for gender = male and race = black

• For the known values of gender and mental health issues, the most interesting correlation coefficient is 0.16 for gender = male and mental health issues = yes

• For the known values of race and mental health issues, the most interesting correlation coefficient is 0.31 for race = white and mental health issues = yes

•The deadliest day is Sunday which is closely followed by Wednesday. 250+ people lost their lives on each of these days. The deadliest week is 23 with close to 80 killings being reported. This is closely followed by week 16 and 39 which reported 70 killings. The deadliest month is February with close to 175 reported dead in more than 50 different shootings. October and December also account for more than 150 killings each that take up 3rd and 2nd ranking in deadly months list.

• Of the known shooter mental conditions, more than 100 shooters had some mental health issue with them. These people ended up taking more than 600 lives. Most eye catching relevation has been the corelation of shooters with race = white and mental illness = yes with a coefficient of ~0.32

• More than 140 shooters have belonged to the white race.They killed almost 800 people (> 50% of total killings).

• Men have been involved in more than 90% of the total killings recorded killing more than 1200 people in the process.