Styling and themes in Data Analysis Python - Step-by-Step Execution

Concept Flow - Styling and themes

Start with DataFrame

↓

Choose style method

↓

Apply built-in or custom style

↓

Render styled DataFrame

↓

View output with colors/fonts

↓

Optionally save or export styled output

The flow shows starting with data, applying styles or themes, then rendering the styled table for better visual understanding.

Execution Sample

Data Analysis Python

import pandas as pd

df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})

styled = df.style.highlight_max(axis=0)

styled

This code creates a DataFrame and highlights the maximum value in each column.

Execution Table

Step	Action	DataFrame State	Style Applied	Output Description
1	Create DataFrame	{'A': [1,2], 'B': [3,4]}	None	Plain DataFrame with values
2	Call style.highlight_max(axis=0)	Same DataFrame	Highlight max per column	Max values in columns A and B will be highlighted
3	Render styled DataFrame	Same DataFrame	Highlight max per column	Output shows cells with max values colored (2 in A, 4 in B)
4	End	Same DataFrame	Highlight max per column	Styling applied successfully, ready for display or export

💡 Styling applied and rendering complete, no further steps

Variable Tracker

Variable	Start	After style applied	Final
df	{'A': [1,2], 'B': [3,4]}	{'A': [1,2], 'B': [3,4]}	{'A': [1,2], 'B': [3,4]}
styled	None	Styler object with highlight_max style	Styler object with highlight_max style

Key Moments - 2 Insights

Why doesn't the original DataFrame 'df' change after applying style?

Styling returns a new Styler object without modifying the original DataFrame, as shown in execution_table step 2 and variable_tracker where 'df' stays the same.

How does the highlight_max style decide which cells to color?

It checks each column for the maximum value and applies color only to those cells, as seen in execution_table step 3 where max values 2 and 4 are highlighted.

Visual Quiz - 3 Questions

Look at the execution_table at step 3, which values are highlighted?

A 1 in column A and 3 in column B

B 2 in column A and 4 in column B

C All values in column A

D No values are highlighted

💡 Hint

Refer to the 'Style Applied' and 'Output Description' columns in step 3 of execution_table

According to variable_tracker, what is the value of 'df' after styling is applied?

A Original DataFrame unchanged

B Empty DataFrame

C DataFrame with highlighted cells

D None

💡 Hint

Check the 'df' row values in variable_tracker after style applied

If we change highlight_max to highlight_min, what changes in the execution_table output?

A No cells will be highlighted

B Maximum values will still be highlighted

C Minimum values in each column will be highlighted instead of maximum

D All cells will be highlighted

💡 Hint

Think about how highlight_max works and what highlight_min would do differently

Concept Snapshot

Styling and themes in pandas:
- Use df.style to start styling
- Apply built-in methods like highlight_max or custom functions
- Styling returns a Styler object, original data unchanged
- Rendered output shows colors/fonts for better data insight
- Can export styled tables to HTML for reports

Full Transcript

This lesson shows how to style pandas DataFrames using the style property. We start with a DataFrame of numbers. Then we apply a style method, highlight_max, which colors the highest values in each column. The original DataFrame stays the same; styling creates a new Styler object. When rendered, the output shows colored cells for max values, making it easier to spot important data. This process helps make data tables clearer and more visually appealing for analysis or reports.