Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

Students also viewed these Databases questions