Update app.R

app.R

@@ -8,12 +8,14 @@ library(shiny)
 # Data & QueryChat setup
 # ---------------------------------------------------------------------------
 
-oews <- as.data.frame(readRDS("data/oews.rds"))
+oews <- as.data.frame(readRDS("data/listings.rds"))
+
+# Pre-compute static stats for the Home tab (Airbnb)
+n_listings       <- nrow(listings)
+n_neighbourhoods <- length(unique(listings$neighbourhood))
+n_hosts          <- length(unique(listings$host_id))
+data_period      <- "Snapshot: Feb 2026"   # or use the dataset’s real snapshot date if you know it
 
-# Pre-compute static stats for the Home tab
-n_occupations <- length(unique(oews$occ_title[oews$o_group == "detailed"]))
-n_areas       <- length(unique(oews$area_title))
-data_period   <- "May 2024"
 
 client <- ellmer::chat_openai(
   model = "gpt-5-mini-2025-08-07",
@@ -21,20 +23,22 @@ client <- ellmer::chat_openai(
 )
 
 qc <- querychat::querychat(
-  oews,
+  listings,
   client = client,
-  greeting = "Welcome to Our ISA 401 Assistant for Understanding the OEWS Dataset",
+  greeting = "Welcome! Ask questions about Columbus Airbnb listings (price, room type, neighbourhood, reviews, and availability).",
   extra_instructions = "data/extra_instructions.md",
   data_description = "data/data_desc.md"
 )
 
+
+
 # ---------------------------------------------------------------------------
 # UI
 # ---------------------------------------------------------------------------
 
 ui <- bslib::page_navbar(
   id = "navbar",
-  title = "OEWS Jobs Explorer",
+  title = "Airbnb Listings Explorer",
   theme = bslib::bs_theme(primary = "#C3142D"),
   navbar_options = bslib::navbar_options(bg = "#C3142D"),
   fillable = "Explorer",
@@ -57,9 +61,10 @@ ui <- bslib::page_navbar(
         tags$hr(),
         tags$p("Try asking things like:"),
         tags$ul(
-          tags$li("Show me the top 10 highest paying occupations"),
-          tags$li("Filter to software developers in California"),
-          tags$li("What are the jobs with more than 1 million employees?")
+        tags$li("Show entire homes under $150 in Short North"),
+        tags$li("What neighbourhoods have the lowest average price?"),
+        tags$li("Show listings with zero reviews and availability_365 = 0")
+
         )
       )
     ),
@@ -78,10 +83,10 @@ ui <- bslib::page_navbar(
       style = "background: linear-gradient(135deg, #C3142D 0%, #8B0E20 100%);",
       bslib::card_body(
         class = "text-center py-5",
-        tags$h1("OEWS Jobs Explorer", class = "display-4 fw-bold"),
+      tags$h1("Airbnb Listings Explorer", class = "display-4 fw-bold"),
         tags$p(
           class = "lead mt-3 mb-4",
-          "Explore U.S. Occupational Employment and Wage Statistics using natural language queries powered by AI"
+          "Explore Columbus Airbnb listings using natural language queries powered by AI"
         ),
         tags$p(class = "text-white-50 mb-4", "A Business Intelligence and Data Visualization Assignment for ISA 401 at Miami University"),
         shiny::actionButton(
@@ -118,8 +123,9 @@ ui <- bslib::page_navbar(
       bslib::value_box(
         title = "Data Period",
         value = data_period,
-        p(format(n_occupations, big.mark = ","), " occupations \u00B7 ",
-          format(n_areas, big.mark = ","), " areas"),
+        p(format(n_listings, big.mark = ","), " listings \u00B7 ",
+        format(n_hosts, big.mark = ","), " hosts \u00B7 ",
+        format(n_neighbourhoods, big.mark = ","), " neighbourhoods"),
         showcase = bsicons::bs_icon("bar-chart-line"),
         theme = "light"
       )
@@ -138,7 +144,7 @@ ui <- bslib::page_navbar(
             tags$a("querychat", href = "https://posit-dev.github.io/querychat/",
                    target = "_blank"),
             " R package to let you query the ",
-            tags$strong("OEWS May 2024"),
+            tags$strong("Columbus Airbnb listings"),
             " dataset from the ",
             tags$a("Bureau of Labor Statistics",
                    href = "https://www.bls.gov/oes/tables.htm", target = "_blank"),
@@ -234,7 +240,7 @@ ui <- bslib::page_navbar(
 # ---------------------------------------------------------------------------
 
 server <- function(input, output, session) {
-  qc_vals <- qc$server()
+  qc_vals$title() %||% "Airbnb Listings"
 
   # Navigate to Explorer tab on button click
   shiny::observeEvent(input$go_explorer, {
@@ -242,7 +248,7 @@ server <- function(input, output, session) {
   })
 
   output$explorer_table_title <- shiny::renderText({
-    qc_vals$title() %||% "OEWS Data"
+    qc_vals$title() %||% "Airbnb Listings"
   })
 
   output$table <- DT::renderDT({
@@ -254,7 +260,7 @@ server <- function(input, output, session) {
   })
 
   output$sql <- shiny::renderText({
-    qc_vals$sql() %||% "SELECT * FROM oews"
+    qc_vals$sql() %||% "SELECT * FROM listings"
   })
 }