﻿ Pandas: Filter by combine 2 logical operators in a given dataframe - w3resource

# Pandas: Filter by combine 2 logical operators in a given dataframe

## Pandas Filter: Exercise-19 with Solution

Write a Pandas program to filter all records where the average consumption of beverages per person from .5 to 2.50 in world alcohol consumption dataset.

Test Data:

```   Year       WHO region                Country Beverage Types  Display Value
0  1986  Western Pacific               Viet Nam           Wine           0.00
1  1986         Americas                Uruguay          Other           0.50
2  1985           Africa           Cte d'Ivoire           Wine           1.62
3  1986         Americas               Colombia           Beer           4.27
4  1987         Americas  Saint Kitts and Nevis           Beer           1.98
```

Sample Solution:

Python Code :

``````import pandas as pd
# World alcohol consumption data
print("World alcohol consumption sample data:")
print("\nFilter all records where the average consumption of beverages per person from .5 to 2.50.:")
print(w_a_con[(w_a_con['Display Value'] < 2.5) & (w_a_con['Display Value']>.5)].head())
``````

Sample Output:

```World alcohol consumption sample data:
Year       WHO region      ...      Beverage Types Display Value
0  1986  Western Pacific      ...                Wine          0.00
1  1986         Americas      ...               Other          0.50
2  1985           Africa      ...                Wine          1.62
3  1986         Americas      ...                Beer          4.27
4  1987         Americas      ...                Beer          1.98

[5 rows x 5 columns]

Filter all records where the average consumption of beverages per person from .5 to 2.50.:
Year WHO region      ...      Beverage Types Display Value
2   1985     Africa      ...                Wine          1.62
4   1987   Americas      ...                Beer          1.98
8   1986   Americas      ...             Spirits          1.55
11  1989   Americas      ...                Beer          0.62
17  1989     Africa      ...                Beer          2.23

[5 rows x 5 columns]
```

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz

﻿

## Python: Tips of the Day

Merging two dicts in Python 3.5+ with a single expression

Example:

```# How to merge two dictionaries
# in Python 3.5+

x = {'p': 1, 'q': 3}
y = {'q': 5, 'r': 8}

z = {**x, **y}

z
{'r': 4, 'p': 1, 'q': 3}

z = dict(x, **y)
print(z)
```

Output:

```{'p': 1, 'q': 5, 'r': 8}
```