第六节 调用函数

books = pd.read_excel('C:/books.xlsx',index_col='ID')
books['Price'] = books['ListPrice']*books['Discount']
print(books)

一列×一列

i in books.index:
    books['Price'].at[i] = books['ListPrice'].at[i]*books['Discount'].at[i]

另解，每一个元素×每一个元素

for i in range(5,16):
    books['Price'].at[i] = books['ListPrice'].at[i]*books['Discount'].at[i]

从4行到15行的乘法

def add_2(x):
    return x+2
books['ListPrice'] = books['ListPrice'].apply(add_2)

利用函数实现运算，每列+2

books['ListPrice'] = books['ListPrice'].apply(lambda x:x+2)

另解，利用lambda表达式实现每列+2功能