求助！！！怎么实现这个 有三列数据，怎么让第一列数据根据第二

你最下面的两次1为什么填充的a a？？不应该是 j x 吗？？

import xlrd
from openpyxl import Workbook
from pprint import pprint
dataset = []
workbook = xlrd.open_workbook(r'D:\book.xlsx')
table = workbook.sheets()[0] # 获取一个工作表
# 循环获取行内容保存
for row in range(table.nrows):
····dataset.append(table.row_values(row))
pprint(dataset)
zero, one = 0, 0
for i in range(len(dataset)):
····if dataset[i][1] == 0:
········dataset[i][0] = dataset[i][2]
········zero = i
····elif dataset[i][1] == 1:
········dataset[i][0] = dataset[zero][2]
········one = i
····elif dataset[i][1] == 2:
········dataset[i][0] = dataset[one][2]
pprint(dataset)
# 保存
wb = Workbook()
ws1 = wb.active
for conten in dataset:
····ws1.append(conten)
wb.save(r'D:\book2.xlsx')

缩进错误，if 和elif 后面的代码 缩进四个空格

同学，有问题可以来我小店咨询，简单的都可以无偿帮您解答的【python爬虫spss数据分析学生代做matlab程序r语言https://m.tb.cn/h.V4scFDU 需要代做也可以哦