Financial data analysis pattern in Data Analysis Python - Step-by-Step Execution

Concept Flow - Financial data analysis pattern

Load financial data

↓

Clean and prepare data

↓

Calculate key metrics

↓

Visualize trends and patterns

↓

Make data-driven decisions

This flow shows the main steps in analyzing financial data: loading, cleaning, calculating metrics, visualizing, and deciding.

Execution Sample

Data Analysis Python

import pandas as pd

# Load data
fin_data = pd.read_csv('financial_data.csv')

# Calculate daily returns
fin_data['Return'] = fin_data['Close'].pct_change()

# Calculate moving average
fin_data['MA_5'] = fin_data['Close'].rolling(window=5).mean()

This code loads financial data, calculates daily returns, and computes a 5-day moving average.

Execution Table

Step	Action	Variable/Column	Value/Result
1	Load CSV file	fin_data	DataFrame with columns: Date, Open, High, Low, Close, Volume
2	Calculate daily returns	fin_data['Return']	NaN for first row, then percent change of Close price
3	Calculate 5-day moving average	fin_data['MA_5']	NaN for first 4 rows, then average of last 5 Close prices
4	Check first 7 rows	fin_data.head(7)	Shows Date, Close, Return, MA_5 columns with calculated values
5	Exit	-	All calculations done

💡 All financial metrics calculated for the dataset

Variable Tracker

Variable	Start	After Step 2	After Step 3	Final
fin_data['Return']	Not present	NaN, 0.01, -0.005, 0.02, ...	Same as after Step 2	Final daily returns with NaN for first row
fin_data['MA_5']	Not present	Not present	NaN, NaN, NaN, NaN, 100.5, 101.2, ...	Final 5-day moving averages with NaN for first 4 rows

Key Moments - 2 Insights

Why is the first value of daily returns NaN?

Because there is no previous day to compare for the first row, so pct_change() returns NaN as shown in execution_table step 2.

Why do the first 4 values of the moving average column show NaN?

A 5-day moving average needs 5 data points, so the first 4 rows don't have enough data, resulting in NaN as seen in execution_table step 3.

Visual Quiz - 3 Questions

Look at the execution table, what is the value of fin_data['Return'] at the first row?

A NaN

B 0

C 1

D -1

💡 Hint

Refer to execution_table row 2 where daily returns are calculated and first value is NaN.

At which step do we first see the 5-day moving average values calculated?

A Step 1

B Step 2

C Step 3

D Step 4

💡 Hint

Check execution_table row 3 describing calculation of MA_5.

If the window size for moving average changed to 3, how would the NaN count in fin_data['MA_5'] change?

A More NaNs at start

B Fewer NaNs at start

C No NaNs at all

D NaNs remain the same

💡 Hint

Refer to key_moments about how window size affects initial NaNs in moving average.

Concept Snapshot

Financial data analysis pattern:
1. Load data (CSV or other)
2. Clean and prepare (handle missing data)
3. Calculate metrics (returns, moving averages)
4. Visualize trends (charts, graphs)
5. Use insights to decide

Full Transcript

This lesson shows how to analyze financial data step-by-step. First, we load the data from a CSV file into a DataFrame. Then, we calculate daily returns using percent change of closing prices. Next, we compute a 5-day moving average to smooth price trends. We observe that the first daily return is NaN because there is no previous day to compare. Similarly, the first 4 moving average values are NaN because we need 5 days of data to calculate it. These steps help us understand price movements and prepare for visualization or decision-making.