/
VAworking.R
41 lines (32 loc) · 1.02 KB
/
VAworking.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
## VA data summary stats
#Get data
datalist = list() # initialize list
source("getVAdata.R") # load function
for (i in 1:5){
yr = 2006 + i
datalist[[i]] = get.VAdata(yr)
}
VAdata = rbindlist(datalist)
save(VAtest, file = "VAtest.Rda")
# function to calc GDP for total economy for a given year
getGDP = function(yr){
GDP = sum(subset(VAdata, YR == yr, c(VAEMP, VAGOS, VAMPI, VATPI)))
return(GDP)
}
#function to calc GDP for county for year
getGCP = function(fips, yr){
GCP = sum(subset(VAdata, YR == yr & FIPS == fips,
c(VAEMP, VAGOS, VAMPI, VATPI)))
return(GCP)
}
# function to calc GDP for an industry in a county for a given year
getICP = function(fips, ic, yr){
ICP = sum(subset(VAdata, YR == yr & IC == ic & FIPS == fips,
c(VAEMP, VAGOS, VAMPI, VATPI)))
return(ICP)
}
# function to get percent change in GDP
percentGDPchange = function(yr.initial, yr.final){
percentchange = ((getGDP(yr.final)-getGDP(yr.initial))*100)/getGDP(yr.initial)
return(percentchange)
}