Apple 2021–2025 Financial Data Visualization Analysis

Project Introduction

This project uses Python Pandas to process Apple's 5-year annual report Excel financial data, and Matplotlib to build multi-dimensional financial trend charts. It analyzes operating revenue, net profit, gross profit margin and ROE to evaluate the company’s operating scale and profitability quality.

Tech Stack

Python | Pandas | Matplotlib | Excel Data Processing | Financial Quantitative Analysis | Data Visualization

Visualization Output Charts

1. Revenue & Net Profit Trend Chart

2. Gross Margin & ROE Profitability Comparison

Core Project Functions

1. Automatically read structured Excel financial tables, auto identify year columns without hard-coded date strings
2. Extract four core financial indicators: operating revenue, net profit, gross profit margin, return on equity
3. Two independent line charts to separate "business scale analysis" and "profit efficiency analysis"
4. Solve Matplotlib Chinese font garbled problem, compatible with datetime column format

Quick Run Guide

Step 1 Install Dependencies

pip install pandas matplotlib openpyxl

Step 2 Execute Analysis Script

python apple_analysis.py