Pandas: Filtering records by label or index in a given dataframe

Last update on April 04 2025 13:43:03 (UTC/GMT +8 hours)

15. Range-based Filtering and Column Selection

Write a Pandas program to filter the specified columns and records by range from 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
w_a_con = pd.read_csv('world_alcohol.csv')
print("World alcohol consumption sample data:")
print(w_a_con.head())
print("\nFiltering records by label or index:")
print(w_a_con.loc[0:4, ["WHO region", "Beverage Types"]])

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]

Filtering records by label or index:
        WHO region Beverage Types
0  Western Pacific           Wine
1         Americas          Other
2           Africa           Wine
3         Americas           Beer
4         Americas           Beer

Click to download world_alcohol.csv

For more Practice: Solve these Related Problems:

• Write a Pandas program to select a specified range of rows and columns, and then filter rows where 'Display Value' falls between two given numbers.
• Write a Pandas program to extract a subset of columns and then filter rows based on a range condition on the 'Year' column.
• Write a Pandas program to slice the dataset for a range of rows, then apply a numeric filter on 'Display Value' within that slice.
• Write a Pandas program to select specific columns for a block of rows and then filter the rows where 'Year' is within a certain range.

Python Code Editor:

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

Previous: Write a Pandas program to find out the records where consumption of beverages per person average >=4 and Beverage Types is Beer, Wine, Spirits from world alcohol consumption dataset.