How to filter by product description and retail price – Python

Here is a simple Python script using pandas library to filter the data based on Product Description containing ‘Description 1001’ and Retail Price greater than 15. Please make sure you have the pandas library installed.

import pandas as pd

# Load the data from text file into DataFrame
df = pd.read_csv('demo_products_data_text_to_table5.txt', delimiter=';')

# Filter the data based on Product Description and Retail Price (e.g., filter for Description containing 'Description 1001' and Retail Price greater than 15)
filtered_df = df[(df['Product Description'].str.contains('Description 1001')) & (df['Retail Price'] > 15)]

# Display the filtered data
print(filtered_df)

This code assumes that your text file is in the same directory as your script and is named ‘demo_products_data_text_to_table5.txt‘. If the file name or location is different, please adjust the code accordingly. You may also modify the filter conditions as needed for your specific requirements.