Skip to content

Instantly share code, notes, and snippets.

@aarong1
Created October 25, 2021 18:05
Show Gist options
  • Save aarong1/a2a9da32a265ffaa3e58b2c229d721b7 to your computer and use it in GitHub Desktop.
Save aarong1/a2a9da32a265ffaa3e58b2c229d721b7 to your computer and use it in GitHub Desktop.
characterise nested df for pretty printing
Cclusters1 <- Cclusters%>%
distinct(CaseNumber,ClusterID)%>%
group_by(CaseNumber)%>%
mutate(wot=all(is.na(ClusterID)))%>%
group_by(CaseNumber)%>%
summarise(ls=list(ClusterID),wot)%>%
mutate(clusters=paste0(ls))%>%
mutate(clusters=str_replace_all(clusters,pattern = '\\(',replacement=''))%>%
mutate(clusters=str_replace_all(clusters,pattern = '\\)',replacement=''))%>%
mutate(clusters=str_replace_all(clusters,pattern = '"',replacement=''))%>%
mutate(clusters=str_replace_all(clusters,pattern = 'c',replacement=''))%>%
mutate(clusters=ifelse(grepl('NA',clusters),NA,clusters))%>%
distinct()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment