首先是这样一个数据集:
进行价格计算:
import pandas as pd
books = pd.read_excel("C:/Users/Administrator/Desktop/Books.xlsx",index_col="ID")
books.Price = books.ListPrice*books.Discount
books["Price"] = books["ListPrice"]*books["Discount"]#和上一行代码相同效果,不同写法
另一种写法,可以range进行填充:
for i in range(1,5):
books["Price"].at[i] = books["ListPrice"].at[i] * books["Discount"].at[i]