library(dplyr)
library(ggplot2)
library(tidyr)
ckd_data <- read.csv("C:/Users/Skj23/Documents/ckd-dataset-v2.csv")
ckd_data <- ckd_data %>%mutate(across(c(sc, bu, hemo, bgr, pcv, rbcc), ~ sapply(., convert)))
ckd_data <- ckd_data[ckd_data$class %in% c("ckd", "notckd"), ]
ckd_data_long <- ckd_data %>%pivot_longer(cols = c(sc, bu, hemo, bgr, pcv, rbcc),names_to = "lab",values_to = "value")
avg_lab_tests <- ckd_data_long %>%group_by(class, lab) %>%summarise(avg = mean(value, na.rm = TRUE), .groups = 'drop')
avg_lab_tests_plot <- ggplot(avg_lab_tests, aes(x = lab, y = avg, color = class)) +geom_point(size = 3) +geom_line(aes(group = class)) + labs(x = "Lab Tests", y = "Average Value")