Divide the dataframe1 column values with another dataframe column value

Question

I have 2 dateframes DF1 & DF2.i want perform the division for all DF2_sale column values with DF1_Expectation and update in DF1_percentage

df1 = pd.DataFrame({'Period'     : ['Jan', 'Feb', 'Mar'],
               'Sale': [10 , 20, 30],
               })
df2 = pd.DataFrame({'Loc': ['UAE'],
               'Expectation': [98],
               })

Please refer attached dataframe screens

For Pandas related questions it helps everyone if you can post a reproducible example of your data rather than a picture of some data. — David Buck
– David Buck, Commented Nov 24, 2019 at 12:56

Pawel Kam · Accepted Answer · 2019-11-24 15:08:00Z

1

To apply some operation along an axis of the DataFrame you can always use apply. For example:

df1['Percentage'] = df1['Sale'].apply(lambda x: x / df2['Expectation'])

or, if instead of a simple division you want to count percentage:

df1['Percentage'] = df1['Sale'].apply(lambda x: x * df2['Expectation'] / 100)

Details in the documentation.

edited Nov 24, 2019 at 15:08

answered Nov 24, 2019 at 13:54

Pawel Kam

2,1823 gold badges18 silver badges34 bronze badges

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

Comments

Vlad Bezden · Accepted Answer · 2019-11-24 14:18:02Z

0

You can use pandas.apply method:

import pandas as pd


df1 = pd.DataFrame({"Period": ["Jan", "Feb", "Mar"], "Sale": [10, 20, 30]})
df2 = pd.DataFrame({"Loc": ["UAE"], "Expectation": [98]})

df1['Percentage'] = df1['Sale'].apply(lambda x: x * df2['Expectation'] / 100)
print(f"df1 = {df1}")

output:

df1 =   Period  Sale  Percentage
0    Jan    10         9.8      
1    Feb    20        19.6      
2    Mar    30        29.4

answered Nov 24, 2019 at 14:18

Vlad Bezden

90.7k27 gold badges261 silver badges190 bronze badges

Collectives™ on Stack Overflow

Divide the dataframe1 column values with another dataframe column value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related