CODEWITHSUNDEEP
pythonpandasnumpydataframe
user1922364
user1922364

Reputation: 573

Calculating Interest Rates Python Dataframe

I Need to calculate the compund interest rate so, lets say I have a Dataframe like that:

   days
1   10
2   15
3   20

What I want to get is (suppose the interest rate is 1% every day:

    days   interst rate
1   10     10,46%
2   15     16,10%
3   20     22,02%

My code is as follows:

def inclusao_juros (x):
    dias = df_arrumada_4['Prazo Medio']
    return ((1.0009723)^dias)-1

df_arrumada_4['juros_acumulado'] = df_arrumada_4['Prazo Medio'].apply(inclusao_juros)

What should I do??? Tks

Upvotes: 2

Views: 1080

Answers (2)

BENY
BENY

Reputation: 323306

IIUC

pd.Series([1.01]*len(df)).pow(df.reset_index().days,0).sub(1)
Out[695]: 
0    0.104622
1    0.160969
2    0.220190
dtype: float64

Jez's : pd.Series([1.01]*len(df),index=df.index).pow(df.days,0).sub(1)

Or using your apply 

df.days.apply(lambda x: 1.01**x -1)
Out[697]: 
1    0.104622
2    0.160969
3    0.220190
Name: days, dtype: float64

Upvotes: 1

jezrael
jezrael

Reputation: 862771

I think you need numpy.power:

df['new'] = np.power(1.01, df['days']) - 1
print (df)
   days       new
1    10  0.104622
2    15  0.160969
3    20  0.220190

Upvotes: 2

Related Questions