File size: 1,077 Bytes
d93acc5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
library(shiny)
library(readxl)
library(dlookr)
library(rpivotTable)

ui <- fluidPage(
  titlePanel("EDA no Browser – rpivotTable + dlookr"),

  sidebarLayout(
    sidebarPanel(
      h4("Dataset"),
      p("Arquivo: STATUS1.xlsx"),
      actionButton("diag", "Gerar diagnóstico dlookr")
    ),

    mainPanel(
      tabsetPanel(
        tabPanel("Pivot Table",
                 rpivotTableOutput("pivot")),
        tabPanel("Diagnóstico",
                 uiOutput("diag_ui"))
      )
    )
  )
)

server <- function(input, output, session) {

  STATUS <- reactive({
    read_excel("STATUS1.xlsx")
  })

  output$pivot <- renderRpivotTable({
    rpivotTable(STATUS())
  })

  observeEvent(input$diag, {

    dir.create("www", showWarnings = FALSE)

    diagnose_web_report(
      STATUS(),
      output_dir = "www",
      output_file = "diagnostico.html"
    )

    output$diag_ui <- renderUI({
      tags$iframe(
        src = "diagnostico.html",
        width = "100%",
        height = "800px",
        style = "border:none;"
      )
    })
  })
}

shinyApp(ui, server)