Python处理EML解析数据，统计及排序并使用pyecharts可视化柱状图输出

 

1. 针对之前eml解析出来的数据，做一个每个内容的统计排序及图形化输出。例如收件人，发件人等等

 

纯记录，我太菜了

# -*- coding:utf-8 -*-
from typing import Dict, Any, List

import openpyxl
from collections import Counter

infos1 = []
infos2 = []
infos3 = []
infos4 = []
# 目标文件
destinefile = 'result_le.xlsx'

#创建wb
info_file = openpyxl.load_workbook(destinefile)
#获取sheet
info_sheet = info_file.get_sheet_by_name('result')
#创建sheet
sheet2 = info_file.create_sheet('From')
sheet3 = info_file.create_sheet('To')
sheet4 = info_file.create_sheet('Cc')
sheet5 = info_file.create_sheet('Subject')
#获取sheet的行数
row_count = info_sheet.max_row
print(row_count)
#获取sheet的内容
for row in range(1, row_count):
    # 1为要统计的列序号，注意从1开始，存入list info
    infos1.append(info_sheet.cell(row,1).value)
    infos2.append(info_sheet.cell(row,2).value)
    infos3.append(info_sheet