Introduction In today's data-driven world, understanding text data is crucial across various domains, from data analysis to engineering and architecture. However, dealing with text data often requires converting it into numerical representations for machine learning models to process efficiently. This is where embedding vectors come into play, offering...
Introduction In this tutorial, we will explain step-by-step how to save a T-SQL query as view in Microsoft Fabric. Goal An existing T-SQL query should be saved as view. Step 1: Open Data Warehouse Experience We have already signed in into Fabric and opened the Data Warehouse Experience. We have...
Introduction In this tutorial, we will show you how to concatenate multiple string columns of a PySpark DataFrame into a single column. In order to do this, we will use the functions concat() and concat_ws() of PySpark. Import Libraries First, we import the following python modules: from pyspark.sql...
Introduction In the realm of data visualization, bar charts stand tall as one of the most effective and widely used tools for conveying information. In Power BI, it is very easy to create vertical and horizontal bar charts. Furthermore a grouping can be added, which can be displayed in different...
Introduction In order to work with data in Microsoft Fabric, you first need to get data into it. There are several ways to do this. One way is to use a notebook. In this tutorial, we will explain step-by-step how to ingest data into a Fabric lakehouse using a notebook....
Introduction In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse with T-SQL using the visual query editor. Goal Data should be queried from a table in the warehouse with T-SQL using the visual query editor. Data We consider the table student that is stored...
Introduction In this tutorial, we will show you how to remove the leading and trailing whitespaces from a string column of a PySpark DataFrame. In order to do this, we will use the functions trim(), ltrim() and rtrim() of PySpark. Import Libraries First, we import the following python modules: from...
Introduction In this tutorial, we will explain step-by-step how o read an Excel file into a PySpark DataFrame in Databricks. Configure Cluster First, install on a Databricks cluster the spark-excel library (also referred as com.crealytics.spark.excel). To do this, select your Databricks cluster in the "Compute"...
Introduction In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse using T-SQL. Goal Data should be queried from a table in the warehouse with T-SQL. Data We consider the table student that is stored in the warehouse "dlnerds_warehouse". Step 1: Open...
