Python Pandas - 查询 DataFrame 的列
要查询PandasDataFrame的列，请使用query().我们正在查询以过滤记录。首先，让我们创建一个PandasDataFrame
dataFrame = pd.DataFrame({"Product": ["SmartTV", "PenDrive", "Speaker", "Earphone"],"Opening_Stock": [300, 700, 1200, 1500],"Closing_Stock": [200, 500, 1000, 900]})使用query()与条件查询列-
print(dataFrame.query('Opening_Stock >=500 & Closing_Stock < 1000 & Product.str.startswith("P").values'))示例
以下是完整的代码-
import pandas as pd
dataFrame = pd.DataFrame({"Product": ["SmartTV", "PenDrive", "Speaker", "Earphone"],"Opening_Stock": [300, 700, 1200, 1500],"Closing_Stock": [200, 500, 1000, 900]})
print"DataFrame...\n",dataFrame
#usingquery()toquerycolumns
print"\nQuerying columns to filter records...\n"
print(dataFrame.query('Opening_Stock >=500 & Closing_Stock < 1000 & Product.str.startswith("P").values'))输出结果这将产生以下输出-
DataFrame...
Closing_Stock Opening_Stock Product
0 200 300 SmartTV
1 500 700 PenDrive
2 1000 1200 Speaker
3 900 1500 Earphone
Querying columns to filter records...
Closing_Stock Opening_Stock Product
1 500 700 PenDrive热门推荐
10 新郎表白成语祝福语简短
11 祝妹妹毕业祝福语简短
12 送去考试祝福语大全简短
13 周年蛋糕祝福语简短英语
14 永远漂亮祝福语女生简短
15 祝福语大全简短赞美同学
16 潮汕生日谚语祝福语简短
17 嫂子生日英语祝福语简短
18 关于开车的祝福语简短