定义函数\排序\筛选

import pandas as pd

books = pd.read_excel('D:/Code/.vscode/Books.xlsx',index_col='ID')
# books['price'] = books['ListPrice'] * books['Discount']

# for i in range(5,16):
    
#     books['Price'].at[i] = books['ListPrice'].at[i] * books['Discount'].at[i]
    
# books['ListPrice'] = books['ListPrice'] +2        
# def add_2(x):
    
#     return x+2
 
# books['ListPrice'] = books['ListPrice'].apply(add_2)

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

print(books)
=====================================================

import pandas as pd 
products = pd.read_excel('D:/Code/.vscode/list.xlsx',index_col='ID')
products.sort_values(by=['Worthy','Price'],inplace=True,ascending=[True,False])
# products.sort_values(by='Price',inplace=True,ascending=False)
print(products)

============================================================
import pandas as pd 

# def age_18_to_30(a):
#     return 18<= a <30


# def level_a(s):
#     return 85<= s <100

students = pd.read_excel('D:/Code/.vscode/Students.xlsx',index_col='ID')
# students = students.loc[students['Age'].apply(age_18_to_30)].loc[students['Score'].apply(level_a)]
# students = students.loc[students.Age.apply(age_18_to_30)].loc[students.Score.apply(level_a)]

students = students.loc[students.Age.apply(lambda a: 18<= a <30)] \
    .loc[students.Score.apply(lambda s:85<= s <100)]

print(students)