替换单元格的值:
将'A'列第5行的值替换/设置为'xxx'
import pandas as pd
df = pd.read_excel('file.xlsx', sheet_name=None, header=0)
df.loc[5, 'A'] = 'xxx'
替换某列中多个符合条件的单元格的值:
df.loc[df['A']=='xxx', 'A'] = 'XXX'
替换单元格的值:
将'A'列第5行的值替换/设置为'xxx'
import pandas as pd
df = pd.read_excel('file.xlsx', sheet_name=None, header=0)
df.loc[5, 'A'] = 'xxx'
替换某列中多个符合条件的单元格的值:
df.loc[df['A']=='xxx', 'A'] = 'XXX'