当前位置:软件学习 > Excel >>

用python查找excel里面的某一列的重复数据,剔除之后打印

[python] 
import xlrd  
     
def open_excel(fileName="simple.xls"): 
    try: 
        fileHandler = xlrd.open_workbook(fileName) 
        return fileHandler 
    except Exception, e: 
        print str(e)     
         
def scan_excel(sheet_name1=u'Sheet1'): 
    handler = open_excel() 
    page = handler.sheet_by_name(sheet_name1) 
    return page 
     
def trim_cols(index=0): 
    page = scan_excel() 
    col1 = page.col_values(index) 
    col2 = [] 
     
    for item in col1: 
        if item not in col2: 
            col2.append(item) 
    print col1 
    print col2 
     
def main(): 
    trim_cols() 
     
if __name__ == "__main__": 
    main()     
打印结果:
[1.0, 2.0, 3.0, 4.0, 1.0, 2.0, 3.0, 4.0]
[1.0, 2.0, 3.0, 4.0]
补充:Web开发 , Python ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,