bearloga

-- Usage: spark3-sql -f demo_data.sql -d db=bearloga

DROP TABLE IF EXISTS ${db}.demo_data_v1;
CREATE TABLE IF NOT EXISTS ${db}.demo_data_v1 (
  user_id int,
  action string,
  experiments array<map<string, string>>
)
LOCATION '/tmp/${db}/demo_data_v1';

bearloga

Recoding and Sharing Name Pronunciations

Follow these instructions for recording audio

• on a Mac: https://support.apple.com/guide/voice-memos/record-vmaa4b813415/mac
• on a Windows PC: https://www.windowscentral.com/how-record-sound-using-voice-recorder-app-windows-10

Convert audio

Convert the file to a supported open format for uploading to Wikimedia Commons:

bearloga

bearloga

bearloga

---
title: "Sympy Engine"
output: html_notebook
editor_options: 
  chunk_output_type: inline
---

Assuming the "sympy" knitr engine has been registered:

```{sympy, results='asis'}

bearloga

bearloga

---
title: "Printing chunk engine via hook"
output: github_document
---

```{r setup, include=FALSE}
library(knitr)
opts_chunk$set(echo = TRUE, warning = FALSE, message = FALSE)

print_engine_hook <- function(before, options, envir) {

bearloga

Solution to SQL Murdery Mystery

A walkthrough of the solution to SQL Murder Mystery by Northwestern University Knight Lab. Solution by Mikhail Popov

Prompt

A crime has taken place and the detective needs your help. The detective gave you the crime scene report, but you somehow lost it. You vaguely remember that the crime was a ​murder​ that occurred sometime on ​Jan.15, 2018​ and that it took place in ​SQL City​. Start by retrieving the corresponding crime scene report from the police department’s database.

Witness reports

bearloga

# daily_stats has 5 columns used by this code: date, time_spent_10/25/50/75/90

ggplot(daily_stats) +
    geom_segment(aes(x = date, xend = date, y = time_spent_10, yend = time_spent_90),
                 size = 1, color = "#00af89") +
    geom_segment(aes(x = date, xend = date, y = time_spent_25, yend = time_spent_75),
                 size = 2, color = "#14866d") +
    # geom_ribbon(aes(x = date, ymin = time_spent_lower, ymax = time_spent_upper), alpha = 0.3) +
    # geom_line(aes(x = date, y = time_spent_middle)) +
    geom_label(

bearloga