商品信息管理系统-增删查改

 初级程序，没有用mysql。只导入了pandas库。

附上全代码与程序框架

import pandas as pd
goods_info=pd.DataFrame(None,columns=['id','sname','kcl','xsl','category'])
#goods_info= pd.read_excel(r'D:\VRP\logi_node.xlsx')
goods_info.set_index('id')

def add1(temp1,temp2,temp3,temp4,temp5):       #1增加信息
        goods_info.loc[temp1,'id']=temp1
        goods_info.loc[temp1,'sname']=temp2
        goods_info.loc[temp1,'kcl']=temp3
        goods_info.loc[temp1,'xsl']=temp4
        goods_info.loc[temp1,'category']=temp5
        name=goods_info.loc[temp1,'sname']
        print(f"{(name)}信息增加成功\n") 

def delete1(temp):                              #2删除信息
    name=goods_info.loc[temp,'sname']
    goods_info.drop(index = temp, inplace = True)

    print(f"{(name)}信息增加成功\n") 

def update1(temp):                              #3修改信息
        flag=1
        while flag:
            print("选出你要修改的数据")
            print("1:  修改商品名称　　　　　　2:   修改商品库存")
            print("3:  修改销售量            4:   修改品类 ")
            a = int(input("输入相应数字:"))
            if a==1:
                b=input("输入修改后的商品名称:")
                goods_info.loc[temp,'sname']=b
                flag=0
            elif a==2:
                b=int(input("输入修改后的商品库存:"))
                goods_info.loc[temp,'kcl']=b
                flag=0
            elif a==3:
                b=int(input("输入修改后的销售量:"))
                goods_info.loc[temp,'xsl']=b
                flag=0
            elif a==4:
                b=input("输入修改后的品类:")
                goods_info.loc[temp,'category']=b
                flag=0
            else:
                print("输入数字错误，重新输入\n")
        print("修改数据信息成功\n")  
def find1():                               #4查找数据
    while True:
        print("1:  按名称查找　　　　　　2:   按品类查找 ")
        print("3:  查询待补充库存信息      4:   查询销售量 ")
        print("5:  查询销售比例　　　　6:   退出 \n  ")
        a=int(input("输入相应的数字:"))   
        if a==1:
            b=input("输入查找名称:")
            print(goods_info.loc[lambda df: df['sname'] == b])
        elif a==2:
            b=input("输入品类:")
            print(goods_info.loc[lambda df: df['category'] == b])     
        elif a==3:
            print(goods_info.loc[lambda df: df['kcl'] < 5])   
        elif a==4:
            print(goods_info[['sname','xsl']])
        elif a==5:
            # d=goods_info['xsl'].sum()
            goods_info[u'sale_rate'] = (goods_info[u'xsl'])/sum(goods_info[u'xsl'])    
            goods_info[u'sale_rate'] =goods_info[u'sale_rate'].apply(lambda x: format(x, '.2%'))
            # goods_info.insert(5, "sale-rate", sale_rate_l)
            print(goods_info[['sname','sale_rate']])
            goods_info.drop('sale_rate',axis=1,inplace=True)
        elif a==6:                                      #6退出
            break
        else:
            print("输入错误，重新输入")           

def findall():                                 #5查看所有数据
    if len(len(goods_info)) == 0:
        print("表无数据,请新增\n")   
    else:
        print(goods_info)

def run():
    
    while True:
        print("------------------------商品管理系统----------------------:")
        print("1:  添加商品信息　　　　　　2:   删除商品信息 ")
        print("3:  修改商品信息            4:   查找商品信息 ")
        print("5:  输出所有商品信息　　　　6:   退出 \n  ")
        a=int(input("输入相应的数字:"))          
        if a==1:
            temp1=int(input("输入商品编号:"))
            temp2=input("输入学商品名称:")
            temp3=int(input("输入商品库存"))
            temp4=int(input("输入商品销售量:"))
            temp5=input("输入品类:")
            add1(temp1,temp2,temp3,temp4,temp5)         #1增加信息
            print("\n") 
        elif a==2:                                      #2删除信息
            temp=int(input("输入删除商品的编号:"))
            delete1(temp)
            print("\n")
        elif a==3:                                      #3修改信息
            temp=int(input("输入要修改的商品编号:"))
            update1(temp)
            print("\n")
        elif a==4:                                      #4查找数据
            # temp=int(input("输入商品编号:"))
            find1()
            
        elif a==5:                                      #5查看数据
            print(goods_info)
            print("\n")
        elif a==6:                                      #6退出
            print('------------------系统关闭,谢谢使用----------------------')
            break
        else:
            print("输入错误，重新输入")


if __name__ == '__main__':
    run()