Question: Question #6 1. Use pandas read csv() function to read the BlackFriday.csv file You can find the csv file in Blackboard. (Note: This is a


Question #6 1. Use pandas read csv() function to read the BlackFriday.csv file You can find the csv file in Blackboard. (Note: This is a dataset available in Kaggle. It is a dataset of 550000 observations about the black Friday in a retail store, it contains different kinds of variables either numerical or categorical. It contains missing values.) 2. Find the number of male and female in this dataset 3. Find the average purchase amount by individuals' gender 4. Find the average purchase amount by age and gender (Hint: you need to use group by with multiple item) maximum purchase amount (ascending) maximum purchase amount (descending) 5. Find the maximum purchase amount by age and city category and sort the result by the 6. Find the minimum purchase amount by gender and marital status and sort the result by the 2-6 4 2851 28534454 3-12 2 811118588154251158881685 C. 2 2 2 2 ci A A A A C A BB B A A A A A A A A A B C C CCCC CC C 2 23.45678910 12 . 14 15 16 17 18 19 20 21 23 24 25 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
