df <- read_excel(here("SD2301_tidy.xlsx")) |>
select(mice, category, TNF:STAT3) |>
pivot_longer(cols = !c(mice,category), names_to = "transcript", values_to = "value") |>
mutate(arm = case_when(
category == 1 ~ "Negative Control",
category == 2 ~ "Drug Control",
category == 3 ~ "Inflamm",
category == 4 ~ "Inflamm & SD3",
category == 5 ~ "Inflamm & SD")) |>
mutate(transcript = case_when(
transcript == "TNF" ~ "TNFa",
transcript == "IL1" ~ "IL-1b",
transcript == "IL6" ~ "IL-6",
transcript == "STAT3" ~ "STAT3",
transcript == "TGF" ~ "TGFb",
transcript == "INF" ~ "IFNg",
transcript == "il10" ~ "IL-10")) |>
mutate(arm = ordered(arm, levels = c("Negative Control", "Drug Control", "Inflamm", "Inflamm & SD3", "Inflamm & SD"))) |>
mutate(transcript = factor(transcript, levels = c("TNFa", "IL-1b", "IL-6", "IFNg", "TGFb", "STAT3", 'IL-10'))) |>
filter(transcript != "TGFb" & transcript != "STAT3") |>
filter(arm != "Inflamm & SD3") |>
filter(!is.na(value))