Exporting to Excel in Data Analysis Python - Mini Project: Build & Apply

Exporting to Excel

📖 Scenario: You work in a small business that tracks monthly sales data. You want to save this data into an Excel file so you can share it with your team easily.

🎯 Goal: Create a small sales data table using a dictionary, convert it to a DataFrame, and export it to an Excel file named sales_data.xlsx.

📋 What You'll Learn

Create a dictionary called sales with the exact keys 'Month' and 'Sales' and the exact values ['January', 'February', 'March'] and [2500, 3000, 2800] respectively.

Create a variable called df that converts the sales dictionary into a pandas DataFrame.

Create a variable called filename and set it to the string 'sales_data.xlsx'.

Use the to_excel method on df to export the data to the Excel file named by filename.

Print the string 'Data exported to sales_data.xlsx' to confirm the export.

💡 Why This Matters

🌍 Real World

Saving data to Excel files is common in business to share reports and summaries with team members who use spreadsheet software.

💼 Career

Data analysts and scientists often export data to Excel for easy viewing, sharing, and further analysis by non-technical stakeholders.

1

Create the sales data dictionary

Create a dictionary called sales with the keys 'Month' and 'Sales'. Set the value for 'Month' to the list ['January', 'February', 'March'] and the value for 'Sales' to the list [2500, 3000, 2800].

Data Analysis Python

# Create the sales dictionary with months and sales
# Your code here

Need a hint?

Use curly braces {} to create a dictionary. The keys are strings and the values are lists.

2

Convert the dictionary to a DataFrame and set filename

Import pandas as pd. Create a variable called df that converts the sales dictionary into a pandas DataFrame using pd.DataFrame(sales). Then create a variable called filename and set it to the string 'sales_data.xlsx'.

Data Analysis Python

import pandas as pd

# Convert sales dictionary to DataFrame
# Your code here

# Set the filename
# Your code here

Need a hint?

Use pd.DataFrame() to convert the dictionary to a DataFrame. Assign the filename as a string.

3

Export the DataFrame to an Excel file

Use the to_excel method on the DataFrame df to export the data to an Excel file named by the variable filename. Use the argument index=False to avoid saving the row numbers.

Data Analysis Python

# Export the DataFrame to Excel without the index
# Your code here

Need a hint?

Call df.to_excel() with the filename and index=False to export without row numbers.

4

Print confirmation message

Print the exact string 'Data exported to sales_data.xlsx' to confirm the export was successful.

Data Analysis Python

# Print confirmation message
# Your code here

Need a hint?

Use print() to show the confirmation message exactly as given.