-
Notifications
You must be signed in to change notification settings - Fork 0
/
Phoenix_Processing.R
101 lines (88 loc) · 4.65 KB
/
Phoenix_Processing.R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
rm(list=ls())
library(here)
library(reshape2)
library(dplyr)
library(corrplot)
source1<-read.csv("/Users/zhanna.terechshenko/MA/DATA/Phoenix/ClineCenterHistoricalPhoenixEventData/PhoenixFBIS_1995-2004.csv")
source2<-read.csv("/Users/zhanna.terechshenko/MA/DATA/Phoenix/ClineCenterHistoricalPhoenixEventData/PhoenixNYT_1945-2005.csv")
source3<-read.csv("/Users/zhanna.terechshenko/MA/DATA/Phoenix/ClineCenterHistoricalPhoenixEventData/PhoenixSWB_1979-2015.csv")
sources <-rbind(source1, source2, source3)
#international
phoenix.data1 = sources %>%
filter(source_root != target_root) %>%
filter(source_agent=="GOV" | source_agent=="MIL") %>%
filter(source_root!="") %>%
filter(target_agent=="GOV" | target_agent=='MIL') %>%
filter(target_root!="") %>%
filter(is.na(year)==F) %>%
filter(year >=1995) %>%
filter(source_root!="PSE" & source_root!="HKG" &
source_root!="NGO" & source_root!="IGO" & source_root!="MNC" &
source_root!="BMU" & source_root!="ABW" & source_root!="AIA" &
source_root!="COK" & source_root!="CYM") %>%
filter(target_root!="PSE" & target_root!="HKG" &
target_root!="NGO" & target_root!="IGO" & target_root!="MNC" &
target_root!="BMU" & target_root!="ABW" & target_root!="AIA" &
target_root!="COK" & target_root!="CYM") %>%
mutate(cow1 = countrycode(source_root, 'iso3c', 'cown')) %>%
mutate(cow1 = ifelse(source_root=='SRB', '345', cow1)) %>%
mutate(cow1 = ifelse(source_root=='TMP', '860', cow1)) %>%
mutate(cow1 = ifelse(source_root=='SUN', '365', cow1)) %>%
mutate(cow1 = ifelse(source_root=='KSV', '347', cow1)) %>%
mutate(cow2 = countrycode(target_root, 'iso3c', 'cown')) %>%
mutate(cow2 = ifelse(target_root=='SRB', '345', cow2)) %>%
mutate(cow2 = ifelse(target_root=='TMP', '860', cow2)) %>%
mutate(cow2 = ifelse(target_root=='SUN', '365', cow2)) %>%
mutate(cow2 = ifelse(target_root=='KSV', '347', cow2)) %>%
mutate(country = cow1) %>%
mutate(vcp = ifelse(quad_class==1, 1, 0)) %>% # verbal cooperation
mutate(mcp = ifelse(quad_class==2, 1, 0)) %>% # material cooperation
mutate(vcf = ifelse(quad_class==3, 1, 0)) %>% # verbal conflict
mutate(mcf = ifelse(quad_class==4, 1, 0)) %>% # material conflict
select(country, year, month, cow1, cow2, vcp, mcp, vcf, mcf)
phoenix.data2 = phoenix.data1 %>%
mutate(country = cow2)
pho = rbind(phoenix.data1, phoenix.data2)
pho.data = pho %>%
select(country, year, month, vcp, mcp, vcf, mcf) %>%
melt(id.vars = c('country','year', 'month')) %>%
dcast(country+year+month~variable, fun.aggregate=sum)
names(pho.data)<-c('country', 'year', 'month','vcp', 'mcp', 'vcf', 'mcf')
write.csv(pho.data, "pho_international.csv")
#domestic
phoenix.data3 = sources %>%
filter(source_root == target_root) %>%
filter(source_agent=="GOV" | source_agent=="MIL" | source_agent=="REB") %>%
filter(source_root!="") %>%
filter(target_agent=="GOV" | target_agent=='MIL' | target_agent=="REB") %>%
filter(target_root!="") %>%
filter(is.na(year)==F) %>%
filter(year >=1995) %>%
filter(source_root!="PSE" & source_root!="HKG" &
source_root!="NGO" & source_root!="IGO" & source_root!="MNC" &
source_root!="BMU" & source_root!="ABW" & source_root!="AIA" &
source_root!="COK" & source_root!="CYM") %>%
filter(target_root!="PSE" & target_root!="HKG" &
target_root!="NGO" & target_root!="IGO" & target_root!="MNC" &
target_root!="BMU" & target_root!="ABW" & target_root!="AIA" &
target_root!="COK" & target_root!="CYM") %>%
mutate(cow1 = countrycode(source_root, 'iso3c', 'cown')) %>%
mutate(cow1 = ifelse(source_root=='SRB', '345', cow1)) %>%
mutate(cow1 = ifelse(source_root=='TMP', '860', cow1)) %>%
mutate(cow1 = ifelse(source_root=='SUN', '365', cow1)) %>%
mutate(cow1 = ifelse(source_root=='KSV', '347', cow1)) %>%
mutate(cow2 = countrycode(target_root, 'iso3c', 'cown')) %>%
mutate(cow2 = ifelse(target_root=='SRB', '345', cow2)) %>%
mutate(cow2 = ifelse(target_root=='TMP', '860', cow2)) %>%
mutate(cow2 = ifelse(target_root=='SUN', '365', cow2)) %>%
mutate(cow2 = ifelse(target_root=='KSV', '347', cow2)) %>%
mutate(country = cow1) %>%
mutate(vcp = ifelse(quad_class==1, 1, 0)) %>% # verbal cooperation
mutate(mcp = ifelse(quad_class==2, 1, 0)) %>% # material cooperation
mutate(vcf = ifelse(quad_class==3, 1, 0)) %>% # verbal conflict
mutate(mcf = ifelse(quad_class==4, 1, 0)) %>% # material conflict
select(country, year, month, vcp, mcp, vcf, mcf)
pho.data3 = phoenix.data3 %>%
melt(id.vars = c('country','year', 'month')) %>%
dcast(country+year+month~variable, fun.aggregate=sum)
write.csv(pho.data3, "pho_domestic.csv")