Questions tagged [dt]

DT is an R package that provides an interface to the JavaScript library DataTables. Use the data.table tag for questions related to the data.frame extension package data.table.

The R package DT provides an R interface to the JavaScript library DataTables. R data objects (matrices or data frames) can be displayed as tables on HTML pages, and DataTables provides filtering, pagination, sorting, and many other features in the tables. See the package website http://rstudio.github.io/DT for more information.

1888 questions
0
votes
0 answers

CheckboxInput with Edit table in DT R Shiny

I tried to combine editing table by adding, deleting row in DT table with checkboxInput(). It is not quite correct. If I didn't add editing feature, it returned correct, but if I added editing feature,it didn't response after I added another row. I…
Ben
  • 181
  • 6
0
votes
1 answer

In R Datatable is their a way to conditionally add a plus sign to a number?

I have a column in my table that is a percent change so I would like to have it show as plus or minus. The issue is I still want it to be sortable so it needs to be numeric rather than a string. I assume something can be done in the datatable…
bpheazye
  • 146
  • 1
  • 16
0
votes
1 answer

Add download buttons is breaking my text truncation/hover functionality for a datatable in R

I'm trying to display a data set using the DT package for R which lets you render javascript datatables. Two of the columns contain text that is quite long so my colleague wrote some JS to truncate the text while letting you see the whole text when…
Ben G
  • 4,148
  • 2
  • 22
  • 42
0
votes
0 answers

R-markdown datatable incompatible with multiple chunks options set to results='hold'

When knitting an .rmd with hidden code chunks, datatable outputs, and setting the options of multiple chunks to results='hold', the output disappears. Here's a sample .rmd: --- output: html_document: code_folding:…
bcarothers
  • 824
  • 8
  • 19
0
votes
2 answers

Is there any possibility to execute this code ? R markdown problem

My goal is to export data into PDF. To do so, i used this code. The expected result is to export the PDF output without any error in compiling. Actually, there is a problem in displaying the PDF output. I installed TinyTex with this command…
Aimane CAF
  • 47
  • 7
0
votes
0 answers

Is there any way to customize my PDF Output (R Shiny)?

I want to customize my PDF output by : Centering my data table Enlarging logo Writing Data Extraction below the logo Making the table pretty I think that we need to work with JavaScript to solve this kind of problem, if anyone knows how to do so,…
Aimane CAF
  • 47
  • 7
0
votes
0 answers

Highlighting table Cells based on headers mentioned in one column data

I am working on below code definition: If first column value is 'Modified' and second column contains column names which's values has been changed based on this the data cell needs to be highlighted I am referring to the code as reference :…
Nirali
  • 1
  • 2
0
votes
1 answer

Persistent column filters with Shiny DT

I'm trying to adapt this method for capturing DT's column search term responses and re-applying them when table refreshes due to an update of its reactive data object. I can't figure out the right formulation to achieve this. Reproducible…
geotheory
  • 22,624
  • 29
  • 119
  • 196
0
votes
1 answer

Plotly and DT tables with Flexdashboard

I'm having difficulties with the placement of plots and tables within flexdashboard. Here's a reprex: --- title: "FlexDashboard" output: flexdashboard::flex_dashboard: orientation: column --- ```{r setup,…
Thomas Speidel
  • 1,369
  • 1
  • 14
  • 26
0
votes
1 answer

Use facet wrap with a data table object

I'm using the DT package and I'd like to show two tables on separate panes with one dataset. Ideally, I'd like something like facet wrap that would let me make tables based on the plan id. I'd like to have one table that has all the values for the…
Cauder
  • 2,157
  • 4
  • 30
  • 69
0
votes
0 answers

Getting dropdown lists to work inside cells in DT datatable in R Shiny

I'm trying to make a DT data table with dropdown menus available in R Shiny, similar to this post: How to create a dropdown list in a Shiny table using datatable when editing the table?. I believe I have done everything correct, but the table is…
user8229029
  • 883
  • 9
  • 21
0
votes
1 answer

Vertical alignment of numericInput in DT

I've been trying to vertically align the elements inside a dataframe rendered by dt, to do this I used the className = "dt-center" arguments inside the options of the datatable function, while this works for most of the elements of my dataframe, it…
Erlinska
  • 433
  • 5
  • 16
0
votes
1 answer

Formatting columns in a dataframe including widgets with DT

I'm trying to format a dataframe rendered by DT (adding color to specifics columns, changing the font, ...), and I was thinking about using the format functions available in DT (i.e. formatStyle, formatCurrency). However, these functions can only be…
Erlinska
  • 433
  • 5
  • 16
0
votes
0 answers

Creating custom formatting for a pivot table based on another table with identical dimensions (R)

I have two pivot tables as below. I need the main table to get its formatting from the bottom table based on the rule specified. I am not entirely sure of how to pass formatting from the one table to the other given we are only passing the one table…
0
votes
1 answer

Replacing initial Dataframe from an editable DataTable and using that new data frame in another table

I have a nested DataTable in my Shiny app. Some of the columns in the child table are editable by the user. The goal here is to have the user edit the values and then the data frame would be replaced with those new values. Then I would like to take…
1 2 3
99
100