# Fetch LIVE data from FRED API
from dotenv import load_dotenv
from datetime import datetime
import pyfredapi as pf

load_dotenv()

print(f"Notebook executed at: {datetime.now()}")
print()

# Fetch latest US unemployment rate
data = pf.get_series(series_id="UNRATE")
latest = data.tail(3)
print("Latest US Unemployment Rate (from FRED):")
print(latest[["date", "value"]].to_string(index=False))

# Basic math
x = 10
y = 20
print(f"x + y = {x + y}")
print(f"x * y = {x * y}")

# List comprehension
squares = [i**2 for i in range(10)]
print(f"Squares: {squares}")

import pandas as pd
import numpy as np

# Create a simple dataframe
df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'Score': [85.5, 90.2, 78.9]
})
df

import plotly.express as px

# Simple plot
fig = px.bar(df, x='Name', y='Score', title='Test Scores')
fig.show()