Section13_final_project

PART 1: DATA PREP

Email from Ski Shop Manager:

Our Excel expert has been skiing for 3 months now, and we really need to analyze our Black Friday sales data!

In the Excel workbook attached, you'll see that we're missing data for taxes and totals. Can you fill in those rows of data using Python?

You'll find more detailed instructions in the notebook attached, and I'll follow up shortly with more steps for the analysis.

Key Objectives

1. Read in data from an Excel workbook
2. Define a function that prints cell contents
3. Use for loops to manipulate Excel data
4. Import and call a previously saved function
5. Write data into Excel cells
6. Save an Excel workbook

PART 2: DATA ANALYSIS

Email from Ski Shop Manager:

We need to calculate some key metrics by aggregating our data, which will be super helpful for determining how well we performed during Black Friday.

Key Objectives

1. Define a function that sums Excel columns, leveraging a list comprehension
2. Apply numerical functions to calculating KPIs
3. Use set operations to find unique items
4. Create a dictionary using nested loops
5. Challenge: Write a function that calculates the sum of an Excel column, grouped by the unique values in another column