How to add two sub-columns in one (Concat) using datatable (DT) in R Markdown/Shiny?

bharath222 · October 9, 2018, 9:54pm


I would like to see two columns in one using DT package. 

Example:

             Score
Count of scores  Sum of scores


I am  rendering the table from Markdown: 

renderDataTable({  
  DT::datatable(


I would appreciate any help.

Thanks.

jrlewi · October 10, 2018, 3:10am

Hi @bharath222: It's hard to understand what you are trying to accomplish without providing a reproducible example (a.k.a. reprex). I've provided a couple links discussing what a reprex is and tips for creating them.

FAQ: What's a reproducible example (`reprex`) and how do I create one? meta

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

bharath222 · October 10, 2018, 4:04pm

Hi,

Thank you for letting me know. I was not able to create the reprex in R so I have created in Excel and pasted here. Please let me know if you don't understand. (see below image)

This is how I wanted to create a table in Shiny using DT package. Is it possible to do that? or is there any other package to create a table exactly the same.

Thanks.

bharath222 · October 11, 2018, 4:23am

I found the solution here: https://rstudio.github.io/DT/