python pandas向excel中增删记录（简单的商品目录展示、商品的上架和下架）

import pandas as pd

while True:
    df_info = pd.read_excel("pro_info.xlsx") # 读取商品文件信息
    df = df_info.set_index('number') # 将编号转换为索引
    print(df)# 打印已经存在的信息

    operating = [ "01—上架商品", "02-下架商品"]# 操作指南

    def del_pro(number):# 删除记录
        df_info = df.drop(number)
        df_info.to_excel("pro_info.xlsx")

    def add_pro(number, name, price):# 增加记录
        name_index = number
        df_info.loc[name_index] = [number, name, price]
        df_info.to_excel("pro_info.xlsx", index=False)

    print("-----------商品操作------------")
    print(operating)
    operate = input("输入序号进行操作:")

    if operate == '01':
        number = input("添加商品编号：")
        name = input("输入商品名称:")
        price = input("输入价格:")
        add_pro(number,name,price)

    if operate == '02':
        number = input("输入商品编号:")
        del_pro(number)

    elif operate == "q":
        break