1)Use Python to solve questions A database has 5 transactions. Let min sup = 60% and min.conf 80%. TID items_bought {М, О, N, K, E, Y} {D, O, N, K, E, Y } {М, А, К, Е} {M, U, C, K, Y} {С, О, О, К, I,E} T100 T200 T300 T400 Т500 (a) Find all frequent itemsets using Apriori (b) List all of the strong association rules (with support s and confidence c) matching the following metarule, where X is a variable representing customers, and item; denotes variables representing items (e.g., "A", "B", etc.): Vx E transaction, buys(X, item,) A buys(X, item2) buys(X, item3) [s, c

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
i need the answer quickly
1)Use Python to solve questions
A database has 5 transactions. Let min_sup = 60% and min.conf
80%.
TID
items.bought
{М, О, N, K, E, Y}
{D, O, N, K, E, Y }
{М, А, К, Е}
{M, U, C, K, Y}
{С, О, О, К, I,E}
T100
T200
T300
T400
Т500
(a) Find all frequent itemsets using Apriori
(b) List all of the strong association rules (with supports and confidence c) matching the following
metarule, where X is a variable representing customers, and item; denotes variables representing
items (e.g., "A", "B", etc.):
Vx E transaction, buys(X, item1) A buys(X, item2) = buys(X, item3) [s, c]
2)Use Python to solve questions
A database has four transactions. Let min_sup = 60% and min.conf = 80%.
cust ID
items_bought (in the form of brand-item.category)
{King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread}
{Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread}
{Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie}
{Wonder-Bread, Sunset-Milk, Dairyland-Cheese}
TID
01
T100
02
T200
01
T300
03
T400
(a) At the granularity of item.category (e.g., item; could be "Milk"), for the following rule template,
VX e transaction, buys(X, itemı) A buys(X, item2) = buys(X, item3) [s, c]
list the frequent k-itemset for the largest k, and all of the strong association rules (with their
support s and confidence c) containing the frequent k-itemset for the largest k.
(b) At the granularity of brand-item.category (e.g., item; could be "Sunset-Milk"), for the following
rule template,
X € customer, buys(X, item1) A buys(X, item2) buys(X, item3)
list the frequent k-itemset for the largest k (but do not print any rules).
Transcribed Image Text:1)Use Python to solve questions A database has 5 transactions. Let min_sup = 60% and min.conf 80%. TID items.bought {М, О, N, K, E, Y} {D, O, N, K, E, Y } {М, А, К, Е} {M, U, C, K, Y} {С, О, О, К, I,E} T100 T200 T300 T400 Т500 (a) Find all frequent itemsets using Apriori (b) List all of the strong association rules (with supports and confidence c) matching the following metarule, where X is a variable representing customers, and item; denotes variables representing items (e.g., "A", "B", etc.): Vx E transaction, buys(X, item1) A buys(X, item2) = buys(X, item3) [s, c] 2)Use Python to solve questions A database has four transactions. Let min_sup = 60% and min.conf = 80%. cust ID items_bought (in the form of brand-item.category) {King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread} {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread} {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie} {Wonder-Bread, Sunset-Milk, Dairyland-Cheese} TID 01 T100 02 T200 01 T300 03 T400 (a) At the granularity of item.category (e.g., item; could be "Milk"), for the following rule template, VX e transaction, buys(X, itemı) A buys(X, item2) = buys(X, item3) [s, c] list the frequent k-itemset for the largest k, and all of the strong association rules (with their support s and confidence c) containing the frequent k-itemset for the largest k. (b) At the granularity of brand-item.category (e.g., item; could be "Sunset-Milk"), for the following rule template, X € customer, buys(X, item1) A buys(X, item2) buys(X, item3) list the frequent k-itemset for the largest k (but do not print any rules).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education