Gopal Krishna Ranjan

Gopal is a passionate Data Engineer and Data Analyst. He has implemented many end to end solutions using Big Data, Machine Learning, OLAP, OLTP, and cloud technologies. He loves to share his experience at https://sqlrelease.com//. Connect with Gopal on LinkedIn at https://www.linkedin.com/in/ergkranjan/.

Streamlining Data Analysis: A Step-by-Step Guide to Reading Parquet Files with Pandas

In today’s world where using data wisely is very important, being good at analyzing data helps us make smart choices. Parquet files have become popular because they save data well and organize it neatly, making it easy for data experts to use. This guide will show you how to read Parquet files using Pandas, a […]

Streamlining Data Analysis: A Step-by-Step Guide to Reading Parquet Files with Pandas Read More »

Reading Data from Cosmos DB in Databricks: A Comprehensive Guide

In today’s data-driven world, organizations leverage various data storage solutions to manage and analyze their data effectively. Cosmos DB, a globally distributed NoSQL database service from Microsoft Azure, is widely used for building highly scalable and responsive applications. In this blog post, we will explore how to read data from Cosmos DB in Databricks, a

Reading Data from Cosmos DB in Databricks: A Comprehensive Guide Read More »

PySpark Dataframes: Adding a Column with a List of Values

PySpark is a tool that lets you work with big amounts of data in Python. It’s part of Apache Spark, which is known for handling really big datasets. A common thing people need to do when they’re organizing data is to add a new piece of information to a table, which in the world of

PySpark Dataframes: Adding a Column with a List of Values Read More »

Pydantic Serialization Optimization: Remove Unneeded Fields with Ease

Pydantic, a leading data validation library in Python, streamlines the creation of data models with its powerful features. One such feature is the model_dump method, offering a convenient way to serialize Pydantic models. However, there are situations where excluding specific fields from the serialized output becomes crucial. This blog post explores the need for field

Pydantic Serialization Optimization: Remove Unneeded Fields with Ease Read More »

Dynamically Create Spark DataFrame Schema from Pandas DataFrame

Apache Spark has become a powerful tool for processing large-scale data in a distributed environment. One of its key components is the Spark DataFrame, which offers a higher-level abstraction over distributed data and enables efficient data manipulation. Spark DataFrame is typically used to manipulate large amounts of data in a distributed environment. When working within

Dynamically Create Spark DataFrame Schema from Pandas DataFrame Read More »

Python Regex – re match vs re search vs re findall

Python Regular expressions, known as regex, are a powerful tool for pattern matching and string manipulation. Python provides a built-in module called re that allows us to use regular expressions. This module offers several functions for performing various regex operations, including matching, searching, and finding all occurrences of a pattern. In this blog post, we

Python Regex – re match vs re search vs re findall Read More »

Git: Step-by-Step Guide to Rebasing the Develop Branch onto Main

Rebasing the develop branch onto the main branch is a popular workflow in Git that allows you to incorporate the latest changes from the main branch into the develop branch while maintaining a linear history. This is very useful especially when working on a project working together with multiple teams and developers. This post provides

Git: Step-by-Step Guide to Rebasing the Develop Branch onto Main Read More »

SQL Server Docker Installation: Step-by-Step Guide for Windows

SQL Server is a very popular, powerful, and versatile option in the ever-evolving landscape of database management. It is a robust and widely used relational database management system (RDBMS) developed and managed by Microsoft. SQL Server natively supports SQL (Structured Query Language) for querying and manipulating data stored in the tables. This makes SQL Server

SQL Server Docker Installation: Step-by-Step Guide for Windows Read More »

Displaying Long Strings in Pandas: How to Print Complete Text in DataFrame Without Truncation

Introduction While working with pandas DataFrames, we may get the truncated text data especially if the data size is large. The truncation of the text data while displaying can create difficulties when attempting to thoroughly analyze the complete content. This is frustrating, especially when the text contains important details that are crucial for the analysis.

Displaying Long Strings in Pandas: How to Print Complete Text in DataFrame Without Truncation Read More »

The Easiest Way to Display All Columns of a Pandas DataFrame

In the domain of data analysis and manipulation, pandas is a powerhouse library in Python. However, when working with larger datasets or complex dataframes, displaying all columns can be a challenging task. When we display the content of a pandas dataframe, pandas try to fit all the dataframe columns on the screen. As a result,

The Easiest Way to Display All Columns of a Pandas DataFrame Read More »