/Python/Impute data by using groupby and transform

Impute data by using groupby and transform

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

Source: stackoverflow.com

Impute data by using groupby and transform

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

Source: stackoverflow.com

Similar codes

7 votes175 views3 answers
Pandas empty dataframe with column names
Python
13 votes155 views1 answer
Selenium getting started
Python
2 votes159 views2 answers
'flask' is not recognized as an internal or external command, operable program or batch file.
Python
85 votes167 views6 answers
How to activate virtual environment in python
Python
0 vote212 views2 answers
Python dict for k v
Python
0 vote234 views1 answer
Django.com
Python Django
7 votes174 views3 answers
Python selenium click element
Python
0 vote121 views1 answer
Django include all columns admin show
Python
0 vote203 views1 answer
Initial TypedMultipleChoiceField django
Python Django
-1 vote161 views2 answers
Python how to insert values into string
Python