Skip to content
Advertisement

How can I create a new pandas DataFrame out of an existing one applying a function to every column without a for loop?

A simplified script I have now working is as follows:

columns = df.columns.tolist()

df1=pd.DataFrame()

for i in columns:
    df1[i]=[random.uniform(-1*(df[i].std()*3),(df[i].std()*3))+df[i].mean()]

How can I get the same result (a one row dataframe) with a simpler, more efficient code?

Advertisement

Answer

Try with apply:

df1 = df.apply(lambda x: random.uniform(-3*x.std(),3*x.std())+x.mean())
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement