vastorbit.datasets.load_smart_meters

vastorbit.datasets.load_smart_meters(schema: str | None = None, name: str = 'smart_meters') → VastFrame

Ingests the smart meters dataset into the VAST DataBase.

This dataset is ideal for time series and regression models. If a table with the same name and schema already exists, this function creates a VastFrame from the input relation.

Parameters:

• schema (str, optional) – Schema of the new relation. If empty, the temporary schema is used.

• name (str, optional) – Name of the new relation.

Returns:

The smart meters VastFrame.

Return type:

VastFrame

Examples

from vastorbit.datasets import load_smart_meters

vdf = load_smart_meters()

	📅 time Timestamp(3)	123 val Decimal(11, 7)	123 id Integer
1	2015-06-19 17:30:00	0.05	0
2	2015-06-20 20:30:00	0.177	0
3	2015-06-21 02:00:00	0.347	0
4	2015-06-21 07:15:00	0.086	0
5	2015-06-21 23:45:00	0.098	0
6	2015-06-22 00:30:00	0.109	0
7	2015-06-22 21:00:00	0.379	0
8	2015-06-23 03:30:00	0.017	0
9	2015-06-23 10:45:00	0.145	0
10	2015-06-23 11:45:00	0.21	0
11	2015-06-23 21:30:00	0.099	0
12	2015-06-24 02:15:00	0.156	0
13	2015-06-24 18:30:00	0.419	0
14	2015-06-25 03:45:00	0.096	0
15	2015-06-26 00:15:00	0.379	0
16	2015-06-26 09:30:00	0.142	0
17	2015-06-28 04:00:00	0.12	0
18	2015-06-29 00:30:00	0.373	0
19	2015-06-29 04:00:00	0.013	0
20	2015-06-29 22:45:00	0.434	0
21	2015-07-01 09:00:00	0.064	0
22	2015-07-01 11:15:00	0.056	0
23	2015-07-01 21:45:00	0.202	0
24	2015-07-02 06:45:00	0.17	0
25	2015-07-02 10:45:00	0.105	0
26	2015-07-03 06:15:00	0.331	0
27	2015-07-03 18:15:00	0.714	0
28	2015-07-04 17:30:00	0.176	0
29	2015-07-04 23:45:00	0.207	0
30	2015-07-05 00:45:00	0.081	0
31	2015-07-05 08:15:00	0.188	0
32	2015-07-05 10:30:00	0.165	0
33	2015-07-06 00:45:00	0.231	0
34	2015-07-06 14:45:00	0.275	0
35	2015-07-08 22:30:00	0.125	0
36	2015-07-08 23:15:00	0.217	0
37	2015-07-09 17:30:00	0.92	0
38	2015-07-09 19:30:00	0.155	0
39	2015-07-10 06:45:00	0.094	0
40	2015-07-10 07:45:00	0.435	0
41	2015-07-10 12:45:00	0.036	0
42	2015-07-11 06:00:00	0.051	0
43	2015-07-11 15:15:00	0.145	0
44	2015-07-12 02:30:00	0.034	0
45	2015-07-12 03:15:00	0.067	0
46	2015-07-12 03:45:00	0.081	0
47	2015-07-12 16:00:00	0.113	0
48	2015-07-13 00:00:00	0.433	0
49	2015-07-13 12:45:00	0.197	0
50	2015-07-13 18:00:00	0.736	0
51	2015-07-13 21:15:00	0.91	0
52	2015-07-15 18:30:00	2.497	0
53	2015-07-16 14:30:00	0.483	0
54	2015-07-17 11:45:00	0.537	0
55	2015-07-17 12:15:00	0.261	0
56	2015-07-20 17:15:00	0.208	0
57	2015-07-20 21:00:00	0.649	0
58	2015-07-21 01:30:00	1.144	0
59	2015-07-21 11:45:00	0.167	0
60	2015-07-21 15:45:00	0.274	0
61	2015-07-21 16:30:00	0.302	0
62	2015-07-22 12:30:00	0.05	0
63	2015-07-22 14:00:00	0.403	0
64	2015-07-22 17:45:00	0.901	0
65	2015-07-23 04:45:00	0.051	0
66	2015-07-23 11:30:00	1.236	0
67	2015-07-24 09:45:00	0.59	0
68	2015-07-24 19:15:00	0.39	0
69	2015-07-26 12:45:00	0.228	0
70	2015-07-27 04:15:00	0.037	0
71	2015-07-28 13:30:00	0.425	0
72	2015-07-28 14:45:00	0.149	0
73	2015-07-31 21:45:00	0.232	0
74	2015-07-31 23:45:00	0.106	0
75	2015-08-01 00:45:00	0.218	0
76	2015-08-02 06:45:00	0.127	0
77	2015-08-02 12:30:00	0.088	0
78	2015-08-02 16:00:00	0.22	0
79	2015-08-02 16:30:00	0.22	0
80	2015-08-03 03:00:00	0.026	0
81	2015-08-03 05:45:00	0.1	0
82	2015-08-03 09:45:00	0.08	0
83	2015-08-04 01:15:00	0.26	0
84	2015-08-04 13:00:00	1.101	0
85	2015-08-06 06:00:00	0.055	0
86	2015-08-06 08:45:00	0.022	0
87	2015-08-06 12:00:00	0.32	0
88	2015-08-06 16:30:00	0.327	0
89	2015-08-07 00:15:00	0.539	0
90	2015-08-07 07:45:00	0.022	0
91	2015-08-07 14:30:00	0.509	0
92	2015-08-07 17:30:00	0.196	0
93	2015-08-07 22:15:00	0.251	0
94	2015-08-08 04:45:00	0.088	0
95	2015-08-09 21:45:00	2.465	0
96	2015-08-10 10:30:00	0.05	0
97	2015-08-11 05:00:00	0.08	0
98	2015-08-11 16:45:00	0.065	0
99	2015-08-11 20:15:00	0.066	0
100	2015-08-11 20:45:00	0.145	0

Rows: 1-100 | Columns: 3