Economics EN
Colombian labor market — STEP program case study
Colombia's STEP survey plus Frey & Osborne: regressions to adjust automation risk by age, gender, education, and job skills.
Read artifact →Blog
Notes, build-alongs, and case studies on data, ML, BI, and economics—in English and Spanish—each framed by the problem, the method, and the measurable impact.
Economics EN
Real cost of credit in Colombia: Fisher and CPI
Build a fixed-payment amortization table in Python, estimate the real rate with Fisher, and restate each loan payment in constant pesos today.
Economics EN
Colombia CPI indexation in Python with monthly IPC
Turn official Colombian IPC into peso indexation in Python—validate the monthly series and export an auditable calculation trail for reviews.
Machine Learning EN
Local RAG with Ollama in Python — ask your docs without API keys
Python 3 tutorial: chunk Markdown, embed with Ollama, store in ChromaDB, and ask questions locally—no OpenAI bill.
Machine Learning EN
A Python MCP server that lets Cursor, Claude, and Codex query BigQuery safely
Build a Python MCP server so Cursor, Claude Desktop, or Codex can list BigQuery tables and run parameterized read-only SQL—with a byte cap.
Analysis EN
Unlocking the Power of Experimental Design in Data Analysis and Science
What experimental design is, why you plan controls before you collect data, and where it shows up in real analysis work.
Analysis EN
Creating a Fun and Simple 2D Game with Pygame
A minimal 2D Pygame project: sprites, collision, score. Small enough to finish in an afternoon if you already know a bit of Python.
Analysis EN
Introduction to PyAutoGUI: A Beginner's Guide to Understanding What PyAutoGUI is, and How it Works
PyAutoGUI automates the boring clicks—mouse, keyboard, screenshots. A plain intro to what it does and when it's worth using.
Business Intelligence EN
Mastering Data Visualization with Plotly in Python: A Comprehensive Tutorial
Plotly in Python for scatter plots and animated charts—install, a few dataset examples, and code you can copy into your own notebook.
Economics EN
Behavioral Economics and Data Analysis: An Introduction
Cognitive biases show up in data work too—confirmation bias, availability heuristic, and a few ways to keep them from skewing your analysis.
Economics ES
Mercado laboral Colombiano. Caso de estudio, Programa STEP
La automatización de trabajos corresponde al desarrollo e inclusión de nuevas tecnologías en las cadenas de valor de las empresas. Sin embargo, este cambio…
Economics EN
Colombia IPC inflation calculator in Python (2003–2020)
Build a Colombia IPC (CPI) inflation calculator in Python—convert pesos across years with Banrep/DANE data. Useful as a calculadora de inflación / IPC Colombia.
Economics ES
Calculadora de inflación Colombia en Python (IPC)
Aprende a construir una calculadora de inflación con IPC de Colombia en Python: convierte pesos entre años con series Banrep/DANE y deja el cálculo auditable.
Business Intelligence EN
Decrees and Resolutions of Colombia's Ministry of Health and Social Protection (2000–2020)
Selenium scrapers, PDF transcription, and text mining on MinSalud decrees and resolutions from 2000 to 2020—coverage, epidemics, fraud.
Business Intelligence ES
Decretos y Resoluciones del Ministerio de Salud y Protección Social de Colombia (2000-2020)
Según estudios de McKinsey https://www.mckinsey.com/ , el análisis del datos referente a información no estructurada como audios, textos e imagen, a futuro…
Business Intelligence EN
How to build a fixed-payment loan simulator in Python?
Simulate a fixed-rate loan in Python with numpy_financial: monthly payment, full amortization table, and charts of the declining balance over time.
Business Intelligence ES
Simulador de créditos a cuotas fijas en Python
Simula un crédito de cuotas fijas en Python: calcula la cuota, genera la tabla de amortización y visualiza cómo baja el saldo con el tiempo.
Business Intelligence EN
How to interact with APIs in Python? Case of study, the ICFES's results in Colombia, 2019-2
Hook Python to datos.gov.co, pull ICFES 2019-2 scores, push them to BigQuery, and build school charts in Data Studio.
Business Intelligence ES
¿Cómo interactuar con APIs en Python? Caso de estudio, resultados del Icfes en Colombia del 2019-2
Actualmente, el gobierno colombiano dispone de una plataforma para revisión de datos públicos llamado datos.gov.co https://www.datos.gov.co/ en la cual se …
Analysis ES
¿Cómo realizar un reproductor de música en Python?
Tutorial en Python para un reproductor de música con POO: tkinter, pygame, carpeta de canciones, botones play/pause/stop y control de volumen.
Analysis EN
How to build a music player in Python?
Build a desktop music player in Python with tkinter and pygame: choose a track, play/pause/stop, set volume, and show elapsed playback time.
Economics ES
Optimización Teoría del consumidor en Python
Hoy día en las aulas de clase, en las asignaturas del pregrado en Economía, se empieza enseñando la Teoría del consumidor, tema de un gran campo de la econ…
Economics EN
Optimization Consumer Theory in Python
Consumer theory in Python with scipy: budget lines, utility maximization, and plots that go beyond the textbook.
Business Intelligence ES
Web Scraping plebiscito 2016 Colombia
Descripción y Motivación El plebiscito https://es.wikipedia.org/wiki/Plebiscito de 2016 en Colombia sobre los acuerdos de paz de Colombia de 2016 fue el me…
Business Intelligence EN
Web Scraping, case of study plebiscite in Colombia,2016
The 2016 peace plebiscite in Colombia, scraped with Python and plotted in Data Studio—turnout, votes, and what the numbers showed.
Analysis EN
How can I use Python to automate the sending of emails?
Automate emailing a generated CSV with Python 3 and Windows Task Scheduler using a Gmail app password, a short .py script, and a recurring job.
Analysis ES
¿Cómo programar el envío automático de correos con Python?
Automatiza el envío de un archivo por correo con Python 3 y el Programador de tareas de Windows: Gmail, script .py y programación recurrente.
Start here
English and Spanish artifacts — start with these English hubs; open any card for the language switcher when a pair exists.
Economics and Colombia
- Colombia CPI indexation engine with a monthly audit trail
- Real cost of credit: amortization, Fisher, and CPI
- Original Colombia CPI / IPC calculator (Python)
- Loan interest and amortization simulator
- Consumer optimization under a budget constraint