Projects

An Application of Location Quotients to High-Impact Offenses

Crime Localization in Mexico 2025

python

Traditional crime rate metrics often mask geographic risk disparities by presenting aggregate averages.
In contrast, the LQ provides a robust analytical tool for determining whether a specific geographic area experiences a disproportionate share of a given crime type relative to a larger reference area, thereby highlighting true criminal hotspots.

Jesus L. Monroy

Mexico City Crime According to the Statistics

Issues and Figures, 2019-2024

python

Crime in Mexico City presents a complex and evolving challenge. The city, a sprawling metropolis, grapples with a range of criminal activities, from petty theft and street-level drug offenses to organized crime and violent acts. Factors contributing to this multifaceted issue include socioeconomic disparities, corruption, and the influence of transnational criminal organizations.

Mexico City Crime Incidence 2019-2024

tableau

This dashboard was designed to track crime incidence in Mexico City during 2019-2024 by time, gender, age, mayorship and neighborhood.

Stop Building Dashboards

Start Understanding the White Collar Workflow

python

sql

In today’s data-driven world, Business Intelligence (BI) tools promise powerful insights and streamlined reporting. Yet, the humble spreadsheet and slideshow persist in the white-collar world. While BI tools manages complex analysis and visualization, spreadsheets and slideshows offer unique advantages that keep them firmly entrenched in our workflows.

Gasoline Prices in Mexico

Fuel Price Fluctuations, A Constant Concern

python

Gasoline prices in Mexico are a complex issue influenced by various factors. In this article we examine the gasoline prices in the 32 States that constitute Mexico and also their differences in cost, sale price and profits. Challenges remain in stabilizing prices and mitigating the impact on consumers and the economy.

Implementing a Database System with DuckDB for Local Processing and MotherDuck for Scalable Cloud Storage

python

sql

This project explores how to leverage the strengths of DuckDB and MotherDuck to build a robust data processing and storage solution. DuckDB excels at fast in-memory analytics, while MotherDuck provides a scalable and cost-effective cloud data warehouse. By combining these technologies, you can achieve optimal performance for both local and cloud-based data operations.

Data Alchemy, SQL Analysis within Python

A Case Study using Duckdb, Polars and Plotly

python

sql

This project focuses on leveraging the strengths of DuckDB, Polars, and Plotly for efficient data analysis and visualization. DuckDB is used for fast in-memory data processing, Polars provides a user-friendly and high-performance DataFrame library, and Plotly offers interactive and customizable visualizations.

Geospatial Analysis in Python

A Case Study using Duckdb, Polars and Folium

python

Geospatial analysis involves the application of spatial concepts and techniques to data that has geographic coordinates. With the rise of big data and the increasing availability of geospatial information, the demand for effective geospatial analysis tools has grown significantly. Python, with its rich ecosystem of libraries, has emerged as a powerful and popular choice for geospatial data scientists.

Why BI Tools Fall Short, A Failure to Capture the Office Workflow

Slideshows and Spreadsheets Still Rule the Business World

python

Despite BI solutions, spreadsheets & slideshows persist in data-driven decision making.

Sports Commerce

tableau

This dashboard was designed to show sales by store and time intervals.

Supercharge Your SQL Analysis with Python and DuckDB

Rethinking Data Analysis: A New Paradigm

python

sql

This article explores the synergy between Python and DuckDB, a powerful in-memory database, to revolutionize SQL-based data analysis. By leveraging Python’s extensive data science ecosystem and DuckDB’s lightning-fast query execution, data professionals can significantly accelerate their workflows.

Covid Cases in Americas

tableau

This dashboard was designed to track cases and deaths by covid in Americas in 2024 by region and country.

Flying into Mexico

A Bird’s-Eye View of Major Airports

python

As a popular tourist destination, Mexico offers visitors a diverse range of experiences, from ancient ruins to pristine beaches. The country’s well-connected airport system ensures seamless travel to these captivating destinations.

Spotipy, A Python Library for Spotify Music Lovers

Discover your Music Habits with Python

python

Ever wondered about the intricacies of your listening habits on Spotify? Or perhaps you’re a developer looking to build a music-related application? Enter Spotipy, a fantastic Python library that acts as a bridge between your code and the Spotify Web API.

Creating Stunning Charts with Datawrapper and Python

python

Datawrapper is a powerful online tool designed to help you create engaging and informative data visualizations. Whether you’re a journalist, researcher, or simply someone who wants to present data in a more visually appealing way, Datawrapper can make the process quick and easy.

Mexico City’s Underground

A History of Challenges and Triumphs

python

Mexico City’s metro is the largest and busiest in Latin America, serving more than 5.5 million passengers daily in its 195 stations and 12 lines

Mexico’s Peace index 2024

python

The Mexico Peace Index (MPI), created by the Institute for Economics and Peace (IEP), is a valuable tool for understanding peacefulness in Mexico.
According to IEP, Mexico’s peacefulness has improved for 04 years in a row. However, the situation isn’t uniform. While 15 states showed improvement, 17 got worse. Drug cartel activity and political violence remain challenges.

Building Data Pipelines with BigQuery and Python

python

sql

