pgls_audiogram_hf.R

#pgls_todo_hm<-pgls_todo_nogeomet[seq(2,length(pgls_todo_nogeomet),2)]

#Head mass only
#modellist<-pgls_todo_hm
pgls_models_list_hf<-lapply(modellist_hf,pgls_models)#run pgls


#make list of dataframes with the PGLS outputs.
tbllist_audiogram<-list()
for (i in seq_along(pgls_models_list_hf)){#change th 'Model' colume in this as appropriate
  tbllist_audiogram[[i]]<-as.data.frame(summary(pgls_models_list_hf[[i]])$'coefficients')
  tbllist_audiogram[[i]]$Adj_Rsquared<-summary(pgls_models_list_hf[[i]])$'adj.r.squared'[1]#rsquared
  tbllist_audiogram[[i]]$Model<-modellist_hf[i]#formula<_____________________CHECK FORMULA LIST HERE is correct
  tbllist_audiogram[[i]]$Lambda<-summary(pgls_models_list_hf[[i]])$'param'[[2]]#lambda
  tbllist_audiogram[[i]]$Fstat<-summary(pgls_models_list_hf[[i]])$fstatistic[1]
  tbllist_audiogram[[i]]$Fstat_numdf<-summary(pgls_models_list_hf[[i]])$fstatistic[2]
  tbllist_audiogram[[i]]$Fstat_dendf<-summary(pgls_models_list_hf[[i]])$fstatistic[3]

}

#organize the dataframe table (significant digist, remove redundant F stat & R squared)
for(i in seq_along(tbllist_audiogram)){
  tbllist_audiogram[[i]]$Coefficients<-row.names(tbllist_audiogram[[i]])
  tbllist_audiogram[[i]]$Coefficients<-gsub('[[:digit:]]+', '', tbllist_audiogram[[i]]$Coefficients)#regex to remove number automatically added during the loop
  #identify numeric cols and character cols to apply the significant digits function
  character_cols<-unlist(lapply(tbllist_audiogram[[i]], is.character))
  numeric_cols <- unlist(lapply(tbllist_audiogram[[i]], is.numeric))# Identify numeric columns
  tbllist_audiogram[[i]]<-cbind(tbllist_audiogram[[i]][,which(character_cols)],signif(tbllist_audiogram[[i]][,which(numeric_cols)], digits = 3))
  #tbllist_audiogram[[i]] <- tbllist_audiogram[[i]][, c(6,11,8:10,7,5,1:4)]#change order of columns
  #dplyr::select_if(tbllist_audiogram[[i]], is.numeric)#select only numeric data
  colnames(tbllist_audiogram[[i]])[6]<-"P.val"#rename b/c flextable doesn't work will with the '>' sign
  row.names(tbllist_audiogram[[i]])<-c()#remove row names
  print(tbllist_audiogram[[i]])
}

audiogrampgls_hf<-do.call(rbind.data.frame,tbllist_audiogram)
audiogrampgls_hf$category<-rep(categorylist_hf,each = 2)

audiogrampgls_hf <- subset(audiogrampgls_hf, select = c(category,Model,Coefficients,Estimate, `Std. Error`,P.val,Adj_Rsquared,Lambda))

#visualize the table better using the flextable package
flexall<-flextable(audiogrampgls_hf) %>% add_header_lines(
  values = "Table X. Models for selection") %>%
  bold(i = ~ P.val < 0.05) %>% # select columns add: j = ~ Coefficients + P.val
  autofit()
flexall

#write table to word file
toprint<-read_docx() #create word doc object
body_add_flextable(toprint,flexall)#add pgls output table
body_end_section_landscape(toprint)