How to use pd.concat with an un initiated dataframe?

Question

I want to be able to concat dataframe results to memory as they go through a function and end up with a whole new dataframe with just the results. How do I do this without having a dataframe all ready created before the function? For example:

import pandas as pd
import numpy as np   

rand_df = pd.DataFrame({'A': [ 'x','x','y','y','z','z','z'],'B': np.random.randn(7)})

    def myFuncOnDF(df, row):
        df = df.groupby(['A']).get_group(row).describe()

    myFuncOnDF(rand_df, 'x')
    myFuncOnDF(rand_df, 'y')
    myFuncOnDF(rand_df, 'z')

How would I concat the results of myFuncOnDF() to a new dataframe that doesn't exist yet?

piRSquared · Accepted Answer · 2017-04-02 17:27:17Z

5

Not really sure what you expected but groupby and describeaccomplishes the same thing

rand_df.groupby('A').B.describe().unstack()

   count      mean       std       min       25%       50%       75%       max
A                                                                             
x    2.0  0.362296  0.371891  0.099329  0.230813  0.362296  0.493779  0.625262
y    2.0  0.473104  0.188415  0.339874  0.406489  0.473104  0.539719  0.606333
z    3.0  0.506519  1.087770 -0.607696 -0.023102  0.561492  1.063626  1.565760

edited Apr 2, 2017 at 17:27

answered Apr 2, 2017 at 16:29

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maxim Over a year ago

This is a great feature I knew nothing about. Thanks for sharing!

Collectives™ on Stack Overflow

How to use pd.concat with an un initiated dataframe?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related