python比较excel中两列数据_python数据清洗-区分excel两列不同的值

pandas和SQL数据分析实战视频教程

A列在B列中不存在的值

# -*- coding: utf-8 -*-

"""

Created on Thu Jun 23 10:33:27 2016

@author: Administrator

"""

import xlrd

fileName="省份处理.xlsx"

#获取一个excel内首页表格

def Get_sheet1_from_oneExcel(excelFileName):

wb=xlrd.open_workbook(excelFileName)

sheet=wb.sheets()[0]

return sheet

sheet=Get_sheet1_from_oneExcel(fileName)

list_columnA=sheet.col_values(0)

list_columnB=sheet.col_values(1)

diffrence_list=[]

for i in list_columnA:

if i=="":

continue

if i not in list_columnB:

diffrence_list.append(i)

'''

diffrence_list

Out[47]: ['总局']

'''

print(diffrence_list)