Mendefinisikan fungsi agregasi

Terkejut dengan tingginya porsi item bertema tanda (sign) dalam inventarisnya, peritel memutuskan bahwa masuk akal untuk melakukan agregasi lebih lanjut untuk berbagai kategori agar dapat mengeksplorasi data dengan lebih baik. Ini terlihat sepele bagi Anda, tetapi peritel sebelumnya bahkan belum mampu melakukan analisis deskriptif dasar atas transaksinya dan itemnya.

Peritel meminta Anda melakukan agregasi untuk kategori candles, bags, dan boxes. Untuk menyederhanakan tugas, Anda memutuskan untuk menulis sebuah fungsi. Fungsi ini akan menerima string yang berisi kategori suatu item. Lalu fungsi akan menghasilkan sebuah DataFrame yang menunjukkan apakah setiap transaksi mencakup item dari kategori tersebut. Perhatikan bahwa pandas telah diimpor untuk Anda sebagai pd. Selain itu, data telah diimpor dalam format one-hot encoded sebagai onehot.

Latihan ini merupakan bagian dari kursus

Analisis Market Basket dengan Python

Instruksi latihan

Lengkapi list comprehension yang mengekstrak subset header kolom.
Pilih kolom untuk item yang ingin Anda agregasikan.
Lakukan agregasi menggunakan fungsi aggregate() untuk bags, boxes, dan candles dengan menggunakan string bag, box, dan candle.

Latihan interaktif langsung praktik

Cobalah latihan ini dengan melengkapi kode contoh ini.

def aggregate(item):
	# Select the column headers for sign items in onehot
	item_headers = [i for i in ____.columns if i.lower().find(item)>=0]

	# Select columns of sign items
	item_columns = onehot[____]

	# Return category of aggregated items
	return item_columns.sum(axis = 1) >= 1.0

# Aggregate items for the bags, boxes, and candles categories  
bags = aggregate('bag')
boxes = aggregate('____')
candles = ____

Edit dan Jalankan Kode

Latihan ini merupakan bagian dari kursus

Analisis Market Basket dengan Python

SkillTag.level.intermediateSkillTag.label

4.9+

Mulai Kursus Gratis

In this chapter, you’ll learn the basics of Market Basket Analysis: association rules, metrics, and pruning. You’ll then apply these concepts to help a small grocery store improve its promotional and product placement efforts.

Exercise 1: What is market basket analysis?Exercise 2: The basics of market basket analysis Exercise 3: Cross-selling products Exercise 4: Identifying association rules Exercise 5: Multiple antecedents and consequents Exercise 6: Preparing data for market basket analysis Exercise 7: Generating association rules Exercise 8: The simplest metric Exercise 9: One-hot encoding transaction data Exercise 10: Computing the support metric

Association rules tell us that two or more items are related. Metrics allow us to quantify the usefulness of those relationships. In this chapter, you’ll apply six metrics to evaluate association rules: supply, confidence, lift, conviction, leverage, and Zhang's metric. You’ll then use association rules and metrics to assist a library and an e-book seller.

Exercise 1: Confidence and lift Exercise 2: Recommending books with support Exercise 3: Refining support with confidence Exercise 4: Further refinement with lift Exercise 5: Leverage and conviction Exercise 6: Lift versus leverage Exercise 7: Computing conviction Exercise 8: Computing conviction with a function Exercise 9: Promoting ebooks with conviction Exercise 10: Association and dissociation Exercise 11: Computing association and dissociation Exercise 12: Defining Zhang's metric Exercise 13: Applying Zhang's metric Exercise 14: Advanced rules Exercise 15: Filtering with support and conviction Exercise 16: Using multi-metric filtering to cross-promote books

The fundamental problem of Market Basket Analysis is determining how to translate vast amounts of customer decisions into a small number of useful rules. This process typically starts with the application of the Apriori algorithm and involves the use of additional strategies, such as pruning and aggregation. In this chapter, you’ll learn how to use these methods and will ultimately apply them in exercises where you assist a retailer in selecting a physical store layout and performing product cross-promotions.

Exercise 1: Agregasi Exercise 2: Melakukan agregasi Exercise 3: Mendefinisikan fungsi agregasi

Latihan Saat Ini

Exercise 4: Algoritma Apriori Exercise 5: Pruning dan Apriori Exercise 6: Mengidentifikasi itemset yang sering muncul dengan Apriori Exercise 7: Memilih ambang dukungan (support)Exercise 8: Pemangkasan hasil Apriori dasar Exercise 9: Membuat aturan asosiasi Exercise 10: Pruning dengan lift Exercise 11: Pemangkasan dengan confidence Exercise 12: Pemangkasan lanjutan pada hasil Apriori Exercise 13: Agregasi dan pemfilteran Exercise 14: Menerapkan aturan Zhang Exercise 15: Penyaringan lanjutan dengan banyak metrik

In this final chapter, you’ll learn how visualizations are used to guide the pruning process and summarize final results, which will typically take the form of itemsets or rules. You’ll master the three most useful visualizations -- heatmaps, scatterplots, and parallel coordinates plots – and will apply them to assist a movie streaming service.

Exercise 1: Heatmaps Exercise 2: Visualizing itemset support Exercise 3: Heatmaps with lift Exercise 4: Interpreting heatmaps Exercise 5: Scatterplots Exercise 6: Pruning with scatterplots Exercise 7: Optimality of the support-confidence border Exercise 8: Parallel coordinates plot Exercise 9: Using parallel coordinates to visualize rules Exercise 10: Refining a parallel coordinates plot Exercise 11: Congratulations!