pandas库尝试修改excel文件

将net inome列中大于100的值全部改为1000. 怎么用pandas进行实现啊

import pandas as pd
df = pd.read_excel('xxx.xlsx')
df[df['net inome'] > 100]['net inome'] = 1000
df.head()

import pandas as pd
from random import randint
lst = [[randint(1,500) for i in range(3)] for j in range(5)]
df1 = pd.DataFrame(lst)
df1.columns = ['H1','H2','H3']
print(df1)
df1['H3'] = df1['H3'].apply(lambda x: 1000 if x>100 else x)
print(df1)