pandas groupby transform: multiple functions applied at the same time with custom names

Viewed 751

as the title suggests, I want to be able to do the following (best explained with some code) [pandas 0.20.1 is mandatory]

import pandas as pd
import numpy as np

a = pd.DataFrame(np.random.rand(10, 4), columns=[['a','a','b','b'], ['alfa','beta','alfa','beta',]])

def as_is(x):
    return x
def power_2(x):
    return x**2

# desired result

a.transform([as_is, power_2])

the problem is the function could be more complex than this and thus I would lose the "naming" feature as pandas.DataFrame.transform only allows for lists to be passed whereas a dictionary would have been most convenient.

going back to the basics, I got to this:

dict_funct= {'as_is': as_is, 'power_2': power_2}

def wrapper(x):
    return pd.concat({k: x.apply(v) for k,v in dict_funct.items()}, axis=1)

a.groupby(level=[0,1], axis=1).apply(wrapper)

but the output Dataframe is all nan, presumably due to multi-index columns ordering. is there any way I can fix this?

1 Answers
Related