整理一波人类的过敏源数据库

数据来源：http://allergen.org/index.php
数量：共1058种
提取超链接代码：

import pandas as pd
import openpyxl

df = pd.read_excel('allergen——database.xlsx', header = 0, index_col = 0)
d = openpyxl.load_workbook('allergen——database.xlsx').active
link = []
for i in range(1, 1060):
    if d.cell(i, 8).hyperlink is None:
        pass
    else:
        link.append(d.cell(i, 8).hyperlink.target)

df.链接 = link
df.to_excel('allergen_database.xlsx', encoding = 'utf-8')

统计传播途径代码：

import pandas as pd
import matplotlib.pyplot as plt

plt.rcParams['font.sans-serif'] = ['Arial Unicode MS']
df = pd.read_excel('allergen——database.xlsx', header = 0, index_col = 0)
data = df.过敏源暴露途径.value_counts().to_dict()
labels, values = list(data.keys()), list(data.values())
plt.pie(colors = plt.cm.get_cmap('Set3')(range(len(labels))), x = values, autopct = '%1.1f%%')
plt.legend(labels = labels, loc = 2, bbox_to_anchor = (1.05, 1.0), borderaxespad = 0.)
plt.title('过敏源传播途径占比饼状图')
plt.rcParams['savefig.dpi'] = 600
plt.tight_layout()
plt.savefig('pie_过敏源传播途径.jpg', bbox_inches = 'tight')

统计结果：

数据库资源下载：https://download.csdn.net/download/yhlhhhhh/76256430