Cost

Lorem...

# Get the activity data
var_dict  <- create_data_table_variable_dictionary(db_conn_struct$swd_act$table_name)    #create the named list to convert to standardised naming
base_vars <- c(pseudo_nhs_id         = var_dict[["pseudo_nhs_id"]],              #grab the basic variables we'll need
               spell_start_date      = var_dict[["episode_start_date"]],         #datetime_window looking at prescriptions start_date==end_date
               spell_end_date        = var_dict[["episode_end_date"]],           #datetime_window looking at prescriptions start_date==end_date
               activity_provider     = var_dict[["pod_level_1"]],                #the column containing the 'primary_care_contact' or ' secondary' or 'community' etc flag
               activity_setting      = var_dict[["pod_level_2a"]],
               activity_urgency      = var_dict[["pod_level_2b"]],
               activity_specialty    = var_dict[["details_level_1b"]],
               activity_cost         = var_dict[["episode_cost_1"]])             #the column containing the cost of the medication

data <- db_conn_struct$swd_act$data %>%
  dplyr::select(dplyr::all_of(base_vars)) %>%                                  #select the variables to work with
  dplyr::distinct() %>%
  dplyr::filter(!is.na(.data$pseudo_nhs_id) &
                !is.na(.data$spell_start_date) &
                !is.na(.data$spell_end_date) &
                .data$pseudo_nhs_id %in% ids &
                .data$activity_provider %in% c('primary_care_prescription', 'primary_care_contact', 'secondary', 'community', 'mental_health', '999', '111')) %>%
  dplyr::collect() %>%
  dplyr::mutate(pseudo_nhs_id       = as.numeric(.data$pseudo_nhs_id),
                activity_start_date = .data$spell_start_date,
                activity_end_date   = .data$spell_end_date,
                activity_specialty  = dplyr::coalesce(.data$activity_specialty, .data$activity_setting),
                activity_specialty  = replace(.data$activity_specialty, .data$activity_specialty=="ae", "emergency medicine service")) %>%
  dplyr::select(.data$pseudo_nhs_id,
                .data$activity_start_date,
                .data$activity_end_date,
                .data$activity_provider,
                .data$activity_setting,
                .data$activity_urgency,
                .data$activity_specialty,
                .data$activity_cost)


# Combine asc_spells with all activity data and filter into the time window around the acs event
pre_win   = -90 #days
post_win  = 365 #days
day_intervals = seq(pre_win, post_win, 1)

full_data = dplyr::full_join(acs_spells, data, by=c("pseudo_nhs_id")) %>%
  dplyr::mutate(relative_time_days = lubridate::interval(.data$idx_acs_datetime, .data$activity_start_date)/lubridate::ddays(1),
                relative_time_days_min = lubridate::interval(.data$idx_acs_datetime, .data$min_swd_date)/lubridate::ddays(1),
                relative_time_days_max = lubridate::interval(.data$idx_acs_datetime, .data$max_swd_date)/lubridate::ddays(1)) %>%
  dplyr::filter(relative_time_days >= pre_win &
                relative_time_days <= post_win)  %>%
  dplyr::mutate(day_group = day_intervals[findInterval(.data$relative_time_days, day_intervals)],
                sec_act_type = dplyr::case_when( .data$activity_provider!="secondary" ~ NA_character_,
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="maternity") ~ "Maternity",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="ae") ~ "A&E",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="op" & .data$activity_urgency=="procedure") ~ "Outpatient procedure",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="op") ~ "Outpatient other",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="critical care") ~ "Non-elective IP",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="ip" & .data$activity_urgency=="non_elective") ~ "Non-elective IP",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="ip" & is.na(.data$activity_urgency)) ~ "Non-elective IP",
                                                               (.data$activity_provider=="secondary" & .data$activity_setting=="ip" & .data$activity_urgency=="elective") ~ "Elective IP",
                                                               TRUE ~ "error")) %>%
  # Filter out people who weren't in the attributes
  dplyr::mutate(possible_censor = !(day_group >= relative_time_days_min & day_group <= relative_time_days_max) | any(is.na(c(relative_time_days_min, relative_time_days_max))),
                cost_missing    = is.na(.data$activity_cost),
                remove          = .data$possible_censor & .data$cost_missing) %>%
  dplyr::filter(!remove)




