ISSUE 429 · March 21, 2023

Projects

Meet 🤖. Your SQL Tutor.

This ChatGPT SQL Tutor was trained on a selection of posts and resources on SQL interview questions. It can quiz, teach and answer questions about a variety of SQL topics, from beginner to advanced. This is experimental but worth playing with, especially if you've been wondering what all the ChatGPT hype is about.
Data Elixir Labs 

Sponsored Link

Build Data Solutions 10X Faster.

You can't optimize for everything all at once. That's why we take a holistic, metadata-driven approach to data integration that optimizes for agility, not fragmentation. By unifying each layer of the data stack, TimeXtender empowers you to build data solutions 10x faster, while reducing your costs by 70%-80%.

Tutorials & Opinions

But what is the Central Limit Theorem?

Awesome visual introduction to probability's most important theorem, the Central Limit Theorem.
3Blue1Brown | Grant Sanderson

Automating checks of *handcrafted* Word tables with {docxtractr}

There are a lot of ways to package data and Word is generally not preferred! But in case you ended up with data that was stuck in complicated Word Tables, this tutorial will help you extract and clean it programmatically using R's {docxtractr} package.
Bruno Rodrigues

The Bayesian Killer App

This tutorial is a hands-on introduction to Bayesian Decision Analysis, which is a framework for using probability to guide decision-making under uncertainty. Includes slides, Jupyter notebooks and video lecture.
Allen Downey

Scraping London Marathon data with {rvest}

Let’s say you want get a table of data from a website that doesn’t provide API access. This tutorial walks through a simple way to get that data into R using the {rvest} package.
Nicola Rennie 

Mathematics for Machine Learning and Data Science 

In this online course from Coursera, you’ll learn the fundamental mathematics toolkit of machine learning: calculus, linear algebra, statistics, and probability. This is a beginner-friendly Specialization.
// sponsored

Tools & Code

Structured text tools

The next time you need to manipulate structured text data, here's a great collection of command line tools to help with niche use-cases. It's organized by file format, including Awk-like formats, CSV, JSON, HTML, config files, log files, single-file databases, and more.
GitHub | D. Bohdan

mapwidget

The mapwidget package provides a set of custom map widgets for creating interactive 2D/3D maps in a Jupyter environment. Uses JavaScript mapping libraries with bidirectional communication. Supports Cesium, Leaflet, Mapbox, MapLibre, and OpenLayers.
mapwidget

Career

What Comes After Senior-Level Capabilities And How Do You Get There?

Given two data scientists, one in year 15 and the other in year 30, why would one be any better than the other? Understanding that is critical to using your years wisely and learning the right lessons along the way. High ROI Data Science | Vin Vashishta

Outlier

Every Possible Wordle Solution Visualized

This is a great idea for visualizing how letters fit together. It's a Wordle "Solver" that lets you see different solutions in realtime as you give it clues. How many words have Q in the middle? How about E at the end? The tool shows 2309 words and it's super compact and intuitive to use.
PerThirtySix | Shri Khalpada

How did you like this issue of Data Elixir?

👎    1     2     3     4     5   👍

Was this email forwarded to you?  Sign up here >>