TIL: Template

One or two sentences on what I learned.

result = [x**2 for x in range(10)]
print(result)

import pandas as pd

df = pd.read_csv("data.csv")
df.head()

SELECT *
FROM 'data.csv'
LIMIT 5;

Optional caveat or aside, placed right after a comparison, it tucks under it.

import pandas as pd
data = pd.read_csv("data.csv")
data.groupby("category")["value"].agg(["count", "mean"])

library(data.table)
data = fread("data.csv")
data[, .(n = .N, mean = mean(value, na.rm = TRUE)), by = category]

-- SQL (use ```{.sql .duckdb} to label it DuckDB)
SELECT category, COUNT(*) AS n, AVG(value) AS mean
FROM 'data.csv'
GROUP BY category;