CA1 Practical
DATASET
Problem statement 1
Table Creator
Column filter: Remove card , email and Co-Email column
Row filter: To Keep ProductID starting with : prd2
Column Splitter: Split Product column
Normalizer: Apply to sales and quantity column
Use column merger for email and co-email
Groupby : With Region and Mean sales
Write Groupby output to csv
Display Groupby output with Bar chart
Problem statement 2
Table Creator
Column filter: Remove column starts with C
Handling Missing Value: Remove rows with missing ProductID
Row filter: Keep only onion
Normalizer: Apply to all numeric column
Rename age column as age Normalized
Groupby: With Category and sum profit
Write Groupby output to Excel
Display Groupby output with Bar chart
Problem statement 3
Table Creator
Column filter: Remove column ends with y
Row filter: Keep only west Region
Handling Missing Value: Replace missing value in Age by its mean
Sort the Age column
Normalizer: Apply to profit and quantity column
Groupby: With Product and sum quantity
Write Groupby output to csv
Display Groupby output with Bar chart
Problem statement 4
Table Creator
Column filter: Keep quantity ranging from 2 to 12
Row filter: Keep only Germany
Handling Missing Value: Remove rows with missing ProductID
Make all column appear A-Z order
Normalizer: Apply to all numeric column
Groupby: With Country and median quantity
Write Groupby output to Excel
Display Groupby output with Bar chart
Problem statement 5
Table Creator
Column filter: Keep quantity ranging from 2 to 12
Row filter: Keep only Non missing card
Missing Value column filter: Apply on Co-email for 20% and above
Constant Value: Add Constant Value “yes” to table
Row splitter: Country starting with U and not U
Groupby: With Country and median quantity
Write Groupby output to Excel
Display Groupby output with Bar chart
Problem statement 6
Table Creator
Column filter: Keep numeric columns
Remove Duplicates: Remove duplicate rows
Handling Missing Value: Replace missing value in Age by its mean
Row splitter: Country starting with U and not U
Use column merger for email and co-email
Groupby: With Country and median quantity
Write Groupby output to Excel
Display Groupby output with Bar chart
Problem statement 7
Table Creator
Column filter: Keep string columns
Row sampling: Keep first 5 rows
Handling Missing Value: Remove rows with missing ProductID
Row splitter: Country starting with U and not U
Column Splitter: Split Product column
Groupby: With Country and median quantity
Write Groupby output to Excel
Display Groupby output with Bar chart