Problem Statement The task is to write a function that validates whether a given postal code string meets certain conditions such as being a six-digit number with specific digits at specific positions and having a certain sum of digits. Link: HackerRank Complexity: Hard Solution: The solution to this problem involves the use of regular expressions. We define …
Problem Statement You are given a list of K lists, each of which contains N positive integers. You need to pick one number from each list such that the sum of the chosen numbers is less than or equal to a given integer M. Find the maximum possible value of the sum of the chosen …
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 …
