I have a summary below 6*5
AA AB AC AD AE
WA 66 40 68 64 22
CA 27 31 34 64 33
NY 41 52 32 43 69
LA 49 30 48 62 28
Total 183 153 182 233 152
if i want to dynamically change the "Total" to "sum" for every summary, because my symmary will always give Total
how can i change it dynamically
is it a data.frame or a matrix? I ask because WA, CA,NY,LA, Total don't appear to be under a column with any name
yes i converted to a dataframe
tab1 <- cro_cpct(dat1[[1]],dat1[[2]])
tab1 <- as.data.frame(tab1)
Is there a name for the column, will this be consistent? Or is the best approach to assume the first column contains it?
yes this will always give "Total" by default to create summary
I assume you mean that assuming its the first column works..
tab1 <- cro_cpct(dat1[[1]],dat1[[2]])
tab1 <- as.data.frame(tab1)
tab1[which(tab1[,1]=="Total"),1] <- "Sum"
awsome, that worked thanks
system
Closed
8
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.