df1['warehouse'] = df1['store'].map(df2.set_index('store_code')['warehouse'])
print (df1)

id  store address warehouse
0   1    100     xyz      Land
1   2    200     qwe       Sea
2   3    300     asd      Land
3   4    400     zxc      Land
4   5    500     bnm       Sea