python遍历excel_如何遍历excel中的列并在python中操作它？

我有2个excel xlsm文件。第一个文件我将2列数据合并到一个字典中，我想将该字典的键与第二个文件中的数据列表进行比较。如果来自两个数据的密钥和“代码”都是等价的，那么“代码变得更改为与密钥配对的值。我不知道如何执行此过程我所做的全部是制作字典并对它们进行比较。import itertools #module that includes functions to work with iterable data

import pandas as pd # this allows for data manipulation and analysis to and

from excel

from pandas import ExcelWriter

from pandas import ExcelFile

import pickle # its a module that publishes objects or other data so they

can be saved to a file and opened again later

import os.path # allows to work/manipulate on file names and paths

import xlrd # A module that allows python to read excel files

import xlwings as xw # module that helps to tie python, excel, and pandas

to take data from a database, manipulate it and present it in a spreadsheet

from tkinter import * # standard GUI

from tkinter.filedialog import askopenfilename # module with open and save

functions