← 返回题库
初级

查询商品编号和名称(系统初始化-基础档案查询)

未完成
初级参考 完整示例代码供参考,建议自己理解后重新输入
def solve():
    import sqlite3
    import pandas as pd
    
    conn = sqlite3.connect(':memory:')
    
    base_url = 'https://liangdaima.com/static/data/crm/state_00/'
    
    tables = ['suppliers', 'customers', 'products', 
              'stock_in', 'stock_in_items', 
              'stock_out', 'stock_out_items']
    
    for table in tables:
        try:
            url = base_url + table + '.csv'
            df = pd.read_csv(url)
            df.to_sql(table, conn, index=False)
        except Exception as e:
            pass
    
    result = conn.execute('SELECT 物料编码, 物料名称 FROM products').fetchall()
    conn.close()
    return result

示例

输入
print(solve())
期望输出
[('HW001', 'Mate 50'), ('HW002', 'Mate 50'), ('HW003', 'P50'), ('HW004', 'P50 Pro'), ('XM001', '小米12X'), ('XM002', '小米12X'), ('XM003', '小米13'), ('XM004', '小米13 Pro'), ('OP001', 'OPPO Find X5'), ('OP002', 'OPPO Reno8'), ('VV001', 'vivo X80'), ('AP001', 'iPhone 14')]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号,在浏览器中直接运行 Python 代码