As a Data Engineer, I collect, extract and transform raw data in order to provide clean, reliable and usable data.
Introduction dbt empowers data professionals to transform raw data into clean, analytics-ready datasets. Mastering its essential commands is key to unlocking its full potential. In this tutorial, we’ll explore the key dbt commands, providing both the syntax and a short description for each command. This tutorial is also a...
Introduction When dealing with large datasets in PySpark, it's common to encounter situations where you need to manipulate string data within your DataFrame columns. One such common operation is extracting a portion of a string—also known as a substring—from a column. In this tutorial, we will...
Introduction FastAPI is a modern web framework that empowers developers to build web APIs quickly and efficiently using Python. A POST endpoint in FastAPI allows clients to submit data to the server, often for creating new resources. One part of a POST request ist the Request Body, which contains the...
Introduction FastAPI is a modern web framework that empowers developers to build web APIs quickly and efficiently using Python. A GET endpoint allows clients to retrieve data from a server. In a GET request, query parameters allow passing additional information to an endpoint via the URL's query string,...
Introduction FastAPI is a modern web framework that empowers developers to build web APIs quickly and efficiently using Python. A GET endpoint allows clients to retrieve data from a server. In a GET request, path parameters can be used to pass values directly in the URL to retrieve specific resources....
Introduction In data processing and analysis with PySpark, it's often important to know the structure of your data, such as the number of rows and columns in a DataFrame. This is crucial for various operations, including data validation, transformations, and general exploration. In this tutorial, we'll...
Introduction The Requests module offers a simple and user-friendly way of making HTTP requests in Python. Whether you are retrieving data from a web page, interacting with an API, or sending information to a server, the Requests module makes the task straightforward. In this tutorial, we will explore how to...
Introduction In this tutorial, we want to count the distinct values of a PySpark DataFrame column. In order to do this, we use the distinct().count() method and the countDistinct() function of PySpark. Import Libraries First, we import the following python modules: from pyspark.sql import SparkSession from pyspark.sql....
Introduction When working with complex data, you often come across nested JSON structures that are stored in a single column. These nested structures can be difficult to analyze in their raw form, so flattening the JSON column becomes essential for data preparation. Dataflows in Microsoft Fabric provide a powerful way...