#Apply

Tags: 5 posts

November 28, 2025 6 min read

pandas groupby() — A Practical Guide

pandas groupby() — A Practical Guide What is groupby()? groupby() splits a DataFrame into buckets based on one or more column values, lets you run a function on each bucket independently, then stitches all the results back together into one …
December 1, 2019 1 min read

Hackerrank SQL - Aggregation

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. Weather Observation Station 17 Weather Observation Station 18 Weather Observation Station 19 Weather Observation Station 20 …
December 1, 2019 2 min read

Hackerrank SQL - Advanced Select

Following problems are discussed here. To solve the same, please visit hackerrank website{:target="_blank"}. New Companies Binary Tree Nodes Occupations The PADS Type of Triangle New Companies select company.company_code, company.founder, …
April 23, 2019 1 min read

Applying functions over pandas dataframe using apply, applymap and map

Importing Packages and Datasets import pandas as pd import numpy as np data = pd.DataFrame(np.random.rand(4, 3)*100, columns=['Physics','Çhemistry','Maths'], index = ['Student 1', 'Student 2','Student …
January 1, 2019 2 min read

T-SQL - Working with subqueries and APPLY

Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL These queries works on AdventureWorks database and information regarding the same can be accessed by visiting …