Skip to content

Instantly share code, notes, and snippets.

View cecilialee's full-sized avatar

Cecilia Lee cecilialee

View GitHub Profile
@cecilialee
cecilialee / filter_row_contains_certain_string.R
Last active March 6, 2018 02:30
Filtering row which contains a certain string using dplyr in R. #r
library(dplyr)
iris %>% filter(grepl("se", Species))
@cecilialee
cecilialee / separate_column_to_columns.R
Last active March 2, 2018 22:57
Separate one column into multiple columns in R. #r #tidyr
library(tidyr)
library(dplyr)
df <- data.frame(x = c(NA, "a|b", "a|d", "b|c"))
df %>% separate(x, c("word1", "word2"))
@cecilialee
cecilialee / summary_to_df.R
Created March 2, 2018 12:24
Turn summary statistics to tidy data frame in R. #r
library(broom)
tidy(glimpse(mtcars))
@cecilialee
cecilialee / run_shiny_in_terminal
Created March 2, 2018 07:56
Run Shiny in terminal. #r #shiny
Rscript -e "shiny::runApp('poldata_app.R')"
@cecilialee
cecilialee / import_csv_to_sqlite.R
Created March 2, 2018 06:57
Import CSV to Sqlite with sqldf in R. #r
# create a test file
write.table(iris, "iris.csv", sep = ",", quote = FALSE, row.names = FALSE)
# create an empty database.
# can skip this step if database already exists.
sqldf("attach testingdb as new")
# or: cat(file = "testingdb")
# read into table called iris in the testingdb sqlite database
library(sqldf)
@cecilialee
cecilialee / tabset_panel.R
Created February 24, 2018 07:45
Tabset panel in Shiny. #r #shiny
library(shiny)
library(dplyr)
library(ggplot2)
ui = fluidPage(
tabsetPanel(
tabPanel("Plot",
plotOutput("my_plot")
),
tabPanel("Data",
@cecilialee
cecilialee / hide_show_conditional_panel.R
Last active February 24, 2018 08:19
Hide and show elements in Shiny. #r #shiny
# hide and show elements using conditional panel
library(shiny)
ui = basicPage(
checkboxInput("show", "Show datatable",
value = FALSE),
conditionalPanel("input.show == true",
dataTableOutput("mtcars"))
)
@cecilialee
cecilialee / filter_datatable_download_shiny.R
Created February 24, 2018 03:44
Filter datatable columns with download option in Shiny. #r #shiny
library(shiny)
library(dplyr)
library(readr)
load(url("http://s3.amazonaws.com/assets.datacamp.com/production/course_4850/datasets/movies.Rdata"))
# UI
ui <- fluidPage(
sidebarLayout(
# Input(s)
@cecilialee
cecilialee / download_files_shiny.R
Created February 24, 2018 03:26
Download files function in Shiny. #r #shiny
library(shiny)
library(dplyr)
library(readr)
load(url("http://s3.amazonaws.com/assets.datacamp.com/production/course_4850/datasets/movies.Rdata"))
# UI
ui <- fluidPage(
sidebarLayout(
# Input(s)
@cecilialee
cecilialee / multiple_line_string.R
Created February 24, 2018 03:17
Render string in multiple lines using HTML in Shiny. #r #shiny
library(shiny)
ui = basicPage(
textInput("txt1", "Input the first string"),
textInput("txt2", "Input the second string"),
uiOutput("cat_str")
)
server = function(input, output) {