Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started