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…May 26May 26
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…Apr 2Apr 2
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…Feb 122Feb 122
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…Jan 241Jan 241
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…Jan 134Jan 134
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…Jan 28Jan 28
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…Dec 22, 20233Dec 22, 20233
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…Dec 17, 20236Dec 17, 20236
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.Dec 11, 20232Dec 11, 20232