Transform cancer codes (dx + 2 px)
Only for who have cancer dx
Transform smoking and prior irradiation
Combine data
group by race
## # A tibble: 6 x 14
## RACE n m_age m_pay1 m_zipinc_qrtl m_MEDINCSTQ m_los m_DIED m_DM m_DMCX
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 1 1340 63.7 2.04 1.63 2.50 4.62 0.0410 0.182 0.0164
## 2 2 305 57.1 2.06 1.29 2.03 4.58 0.0525 0.266 0.0393
## 3 3 44 59.9 2.09 1.98 3.02 3.89 0 0.205 0.0227
## 4 4 8 69 1.88 2.38 3.5 5.38 0.125 0.25 0.125
## 5 5 3 64.3 1.33 1 1 6.33 0 0.667 0.333
## 6 6 10 59.8 2.1 1.1 1.5 5.1 0 0.3 0
## # … with 4 more variables: m_OBESE <dbl>, m_smoke <dbl>, m_irra <dbl>,
## # m_comorbidity <dbl>
group by race & hispanic
## # A tibble: 6 x 11
## # Groups: RACE [6]
## RACE HISPANIC_X n m_pay1 m_zipinc_qrtl m_MEDINCSTQ m_los m_DIED m_DM
## <dbl> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 1 2 1340 2.04 1.63 2.50 4.62 0.0410 0.182
## 2 2 2 305 2.06 1.29 2.03 4.58 0.0525 0.266
## 3 3 1 44 2.09 1.98 3.02 3.89 0 0.205
## 4 4 2 8 1.88 2.38 3.5 5.38 0.125 0.25
## 5 5 2 3 1.33 1 1 6.33 0 0.667
## 6 6 2 10 2.1 1.1 1.5 5.1 0 0.3
## # … with 2 more variables: m_DMCX <dbl>, m_OBESE <dbl>
race 1
## # A tibble: 4 x 13
## # Groups: mastectomy [2]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 1093 1.99 1.60 2.47 5.27 0.0503
## 2 0 1 1 2 1 1 3 0
## 3 1 0 234 2.27 1.74 2.64 1.64 0
## 4 1 1 12 2.42 2 2.58 3.58 0
## # … with 5 more variables: DM <dbl>, DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>
race 2
## # A tibble: 3 x 13
## # Groups: mastectomy [2]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED DM
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 253 2.00 1.24 2 5.14 0.0632 0.281
## 2 1 0 48 2.27 1.56 2.19 1.81 0 0.208
## 3 1 1 4 3.25 1.25 2 2.25 0 0
## # … with 4 more variables: DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>
race 3
## # A tibble: 2 x 13
## # Groups: mastectomy [2]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED DM
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 29 2.03 1.86 2.83 5.03 0 0.241
## 2 1 0 15 2.2 2.2 3.4 1.67 0 0.133
## # … with 4 more variables: DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>
race 4
## # A tibble: 3 x 13
## # Groups: mastectomy [2]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED DM
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 4 1 2.75 3.25 9 0.25 0.25
## 2 1 0 3 2.67 2 3.67 1.67 0 0.333
## 3 1 1 1 3 2 4 2 0 0
## # … with 4 more variables: DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>
race 5
## # A tibble: 1 x 13
## # Groups: mastectomy [1]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED DM
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 3 1.33 1 1 6.33 0 0.667
## # … with 4 more variables: DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>
race 6
## # A tibble: 2 x 13
## # Groups: mastectomy [2]
## mastectomy reconstruction n pay1 zipinc_qrtl MEDINCSTQ los DIED DM
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 0 0 9 2.22 1.11 1.44 5.56 0 0.333
## 2 1 0 1 1 1 2 1 0 0
## # … with 4 more variables: DMCX <dbl>, OBESE <dbl>, Mastectomy <dbl>,
## # Reconstruction <dbl>