-
Notifications
You must be signed in to change notification settings - Fork 0
/
RPension_Database.Rmd
63 lines (53 loc) · 1.74 KB
/
RPension_Database.Rmd
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
---
title: "Reason Database Project in R"
author: "Anil"
date: "7/9/2020"
output:
word_document: default
pdf_document: default
---
## R Markdown
This is an R Markdown document. Pension Database Project (R + SQL):
By Anil, Truong, Marc, Swaroop, Jordan
Internal shiny app: <https://app.asana.com/0/450030537891393/1177895321496545>
GitHub repository: <https://github.com/ReasonFoundation/databaseR>
## Add Gain/Loss columns to the R database app (generate 0 for missing plans)
## Add new discount_rate_Assumption column(s) to R database app
## Check statutory columns for other Reason plans
_________________________
Functionality:
Search by state, by plan, by year,
View & download pulled data table
Filter data for state & some municipal plans
View data sources
Graph UAL/Inv.Returns
_________________________
Credentials to access database on postgreSQL:
dbname = "d629vjn37pbl3l",
host = "ec2-3-209-200-73.compute-1.amazonaws.com",
port = 5432,
user = "reason_readonly",
password = "p88088bd28ea68027ee96c65996f7ea3b56db0e27d7c9928c05edc6c23ef2bc27",
sslmode = "require"
This file: https://github.com/ReasonFoundation/pensionviewr/blob/master/R/sysdata.rda
## Functionality of `pensionviewr` package
```{r }
library(reasontheme)
library(pensionviewr)
lsf.str("package:pensionviewr")
```
## Raw format (pullData())
```{r}
pl <- planList()
library(data.table)
x <- data.table(pullData(pl, "New Mexico Educational Retirement Board"))
colnames(x)
#library(devtools)
#library(roxygen2)
#pullSourceData.test <- source_url("https://raw.githubusercontent.com/ReasonFoundation/databaseR/master/PullSourceData.R")
#pullSourceData.test
#pullSourceData.test$value("New Mexico Educational Retirement Board")
```
## Data Filtering
```{r}
```