apriori的关联分析

apriori的关联分析。

import pandas as pd
import numpy as np
from mlxtend.frequent_patterns import apriori,association_rules
from mlxtend.preprocessing import TransactionEncoder 

xlsx_file = "C:/Users/DELL/Desktop/20210202/test.xlsx"

xlsx_feature = pd.read_excel(xlsx_file) #usecols属性读取excel文件中的指定列，列号从0起始；skiprows属性跳过excel文件中指定行，行号从0起始
#通过pd.DataFrame将excel文件转化为DataFrame类型，多此一举
feature = pd.DataFrame(xlsx_feature)
feature = feature.set_index('type')
feature.astype(np.uint8)

result =apriori(df,min_support=0.2,use_colnames=True)
result_complet = association_rules(result,min_threshold=0.2)

result = result_complet.sort_values(by=['lift'],ascending = False)
result.head(10)