Hi everyone,
I am doing analysis of elections in Japan. Currently, I try to find SF-ratios and built histrograms. The SF-ratio = votes of third-place candidate divided by second-place candidate's votes.
I have data on elections from 2009-2014. I sorted and kept only second- and third-place candidates. However, I can't find the best code to divide those votes in each of the districts (ex. Aichi 1 in 2009 SF ratio = JCP (3-place) votes divided by LDP (2-place) votes, thus in every ditricts by year. Could you please help me with a right code.
Here is exdata
Best,
Kuat
I am doing analysis of elections in Japan. Currently, I try to find SF-ratios and built histrograms. The SF-ratio = votes of third-place candidate divided by second-place candidate's votes.
I have data on elections from 2009-2014. I sorted and kept only second- and third-place candidates. However, I can't find the best code to divide those votes in each of the districts (ex. Aichi 1 in 2009 SF ratio = JCP (3-place) votes divided by LDP (2-place) votes, thus in every ditricts by year. Could you please help me with a right code.
Here is exdata
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int year str22 kuname str17 region str26 party_en long(ku_vote ku_totvote) byte(ku_rank ku_m) 2009 "Aichi 1" "Tokai" "LDP" 78691 224958 2 1 2009 "Aichi 1" "Tokai" "JCP" 14485 224958 3 1 2009 "Aichi 10" "Tokai" "Happiness Realization" 7861 283966 3 1 2009 "Aichi 10" "Tokai" "LDP" 103704 283966 2 1 2009 "Aichi 11" "Tokai" "Happiness Realization" 8326 277010 3 1 2009 "Aichi 11" "Tokai" "LDP" 91334 277010 2 1 2009 "Aichi 12" "Tokai" "LDP" 122198 326892 2 1 2009 "Aichi 12" "Tokai" "JCP" 20551 326892 3 1 2009 "Aichi 13" "Tokai" "LDP" 128995 287724 2 1 2009 "Aichi 13" "Tokai" "Happiness Realization" 3950 287724 3 1 2009 "Aichi 14" "Tokai" "Happiness Realization" 5304 192953 3 1 2009 "Aichi 14" "Tokai" "LDP" 70564 192953 2 1 2009 "Aichi 15" "Tokai" "LDP" 94803 240238 2 1 2009 "Aichi 15" "Tokai" "JCP" 14595 240238 3 1 2009 "Aichi 2" "Tokai" "JCP" 18908 243557 3 1 2009 "Aichi 2" "Tokai" "LDP" 58225 243557 2 1 2009 "Aichi 3" "Tokai" "LDP" 68636 247259 2 1 2009 "Aichi 3" "Tokai" "JCP" 21611 247259 3 1 2009 "Aichi 4" "Tokai" "LDP" 64367 225661 2 1 2009 "Aichi 4" "Tokai" "JCP" 28826 225661 3 1 2009 "Aichi 5" "Tokai" "LDP" 88964 255241 2 1 2009 "Aichi 5" "Tokai" "Happiness Realization" 8042 255241 3 1 2009 "Aichi 6" "Tokai" "LDP" 102252 284898 2 1 2009 "Aichi 6" "Tokai" "Independent" 6736 284898 3 1 2009 "Aichi 7" "Tokai" "LDP" 108783 297843 2 1 2009 "Aichi 7" "Tokai" "Happiness Realization" 7032 297843 3 1 2009 "Aichi 8" "Tokai" "Happiness Realization" 4907 287328 3 1 2009 "Aichi 8" "Tokai" "LDP" 109582 287328 2 1 2009 "Aichi 9" "Tokai" "Happiness Realization" 8200 289358 3 1 2009 "Aichi 9" "Tokai" "LDP" 100549 289358 2 1 2009 "Akita 1" "Tohoku" "JCP" 15830 179504 3 1 2009 "Akita 1" "Tohoku" "LDP" 61752 179504 2 1 2009 "Akita 2" "Tohoku" "SDP" 23719 220257 3 1 2009 "Akita 2" "Tohoku" "LDP" 92600 220257 2 1 2009 "Akita 3" "Tohoku" "LDPI" 76787 271986 3 1 2009 "Akita 3" "Tohoku" "LDP" 90575 271986 2 1 2009 "Aomori 1" "Tohoku" "LDPI" 35283 227789 3 1 2009 "Aomori 1" "Tohoku" "LDPI" 68910 227789 2 1 2009 "Aomori 2" "Tohoku" "DPJ" 64334 160440 2 1 2009 "Aomori 2" "Tohoku" "Independent" 7164 160440 3 1 2009 "Aomori 3" "Tohoku" "DPJ" 89809 182234 2 1 2009 "Aomori 3" "Tohoku" "Happiness Realization" 2249 182234 3 1 2009 "Aomori 4" "Tohoku" "Happiness Realization" 3719 214029 3 1 2009 "Aomori 4" "Tohoku" "DPJ" 97747 214029 2 1 2009 "Chiba 1" "Minami Kanto" "LDP" 94820 251698 2 1 2009 "Chiba 1" "Minami Kanto" "JCP" 12540 251698 3 1 2009 "Chiba 10" "Minami Kanto" "Happiness Realization" 3158 229467 3 1 2009 "Chiba 10" "Minami Kanto" "LDP" 107745 229467 2 1 2009 "Chiba 11" "Minami Kanto" "DPJ" 112707 235133 2 1 2009 "Chiba 11" "Minami Kanto" "Happiness Realization" 5489 235133 3 1 2009 "Chiba 12" "Minami Kanto" "DPJ" 114921 252906 2 1 2009 "Chiba 12" "Minami Kanto" "Happiness Realization" 3687 252906 3 1 2009 "Chiba 13" "Minami Kanto" "LDP" 80573 207055 2 1 2009 "Chiba 13" "Minami Kanto" "Happiness Realization" 4293 207055 3 1 2009 "Chiba 2" "Minami Kanto" "JCP" 22052 269282 3 1 2009 "Chiba 2" "Minami Kanto" "LDP" 89311 269282 2 1 2009 "Chiba 3" "Minami Kanto" "Happiness Realization" 4210 202022 3 1 2009 "Chiba 3" "Minami Kanto" "LDP" 85777 202022 2 1 2009 "Chiba 4" "Minami Kanto" "LDP" 85425 302311 2 1 2009 "Chiba 4" "Minami Kanto" "Your Party" 28280 302311 3 1 2009 "Chiba 5" "Minami Kanto" "LDP" 83422 256434 2 1 2009 "Chiba 5" "Minami Kanto" "Your Party" 42379 256434 3 1 2009 "Chiba 6" "Minami Kanto" "LDP" 72401 219222 2 1 2009 "Chiba 6" "Minami Kanto" "Your Party" 15063 219222 3 1 2009 "Chiba 7" "Minami Kanto" "SDP" 23086 256135 3 1 2009 "Chiba 7" "Minami Kanto" "LDP" 104262 256135 2 1 2009 "Chiba 8" "Minami Kanto" "JCP" 19378 259360 3 1 2009 "Chiba 8" "Minami Kanto" "LDP" 97007 259360 2 1 2009 "Chiba 9" "Minami Kanto" "LDP" 101734 251024 2 1 2009 "Chiba 9" "Minami Kanto" "Independent" 7651 251024 3 1 2009 "Ehime 1" "Shikoku" "JCP" 8035 268171 3 1 2009 "Ehime 1" "Shikoku" "DPJ" 127562 268171 2 1 2009 "Ehime 2" "Shikoku" "SDP" 85299 197629 2 1 2009 "Ehime 2" "Shikoku" "LDPI" 12002 197629 3 1 2009 "Ehime 3" "Shikoku" "Happiness Realization" 2856 186211 3 1 2009 "Ehime 3" "Shikoku" "LDP" 79924 186211 2 1 2009 "Ehime 4" "Shikoku" "Your Party Ind." 44777 184805 3 1 2009 "Ehime 4" "Shikoku" "DPJ" 65578 184805 2 1 2009 "Fukui 1" "Hokuriku Shinetsu" "DPJ" 72119 158028 2 1 2009 "Fukui 1" "Hokuriku Shinetsu" "JCP" 6940 158028 3 1 2009 "Fukui 2" "Hokuriku Shinetsu" "Happiness Realization" 2403 160932 3 1 2009 "Fukui 2" "Hokuriku Shinetsu" "DPJ" 78496 160932 2 1 2009 "Fukui 3" "Hokuriku Shinetsu" "Happiness Realization" 4058 158940 3 1 2009 "Fukui 3" "Hokuriku Shinetsu" "DPJ" 74158 158940 2 1 2009 "Fukuoka 1" "Kyushu" "JCP" 18046 233888 3 1 2009 "Fukuoka 1" "Kyushu" "LDP" 88648 233888 2 1 2009 "Fukuoka 10" "Kyushu" "JCP" 22980 256564 3 1 2009 "Fukuoka 10" "Kyushu" "LDP" 106365 256564 2 1 2009 "Fukuoka 11" "Kyushu" "JCP" 14475 185143 3 1 2009 "Fukuoka 11" "Kyushu" "SDP" 61192 185143 2 1 2009 "Fukuoka 2" "Kyushu" "JCP" 16818 279562 3 1 2009 "Fukuoka 2" "Kyushu" "LDP" 103270 279562 2 1 2009 "Fukuoka 3" "Kyushu" "LDP" 108236 269640 2 1 2009 "Fukuoka 3" "Kyushu" "JCP" 14551 269640 3 1 2009 "Fukuoka 4" "Kyushu" "Happiness Realization" 5437 231061 3 1 2009 "Fukuoka 4" "Kyushu" "LDP" 106124 231061 2 1 2009 "Fukuoka 5" "Kyushu" "Happiness Realization" 5139 279408 3 1 2009 "Fukuoka 5" "Kyushu" "LDP" 125767 279408 2 1 2009 "Fukuoka 6" "Kyushu" "DPJ" 119481 262237 2 1 2009 "Fukuoka 6" "Kyushu" "Happiness Realization" 4429 262237 3 1 end
Best,
Kuat
