R Shiny: All the columns have class Character when rendered in a ShinyApp after converting formattable output...
Requirement/Question: Need all the columns in the same format in Shiny App UI as they were in the R environment.
After converting a formattable output to a datatable using as.datatable function, although i am able to filter stuff but all the columns are in character class WHEN rendered in shinyapp. Meaning, 700 > 6000, 9>10 etc. (just because it is not treated as numeric class)
Sample code for testing:
#libraries
library(formattable)
library(shiny)
#upto 2 digits issue cannot be seen as 9.1 >8.1 etc even in character format, hence increasing the numbers by multiplying it to another column.
iris$Sepal.Width <- iris$Sepal.Width*iris$Petal.Length
#creating UI
ui <- fluidPage(
DT::dataTableOutput("table1"))
#creating server
server <- function(input, output){
output$table1 <- DT::renderDataTable(
as.datatable(formattable(iris)))
}
#calling the server
shinyApp(ui, server)
observation: when trying to sort column Sepal.Width in descending order, 9.x will be at top whereas it should be 25.46 in the ShinyUI.
Note: Click Show 100 filter in the ShinyApp then use sort for better understanding of the issue
All the things work perfectly when done in R but fails in ShinyApp. Need to get the same formats in ShinyApp as they were in R environment.
r shiny formattable
asked Nov 13 '18 at 6:19
AnandAnand
13
add a comment |
Requirement/Question: Need all the columns in the same format in Shiny App UI as they were in the R environment.
After converting a formattable output to a datatable using as.datatable function, although i am able to filter stuff but all the columns are in character class WHEN rendered in shinyapp. Meaning, 700 > 6000, 9>10 etc. (just because it is not treated as numeric class)
Sample code for testing:
#libraries
library(formattable)
library(shiny)
#upto 2 digits issue cannot be seen as 9.1 >8.1 etc even in character format, hence increasing the numbers by multiplying it to another column.
iris$Sepal.Width <- iris$Sepal.Width*iris$Petal.Length
#creating UI
ui <- fluidPage(
DT::dataTableOutput("table1"))
#creating server
server <- function(input, output){
output$table1 <- DT::renderDataTable(
as.datatable(formattable(iris)))
}
#calling the server
shinyApp(ui, server)
observation: when trying to sort column Sepal.Width in descending order, 9.x will be at top whereas it should be 25.46 in the ShinyUI.
Note: Click Show 100 filter in the ShinyApp then use sort for better understanding of the issue
All the things work perfectly when done in R but fails in ShinyApp. Need to get the same formats in ShinyApp as they were in R environment.
r shiny formattable
asked Nov 13 '18 at 6:19
AnandAnand
13
add a comment |
Requirement/Question: Need all the columns in the same format in Shiny App UI as they were in the R environment.
After converting a formattable output to a datatable using as.datatable function, although i am able to filter stuff but all the columns are in character class WHEN rendered in shinyapp. Meaning, 700 > 6000, 9>10 etc. (just because it is not treated as numeric class)
Sample code for testing:
#libraries
library(formattable)
library(shiny)
#upto 2 digits issue cannot be seen as 9.1 >8.1 etc even in character format, hence increasing the numbers by multiplying it to another column.
iris$Sepal.Width <- iris$Sepal.Width*iris$Petal.Length
#creating UI
ui <- fluidPage(
DT::dataTableOutput("table1"))
#creating server
server <- function(input, output){
output$table1 <- DT::renderDataTable(
as.datatable(formattable(iris)))
}
#calling the server
shinyApp(ui, server)
observation: when trying to sort column Sepal.Width in descending order, 9.x will be at top whereas it should be 25.46 in the ShinyUI.
Note: Click Show 100 filter in the ShinyApp then use sort for better understanding of the issue
All the things work perfectly when done in R but fails in ShinyApp. Need to get the same formats in ShinyApp as they were in R environment.
r shiny formattable
asked Nov 13 '18 at 6:19
AnandAnand
13
Requirement/Question: Need all the columns in the same format in Shiny App UI as they were in the R environment.
After converting a formattable output to a datatable using as.datatable function, although i am able to filter stuff but all the columns are in character class WHEN rendered in shinyapp. Meaning, 700 > 6000, 9>10 etc. (just because it is not treated as numeric class)
Sample code for testing:
#libraries
library(formattable)
library(shiny)
#upto 2 digits issue cannot be seen as 9.1 >8.1 etc even in character format, hence increasing the numbers by multiplying it to another column.
iris$Sepal.Width <- iris$Sepal.Width*iris$Petal.Length
#creating UI
ui <- fluidPage(
DT::dataTableOutput("table1"))
#creating server
server <- function(input, output){
output$table1 <- DT::renderDataTable(
as.datatable(formattable(iris)))
}
#calling the server
shinyApp(ui, server)
observation: when trying to sort column Sepal.Width in descending order, 9.x will be at top whereas it should be 25.46 in the ShinyUI.
Note: Click Show 100 filter in the ShinyApp then use sort for better understanding of the issue
All the things work perfectly when done in R but fails in ShinyApp. Need to get the same formats in ShinyApp as they were in R environment.
r shiny formattable
r shiny formattable
asked Nov 13 '18 at 6:19
AnandAnand
13
asked Nov 13 '18 at 6:19
AnandAnand
13
edited Nov 14 '18 at 12:55
Anand
asked Nov 13 '18 at 6:19
AnandAnand
13
asked Nov 13 '18 at 6:19
AnandAnand
13
asked Nov 13 '18 at 6:19
AnandAnand
13
13
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53274944%2fr-shiny-all-the-columns-have-class-character-when-rendered-in-a-shinyapp-after%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53274944%2fr-shiny-all-the-columns-have-class-character-when-rendered-in-a-shinyapp-after%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
