# 引入pandas import pandas as pd #

河豚的圆筒　195天前　南京

# 引入pandas import pandas as pd # ## 修改代码开始## ## 读取年终奖金发放表 df = pd.read_excel(' 🔗',sheet_name='年终奖金发放表',converters={"证照号码":str}) # describe()描述统计，通过ronud函数保 ...全文

河豚的圆筒　195天前　南京

# 引入pandas import pandas as pd # ## 修改代码开始## ## 读取销售部门薪酬表 df= pd.read_excel(' 🔗',sheet_name='销售部门薪酬') # 计算应付工资 df['应付工资']=df['底薪']+df['卖房套数']*df['抽成'] # ...全文

河豚的圆筒　196天前　南京

#引入pandas import pandas as pd # ## 修改代码开始## ## 读取excel表格 df = pd.read_excel(' 🔗',sheet_name='年终奖金发放表') #df1为筛选的姓名、年终奖金，个税三列 df1 =df[['姓名','年终奖金','个税']] ...全文

河豚的圆筒　196天前　南京

# 引入pandas import pandas as pd # ## 修改代码开始## ## 读取Excel文件 df=pd.read_excel(' 🔗',sheet_name="工资结算明细表") #计算单位支付合计数 df['单位支付合计数 '] = df['应付工资']+df ...全文

河豚的圆筒　196天前　南京

# 引入pandas import pandas as pd # ## 修改代码开始## ## 创建data数据 data=[['华为电脑',50000,0.05,250,60,395.85,79.17], ['打印机',3400,0.05,170,60,269.15,53.83], ['空调',2200,0.05,110,60,174.15,34.83], ['小轿车',400000,0.05,20000,120,6333.34,3166.67]] ...全文