What is DENSE_RANK? DENSE RANK is a window function in SQL that is used to assign a rank to each row within a result set. The rank assigned to each row is based on the values in one or more columns specified in the ORDER BY clause. The DENSE RANK function is similar to the …
Plotly is a powerful data visualization library that allows you to create interactive charts and graphs. With Plotly, you can create everything from simple line charts to complex 3D visualisations with ease. In this article, we’ll cover the basics of creating interactive visualizations using Plotly, and we’ll provide examples to help you get started. Getting …
Building Interactive Visualisations Using Plotly Read More »
Visualizing data is an important part of data analysis, as it allows us to explore patterns and relationships in our data. One of the most popular libraries for data visualization in Python is Matplotlib. In this blog, we’ll take a look at how to use Matplotlib, as well as another popular data visualisation library, Seaborn, …
Exploratory Data Analysis (EDA) is an essential step in data science that helps to understand the dataset better and derive insights from it. Python is a popular language for data science and analysis, and it offers several libraries for EDA. In this article, we will explore how to perform EDA using Python and its libraries. …
Data analysis and data visualisation are two closely related activities in the field of data science. Getting insights from data using statistical and computational methods is part of data analysis. This process may involve cleaning and transforming the data, and then performing various statistical tests and modeling techniques to extract insights. Once the data analysis …
LAG and LEAD are SQL analytic functions that allow you to access data from a previous or subsequent row in a query result set. LAG provides access to a previous row, while LEAD provides access to the following row. For example, imagine you have a table of sales data with columns for date, product, and …
This task requires to find Human Traffic of Stadium. We need to write a SQL query to extract records with three or more consecutive rows that have an ID and people count greater than or equal to 100. The resulting table should be sorted in ascending order by visit_date. Problem Statement Link: LeetCode Complexity: Hard Table: Stadium +—————+———+ …
The task is to write an SQL query that will retrieve the employees who have the top three highest salaries in each department of a company, based on their unique salaries. The query should return the name of the employee, their department, and their salary. The output can be in any order. Problem Statement Link: LeetCode …
Data pipelines are a crucial component of many data-driven applications. They allow us to extract data from various sources, transform and process it, and load it into a destination storage or system. Python has emerged as one of the most popular languages for building data pipelines. In this article, we will explore the basics of …
Problem Statement Link: LeetCode Complexity: Easy Given an array of integers nums which is sorted in ascending order, and an integer target, write a function to search target in nums. If target exists, then return its index. Otherwise, return -1. You must write an algorithm with O(log n) runtime complexity. Example 1: Input: nums = [-1,0,3,5,9,12], target = 9 Output: 4 Explanation: 9 exists in nums and its …
