Drop a column when using renderTable

Question

output$Table <- 
    renderTable(
      myData()%>%mutate(searchmatch<-str_extract(DocumentText,"([^\\s]+\\s){50}to treat(\\s[^\\s]+){50}"))
     )

This final section of my code searches 'DocumentText' for a character string and adds it into a new column. I would like to drop the 'DocumentText' column after the new column is added as it is very large, I have tried using select(myData,-DocumentText) but this didn't work. I also tried using myData([-2],) bu this also failed; Any suggestions would be great

What object is myData? Is it a function? If it is a dataframe, then myData[-2] or myData[, -2] — jogo
– jogo, Commented Nov 29, 2019 at 10:33
Please add a reproducible example so that you are more likely to get help from others. — SBista
– SBista, Commented Nov 29, 2019 at 10:58

c0rias · Accepted Answer · 2019-11-29 13:28:36Z

1

Alternatively, have you tried

output$Table <- 
    renderTable(
      myData() %>% 
      mutate(searchmatch = str_extract(DocumentText,"([^\\s]+\\s){50}to 
      treat(\\s[^\\s]+){50}")) %>% 
      select(-DocumentText)
     )

answered Nov 29, 2019 at 13:28

c0rias

1437 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Drop a column when using renderTable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related