pandas库尝试修改excel文件

Question

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

Answer 1

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