Association Rule Mining Applications Across Various Business Scenarios with Python Code

Association rule mining is a common data analysis technique used to discover frequent itemsets and association rules in datasets.

1. Retail Business: Discover customer purchase associations for product bundling and promotion strategies.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read transaction data
data = pd.read_csv('transaction_data.csv')
# Transform data for mining
basket = data.groupby(['TransactionID', 'Item'])['Quantity'].sum().unstack().reset_index().fillna(0).set_index('TransactionID')
# Mine frequent itemsets
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
# Generate rules
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
# Print rules
print(rules)

2. E‑commerce: Analyze user purchase behavior to generate personalized recommendations and cross‑selling opportunities.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read purchase data
data = pd.read_csv('purchase_data.csv')
# Transform data for mining
basket = data.groupby(['UserID', 'Product'])['Quantity'].sum().unstack().reset_index().fillna(0).set_index('UserID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

3. Marketing Campaigns: Examine user behavior during campaigns to optimize strategies and increase participation.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read user behavior data
data = pd.read_csv('user_behavior.csv')
# Transform data for mining
basket = data.groupby(['UserID', 'Action'])['Count'].sum().unstack().reset_index().fillna(0).set_index('UserID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

4. Drug Recommendation: Analyze medical data to find drug usage patterns for treatment optimization.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read medical data
data = pd.read_csv('medical_data.csv')
# Transform data for mining
basket = data.groupby(['PatientID', 'Drug'])['Count'].sum().unstack().reset_index().fillna(0).set_index('PatientID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

5. Network Security: Detect malicious behavior by mining association rules from network logs.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read network log data
data = pd.read_csv('network_logs.csv')
# Transform data for mining
basket = data.groupby(['IP', 'Action'])['Count'].sum().unstack().reset_index().fillna(0).set_index('IP')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

6. Customer Relationship Management: Segment customers and personalize marketing by uncovering behavior associations.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read customer behavior data
data = pd.read_csv('customer_behavior.csv')
# Transform data for mining
basket = data.groupby(['CustomerID', 'Action'])['Count'].sum().unstack().reset_index().fillna(0).set_index('CustomerID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

7. Social Network Analysis: Identify user relationship patterns for recommendations and community detection.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read user relationship data
data = pd.read_csv('social_network_data.csv')
# Transform data for mining
basket = data.groupby(['UserID', 'Friend'])['Count'].sum().unstack().reset_index().fillna(0).set_index('UserID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

8. Travel Business: Analyze travel orders to provide personalized itinerary recommendations.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read travel order data
data = pd.read_csv('travel_order_data.csv')
# Transform data for mining
basket = data.groupby(['OrderID', 'Product'])['Quantity'].sum().unstack().reset_index().fillna(0).set_index('OrderID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

9. Market Basket Analysis: Discover product combinations in supermarket baskets for layout and promotion planning.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read market basket data
data = pd.read_csv('market_basket_data.csv')
# Transform data for mining
basket = data.groupby(['BasketID', 'Product'])['Quantity'].sum().unstack().reset_index().fillna(0).set_index('BasketID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

10. Online Advertising: Analyze ad click data to improve ad recommendation and placement strategies.

from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules

# Read ad click data
data = pd.read_csv('ad_click_data.csv')
# Transform data for mining
basket = data.groupby(['UserID', 'AdID'])['Clicks'].sum().unstack().reset_index().fillna(0).set_index('UserID')
frequent_itemsets = apriori(basket, min_support=0.1, use_colnames=True)
rules = association_rules(frequent_itemsets, metric='lift', min_threshold=1)
print(rules)

These code examples illustrate practical applications of association rule mining in diverse business contexts; you can adapt and extend them according to your own data and requirements.