import fredapi as fa

from dotenv import dotenv_values

config = dotenv_values(".env")

import pandas as pd
fred = fa.Fred(config["FRED_API_KEY"])

cp = fred.get_series("PCOFFOTMUSDM")

cp = cp.dropna()
cp_df = pd.DataFrame({"date": cp.index, "cents_per_lb": cp.values})
cp_df["cents_per_lb"] = cp_df["cents_per_lb"].round(3)

cp_df.to_csv(config["CP_DATA_FILE"], index=True)