-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
281 lines (241 loc) · 8.79 KB
/
index.html
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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
<!DOCTYPE html>
<html lang="" xml:lang="">
<head>
<title>Using the EPI CPS microdata extracts in R</title>
<meta charset="utf-8" />
<meta name="author" content="Ben Zipperer" />
<script src="libs/header-attrs-2.28/header-attrs.js"></script>
<link href="libs/remark-css-0.0.1/default.css" rel="stylesheet" />
<link href="libs/remark-css-0.0.1/metropolis.css" rel="stylesheet" />
<link href="libs/remark-css-0.0.1/metropolis-fonts.css" rel="stylesheet" />
<link rel="stylesheet" href="my_metropolis.css" type="text/css" />
</head>
<body>
<textarea id="source">
class: center, middle, inverse, title-slide
.title[
# Using the EPI CPS microdata extracts in R
]
.author[
### Ben Zipperer
]
.date[
### EARN Webinar | 29 August 2024
]
---
# Outline
## 1. Introduction to Current Population Survey
## 2. Set up R / Rstudio to use EPI CPS
## 3. Example usage with sample data
## 4. Download and use the actual data with R
---
# Where we're headed
## Write a R script that uses the EPI CPS extracts
* to calculate the number and share of workers paid less than $20/per hour
* in your state in 2023
* by gender
---
# Resources
### Slides for this talk
https://economic.github.io/zipperer_2024_webinar_epiextracts
### EPI CPS extracts documentation
https://microdata.epi.org/
### epiextractr package
https://economic.github.io/epiextractr/
---
# Current Population Survey data
### CPS background
* One of the most important surveys about the US labor market
* Monthly interviews of about 60,000 households conducted by the Census Bureau
* Source of monthly unemployment rate data
* Also a very good source of hourly wage data
### How to access the data?
* [Bureau of Labor Statistics](https://www.bls.gov/cps/) has easy to use aggregations
* But if you need a custom analysis, especially by state, you need the microdata
* Microdata are the individual survey responses
* You can download the microdata from the [Census](https://www.census.gov/data/datasets/time-series/demo/cps/cps-basic.html) (very cumbersome)
* Or you can use the [EPI CPS extracts](https://microdata.epi.org/) (much easier)
* [IPUMS](https://cps.ipums.org/cps/) is another great source for CPS microdata
### EPI CPS extracts documentation
https://microdata.epi.org/
---
# CPS data structure
### CPS Basic
* Every month households are asked questions about demographics and employment and other "basic" items
- This data the **CPS Basic**. Available monthly back to 1976
### CPS ORG
* About 1/4 of those people are asked questions about wages/earnings and union status
- This is the **CPS ORG**. Available monthly back to 1979ish.
- We're going to focus on this today.
### CPS supplements
* There are other CPS "supplements" that ask additional questions
- Annual poverty rates come from the **CPS March supplement**
- Voting and registration supplement, biennial in November
---
# How do you use the EPI CPS extracts in R?
## Open R/Rstudio and install required packages
**[epiextractr](https://economic.github.io/epiextractr/)**: makes it easy to use and download EPI CPS extracts
```r
install.packages(
"epiextractr",
repos = c("https://economic.r-universe.dev", "https://cloud.r-project.org")
)
```
**[tidyverse](https://www.tidyverse.org/)**: general data processing tools
```r
install.packages("tidyverse")
```
**[usethis](https://usethis.r-lib.org/)**: helpful for some configuration we'll do later
```r
install.packages("usethis")
```
---
# Want to do other analysis with the CPS?
## Wage or union analysis: CPS ORG with `orgwgt`
```r
load_org(2023, orgwgt, ...)
```
## Employment analysis: CPS Basic with `basicwgt`
```r
load_basic(2023, basicwgt, ...)
```
## Data sources and weights
More on data sources and weights: https://microdata.epi.org/methodology/faq/#which-sample-weight-variable-should-i-use
---
# Thank you!
## Slides
https://economic.github.io/zipperer_2024_webinar_epiextracts
</textarea>
<style data-target="print-only">@media screen {.remark-slide-container{display:block;}.remark-slide-scaler{box-shadow:none;}}</style>
<script src="https://remarkjs.com/downloads/remark-latest.min.js"></script>
<script src="macros.js"></script>
<script>var slideshow = remark.create({
"highlightStyle": "github",
"highlightLines": true,
"countIncrementalSlides": false
});
if (window.HTMLWidgets) slideshow.on('afterShowSlide', function (slide) {
window.dispatchEvent(new Event('resize'));
});
(function(d) {
var s = d.createElement("style"), r = d.querySelector(".remark-slide-scaler");
if (!r) return;
s.type = "text/css"; s.innerHTML = "@page {size: " + r.style.width + " " + r.style.height +"; }";
d.head.appendChild(s);
})(document);
(function(d) {
var el = d.getElementsByClassName("remark-slides-area");
if (!el) return;
var slide, slides = slideshow.getSlides(), els = el[0].children;
for (var i = 1; i < slides.length; i++) {
slide = slides[i];
if (slide.properties.continued === "true" || slide.properties.count === "false") {
els[i - 1].className += ' has-continuation';
}
}
var s = d.createElement("style");
s.type = "text/css"; s.innerHTML = "@media print { .has-continuation { display: none; } }";
d.head.appendChild(s);
})(document);
// delete the temporary CSS (for displaying all slides initially) when the user
// starts to view slides
(function() {
var deleted = false;
slideshow.on('beforeShowSlide', function(slide) {
if (deleted) return;
var sheets = document.styleSheets, node;
for (var i = 0; i < sheets.length; i++) {
node = sheets[i].ownerNode;
if (node.dataset["target"] !== "print-only") continue;
node.parentNode.removeChild(node);
}
deleted = true;
});
})();
// add `data-at-shortcutkeys` attribute to <body> to resolve conflicts with JAWS
// screen reader (see PR #262)
(function(d) {
let res = {};
d.querySelectorAll('.remark-help-content table tr').forEach(tr => {
const t = tr.querySelector('td:nth-child(2)').innerText;
tr.querySelectorAll('td:first-child .key').forEach(key => {
const k = key.innerText;
if (/^[a-z]$/.test(k)) res[k] = t; // must be a single letter (key)
});
});
d.body.setAttribute('data-at-shortcutkeys', JSON.stringify(res));
})(document);
(function() {
"use strict"
// Replace <script> tags in slides area to make them executable
var scripts = document.querySelectorAll(
'.remark-slides-area .remark-slide-container script'
);
if (!scripts.length) return;
for (var i = 0; i < scripts.length; i++) {
var s = document.createElement('script');
var code = document.createTextNode(scripts[i].textContent);
s.appendChild(code);
var scriptAttrs = scripts[i].attributes;
for (var j = 0; j < scriptAttrs.length; j++) {
s.setAttribute(scriptAttrs[j].name, scriptAttrs[j].value);
}
scripts[i].parentElement.replaceChild(s, scripts[i]);
}
})();
(function() {
var links = document.getElementsByTagName('a');
for (var i = 0; i < links.length; i++) {
if (/^(https?:)?\/\//.test(links[i].getAttribute('href'))) {
links[i].target = '_blank';
}
}
})();
// adds .remark-code-has-line-highlighted class to <pre> parent elements
// of code chunks containing highlighted lines with class .remark-code-line-highlighted
(function(d) {
const hlines = d.querySelectorAll('.remark-code-line-highlighted');
const preParents = [];
const findPreParent = function(line, p = 0) {
if (p > 1) return null; // traverse up no further than grandparent
const el = line.parentElement;
return el.tagName === "PRE" ? el : findPreParent(el, ++p);
};
for (let line of hlines) {
let pre = findPreParent(line);
if (pre && !preParents.includes(pre)) preParents.push(pre);
}
preParents.forEach(p => p.classList.add("remark-code-has-line-highlighted"));
})(document);</script>
<script>
slideshow._releaseMath = function(el) {
var i, text, code, codes = el.getElementsByTagName('code');
for (i = 0; i < codes.length;) {
code = codes[i];
if (code.parentNode.tagName !== 'PRE' && code.childElementCount === 0) {
text = code.textContent;
if (/^\\\((.|\s)+\\\)$/.test(text) || /^\\\[(.|\s)+\\\]$/.test(text) ||
/^\$\$(.|\s)+\$\$$/.test(text) ||
/^\\begin\{([^}]+)\}(.|\s)+\\end\{[^}]+\}$/.test(text)) {
code.outerHTML = code.innerHTML; // remove <code></code>
continue;
}
}
i++;
}
};
slideshow._releaseMath(document);
</script>
<!-- dynamically load mathjax for compatibility with self-contained -->
<script>
(function () {
var script = document.createElement('script');
script.type = 'text/javascript';
script.src = 'https://mathjax.rstudio.com/latest/MathJax.js?config=TeX-MML-AM_CHTML';
if (location.protocol !== 'file:' && /^https?:/.test(script.src))
script.src = script.src.replace(/^https?:/, '');
document.getElementsByTagName('head')[0].appendChild(script);
})();
</script>
</body>
</html>