So, basically, I have merged two datasets: The first one is the Global Terrorism Database or GTD (slightly edited in excel) which contains all sorts of information on terrorist attacks throughout the world. The second dataset is the Polity5 dataset (also edited in excel) which provides information on the regyme type of every country on a year basis. This is where the problem comes. GTD uses panel data, that is, for every time that a terrorist attack occurs in a certain country the year repeats itself. For example, in 1999 Afghanistan had a polity2 score of -7, but in 1999 there were multiple terrorist attacks in that country, so the year in which it happened appears multiple times. This shouldn't be a bad thing, but I need to create a time series for a paper I'm working on at university.
Is there any way of clustering all the data on terrorist attacks from one year (the year observation appears several times depending on the number of terrorist attacks in that year) into a single year observation? That is, for example there are 100 terrorist attacks in 1999, so the year 1999 will appear 100 times. What I'm trying to do is compile all those terrorist attacks into a single year 1999 observation, so that I am able to create a time series.
On the contrary, is there perhaps a way of creating a time series without touching or editing the year observations?
Another thing I am having trouble with is creating a variable that will show the number of terrorist attacks in a year depending on the country, which would facilitate things a lot more in order to create a time series comparing regyme type and number of terrorist attacks.
I'm not sure if I explained myself correctly, so if you should have any questions on my problem I will answer as quickly as possible. Thank you in advance!
here is the example!
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int year str32 country byte success str35 attacktype1_txt int nkill byte polity2 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 2 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 14 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 1 -8 1991 "Afghanistan" 1 "Armed Assault" 11 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 1 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 4 -8 1991 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 1 -8 1991 "Afghanistan" 1 "Armed Assault" 2 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 16 -8 1991 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 14 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 0 -8 1991 "Afghanistan" 1 "Bombing/Explosion" 2 -8 1991 "Afghanistan" 1 "Assassination" 0 -8 1992 "Afghanistan" 0 "Assassination" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Assassination" 3 0 1992 "Afghanistan" 1 "Facility/Infrastructure Attack" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 11 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Armed Assault" 0 0 1992 "Afghanistan" 0 "Assassination" 0 0 1992 "Afghanistan" 0 "Assassination" 0 0 1992 "Afghanistan" 1 "Armed Assault" 0 0 1992 "Afghanistan" 0 "Assassination" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Assassination" 1 0 1992 "Afghanistan" 1 "Assassination" 2 0 1992 "Afghanistan" 0 "Hostage Taking (Kidnapping)" 1 0 1992 "Afghanistan" 1 "Facility/Infrastructure Attack" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 14 0 1992 "Afghanistan" 1 "Assassination" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Facility/Infrastructure Attack" 0 0 1992 "Afghanistan" 1 "Hostage Taking (Barricade Incident)" 0 0 1992 "Afghanistan" 1 "Assassination" 1 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Armed Assault" 4 0 1992 "Afghanistan" 1 "Assassination" 1 0 1992 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 0 "Assassination" 1 0 1992 "Afghanistan" 0 "Hostage Taking (Kidnapping)" 0 0 1992 "Afghanistan" 1 "Bombing/Explosion" 5 0 1992 "Afghanistan" 1 "Bombing/Explosion" 4 0 1992 "Afghanistan" 1 "Bombing/Explosion" 0 0 1992 "Afghanistan" 1 "Hostage Taking (Barricade Incident)" 1 0 1992 "Afghanistan" 1 "Armed Assault" 0 0 1994 "Afghanistan" 1 "Bombing/Explosion" 0 0 1994 "Afghanistan" 1 "Bombing/Explosion" 0 0 1994 "Afghanistan" 1 "Bombing/Explosion" 0 0 1994 "Afghanistan" 1 "Hostage Taking (Barricade Incident)" 0 0 1994 "Afghanistan" 1 "Assassination" 1 0 1994 "Afghanistan" 1 "Assassination" 1 0 1994 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 0 1994 "Afghanistan" 1 "Bombing/Explosion" 20 0 1994 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 0 1995 "Afghanistan" 0 "Bombing/Explosion" 0 0 1995 "Afghanistan" 1 "Hijacking" 0 0 1995 "Afghanistan" 1 "Assassination" 3 0 1995 "Afghanistan" 1 "Hijacking" 0 0 1995 "Afghanistan" 1 "Bombing/Explosion" 2 0 1995 "Afghanistan" 1 "Hostage Taking (Kidnapping)" 0 0 1996 "Afghanistan" 1 "Bombing/Explosion" 15 -7 1996 "Afghanistan" 0 "Bombing/Explosion" 0 -7 1996 "Afghanistan" 1 "Armed Assault" 0 -7 1996 "Afghanistan" 1 "Unknown" 16 -7 1997 "Afghanistan" 1 "Bombing/Explosion" 4 -7 1998 "Afghanistan" 1 "Bombing/Explosion" 8 -7 1999 "Afghanistan" 1 "Bombing/Explosion" 10 -7 1999 "Afghanistan" 1 "Armed Assault" 2 -7 1999 "Afghanistan" 1 "Bombing/Explosion" 2 -7 1999 "Afghanistan" 1 "Bombing/Explosion" . -7 1999 "Afghanistan" 1 "Bombing/Explosion" 2 -7 1999 "Afghanistan" 1 "Armed Assault" 20 -7 1999 "Afghanistan" 1 "Bombing/Explosion" 0 -7 1999 "Afghanistan" 1 "Bombing/Explosion" 0 -7 1999 "Afghanistan" 1 "Bombing/Explosion" 3 -7 2000 "Afghanistan" 1 "Bombing/Explosion" 25 -7 2000 "Afghanistan" 1 "Bombing/Explosion" 0 -7 2000 "Afghanistan" 1 "Bombing/Explosion" 0 -7 2000 "Afghanistan" 1 "Bombing/Explosion" 0 -7 end
0 Response to Problem with two merged datasets: time series and panel data related
Post a Comment