我有一个读取excel文档的python程序。我只需要允许某些列组合的第一次出现。例如:
A | B
-------------
1. 200 | 201
2. 200 | 202
3. 200 | 201
4. 200 | 203
5. 201 | 201
6. 201 | 202
.............
我想删除/跳过找到重复项的第三行并将其写入 CSV 文件。这是我迄今为止一直在尝试的功能。但它不起作用。
def validateExcel(filename):
xls=xlrd.open_workbook(filename)
setcount = 0
column = 0
count = 0
# sheetcount = 0
for sheet in xls.sheets():
header=""
# sheetcount = sheetcount + 1
number_of_rows = sheet.nrows
number_of_columns = sheet.ncols
sheetname = sheet.name
mylist = []
for row in range (1, number_of_rows):
mylist = []
for col in range(0, 2):
mylist.append(sheet.cell_value(row, col))
print mylist
myset = set(mylist)
print myset
它对我有用:在python 2.7中
def validateExcel(filename):
xls=xlrd.open_workbook(filename)
setcount = 0
column = 0
count = 0
# sheetcount = 0
for sheet in xls.sheets():
header=""
# sheetcount = sheetcount + 1
number_of_rows = sheet.nrows
number_of_columns = sheet.ncols
sheetname = sheet.name
mylist = []
for row in range(1, number_of_rows):
mylist.append((sheet.cell_value(row, 0), sheet.cell_value(row, 1)))
myset = sorted(set(mylist), key=mylist.index)
return myset
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句