New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Latency: Need to unnest "statistics" column and cast to appropriate dtypes #70

Open

blaylockbk opened this issue Dec 19, 2024 · 0 comments

Labels

Latency

Owner

blaylockbk commented Dec 19, 2024 •

edited

Loading

from synoptic import Latency

df = Latency(
    stid="wbb",
    start=datetime(2024, 6, 6),
    end=datetime(2024, 6, 6, 1),
    stats="all",
).df()

# SynopticPy should unnest "statistics" column for you...
df.unnest("statistics")

Need to cast columns to appropriate type (datetime, duration, etc.)

This service reports the delay time (in minutes) of an observation received at our ingest servers relative to the observation’s timestamp.
https://docs.synopticdata.com/services/latency

Duration columns

value
average
maximum
minimum
standard_deviation
median

Datetime columns

date_time
start
end
maxtime
mintime

Count column should be an uint64, right?

Restricted_data and Restricted metadata should be bool

blaylockbk added the Latency label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment