How to apply functions in a Group in a Pandas DataFrame?
DATA MUNGING DATA CLEANING PYTHON MACHINE LEARNING RECIPES PANDAS CHEATSHEET     ALL TAGS

How to apply functions in a Group in a Pandas DataFrame?

How to apply functions in a Group in a Pandas DataFrame?

This recipe helps you apply functions in a Group in a Pandas DataFrame

0
This data science python source code does the following: 1. Creates groups of selected variable for data preprocessing. 2.Creats your own data dictionary and converts them into Pandas dataframe format. 3. Applying groupby function to selected columns.
In [1]:
## How to apply functions in a Group in a Pandas DataFrame
def Kickstarter_Example_69():
    print()
    print(format('How to apply functions in a Group in a Pandas DataFrame','*^82'))

    import warnings
    warnings.filterwarnings("ignore")

    # load libraries
    import pandas as pd

    # Create an example dataframe
    data = {'EmployeeGroup': ['A','A','A','A','A','A','B','B','B','B','B','C','C','C','C','C'],
            'Points': [10,40,50,70,50,50,60,10,40,50,60,70,40,60,40,60]}
    df = pd.DataFrame(data)
    print('\nThe Original DataFrame'); print(df)

    # Apply A Function (Rolling Mean) To The DataFrame, By Group
    print('\nRolling Mean:'); print(df.groupby('EmployeeGroup')['Points'].apply(lambda x:x.rolling(center=False,window=2).mean()))

    # Apply A Function (Mean) To The DataFrame, By Group    
    print('\nAverage:'); print(df.groupby('EmployeeGroup')['Points'].apply(lambda x:x.mean()))

    # Apply A Function (Sum) To The DataFrame, By Group    
    print('\nSum:'); print(df.groupby('EmployeeGroup')['Points'].apply(lambda x:x.sum()))

    # Apply A Function (Max) To The DataFrame, By Group    
    print('\nMaximum:'); print(df.groupby('EmployeeGroup')['Points'].apply(lambda x:x.max()))

    # Apply A Function (Min) To The DataFrame, By Group    
    print('\nMinimum:'); print(df.groupby('EmployeeGroup')['Points'].apply(lambda x:x.min()))

Kickstarter_Example_69()
*************How to apply functions in a Group in a Pandas DataFrame**************

The Original DataFrame
   EmployeeGroup  Points
0              A      10
1              A      40
2              A      50
3              A      70
4              A      50
5              A      50
6              B      60
7              B      10
8              B      40
9              B      50
10             B      60
11             C      70
12             C      40
13             C      60
14             C      40
15             C      60

Rolling Mean:
0      NaN
1     25.0
2     45.0
3     60.0
4     60.0
5     50.0
6      NaN
7     35.0
8     25.0
9     45.0
10    55.0
11     NaN
12    55.0
13    50.0
14    50.0
15    50.0
Name: Points, dtype: float64

Average:
EmployeeGroup
A    45.0
B    44.0
C    54.0
Name: Points, dtype: float64

Sum:
EmployeeGroup
A    270
B    220
C    270
Name: Points, dtype: int64

Maximum:
EmployeeGroup
A    70
B    60
C    70
Name: Points, dtype: int64

Minimum:
EmployeeGroup
A    10
B    10
C    40
Name: Points, dtype: int64

Relevant Projects

Ecommerce product reviews - Pairwise ranking and sentiment analysis
This project analyzes a dataset containing ecommerce product reviews. The goal is to use machine learning models to perform sentiment analysis on product reviews and rank them based on relevance. Reviews play a key role in product recommendation systems.

Deep Learning with Keras in R to Predict Customer Churn
In this deep learning project, we will predict customer churn using Artificial Neural Networks and learn how to model an ANN in R with the keras deep learning package.

Predict Churn for a Telecom company using Logistic Regression
Machine Learning Project in R- Predict the customer churn of telecom sector and find out the key drivers that lead to churn. Learn how the logistic regression model using R can be used to identify the customer churn in telecom dataset.

Identifying Product Bundles from Sales Data Using R Language
In this data science project in R, we are going to talk about subjective segmentation which is a clustering technique to find out product bundles in sales data.

Time Series Forecasting with LSTM Neural Network Python
Deep Learning Project- Learn to apply deep learning paradigm to forecast univariate time series data.

Data Science Project on Wine Quality Prediction in R
In this R data science project, we will explore wine dataset to assess red wine quality. The objective of this data science project is to explore which chemical properties will influence the quality of red wines.

Learn to prepare data for your next machine learning project
Text data requires special preparation before you can start using it for any machine learning project.In this ML project, you will learn about applying Machine Learning models to create classifiers and learn how to make sense of textual data.

Ensemble Machine Learning Project - All State Insurance Claims Severity Prediction
In this ensemble machine learning project, we will predict what kind of claims an insurance company will get. This is implemented in python using ensemble machine learning algorithms.

Solving Multiple Classification use cases Using H2O
In this project, we are going to talk about H2O and functionality in terms of building Machine Learning models.

Machine Learning project for Retail Price Optimization
In this machine learning pricing project, we implement a retail price optimization algorithm using regression trees. This is one of the first steps to building a dynamic pricing model.