Explains the key differences between the = and <- assignment operators in the R programming language, focusing on scoping and side effects.
A tutorial for R users on mastering data wrangling in 5 progressive levels, using the dplyr package and the Ames housing dataset.
A comparison of the native Base R pipe (|>) and the {magrittr} pipe (%>%), covering their syntax, strictness, and use cases for data analysis.
A tech blogger analyzes the decline in their blog's ad revenue, linking it to the rise of AI tools like ChatGPT and GitHub Copilot.
A tutorial on using R to parse Apple Music XML data and create personalized listening statistics similar to Spotify Wrapped.
Analyzing ORNL's AI-generated dataset of 131 million US building footprints, including download, setup, and technical analysis.
The Big Book of R adds five new free, open-source books covering R programming for production, survey analysis, causal inference, biodiversity data, and natural resources.
Analyzing Baltic Sea maritime traffic data using the Finnish Transport Infrastructure Agency's open AIS API with Python and DuckDB.
Explores Bayesian alternatives to the frequentist t-test for comparing two means, discussing non-parametric and resampling-based approaches.
A technical guide explaining why ggplot2 line charts sometimes appear blank and how to fix the issue, focusing on data structure and grouping.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
A tutorial on the six most fundamental R functions for data cleaning, using the tidyverse and palmerpenguins dataset.
Using R simulations to calculate birthday probabilities instead of complex probability math, with code examples.
A tutorial on using Dremio and Docker to run SQL queries directly on Excel files from your local machine.
A technical walkthrough of preparing and analyzing the global Open Charge Map dataset for EV charging points using DuckDB and Python.
A technical analysis of aircraft flight routes using ADS-B telemetry data, Python, and GIS tools, focusing on a specific AirBaltic Airbus A220-300.
Argues against using LLMs to generate SQL queries for novel business questions, highlighting the importance of human analysts for precision.
A benchmark analysis of DuckDB's performance on a massive 1.1 billion row NYC taxi dataset, comparing it to other database technologies.
Introduces BigQuery's new GROUP BY ALL syntax, which automatically infers grouping keys from SELECT items to simplify complex SQL queries.
A guide to analyzing git commit history and file changes using Azure Data Explorer for better repository visibility.
