Python读excel去重

@Python读excel去重

Python读excel去重

excel里某一行重去，去掉这一行，直接上代码

一段漂亮的代码

// An highlighted block
import xlrd                             #打开excel文件
import math;

#将创建的属性字段删除——读取
data = xlrd.open_workbook('PoiDownload_fz11resout.xls')   #打开Excel文件读取数据
sh = data.sheet_by_name("PoiDownload_福州11resout")       #通过工作簿名称获取(excel下面的表单)
print(sh.nrows)                         #行数
print(sh.ncols)                         #列数
n=0
i=0

#写入
file = open('PoiDownload_fz11resout-resout.xls', 'w', encoding='gbk')
# shuxing = ['uid', 'name', 'bdlocal', 'x','y', 'adress', 'city', 'class']
shuxing = ['uid', 'shuxing']
for i in range(len(shuxing)):
    file.write(shuxing[i])
    file.write('\t')
file.write("\n")

uidlist = []
uid = sh.cell_value(0, 0)
file.write(uid)
uidlist.append(uid)
file.write("\t")
shuxing = sh.cell_value(0,1)
file.write(shuxing)
file.write("\t")
file.write("\n")

for n in range(1,sh.nrows):
    uid = sh.cell_value(n,0)
    if uid in uidlist:
        continue
    else:
        uidlist.append(uid)
        file.write(uid)
        file.write("\t")
        shuxing = sh.cell_value(n, 1)
        file.write(shuxing)
        file.write("\t")
        file.write("\n")
file.close()