How to fill the python dataframe column value based on other column value?

Question

Consider my first dataframe as below

Area id   shop id  Name

1         100      Apple
1         101      Apple
2         102      Banana
2         103      Banana
2         104      Jack
3         105      Orange
3         106      Orange
4         107      Kiwi
4         108      Kiwi
4         109      Cherry
4         110      Grape
4         111      Grape

My second dataframe as below

 shop id   Price    revenue
   

   100      140      2000
   101      150      3000
   101      150      3500
   102      130      2200
   102      130      3300
   102      130      3500
   102      130      2700
   103      135      3100
   103      130      3300

I need new dataframe as below to fill the shop name based on shop id in the first data frame

shop id     Name        Price    revenue
       
    
       100    Apple      140      2000
       101    Apple      150      3000
       101    Apple      150      3500
       102    Banana     130      2200
       102    Banana     130      3300
       102    Banana     130      3500
       102    Banana     130      2700
       103    Banana     135      3100
       103    Banana     130      3300

Answer 1

Using pd.merge to get your result.

# Create dataframe
data1 = { ... }
df1 = pd.DataFrame(data1)
data2 = { ... }
df2 = pd.DataFrame(data2)

# Merge the dfs based on 'shop id'
result_df = pd.merge(df2, df1[['shop id', 'Name']], on='shop id')
result_df = result_df[['shop id', 'Name', 'Price', 'revenue']]
print(result_df)