impute data by using groupby and transform

Filthy Flatworm answered on August 10, 2020 Popularity 9/10 Helpfulness 3/10

answer impute data by using groupby and transform

related impute data by using groupby and transform

impute data by using groupby and transform

Comment

import pandas as pd
from datetime import datetime

def generate_data():
    ...

t = datetime.now()
df = generate_data()
df['value'] = df.groupby(['category', 'name'])['value']\
    .transform(lambda x: x.fillna(x.mean()))
print(datetime.now()-t)

# 0:00:00.016012

t = datetime.now()
df = generate_data()
df["value"] = df.groupby(['category', 'name'])\
    .transform(lambda x: x.fillna(x.mean()))['value']
print(datetime.now()-t)

# 0:00:00.030022

Popularity 9/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: group-by python transform using

Link to this answer
Share Copy Link

Contributed on Aug 10 2020

Filthy Flatworm

0 Answers Avg Quality 2/10

Closely Related Answers

impute data by using groupby and transform

Comment

df['value'] = df.groupby(['category', 'name'])['value']\
    .transform(lambda x: x.fillna(x.mean()))

Popularity 9/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on Aug 10 2020

Filthy Flatworm

0 Answers Avg Quality 2/10

impute data by using groupby and transform

Contents

More Related Answers

impute data by using groupby and transform

Closely Related Answers

impute data by using groupby and transform

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.