Kizspy | Question: 31
(Choose 1 answer)
You want to filter the DataFrame df_customer to select male customers aged 40 or older (see dataset below).
Which Pandas code snippet is equivalent to the SQL query: SELECT * FROM df_customer WHERE gender =
'M' AND age >= 40?
import pandas as pd
# Create a DataFrame for customer information
customer_data = {
'customer_id': [1001, 1002, 1003, 1004, 1005],
'name': ['Alice', 'Bob', 'Charlie', 'David', 'Emma'],
'age': [30, 25, 35, 40, 45],
'gender': ['F', 'M', 'M', 'M', 'F']
df_customer = pd.DataFrame(customer_data)
A. df_filtered = df_customer[(df_customer['gender'] == 'M') & (df_customer['age'] >= 40)]
B. df_filtered = df_customer[(df_customer['gender'] == 'M') && (df_customer['age'] >= 40)]
C. df_filtered = df_customer[df_customer['gender'] == 'M' & df_customer['age'] > 40]
D. df_filtered = df_customer[(df_customer['gender'] == 'M') AND (df_customer['age'] >40)]
