Other

%load_ext autoreload
%autoreload 2

from tulip.data.fred import get_series

import plotly.graph_objects as go

from pandas.tseries.offsets import MonthBegin, MonthEnd
from tulip.themes import blog_theme as THEME
from tulip.plots import add_plot_theme
import pyfredapi as pf

# Pull in data
core_pce_level = get_series_from_fred(series_id="PCEPILFE")
# This natively pulls in what is called a DataFrame
core_pce_level.head(5)

# We transform the dataframe into a series (we only want value)
core_pce_level = core_pce_level.set_index('date')['value']
core_pce_level.tail(5)

date
2025-07-01    126.430
2025-08-01    126.714
2025-09-01    126.954
2025-10-01    127.218
2025-11-01    127.422
Name: value, dtype: float64

core_pce_change = core_pce_level.pct_change(6) * 2
core_pce_change = core_pce_change.dropna()
core_pce_change

date
1959-07-01    0.022063
1959-08-01    0.023722
1959-09-01    0.026656
1959-10-01    0.025048
1959-11-01    0.026301
                ...   
2025-07-01    0.029586
2025-08-01    0.025075
2025-09-01    0.026934
2025-10-01    0.027346
2025-11-01    0.025948
Name: value, Length: 797, dtype: float64

# if in doubt...
# core_pce_level.to_clipboard()

# Plotly
fig = go.Figure()

# median line
fig.add_trace(go.Scatter(
    x=core_pce_change.index,
    y=core_pce_change,
    mode='lines',
    name='US CORE PCE (6m change, ann., SA)',
    # line=dict(color=BC.LINE)
))

fig = add_plot_theme(
    fig,
    title='Sticky inflation is falling rapidly', 
    subtitle='US CORE PCE', 
    source='FRED, Still Press',
    x_axis_label='', 
    y_axis_label='',
    extend_months = 12,
    theme='fund'
)

fig

# Plotly
fig = go.Figure()

# median line
fig.add_trace(go.Scatter(
    x=core_pce_change.index,
    y=core_pce_change,
    mode='lines',
    name='US CORE PCE (6m change, ann., SA)',
    # line=dict(color=BC.LINE)
))

fig = add_plot_theme(
    fig,
    title='Sticky inflation is falling rapidly', 
    subtitle='US CORE PCE', 
    source='FRED, Still Press',
    x_axis_label='', 
    y_axis_label='',
    extend_months = 12,
    theme='blog'
)

fig