I have 2 dataframes in python pandas

Dataframe 1

```
User_id  zipcode

1        12345

2        23456

3        34567

```

Dataframe 2

```
ZipCodeLowerBound ZipCodeUpperBound Region

10000             19999             1

20000             29999             2

30000             39999             3

```

How can I map in the Region to dataframe 1 with the condition `if(df1.zipcode>=df2.ZipCodeLowerBound and df1.zipcode<=df2.ZipCodeUpperBound)` using pandas merge