Python Pandas: 打印匹配第一行记录的代码优化
import pandas as pd import sys
从参数1获取文件名
filename = sys.argv[1]
读取查询条件文件
with open(filename, 'r') as file: query_conditions = file.readlines() query_conditions = [condition.strip() for condition in query_conditions]
读取results-20230616T1300.csv文件
#df = pd.read_csv('results-20230616T1300.csv',encoding='GBK') #df = pd.read_csv('items-updated-with-quotes.csv',encoding='GBK') df = pd.read_csv('interactions-data-with-likes_rocket-qat.csv',encoding='GBK')
使用集合实现查询并打印结果
for condition in query_conditions: result = df[df['ITEM_ID'] == condition] if not result.empty: print(result.iloc[0])
原文地址: https://www.cveoy.top/t/topic/qdDx 著作权归作者所有。请勿转载和采集!