ISSUE 429 · March 21, 2023ProjectsMeet 🤖. 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. Sponsored LinkBuild 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 CollectiveTutorials & OpinionsBut what is the Central Limit Theorem?Awesome visual introduction to probability's most important theorem, the Central Limit Theorem. 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. The Bayesian Killer AppThis 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. 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. Mathematics for Machine Learning and Data ScienceIn 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. Tools & CodeStructured text toolsThe 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. mapwidgetThe 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. CareerWhat 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 👉OutlierEvery Possible Wordle Solution VisualizedThis 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. |