Dear all,

I am working on Data on election in Japan.
I need to count in how many same distrcits the LDP and NFP compete by year. (kuname=district name)

I have thousands of observation data.

Could anyone please tell what is the best code to use to count it?

Best,

Kuat

year kuname region party_en ku_vote ku_totvote ku_rank ku_m
1996 Ehime 1 Shikoku NFP 85794 199188 2 1
1996 Ehime 2 Shikoku LDP 118966 169169 1 1
1996 Ehime 3 Shikoku LDP 80415 152919 1 1
1996 Ehime 3 Shikoku NFP 22038 152919 3 1
1996 Ehime 4 Shikoku NFP 61244 186145 2 1
1996 Ehime 4 Shikoku LDP 113587 186145 1 1
1996 Fukui 1 Hokuriku Shinetsu NFP 48214 141708 1 1
1996 Fukui 1 Hokuriku Shinetsu LDP 32263 141708 3 1
1996 Fukui 2 Hokuriku Shinetsu LDP 79222 151324 1 1
1996 Fukui 2 Hokuriku Shinetsu NFP 65024 151324 2 1
1996 Fukui 3 Hokuriku Shinetsu NFP 32426 142635 3 1
1996 Fukui 3 Hokuriku Shinetsu LDP 48762 142635 2 1
1996 Fukuoka 1 Kyushu LDP 56748 159753 2 1
1996 Fukuoka 10 Kyushu LDP 95967 218589 1 1
1996 Fukuoka 10 Kyushu NFP 81678 218589 2 1
1996 Fukuoka 11 Kyushu LDP 42152 173260 3 1
1996 Fukuoka 11 Kyushu NFP 66798 173260 1 1
1996 Fukuoka 2 Kyushu NFP 73066 199217 2 1
1996 Fukuoka 2 Kyushu LDP 98095 199217 1 1
1996 Fukuoka 3 Kyushu NFP 66788 181722 2 1
1996 Fukuoka 3 Kyushu LDP 88953 181722 1 1