Python将列表中字典元素合并为单个字典的方法及Excel数据处理示例

def list_dict(list_data):
  dict_data = {}
  for i in list_data:
    key, = i
    value, = i.values()
    dict_data[key] = value
  return dict_data


if __name__ == '__main__':
  list_data = [{'aa': 'aa'},
         {'bb': 'bb'},
         {'cc': 'cc'},
         {'dd': 'dd'}]
  print list_dict(list_data)

#coding=utf8
from selenium import webdriver
import xlrd,os 
 
dirname = os.path.dirname(os.path.dirname(__file__))
#join时，第二参数首位不能加/，加r的意思是原生字符串
filename = os.path.join(dirname,r'testdata/select_school.xlsx')
 
#row,col获取哪行那列的值
def run_select_shool(row=1,col=1):
  #打开excel文件读取数据
  data = xlrd.open_workbook(filename)
  table = data.sheet_by_index(0)
 
  row = row-1
  col = col-1
  #获取整行整列的值
  nrows = table.row_values(row)
  ncols = table.col_values(0)
  print(nrows[col])
 
def run_select_school2(filename,sheet_index=0,table_header_row=0):
  # 打开excel文件读取数据
  data = xlrd.open_workbook(filename)
  table = data.sheet_by_index(sheet_index)
  nrows = table.nrows
  nclos = table.ncols
 
  #获取表头行的信息，为一个列表
  header_row_data = table.row_values(table_header_row)
  #将每行的信息放入一个字典，再将字典放入一个列表中
  list = []
  for rownum in range(1,nrows):
    rowdata = table.row_values(rownum)
    #如果rowdata有值，
    if rowdata:
      dict = {}
      for j in range(0,len(header_row_data)):
        #将excel中的数据分别设置成键值对的形式，放入字典，如‘标题'：‘name'；
        dict[header_row_data[j]] = rowdata[j]
      list.append(dict)
  print(list)
  return list 
 
run_select_school2(filename)