-CDA考试官方模拟题库

备考刷题，请到

CDA认证小程序

"数据如下： import pandas as pd df = pd.DataFrame({ 'city': ['Beijing', 'Shanghai', 'Beijing', 'Guangzhou', 'Shanghai'], 'price': [100, 200, 150, 80, 120], 'score': [60, 85, 75, 55, 95] }) 如果希望选出城市为 ""Shanghai"" 且 price 在 100~200（含边界）之间，且 score 在 80~100（含边界）之间的行，下列哪一条语句最合适？"

A. df[(df['city'] == 'Shanghai') & (df['price'].between(100, 200)) & (df['score'].between(80, 100))]

B. df.query("city = 'Shanghai' and price.between(100, 200) and score.between(80, 100)")

C. df.query("city == 'Shanghai' and price between 100 and 200 and score between 80 and 100")

D. df[(df['city'] == 'Shanghai') and (df['price'].between(100, 200)) and (df['score'].between(80, 100))]

上一题

下一题

题目解析

题目评论(0)

query中可以使用series.between 但不能用 between… and…. C错误,并且等于判断要用==而不是= B错误。and 不能直接用于 Pandas Series 的布尔运算，应使用 & D选项错误。