Identity crime rising trend

No class this week
The issue i am working on this weak is finishing of my work on Identity based political disputes.
They are on a upwards trend and causing a serious issue for the society. Also its biggest rise was during elections, which might show some correlation to elections. with no concrete proof to back it up

Tring to generate Indian map

I used tableau to generate a Indian map, use different shades for high, moderate and low cases of disputes. Tried to generate another map using GDP has the color shade for state and splitting the IDs as rural and urban to highlight them on the map. But due to problems in splitting the data into urban and rural based fuzzy matching the place name with towns and cities(India) data i found online has made me quit that plan.
started working this new idea about Different types of Identity based violence, why its involved in political based conflicts and its connections

Tried CHI-Square

I ran chi-sqaure as told by professor and got some values like:

Chi-Square Test: Region vs Political Violence
Chi² Statistic : 2228.05
Degrees of Freedom : 5
p-value : 0.00000

this sows a strong association with the regions and hence I am confirm that political violence varies a lot based on regions, i shall try to plot it on a map for easier visualization. But chi sqaure compliments the notion.

Working on MYSQL to adjust right Dataset

We were trying to get right correlation between GDP, literacy , ruling parties, and segregating locations to rural, village.
I was using MySQL to work on some separation, trying to find keywords and stuff. later used python to try divide it into rural and urban events. Just noticed some black magic and witch hunting cases in political violence. Trying to find how its related to it.