mastodon 4.7.3📊 Solutions Engineer at @Posit@fosstodon.org
🧑🏫 Previously Senior Training Engineer at Voltron Data
🌍 Previously Executive Team member at @thecarpentries@fosstodon.org
🎓 PhD in sea cucumbers
🦑 Biodiversity Informatics enthusiast
📦 #RStats developer
👨👦👦 Father of 3 boys
🧘 Stiff yogi, 🏋️Frail CrossFitter
🍜 Ramen fan
#DataScience, #DataEngineering, #OpenScience, #OpenData, #Education, #Inclusivity, #BlackLivesMatter
I solved the Advent of SQL challenges using #DuckDB and #rstats 🎄
The 24 challenges include diverse skills, including:
- JSON and XML data manipulation
- Spatial queries
- Time series analysis
- Recursive CTEs
- Window functions
Full write-up with code examples: https://francoismichonneau.net/2024/12/advent-of-sql/