In the realm of data analytics, Extract, Transform, Load (ETL) processes play a pivotal role.
They streamline the integration of data from various sources, enabling its cleaning, manipulation, and loading into target systems like BigQuery, Google’s cloud-based data warehouse.
By leveraging Python’s versatility and BigQuery’s scalability, you can construct powerful ETL pipelines to prepare your data for insightful analysis.

National Guard’s Deployed Personnel in Mexico

python

Mexico’s National Guard is a relatively new security force established in 2019. It was created to address the country’s high crime rates and complement traditional law enforcement.

Creating Charts with HoloViews

Unveiling Insights with Less Effort by Using HoloViews

python

HoloViews offers a compelling alternative for data visualization in Python. With its emphasis on simplicity, flexibility, and interactivity, HoloViews empowers you to create insightful visualizations that effectively communicate your data’s story.

Creating Dashboards with Python

Unleash the Power of Python

python

Python, a versatile programming language, empowers you to create interactive dashboards that unlock the hidden potential of your data.

Why You Should Use Mermaid to Create Diagrams as a Data Scientist

Use Python code as your Secret Weapon

python

In this article, we will show how you can create diagrams with code within Jupyter and stop using external diagramming graphical user interfaces (GUIs) like draw.io or Lucidchart.

Mexico’s Political Landscape

python

In this article, we will show an overview of Mexico’s Political Scenario and its correlation with Mexico City’s.

Creating Slides with Python and Quarto

python

Quarto offers a powerful and versatile tool for data scientists to create presentations with code that are informative, transparent, reproducible, and visually appealing.

DuckDB: A Compelling Solution for Data Analysis within Python Environment

A valuable tool for data scientists working with Python due to its speed, ease of use, and tight integration.

python

sql

DuckDB is a fast, embedded analytical database that outstands in in-memory operations. It provides a SQL interface, making it easy for users with database querying experience.

Mexico: A Populous Nation with a Dynamic Demographic Landscape

An Overview of Mexico’s Population Dynamics since 1950

python

Mexico boasts a population of nearly 130 million, ranking it as the 10th most populous country globally.
Mexico is a highly urbanized nation, with 88% of the population residing in cities.
This trend is expected to continue, driven by economic opportunities and infrastructure development.

Water Collection System in Mexico City - 2022

Rainwater harvesting systems are a prominent water collection method in Mexico

python

Rainwater harvesting is a sustainable and effective way to manage water resources in Mexico. By promoting water conservation and increasing water security, these systems offer a path towards a more water-resilient future.

Manipulating JSON Files with Python

An Overview Using Pandas

python

This article presents a straightforward and efficient method for reading JSON files using Python Pandas library. We will show how to import JSON data into DataFrames, enabling comprehensive analysis and exploration. This approach significantly simplifies the process of working with JSON data, making it accessible for data analysis.

Exploring Lego Toys with Polars

A quick summary about Lego bricks

python

The Lego brick was invented in 1949 by Ole Kirk Christiansen, and the company has since grown to become one of the world’s leading toy manufacturers. Lego products are sold in over 140 countries, and the company has over 40,000 employees worldwide.

Federal Prisons in Mexico

A Geographical Overview of Mexico’s Federal Penal System

python

Mexico’s federal prisons, known as Ceferesos (Centros Federales de Readaptación Social), are a complex system facing challenges. While intended for rehabilitation, reports often highlight overcrowding, violence, and inadequate living conditions.
In this article we will show the location of federal prisons in Mexico, including the famous Islas Marías, which closed in 2019.
We wil use Folium, a powerful Python library to enhance data analysis and geographic visualization.

Polynomial Regression

An Extension for Linear Regression Models

python

In this article, we shall show where linear regression falls short and we should use polynomial regression instead.

Regression Analysis Overview

A quick summary about linear and nonlinear regression

python

Whether you want to do statistics, machine learning, or economic analysis, it’s likely that you will have to use regression analysis. Regression analysis is one of the most important fields in statistics, economics and machine learning. We shall briefly explore the different techniques about regression.

Cohort Analysis

Understanding Customer Behavior

python

Cohort analysis is an extremely helpful tool that can be used to improve business practices and can effectively increase user retention if businesses implement necessary changes according to the test results.
In today’s world where data is everywhere, cohort analysis is effective in extracting useful information by analyzing the behavioral patterns of customers in order to predict the future of the business.
Observing cohorts over time gives insight into user experience and helps in developing better tactics.

Unleashing the Power of Big Data with PySpark

python

sql

In today’s data-driven world, we’re constantly bombarded with massive amounts of information. Analyzing this data efficiently and effectively is crucial for businesses and researchers alike. That’s where PySpark comes in. It’s a powerful tool that brings the distributed computing capabilities of Apache Spark to the familiar and versatile Python ecosystem.

Missing People in Mexico

tableau

This dashboard was designed to track missing people by location, last place seen and place type.

US Sales Dashboard

tableau

This dashboard was designed to track sales, profits and customers by categories, months and locations.

Looker Studio

looker-studio

We used Looker Studio to present results about customer behavior and online sales and conversions from Google Analytics.

Tableau Charts example

tableau

In this section we present some examples of charts created with Tableau.

Diving into the World of SQL

sql

In today’s data-driven world, the ability to access, manipulate, and understand information is paramount. At the heart of this capability lies SQL (Structured Query…