| 123456789101112131415161718192021222324252627282930313233 |
- import pandas as pd
- import pymysql
- # Excel数据
- df = pd.read_excel('扫货成功数据_2026-04-26 (1).xlsx')
- row = df.iloc[39]
- wear_value = row.iloc[3] # 0.036458
- goods_id = str(row.iloc[1]) # 1133139
- deal_price = row.iloc[6] # NaN
- print('Excel数据:')
- print(f' 序号: {row.iloc[0]}')
- print(f' 饰品ID: {goods_id}')
- print(f' 磨损值: {wear_value}')
- print(f' 成交价格(人民币): {deal_price}')
- print()
- # 数据库数据
- conn = pymysql.connect(host='125.122.32.114', port=3306, user='root', password='Buff123456', database='buff')
- cursor = conn.cursor(pymysql.cursors.DictCursor)
- cursor.execute('SELECT * FROM buff_goods_float_price WHERE goods_id = %s', (goods_id,))
- rows = cursor.fetchall()
- cursor.close()
- conn.close()
- print('数据库中的区间 (goods_id=1133139):')
- for r in rows:
- in_range = r['min_float'] <= wear_value <= r['max_float']
- marker = ' <-- 匹配' if in_range else ''
- print(f" {r['min_float']:.2f} - {r['max_float']:.2f}: qj_min_price={r['qj_min_price']}{marker}")
- print()
- print('问题原因: 成交价格(人民币)为空(NaN)，无法计算利润')
|
