Dear all,
I have a turnout data for election years. I expanded the data for the years between the election circles. Now, I want years to follow the years that elections were held. For example, in Afghanistan, in the second row, it should be 2005, 3rd 2006, 4th 2007, 5th 2008, etc. It must be easy but I could not figure out. Could you help me?
Country electionyear turnout electioncircle
Afghanistan 2004 83.66
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Albania 1991 98.92
Albania 1992 91.5 1
Albania 1996 89.08 4
Albania 1996 89.08 4
Albania 1996 89.08 4
I have a turnout data for election years. I expanded the data for the years between the election circles. Now, I want years to follow the years that elections were held. For example, in Afghanistan, in the second row, it should be 2005, 3rd 2006, 4th 2007, 5th 2008, etc. It must be easy but I could not figure out. Could you help me?
Country electionyear turnout electioncircle
Afghanistan 2004 83.66
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2009 38.8 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2014 38.9 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Afghanistan 2019 19 5
Albania 1991 98.92
Albania 1992 91.5 1
Albania 1996 89.08 4
Albania 1996 89.08 4
Albania 1996 89.08 4
Comment