Romina MendezPython Projects with SQL: Strategies for Effective Query ManagementMany times, when programming in a project involving interaction with a database, we face the ❓question of how to organize our queries and…10 min read·May 26, 2024----
Romina MendezSimplify Database Migrations using Python with AlembicThe following article will discuss working with database migration using the popular Python library called Alembic. However, before diving…7 min read·Apr 2, 2024----
Romina MendezLearning AWS S3 on Localhost: Best Practices with Boto3 and LocalStackIn this article, you will discover new features of S3 and learn how to implement some of them using Boto3 in 🐍Python. Additionally, you…9 min read·Feb 12, 2024--2--2
Romina MendezTransform your R Dataframes: Styles, 🎨 Colors, and 😎 EmojisA few weeks ago I wrote an article about pandas dataframes and how to assign styles, but I received messages about how to do it in R (my…10 min read·Jan 24, 2024--1--1
Romina MendezSQL Assistant: Text-to-SQL Application in Streamlit 🤖In this article, we will explore the application of Vanna.ai, a 🐍 Python library specifically designed for training a model capable of…7 min read·Jan 13, 2024--4--4
Romina MendezTransform your Pandas Dataframes: Styles, 🎨 Colors, and 😎 EmojisIn the following section of this article, we will explore a method to add colors and styles to Pandas DataFrames. Our focus will be on the…9 min read·Jan 2, 2024--8--8
Romina MendezDecoding a Data Model: Using SchemaSpy in Snowflake ❄️In this article, we will delve into a comprehensive exploration of the intricacies of data modeling, spanning from its conceptual inception…5 min read·Dec 22, 2023--3--3
Romina MendezSQL to Python Pandas: A SQL User’s Quick GuideIn this post, we will compare the implementation of Pandas and SQL for data queries. We’ll explore how to use Pandas in a manner similar to…12 min read·Dec 17, 2023--6--6
Romina MendezData QualityIn the following article you will find the definition of data quality, what the domains are and how to quickly implement a solution.13 min read·Dec 11, 2023--2--2