Wrong time format in functions.format_dataframe() output? about hass-data-detective HOT 2 OPEN

Thanks for the heads up, I will update the notebook example when I get time

from hass-data-detective.

I guess it is more a matter of updating the detective package by enforcing the unit='s' in functions.format_dataframe() than the notebook, unless you want to pass it as a new argument when called from the notebook example?

For now, I am just redefining format_dataframe() at the beginning of my notebook so that pd.to_datetime() includes the unit='s' argument instead of relying on the one imported from functions:

def format_dataframe(df: pd.DataFrame) -> pd.DataFrame:
    """Convert states to numeric where possible and format the last_changed."""
    df["state"] = pd.to_numeric(df["state"], errors="coerce")
    df["last_updated_ts"] = pd.to_datetime(
        df["last_updated_ts"].values, errors="ignore", utc=True, unit='s'
    ).tz_localize(None)
    df = df.dropna()
    return df

from hass-data-detective.