Hello,
I have three types of dataset.
Dataset 1 has yearly state district level of total illegal acts in a month.
Dataset 2 has the type of illegal activity plotted yearly against which state it occurs in.
[CODE]
Dataset3 shows the type of illegal activity yearly against the month it was committed in.
My question is how will I use the three datasets , to get the kind of illegal activity committed per month in a particular district in a particular state?
as per the format below.
I have three types of dataset.
Dataset 1 has yearly state district level of total illegal acts in a month.
Code:
Code:* Example generated by -dataex-. To install: ssc install dataex clear input int year str3 state str4 DISTID str39 District int(Jan Feb Apr May Jul Aug Sep Oct Nov Dec Total) 2000 "A&N" "1" "Nicobar" 0 0 0 0 0 1 0 0 0 0 1 2000 "AP" "1" "Anantapur" 1 2 0 0 0 0 0 1 0 0 4 2000 "AP" "2" "Chittoor district" 0 0 1 0 0 0 0 0 0 1 2 2000 "AP" "3" "East Godavari" 0 1 0 0 0 0 1 0 0 0 2 2000 "AP" "4" "Guntur" 0 0 0 2 0 0 0 0 1 1 4 2000 "AP" "5" "Kadapa" 1 0 0 0 0 0 0 0 0 1 2 2000 "AP" "6" "Krishna" 1 0 1 0 0 0 0 0 0 0 2 2000 "AP" "7" "Kurnool" 0 1 0 0 0 0 0 0 0 0 1 2000 "AP" "8" "Nellore" 0 0 0 0 1 1 1 0 0 0 3 2000 "AP" "9" "Prakasam" 0 0 2 1 0 0 1 0 0 0 4 2000 "AP" "10" "Srikakulam" 0 0 0 0 0 0 0 1 0 0 1 2000 "AP" "11" "Visakhapatnam" 2 0 2 0 1 1 1 0 0 0 9 2000 "AP" "12" "West Godavari" 0 0 0 0 3 0 0 0 0 2 5 2000 "AS" "1" "Cachar" 0 0 1 0 0 0 0 0 0 0 1 2000 "AS" "2" "Dhubri" 0 0 0 0 0 1 0 0 0 0 1 2000 "AS" "3" "Hailakandi" 1 0 1 0 0 0 0 0 0 1 3 2000 "AS" "4" "Karimganj" 0 0 0 2 1 0 0 0 0 0 3 2000 "AS" "5" "Kokrajhar" 0 0 0 0 0 0 0 2 0 0 2 2000 "AS" "6" "Morigaon" 1 0 0 0 0 0 0 0 0 0 1 2000 "AS" "7" "Tinsukia" 0 0 0 0 0 0 0 1 0 0 1 2000 "BR" "1" "Araria" 0 0 0 0 3 1 1 1 0 0 6 2000 "BR" "2" "Aurangabad" 1 0 0 0 1 0 0 0 0 0 2 2000 "BR" "3" "Banka" 0 0 0 2 0 0 2 0 0 0 4 2000 "BR" "4" "Begusarai" 6 2 1 0 5 5 2 3 2 0 29 2000 "BR" "5" "Bhagalpur" 0 0 1 0 0 5 0 1 0 0 10 2000 "BR" "6" "Bhojpur" 1 0 1 0 1 0 0 0 1 1 7 2000 "BR" "7" "Buxar" 0 2 0 0 1 2 1 1 1 2 10 2000 "BR" "8" "Darbhanga" 3 3 0 2 1 2 3 4 1 0 21 2000 "BR" "9" "East Champaran" 1 2 1 0 1 3 0 0 0 0 8 2000 "BR" "10" "Gaya" 3 1 2 4 2 2 3 1 0 0 20 2000 "BR" "11" "Gopalganj" 1 0 0 0 1 1 0 0 0 0 3 2000 "BR" "12" "Jamui" 0 0 1 1 1 1 1 0 0 0 5 2000 "BR" "13" "Jehanabad" 1 0 0 0 0 0 1 0 0 0 2 2000 "BR" "14" "Katihar" 0 2 2 1 4 2 1 1 2 0 21 2000 "BR" "15" "Khagaria" 0 0 0 0 0 0 0 0 0 0 1 2000 "BR" "16" "Kishanganj" 0 0 0 0 1 0 0 0 1 0 2 2000 "BR" "17" "Madhepura" 0 0 0 1 0 0 1 0 1 1 5 2000 "BR" "18" "Madhubani" 0 0 0 1 3 2 4 0 1 3 15 2000 "BR" "19" "Munger" 0 0 0 3 1 2 1 2 0 0 11 2000 "BR" "20" "Muzaffarpur" 0 0 2 3 1 4 2 1 0 0 14 2000 "BR" "21" "Nalanda" 1 0 0 0 0 4 2 1 1 1 10 2000 "BR" "22" "Nawada" 1 1 0 0 0 5 1 0 0 0 10 2000 "BR" "23" "Patna" 7 3 1 4 3 6 2 4 0 3 35 2000 "BR" "24" "Purnea" 1 0 1 1 2 1 2 3 0 1 13 2000 "BR" "25" "Rohtas" 0 1 0 0 0 0 0 1 0 0 4 2000 "BR" "26" "Saharsa" 1 0 1 0 0 0 0 1 0 0 4 2000 "BR" "27" "Samastipur" 0 0 1 4 4 8 0 3 2 0 22 2000 "BR" "28" "Saran" 0 0 0 1 0 2 0 4 0 0 8 2000 "BR" "29" "Sheikhpura" 0 0 0 0 1 0 0 0 0 0 2 2000 "BR" "30" "Sitamadhi" 0 2 1 0 0 2 1 2 0 0 8 2000 "BR" "31" "Siwan" 1 0 0 0 2 1 0 2 1 0 7 2000 "BR" "32" "Supaul" 1 0 1 0 1 3 0 0 0 0 6 2000 "BR" "33" "Vaishali" 0 1 0 1 1 2 1 0 0 0 8 2000 "BR" "34" "West Champaran" 0 0 1 3 1 0 2 0 1 0 9 2000 "CH" "1" "Chandigarh" 0 1 0 1 2 1 1 1 1 2 10 2000 "CT" "1" "Bilaspur" 0 0 1 0 0 0 0 0 0 0 1 2000 "CT" "2" "Durg" 0 0 0 0 0 1 1 1 0 2 5 2000 "CT" "3" "Janjgir-Champa" 0 0 0 0 1 1 0 0 0 0 2 2000 "CT" "4" "Jashpur" 1 0 0 0 0 0 0 0 0 0 1 2000 "CT" "5" "Korba" 0 0 0 0 0 0 0 1 0 0 2 2000 "CT" "6" "Mahasamund" 0 0 0 0 0 1 0 0 0 1 2 2000 "CT" "7" "Raigarh" 0 0 0 0 0 0 1 0 0 0 1 2000 "CT" "8" "Raipur" 0 0 0 1 0 3 2 0 0 0 6 2000 "CT" "9" "Surguja" 0 0 0 0 4 0 0 0 0 0 5 2000 "DL" "1" "Delhi" 49 49 67 100 85 75 87 55 32 26 737 2000 "DL" "2" "New Delhi" 6 8 9 12 16 27 17 23 5 12 161 2000 "DL" "3" "South Delhi" 0 0 1 0 0 0 0 0 0 0 1 2000 "GA" "1" "North Goa" 0 0 1 1 1 3 0 0 0 0 7 2000 "GA" "2" "South Goa" 0 0 0 0 0 1 0 1 0 0 2 2000 "GJ" "1" "Ahmedabad" 0 0 0 0 1 1 0 0 0 0 2 2000 "GJ" "2" "Bhavnagar" 0 0 0 1 0 0 0 0 0 0 2 2000 "GJ" "3" "Dahod" 0 0 0 0 0 0 0 1 0 1 2 2000 "GJ" "4" "Kutch" 0 0 0 0 1 0 0 0 0 0 1 2000 "GJ" "5" "Mehsana" 1 0 0 0 0 0 0 0 0 0 1 2000 "GJ" "6" "Patan" 0 0 0 0 0 0 0 1 0 0 2 2000 "GJ" "7" "Surat" 0 1 0 0 0 1 0 0 0 0 2 2000 "GJ" "8" "Surndranagar" 0 0 0 0 0 0 0 1 0 1 2 2000 "GJ" "9" "Vadodara" 0 0 0 0 0 4 0 1 0 0 6 2000 "GJ" "10" "Valsad" 0 0 0 0 0 1 0 0 0 0 1 2000 "HR" "1" "Ambala" 1 1 1 0 1 1 2 0 0 1 11 2000 "HR" "2" "Bhiwani" 0 1 1 2 2 3 2 4 0 4 20 2000 "HR" "3" "Faridabad" 2 5 7 1 8 2 0 4 3 3 40 2000 "HR" "4" "Fatehabad" 1 0 0 0 0 2 1 0 0 0 4 2000 "HR" "5" "Gurgaon" 2 1 3 4 7 5 5 3 7 1 45 2000 "HR" "6" "Hisar" 0 1 1 0 1 3 1 1 0 1 9 2000 "HR" "7" "Jhajjar" 0 2 3 0 0 1 0 0 0 2 12 2000 "HR" "8" "Jind" 0 2 0 1 1 2 1 1 0 0 9 2000 "HR" "9" "Kaithal" 0 0 0 0 0 1 2 0 0 0 3 2000 "HR" "10" "Karnal" 1 2 1 3 2 1 1 3 0 0 17 2000 "HR" "11" "Kurukshetra" 1 0 0 1 0 1 0 4 0 2 11 2000 "HR" "12" "Mahendragarh" 1 1 0 0 3 0 0 0 2 2 11 2000 "HR" "13" "Panchkula" 1 0 0 0 0 0 0 0 0 0 1 2000 "HR" "14" "Panipat" 2 4 1 1 3 2 3 4 1 1 26 2000 "HR" "15" "Rewari" 0 1 0 0 2 3 1 1 0 1 10 2000 "HR" "16" "Rohtak" 0 1 0 4 2 0 1 1 0 0 9 2000 "HR" "17" "Sirsa" 0 0 1 1 0 0 3 0 0 0 5 2000 "HR" "18" "Sonipat" 1 0 1 2 5 2 4 1 0 2 23 2000 "HR" "19" "Yamuna Nagar" 0 0 0 1 0 2 1 2 0 0 7 2000 "HP" "1" "Chamba" 0 0 1 0 1 0 0 0 0 0 2 2000 "HP" "2" "Kangra" 1 1 0 2 0 2 0 0 0 1 7 end
[CODE]
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str4 A str5 B str63 C str2(D E F) str3 G str2(H I) str3(J K) str2 L str3(M N) str2 O str3(P Q) str2(R S T U V) str3(W X) str2 Y str3 Z "Year" "S.No." "Nature of Complaint" "AP" "AR" "AS" "BR" "CG" "GA" "GJ" "HR" "HP" "JH" "KA" "KL" "MP" "MH" "MN" "ML" "MZ" "NL" "OR" "PB" "RJ" "SK" "TN" "2000" "1" "Acid Attack" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "2" "Attempt to Murder" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "3" "Murder" "1" "0" "0" "23" "1" "0" "0" "12" "1" "5" "2" "3" "16" "8" "0" "0" "0" "0" "3" "2" "15" "0" "0" "2000" "4" "Attempt to Rape" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "5" "Rape" "3" "0" "3" "29" "2" "0" "0" "19" "3" "8" "1" "1" "15" "3" "0" "0" "0" "0" "2" "4" "18" "0" "0" "2000" "6" "Attempt to Rape/Rape" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "7" "Caste/Community Based Violence" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "8" "Cyber Crimes against Women" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "9" "Deprivation of Property Rights" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "10" "Divorce" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "11" "Dowry Death/ Dowry Harassment" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "12" "Dowry Death" "1" "0" "0" "48" "2" "0" "3" "21" "1" "11" "0" "3" "42" "6" "0" "0" "0" "0" "1" "6" "28" "0" "1" "2000" "13" "Dowry Harassment " "6" "0" "0" "61" "2" "1" "0" "44" "6" "12" "1" "1" "37" "16" "0" "1" "0" "0" "4" "13" "48" "0" "2" "2000" "14" "Gender Discrimination including equal right to education & work" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2000" "15" "Harassment " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "16" "Harassment At Workplace" "4" "0" "1" "73" "10" "4" "6" "76" "7" "25" "6" "6" "85" "37" "0" "0" "0" "0" "6" "20" "66" "0" "13" "2000" "17" "Indecent Representation of Women" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "18" "Kidnapping / Abduction" "0" "0" "2" "9" "0" "0" "0" "9" "0" "1" "0" "0" "6" "0" "0" "0" "0" "0" "0" "1" "5" "0" "1" "2000" "19" "Maintenance Claim" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2000" "20" "Outraging Modesty of Women" "0" "0" "0" "1" "0" "0" "0" "1" "0" "0" "0" "1" "2" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "2000" "21" "Police Apathy against women" "1" "0" "0" "19" "2" "2" "3" "13" "0" "4" "1" "0" "28" "7" "0" "0" "0" "0" "1" "1" "9" "0" "3" "2000" "22" "Right to Exercise Choice in Marriage" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "23" "Right to live with dignity" "1" "0" "0" "18" "0" "0" "0" "14" "3" "7" "1" "0" "15" "3" "0" "0" "0" "0" "2" "2" "11" "0" "0" "2000" "24" "Sex selective abortion / female foeticide / amniocentesis" "0" "0" "0" "2" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2000" "25" "Sexual harassment (plus@work)" "4" "0" "0" "12" "1" "0" "4" "10" "0" "3" "0" "1" "14" "2" "1" "0" "0" "0" "0" "2" "12" "0" "1" "2000" "26" "Shelter & Rehabilitation of Victims" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "27" "Stalking / Voyeurism" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "28" "Suicide" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2000" "29" "Trafficking / Prostitution of women" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2000" "30" "Violence against Women" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "cl" "" "" "" "" "" "" "" "" "" "S.No." "Nature of Complaint" "AP" "AR" "AS" "BR" "CG" "GA" "GJ" "HR" "HP" "JH" "KA" "KL" "MP" "MH" "MN" "ML" "MZ" "NL" "OR" "PB" "RJ" "SK" "TN" "2001" "1" "Acid Attack" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2001" "2" "Attempt to Murder" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2001" "3" "Murder" "3" "0" "2" "17" "1" "0" "0" "3" "0" "4" "0" "1" "13" "1" "0" "0" "0" "0" "0" "1" "7" "0" "0" "2001" "4" "Attempt to Rape" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "2001" "5" "Rape"
Code:
Code:* Example generated by -dataex-. To install: ssc install dataex clear input str38 years str57 nature int(feb mar) byte apr int(may jun jul aug) byte(sep oct nov dec) "2000" "Acid Attack" . . . . . . . . . . . "2000" "Attempt to Murder" . . . . . . . . . . . "2000" "Murder" 19 18 6 27 13 26 29 32 20 10 11 "2000" "Attempt to Rape" . . . . . . . . . . . "2000" "Attempt_GangRape" . . . . . . . . . . . "2000" "Attempt_MaritialRape" . . . . . . . . . . . "2000" "Attempt_Minor" . . . . . . . . . . . "2000" "Rape" 15 21 27 26 13 28 42 20 34 18 16 "2000" "Gang Rape" . . . . . . . . . . . "2000" "Marital Rape" 0 0 1 0 0 0 5 1 2 1 0 "2000" "Minor Rape" . . . . . . . . . . . "2000" "Caste/Community Based Violence" . . . . . . . . . . . "2000" "Honour Crime" . . . . . . . . . . . "2000" "Honor Killling" . . . . . . . . . . . "2000" "Cyber Crime" . . . . . . . . . . . "2000" "Divorce" . . . . . . . . . . . "2000" "Dowry death/ Dowry Harassment" . . . . . . . . . . . "2000" "Dowry Death" 23 25 24 64 25 64 73 50 63 21 37 "2000" `""Dowry Harrassmnet"' . . . . . . . . . . . "2000" "Harassment" 0 0 0 1 0 0 0 0 0 0 0 "2000" `""Harassment At Workplace"' . . . . . . . . . . . "2000" "Indecent Representation of Women" . . . . . . . . . . . "2000" "Kidnapping / Abduction" 12 18 11 16 8 18 19 15 16 4 7 "2000" "Maintenance Claim" 0 0 1 2 1 0 1 1 0 0 0 "2000" "Outraging Modesty of Women" 3 1 0 0 0 0 0 0 0 0 3 "2000" "Right to Exercise Choice in Marriage" . . . . . . . . . . . "2000" "Right to live with dignity" 16 19 11 24 9 26 44 37 30 17 19 "2000" "Cruelty" . . . . . . . . . . . "2000" "Domestic Violence" 16 19 11 23 9 26 44 37 30 17 19 "2000" `""Sexual harassment (plus@work)"' . . . . . . . . . . . "2000" "Stalking/Voyeurism" . . . . . . . . . . . "2000" "Suicide" . . . . . . . . . . . "2000" "Trafficking / Prostitution of women" 0 0 0 1 0 0 0 0 0 0 0 "2000" "Shelter and Rehabilitation of Victims" . . . . . . . . . . . "2000" "Sexual Assault" . . . . . . . . . . . "2000" "Police Apathy against women" 21 28 25 34 16 30 31 24 45 10 17 "2000" "Sex selective abortion / female foeticide / amniocentesis" 1 0 0 0 0 0 0 0 0 0 0 "2000" "Deprivation of Property Rights" . . . . . . . . . . . "2000" "Abetment to Suicide" . . . . . . . . . . . "2000" "Attempt to Suicide" . . . . . . . . . . . "2001" "Acid Attack" . . . . . . . . . . . "2001" "Attempt to Murder" . . . . . . . . . . . "2001" "Murder" 11 9 16 12 15 14 15 9 5 6 10 "2001" "Attempt to Rape" . . . . . . . . . . . "2001" "Attempt_GangRape" . . . . . . . . . . . end
My question is how will I use the three datasets , to get the kind of illegal activity committed per month in a particular district in a particular state?
as per the format below.
Code:
year state distid month Acid attack gangrape 2000 AP 1 jan 1 2000 AP 1 feb 1 2000 AP 1 March 1 2000 AP 1 April 2000 AP 1 May 1 2000 AP 1 June 1 2000 AP 1 July 1
Comment