Python将excel中C列不是1的数据标记为A

可以使用Python中的pandas和openpyxl模块来实现将Excel中C列不是1的数据标记为A的操作。具体步骤如下：

1. 使用pandas模块读取Excel文件，将数据存储到DataFrame对象中。

import pandas as pd

df = pd.read_excel('example.xlsx')

2. 遍历DataFrame对象的C列，判断其值是否为1，如果不是则将对应行的A列的值标记为A。

for index, row in df.iterrows():
    if row['C'] != 1:
        df.at[index, 'A'] = 'A'

3. 使用openpyxl模块将修改后的数据写入Excel文件中。

from openpyxl import load_workbook

book = load_workbook('example.xlsx')
writer = pd.ExcelWriter('example.xlsx', engine='openpyxl') 
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df.to_excel(writer, index=False)

writer.save()

完整代码如下：

import pandas as pd
from openpyxl import load_workbook

df = pd.read_excel('example.xlsx')

for index, row in df.iterrows():
    if row['C'] != 1:
        df.at[index, 'A'] = 'A'

book = load_workbook('example.xlsx')
writer = pd.ExcelWriter('example.xlsx', engine='openpyxl') 
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df.to_excel(writer, index=False)

writer.save()