full_data_1 = full_data %>%
  dplyr::group_by(.data$pseudo_nhs_id, .data$day_group) %>%
  dplyr::mutate(pt_day_cost = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::slice(1) %>%
  dplyr::arrange(.data$day_group) %>%
  dplyr::ungroup() %>%
  # Introduce zeros for those that don't have any activity on that day
  tidyr::pivot_wider(id_cols=c("pseudo_nhs_id", "relative_time_days_min", "relative_time_days_max"),
                     names_from=day_group,
                     values_from=pt_day_cost,
                     values_fill=0) %>%
  # Back to longer
  tidyr::pivot_longer(!c("pseudo_nhs_id", "relative_time_days_min", "relative_time_days_max"),
                      names_to="day_group",
                      values_to="pt_day_cost") %>%
  dplyr::mutate(day_group = as.numeric(.data$day_group)) %>%
  dplyr::group_by(.data$day_group) %>%
  dplyr::summarise(mean_cost_per_pt_per_day = mean(.data$pt_day_cost, na.rm=T)) %>%
  dplyr::ungroup()


fill_bg <- "white"
fill_col <- "#01967B"
color_pt <-  "gray"
colour_line <- "grey"
bar_width <- 2
y_cap <- 200

ggplot(data=full_data_1,
       aes(x=day_group,
           y=mean_cost_per_pt_per_day)) +
  geom_col(fill=fill_col, width = bar_width)+
  xlim(pre_win, post_win-1)+
  ylim(0, y_cap)+
  theme(panel.background = element_rect(fill = fill_bg),
        plot.background = element_rect(fill = fill_bg),
        panel.grid.major.y = element_blank(),
        panel.grid.major.x = element_line(),
        panel.grid.minor = element_blank(),
        axis.ticks = element_blank(),
        axis.line = element_line(color=colour_line),
        legend.position = "top",
        legend.background = element_rect(fill = fill_bg),
        legend.justification = "left",
        legend.key = element_rect(fill = fill_bg),
        plot.title = element_text(face = "bold")) +
  labs(title="Average daily spend per patient by time",
       subtitle = "BNSSG Acute Coronary Syndrome Patients (n=5743)",
       y="Average daily cost per patient (£)",
       x="Time relative to ACS event (days)") +
  annotate("text", x = c(0), y = c(200), label=c("£4555"), size=4, color="red")



# Look at spend over the years
full_data_2 = full_data %>%
  dplyr::mutate(contributing_cost = dplyr::case_when(.data$activity_start_date <  lubridate::ymd(paste0(format(.data$idx_acs_datetime, "%Y-%m"),"-01")) ~ 0.0,
                                                     .data$activity_start_date >  acs_date_window_max ~ 0.0,
                                                     TRUE ~ .data$activity_cost),
                new_this_month = dplyr::if_else(format(.data$idx_acs_datetime, "%Y-%m")==format(.data$activity_start_date, "%Y-%m"),TRUE,FALSE),
                date_month = format(.data$activity_start_date, "%Y-%m"))


# All - barchart across months
ggplot(data=full_data_2 %>% dplyr::group_by(.data$date_month, .data$new_this_month) %>% dplyr::summarise(cost = sum(.data$contributing_cost, na.rm=T)),
       aes(x=lubridate::ym(date_month),
           y=cost,
           fill=new_this_month)) +
  geom_bar(position="stack", stat="identity") +
  theme_minimal() +
  labs(title="Monthly spend",
       subtitle = "BNSSG Acute Coronary Syndrome Patients (n=5743)",
       y="Cost (£)",
       x="Date") +
  scale_fill_discrete(name="", labels = c("Ongoing care", "New patients")) +
  scale_x_date(date_labels="%b %Y") +
  scale_y_continuous(labels = comma)

# By provider category
ggplot(data=full_data_2 %>%
              dplyr::group_by(.data$activity_provider) %>%
              dplyr::summarise(cost = sum(.data$contributing_cost, na.rm=T)) %>%
              dplyr::ungroup() %>%
              dplyr::mutate(cost_pct = cost / sum(.data$cost)),
       aes(x="", y=cost_pct, fill=activity_provider)) +
  geom_bar(width = 1, stat = "identity") +
  coord_polar("y") +
  theme_minimal() +
  scale_fill_viridis_d(begin=0.0, end=0.90) +
  labs(title="Proportion of spend by activity provider",
       subtitle = "BNSSG Acute Coronary Syndrome Patients",
       fill = "Activity provider",
       y="% cost")

# By ACS type
ggplot(data=full_data_2 %>%
         dplyr::group_by(.data$description_simple) %>%
         dplyr::summarise(cost = sum(.data$contributing_cost, na.rm=T)) %>%
         dplyr::ungroup() %>%
         dplyr::mutate(cost_pct = cost / sum(.data$cost)),
       aes(x="", y=cost_pct, fill=description_simple)) +
  geom_bar(width = 1, stat = "identity") +
  coord_polar("y") +
  theme_minimal() +
  scale_fill_viridis_d(option="magma", begin=0.0, end=0.90) +
  labs(title="Proportion of spend by ACS category",
       subtitle = "BNSSG Acute Coronary Syndrome Patients",
       fill = "ACS category",
       y="% cost")

# By Age category
ggplot(data=full_data_2 %>%
         dplyr::group_by(.data$age_category) %>%
         dplyr::summarise(cost = sum(.data$contributing_cost, na.rm=T)) %>%
         dplyr::ungroup() %>%
         dplyr::mutate(cost_pct = cost / sum(.data$cost)),
       aes(x="", y=cost_pct, fill=age_category)) +
  geom_bar(width = 1, stat = "identity") +
  coord_polar("y") +
  theme_minimal() +
  scale_fill_viridis_d(option="plasma", begin=0.0, end=0.90) +
  labs(title="Proportion of spend by age category",
       subtitle = "BNSSG Acute Coronary Syndrome Patients",
       fill = "Age category",
       y="% cost")


# Look at cumulative spend across time from ACS, by provider
ggplot(data=full_data_2 %>%
         dplyr::filter(!.data$activity_provider %in% c("111", "999")) %>%
         dplyr::ungroup() %>%
         dplyr::select(day_group, activity_provider, contributing_cost) %>%
         dplyr::arrange(.data$day_group, .data$activity_provider) %>%
         dplyr::group_by(.data$activity_provider) %>%
         dplyr::mutate(contributing_cost = tidyr::replace_na(.data$contributing_cost, 0.0),
                       cum_sum = cumsum(.data$contributing_cost)) %>%
         dplyr::group_by(.data$activity_provider, .data$day_group) %>%
         dplyr::slice(which.max(.data$cum_sum)),
       aes(x=day_group,
           y=cum_sum,
           group=activity_provider,
           color=activity_provider)) +
  geom_line(size=1.5) +
  theme_minimal() +
  scale_colour_brewer(type = "qual") +
  labs(title="Cumulative spend relative to index ACS event",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2018 - Dec 2021 (n=5743)",
       y="Cost (£)",
       x="Days from ACS",
       colour="Activity provider") +
  scale_y_continuous(labels = comma)


# Look at normalised cumulative spend across time from ACS, by age
ggplot(data=full_data_2 %>%
         dplyr::filter(!.data$activity_provider %in% c("111", "999")) %>%
         dplyr::ungroup() %>%
         dplyr::select(day_group, activity_provider, age_category, contributing_cost) %>%
         dplyr::arrange(.data$day_group, .data$age_category) %>%
         dplyr::group_by(.data$age_category) %>%
         dplyr::left_join(acs_spells %>% dplyr::group_by(age_category) %>% dplyr::summarise(age_cat_nums=dplyr::n()), by="age_category") %>%
         dplyr::mutate(contributing_cost = tidyr::replace_na(.data$contributing_cost, 0.0),
                       cum_sum = cumsum(.data$contributing_cost),
                       cum_sum_norm = cum_sum / age_cat_nums) %>%
         dplyr::group_by(.data$age_category, .data$day_group) %>%
         dplyr::slice(which.max(.data$cum_sum_norm)),
       aes(x=day_group,
           y=cum_sum_norm,
           group=age_category,
           color=age_category)) +
  geom_line(size=1.5) +
  theme_minimal() +
  scale_colour_brewer(type = "qual") +
  labs(title="Normalised cumulative spend relative to index ACS event",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2018 - Dec 2021 (n=5743)",
       y="Cost (£) (cumulative, per patient)",
       x="Days from ACS",
       colour="Age category") +
  scale_y_continuous(labels = comma)




#Plots

# All spending
ggplot(data=full_data %>%
            dplyr::group_by(.data$pseudo_nhs_id) %>%
            dplyr::summarise(pt_total_cost = sum(.data$activity_cost, na.rm=T)) %>%
            dplyr::arrange(.data$pt_total_cost) %>%
            dplyr::mutate(cum_pt_cost = cumsum(.data$pt_total_cost),
                          cum_pct_cost = cum_pt_cost / sum(.data$pt_total_cost),
                          cum_centile  = seq(0,100, length=dplyr::n())),
       aes(x=cum_centile, y=cum_pct_cost)) + #, group=cut, fill=cut
  geom_point() +
  scale_color_brewer(palette = 'Set3') +
  scale_y_log10(labels = comma) +
  scale_x_log10() +
  labs(title="Cumulative (-90<days<365) spend by proportion of cohort",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2018 - Dec 2021 (n=5743)",
       y="Cumulative Cost (£)",
       x="Proportion of cohort (%)",
       colour="Activity provider")

# Index ACS spending
ggplot(data=full_data %>%
         dplyr::filter(.data$activity_provider=="secondary" & .data$day_group==0) %>%
         dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
         dplyr::summarise(pt_sub_cost = sum(.data$activity_cost, na.rm=T)) %>%
         dplyr::group_by(.data$activity_provider) %>%
         dplyr::arrange(.data$pt_sub_cost, .by_group = TRUE) %>%
         dplyr::mutate(cum_pt_act_cost = cumsum(.data$pt_sub_cost),
                       cum_pct_act_cost = cum_pt_act_cost / sum(.data$pt_sub_cost),
                       cum_act_centile  = seq(0,100, length=dplyr::n())),
       aes(x=cum_act_centile, y=cum_pt_act_cost, color=activity_provider)) + #, group=cut, fill=cut
  geom_point() +
  scale_color_brewer(palette = 'Set3') +
  labs(title="Cumulative ACS-event (day=0) spend by proportion of cohort",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2018 - Dec 2021 (n=5743)",
       y="Cumulative Cost (£)",
       x="Proportion of cohort (%)",
       colour="Activity provider") +
  scale_y_continuous(labels = comma)

# Post ACS spending
ggplot(data=full_data %>%
            dplyr::filter(.data$day_group >0) %>%
            dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
            dplyr::summarise(pt_sub_cost = sum(.data$activity_cost, na.rm=T)) %>%
            dplyr::group_by(.data$activity_provider) %>%
            dplyr::arrange(.data$pt_sub_cost, .by_group = TRUE) %>%
            dplyr::mutate(cum_pt_act_cost = cumsum(.data$pt_sub_cost),
                          cum_pct_act_cost = cum_pt_act_cost / sum(.data$pt_sub_cost),
                          cum_act_centile  = seq(0,100, length=dplyr::n())),
      aes(x=cum_act_centile, y=cum_pt_act_cost, color=activity_provider)) + #, group=cut, fill=cut
  geom_point() +
  scale_color_brewer(palette = 'Set3') +
  labs(title="Cumulative post-ACS (0<day<=365) spend by proportion of cohort",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2018 - Dec 2021 (n=5743)",
       y="Cumulative Cost (£)",
       x="Proportion of cohort (%)",
       colour="Activity provider") +
  scale_y_continuous(labels = comma)




cambridge_score_data <- db_conn_struct$camb_scr$data %>%
  dplyr::select(c("nhs_number","attribute_period","cambridge_score")) %>%                                  #select the variables to work with
  dplyr::distinct() %>%
  dplyr::filter(!is.na(.data$nhs_number) & !is.na(.data$attribute_period) & .data$nhs_number %in% ids) %>%
  dplyr::collect() %>%
  dplyr::rename(pseudo_nhs_id = nhs_number) %>%
  dplyr::mutate(pseudo_nhs_id = as.numeric(pseudo_nhs_id)) %>%
  dplyr::group_by(.data$pseudo_nhs_id) %>%
  dplyr::slice_max(.data$attribute_period) %>%
  dplyr::select(.data$pseudo_nhs_id, .data$cambridge_score)




# Who are the bottom and top spenders in the year after the ACS event (inclusive of ACS event?
ids_top_5pct = full_data %>%
  dplyr::filter(.data$day_group >=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id) %>%
  dplyr::summarise(pt_cost  = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::arrange(.data$pt_cost) %>%
  dplyr::mutate(cum_pt_cost = cumsum(.data$pt_cost)) %>%
  dplyr::ungroup() %>%
  dplyr::slice_tail(prop=0.05) %>%
  dplyr::select(.data$pseudo_nhs_id) %>%
  dplyr::mutate(comp_group="top_5pct")
ids_bot_5pct = full_data %>%
  dplyr::filter(.data$day_group >=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id) %>%
  dplyr::summarise(pt_cost = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::arrange(.data$pt_cost) %>%
  dplyr::mutate(cum_pt_cost = cumsum(.data$pt_cost)) %>%
  dplyr::ungroup() %>%
  dplyr::slice_head(prop=0.05) %>%
  dplyr::select(.data$pseudo_nhs_id) %>%
  dplyr::mutate(comp_group="bot_5pct")

foo=dplyr::left_join(rbind(ids_top_5pct, ids_bot_5pct), full_data_2, by="pseudo_nhs_id") %>%
  dplyr::filter(.data$day_group>=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
  dplyr::mutate(pt_tot_cost = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::slice(n=1) %>%
  dplyr::group_by(.data$comp_group, .data$activity_provider) %>%
  dplyr::summarise(total_cost = sum(.data$pt_tot_cost, na.rm=T),
                   mean_cost  = mean(.data$pt_tot_cost, na.rm=T),
                   mean_age   = mean(age),
                   pct_male   = sum(sex=="male")/dplyr::n(),
                   pct_stemi  = sum(description_simple=="STEMI")/dplyr::n(),
                   pct_nstemi = sum(description_simple=="NSTEMI")/dplyr::n())

# Cambridge multimorbidity score
dplyr::left_join(rbind(ids_top_5pct, ids_bot_5pct), cambridge_score_data, by="pseudo_nhs_id") %>%
  dplyr::group_by(comp_group) %>%
  dplyr::summarise(av_camb_scr = mean(.data$cambridge_score, na.rm=T),
                   sd_camb_scr = sd  (.data$cambridge_score, na.rm=T)) %>%

# Do the spends differ between those that had BP checks
load("nhs_bp_map.RData")
foo=dplyr::left_join(full_data_2, df, by="pseudo_nhs_id") %>%
  dplyr::filter(.data$day_group>=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
  dplyr::mutate(pt_tot_cost = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::slice(n=1) %>%
  dplyr::group_by(.data$bloodpressure_control_1y, .data$activity_provider) %>%
  dplyr::summarise(n = dplyr::n(),
                   total_cost = sum(.data$pt_tot_cost, na.rm=T),
                   mean_cost  = mean(.data$pt_tot_cost, na.rm=T),
                   mean_age   = mean(age),
                   pct_male   = sum(sex=="male")/dplyr::n(),
                   pct_stemi  = sum(description_simple=="STEMI")/dplyr::n(),
                   pct_nstemi = sum(description_simple=="NSTEMI")/dplyr::n())

dplyr::left_join(full_data_2, df, by="pseudo_nhs_id") %>%
  dplyr::filter(.data$day_group>=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id) %>%
  dplyr::slice(n=1) %>%
  dplyr::group_by(.data$bloodpressure_control_1y) %>%
  dplyr::summarise(n = dplyr::n())


# Do the spends differ between those that had HbA1c checks
load("nhs_bp_map.RData")
foo=dplyr::left_join(full_data_2, df, by="pseudo_nhs_id") %>%
  dplyr::filter(.data$day_group>=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
  dplyr::mutate(pt_tot_cost = sum(.data$activity_cost, na.rm=T)) %>%
  dplyr::slice(n=1) %>%
  dplyr::group_by(.data$diabetic_control_1y, .data$activity_provider) %>%
  dplyr::summarise(n = dplyr::n(),
                   total_cost = sum(.data$pt_tot_cost, na.rm=T),
                   mean_cost  = mean(.data$pt_tot_cost, na.rm=T),
                   mean_age   = mean(age),
                   pct_male   = sum(sex=="male")/dplyr::n(),
                   pct_stemi  = sum(description_simple=="STEMI")/dplyr::n(),
                   pct_nstemi = sum(description_simple=="NSTEMI")/dplyr::n())

dplyr::left_join(full_data_2, df, by="pseudo_nhs_id") %>%
  dplyr::filter(.data$day_group>=0) %>%
  dplyr::group_by(.data$pseudo_nhs_id) %>%
  dplyr::slice(n=1) %>%
  dplyr::group_by(.data$diabetic_control_1y) %>%
  dplyr::summarise(n = dplyr::n())


# Pre ACS spending
ggplot(data=full_data %>%
         dplyr::filter(.data$day_group<0 & .data$day_group>=-90) %>%
         dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider) %>%
         dplyr::summarise(pt_sub_cost = sum(.data$activity_cost, na.rm=T)) %>%
         dplyr::group_by(.data$activity_provider) %>%
         dplyr::arrange(.data$pt_sub_cost, .by_group = TRUE) %>%
         dplyr::mutate(cum_pt_act_cost = cumsum(.data$pt_sub_cost),
                       cum_pct_act_cost = cum_pt_act_cost / sum(.data$pt_sub_cost),
                       cum_act_centile  = seq(0,100, length=dplyr::n())),
       aes(x=cum_act_centile, y=cum_pt_act_cost, color=activity_provider)) + #, group=cut, fill=cut
  geom_point() +
  scale_color_brewer(palette = 'Set3') +
  labs(title="Cumulative pre-ACS (-90<=day<0) spend by proportion of cohort",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2017 - Dec 2021 (n=5743)",
       y="Cumulative Cost (£)",
       x="Proportion of cohort (%)",
       colour="Activity provider") +
  scale_y_continuous(labels = comma)

# Secondary care activity type - post ACS
ggplot(data=full_data %>%
            dplyr::filter(.data$activity_provider=="secondary" & .data$day_group >0) %>%
            dplyr::group_by(.data$pseudo_nhs_id, .data$activity_provider, .data$sec_act_type) %>%
            dplyr::summarise(pt_sub_sub_cost = sum(.data$activity_cost, na.rm=T)) %>%
            dplyr::group_by(.data$activity_provider, .data$sec_act_type) %>%
            dplyr::arrange(.data$pt_sub_sub_cost, .by_group = TRUE) %>%
            dplyr::mutate(cum_pt_act_sub_cost = cumsum(.data$pt_sub_sub_cost),
                          cum_pct_act_sub_cost = cum_pt_act_sub_cost / sum(.data$pt_sub_sub_cost),
                          cum_act_sub_centile  = seq(0,100, length=dplyr::n())),
       aes(x=cum_act_sub_centile, y=cum_pt_act_sub_cost, color=sec_act_type)) + #, group=cut, fill=cut
  geom_point() +
  scale_color_brewer(palette = 'Set3') +
  labs(title="Cumulative post-ACS (0<day<=365) secondary care spend by proportion of cohort",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2017 - Dec 2021 (n=5743)",
       y="Cumulative Cost (£)",
       x="Proportion of cohort (%)",
       colour="Activity provider") +
  scale_y_continuous(labels = comma)

# Secondary care activity specialty - post ACS
ggplot(data=full_data %>%
            dplyr::filter(.data$activity_provider=="secondary" & .data$day_group >0) %>%
            dplyr::mutate(time_bins = cut(.data$day_group,
                                          breaks=c(-90,-30,-0.5,0.5,30,90,120,365),
                                          labels=c("-90 to -30","-30 to <0","index ACS day", ">0 to 30", "30 to 90", "90 to 120", "120 to 365"))) %>%
            dplyr::group_by(.data$activity_specialty) %>%
            dplyr::mutate(tot_order = sum(.data$activity_cost)) %>%
            dplyr::group_by(.data$activity_specialty, time_bins, tot_order, sec_act_type) %>%
            dplyr::summarise(total = sum(.data$activity_cost)) %>%
            dplyr::ungroup() %>%
            dplyr::mutate(activity_specialty = factor(.data$activity_specialty, levels = unique(.data$activity_specialty[order(.data$tot_order, decreasing=T)]), ordered = T)) %>%
            dplyr::filter(as.integer(.data$activity_specialty)<=10),
       aes(x=activity_specialty, y=total, fill=time_bins)) + #, group=cut, fill=cut
  geom_bar(stat="identity", position="stack") +
  labs(title="Total post-ACS (0<day<=365) secondary care spend by speciality (top 10)",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2017 - Dec 2021 (n=5743)",
       y="Cost (£)",
       x="Speciality",
       fill="Time from ACS (days)") +
  theme(axis.text.x = element_text(angle = 45, vjust=1, hjust=1)) +
  scale_y_continuous(labels = comma) +
  scale_fill_viridis_d(option="magma", begin = 0.2, end=0.8)



# Secondary care activity type - post ACS - HEATMAP
x_bin = 30
my_breaks = c(rev(seq(-x_bin/2, -90-x_bin,by=-x_bin)), seq(x_bin/2,365+x_bin,by=x_bin))
my_labels = as.character(zoo::rollmean(my_breaks, 2))
ggplot(data=full_data %>%
         dplyr::filter(.data$activity_provider=="secondary" & .data$sec_act_type != "Maternity") %>%
         dplyr::mutate(time_bins = cut(.data$day_group, breaks=my_breaks, labels=my_labels)) %>%
         dplyr::group_by(time_bins, sec_act_type) %>%
         dplyr::summarise(total = sum(.data$activity_cost, na.rm=T) / (lubridate::interval(acs_date_window_min, acs_date_window_max) / lubridate::years(1))) %>%
         dplyr::ungroup(),
       aes(x=time_bins, y=sec_act_type, fill=total)) +
  geom_tile() +
  labs(title="ACS secondary care spend by speciality (-90<day<=365)",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2017 - Dec 2021 (n=5743)",
       y="Activity Type",
       x="Time (days)",
       fill="Total cost, averaged per year (£)") +
  scale_fill_viridis_c(option="magma", begin = 0, end=1, labels = comma,
                       trans=scales::log10_trans())

# Secondary care activity specialty - post ACS - HEATMAP
x_bin = 30
y_len = 15
my_breaks = c(rev(seq(-x_bin/2, -90-x_bin,by=-x_bin)), seq(x_bin/2,365+x_bin,by=x_bin))
my_labels = as.character(zoo::rollmean(my_breaks, 2))
ggplot(data=full_data %>%
         dplyr::filter(.data$activity_provider=="secondary") %>%
         dplyr::mutate(time_bins = cut(.data$day_group, breaks=my_breaks, labels=my_labels)) %>%
         dplyr::group_by(activity_specialty, time_bins, sec_act_type) %>%
         dplyr::summarise(total = sum(.data$activity_cost, na.rm=T) / (lubridate::interval(acs_date_window_min, acs_date_window_max) / lubridate::years(1))) %>%
         dplyr::ungroup() %>%
         dplyr::mutate(activity_specialty = factor(.data$activity_specialty, levels = unique(.data$activity_specialty[order(.data$total, decreasing=T)]), ordered = T)) %>%
         dplyr::filter(as.integer(.data$activity_specialty)<=y_len),
                      # sec_act_type == "Non-elective IP"),
       aes(x=time_bins, y=activity_specialty, fill=total)) +
  geom_tile() +
  labs(title="ACS secondary care spend by speciality (-90<day<=365)",
       subtitle = "BNSSG Acute Coronary Syndrome Patients Jul 2017 - Dec 2021 (n=5743)",
       y="Speciality",
       x="Time (days)",
       fill="Total cost (£)") +
  scale_fill_viridis_c(option="magma", begin = 0, end=1, labels = comma,
                       breaks = c(1, 1000, 100000, 10000000),
                       trans=scales::pseudo_log_trans(sigma = 100, base = exp(1))) +
  facet_wrap(~ sec_act_type)


nicksunderland/acsprojectns documentation built on July 20, 2023, 7:23 p.m.