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%.
Have a product, service, job, or event you'd like to share with Data Elixir readers?
Sponsor an Issue | Talent Collective
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
If you have 3+ years of data science experience, join the Data Elixir Talent Collective where top companies apply to you. For details, check out the Collective 👉
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
 |