Kizspy | Question: 9
(Choose 1 answer)
You have a DataFrame df containing product information, including columns product_id, category, and price.
You want to filter the DataFrame to select products in the 'Electronics' category with prices between $100 and
$200.( See the data below)
import pandas as pd
# Create a DataFrame for product information
product_data = {
'product_id': [1, 2, 3, 4, 5],
'category': ['Electronics', 'Electronics', 'Clothing', 'Electronics', 'Clothing"],
'price': [150, 180, 50, 120, 210]}
df_product = pd.DataFrame(product_data)
Provide pandas command and SQL query to get data based on the requirement?
A. df_filtered=df[(df['category'] == 'Electronics') & (df['price'] >= 100) & (df['price'] <= 200)]
SELECT * FROM df WHERE category = 'Electronics' AND price BETWEEN 100 AND 200
B. df_filtered=df[(df['category'] == 'Electronics') & (df['price'] >= 100) & (df['price'] <= 200)]
SELECT * FROM df WHERE category = 'Electronics' OR price BETWEEN 100 AND 200
C. df_filtered=df[(df['category'] == 'Electronics') | (df['price'] >= 100) & (df['price'] <= 200)]
SELECT * FROM df WHERE category = 'Electronics' AND price BETWEEN 100 AND 200
D. df_filtered=df[(df['category'] == 'Electronics') && (df['price'] >= 100) && (df['price'] <= 200)]
SELECT * FROM df WHERE category = 'Electronics' AND price BETWEEN 100 AND 200
