vDataFrame.rolling¶
In [ ]:
vDataFrame.rolling(func: str,
window: (list, tuple),
columns: (str, list),
by: list = [],
order_by: (dict, list) = [],
name: str = "",)
Adds a new vcolumn to the vDataFrame by using an advanced analytical window function on one or two specific vcolumns.
⚠ Warning: Some window functions can significantly increase vDataFrame memory usage. You should always check the vDataFrame with the 'current_relation' method and save it with the 'to_db' method with the parameters 'inplace = True' and 'relation_type = table'
Parameters¶
| Name | Type | Optional | Description |
|---|---|---|---|
func | str | ❌ | Function to use.
|
window | list / tuple | ❌ | Window Frame Range. If two integers, it will compute a Row Window, otherwise it will compute a Time Window. For example, if set to (-5, 1), the moving windows will take 5 rows preceding and one following. If set to ('- 5 minutes', '0 minutes'), the moving window will take all the elements of the last 5 minutes. |
columns | str / list | ❌ | Input vcolumns. It can be a list of one or two elements. |
by | list | ✓ | vcolumns used in the partition. |
order_by | dict / list | ✓ | List of the vcolumns to use to sort the data using asc order or dictionary of all the sorting methods. For example, to sort by "column1" ASC and "column2" DESC, write {"column1": "asc", "column2": "desc"} |
name | str | ✓ | Name of the new vcolumn. If empty a default name based on the other parameters will be generated. |
Returns¶
vDataFrame : self
Example¶
In [1]:
from verticapy import vDataFrame
flights = vDataFrame("public.usa_flights")
display(flights)
 | Abc destination_airportVarchar(20) | 📅 scheduled_departureTimestamp | 123 departure_delayInt | 123 arrival_delayInt | Abc origin_airportVarchar(20) | Abc airlineVarchar(20) |
| 1 | 10135 | 2015-10-01 10:09:00 | -9 | -2 | 11433 | EV |
| 2 | 10135 | 2015-10-01 10:27:00 | -3 | -14 | 10397 | EV |
| 3 | 10135 | 2015-10-01 13:57:00 | -4 | 6 | 13930 | EV |
| 4 | 10135 | 2015-10-01 14:02:00 | -3 | -8 | 11433 | EV |
| 5 | 10135 | 2015-10-01 14:44:00 | 0 | -1 | 10397 | EV |
| 6 | 10135 | 2015-10-01 20:02:00 | -3 | -11 | 11433 | EV |
| 7 | 10135 | 2015-10-01 21:02:00 | -3 | 4 | 13930 | EV |
| 8 | 10135 | 2015-10-01 21:06:00 | -3 | -14 | 10397 | DL |
| 9 | 10135 | 2015-10-02 10:09:00 | -7 | -14 | 11433 | EV |
| 10 | 10135 | 2015-10-02 10:27:00 | 12 | 4 | 10397 | EV |
| 11 | 10135 | 2015-10-02 13:57:00 | -3 | -2 | 13930 | EV |
| 12 | 10135 | 2015-10-02 14:02:00 | -15 | -19 | 11433 | EV |
| 13 | 10135 | 2015-10-02 14:44:00 | -4 | -6 | 10397 | EV |
| 14 | 10135 | 2015-10-02 20:02:00 | -3 | -3 | 11433 | EV |
| 15 | 10135 | 2015-10-02 21:02:00 | 58 | 59 | 13930 | EV |
| 16 | 10135 | 2015-10-02 21:06:00 | -2 | -14 | 10397 | DL |
| 17 | 10135 | 2015-10-03 10:27:00 | -4 | -2 | 10397 | EV |
| 18 | 10135 | 2015-10-03 21:02:00 | 12 | 11 | 13930 | EV |
| 19 | 10135 | 2015-10-03 21:06:00 | -2 | -16 | 10397 | DL |
| 20 | 10135 | 2015-10-04 10:09:00 | 4 | 23 | 11433 | EV |
| 21 | 10135 | 2015-10-04 10:27:00 | 0 | 11 | 10397 | EV |
| 22 | 10135 | 2015-10-04 13:57:00 | 14 | 11 | 13930 | EV |
| 23 | 10135 | 2015-10-04 14:02:00 | -6 | -10 | 11433 | EV |
| 24 | 10135 | 2015-10-04 14:44:00 | 18 | 18 | 10397 | EV |
| 25 | 10135 | 2015-10-04 20:02:00 | 19 | 12 | 11433 | EV |
| 26 | 10135 | 2015-10-04 21:02:00 | -2 | 5 | 13930 | EV |
| 27 | 10135 | 2015-10-04 21:06:00 | -7 | -13 | 10397 | DL |
| 28 | 10135 | 2015-10-05 10:09:00 | -8 | -3 | 11433 | EV |
| 29 | 10135 | 2015-10-05 13:57:00 | -10 | -20 | 13930 | EV |
| 30 | 10135 | 2015-10-05 14:02:00 | -11 | -17 | 11433 | EV |
| 31 | 10135 | 2015-10-05 14:44:00 | 10 | 20 | 10397 | EV |
| 32 | 10135 | 2015-10-05 20:02:00 | -3 | -11 | 11433 | EV |
| 33 | 10135 | 2015-10-05 21:02:00 | -6 | -9 | 13930 | EV |
| 34 | 10135 | 2015-10-05 21:06:00 | 1 | 1 | 10397 | DL |
| 35 | 10135 | 2015-10-06 10:09:00 | -8 | -1 | 11433 | EV |
| 36 | 10135 | 2015-10-06 10:27:00 | -8 | -2 | 10397 | EV |
| 37 | 10135 | 2015-10-06 13:57:00 | -8 | -18 | 13930 | EV |
| 38 | 10135 | 2015-10-06 14:02:00 | -6 | -7 | 11433 | EV |
| 39 | 10135 | 2015-10-06 14:44:00 | -3 | -1 | 10397 | EV |
| 40 | 10135 | 2015-10-06 20:02:00 | -5 | -8 | 11433 | EV |
| 41 | 10135 | 2015-10-06 21:02:00 | -6 | -15 | 13930 | EV |
| 42 | 10135 | 2015-10-06 21:06:00 | -12 | -19 | 10397 | DL |
| 43 | 10135 | 2015-10-07 10:09:00 | -2 | 2 | 11433 | EV |
| 44 | 10135 | 2015-10-07 11:30:00 | -5 | -6 | 10397 | EV |
| 45 | 10135 | 2015-10-07 13:57:00 | -7 | -18 | 13930 | EV |
| 46 | 10135 | 2015-10-07 14:44:00 | -3 | -12 | 10397 | EV |
| 47 | 10135 | 2015-10-07 20:02:00 | -5 | -16 | 11433 | EV |
| 48 | 10135 | 2015-10-07 21:02:00 | -3 | 2 | 13930 | EV |
| 49 | 10135 | 2015-10-07 21:06:00 | -3 | -23 | 10397 | DL |
| 50 | 10135 | 2015-10-08 10:09:00 | 10 | 4 | 11433 | EV |
| 51 | 10135 | 2015-10-08 10:27:00 | 6 | -2 | 10397 | EV |
| 52 | 10135 | 2015-10-08 13:57:00 | -3 | 1 | 13930 | EV |
| 53 | 10135 | 2015-10-08 14:02:00 | 194 | 200 | 11433 | EV |
| 54 | 10135 | 2015-10-08 14:44:00 | -6 | -4 | 10397 | EV |
| 55 | 10135 | 2015-10-08 20:02:00 | -1 | 3 | 11433 | EV |
| 56 | 10135 | 2015-10-08 21:02:00 | -4 | -6 | 13930 | EV |
| 57 | 10135 | 2015-10-08 21:06:00 | -2 | -13 | 10397 | DL |
| 58 | 10135 | 2015-10-09 10:09:00 | -4 | -2 | 11433 | EV |
| 59 | 10135 | 2015-10-09 10:27:00 | -4 | -4 | 10397 | EV |
| 60 | 10135 | 2015-10-09 13:57:00 | -9 | 1 | 13930 | EV |
| 61 | 10135 | 2015-10-09 14:02:00 | 116 | 107 | 11433 | EV |
| 62 | 10135 | 2015-10-09 14:44:00 | 40 | 47 | 10397 | EV |
| 63 | 10135 | 2015-10-09 20:02:00 | 6 | 2 | 11433 | EV |
| 64 | 10135 | 2015-10-09 21:02:00 | -3 | -4 | 13930 | EV |
| 65 | 10135 | 2015-10-09 21:06:00 | -1 | 15 | 10397 | DL |
| 66 | 10135 | 2015-10-10 10:27:00 | -2 | -4 | 10397 | EV |
| 67 | 10135 | 2015-10-10 21:02:00 | -4 | 10 | 13930 | EV |
| 68 | 10135 | 2015-10-10 21:06:00 | -3 | -16 | 10397 | DL |
| 69 | 10135 | 2015-10-11 10:09:00 | -1 | -4 | 11433 | EV |
| 70 | 10135 | 2015-10-11 10:27:00 | -4 | 0 | 10397 | EV |
| 71 | 10135 | 2015-10-11 13:57:00 | -4 | -2 | 13930 | EV |
| 72 | 10135 | 2015-10-11 14:02:00 | -8 | -12 | 11433 | EV |
| 73 | 10135 | 2015-10-11 14:44:00 | 1 | 35 | 10397 | EV |
| 74 | 10135 | 2015-10-11 20:02:00 | -10 | -16 | 11433 | EV |
| 75 | 10135 | 2015-10-11 21:02:00 | -7 | -10 | 13930 | EV |
| 76 | 10135 | 2015-10-11 21:06:00 | -1 | -7 | 10397 | DL |
| 77 | 10135 | 2015-10-12 10:09:00 | -2 | 1 | 11433 | EV |
| 78 | 10135 | 2015-10-12 10:27:00 | -2 | 0 | 10397 | EV |
| 79 | 10135 | 2015-10-12 13:57:00 | -3 | 2 | 13930 | EV |
| 80 | 10135 | 2015-10-12 14:02:00 | -2 | -5 | 11433 | EV |
| 81 | 10135 | 2015-10-12 14:44:00 | -7 | -10 | 10397 | EV |
| 82 | 10135 | 2015-10-12 20:02:00 | -5 | -1 | 11433 | EV |
| 83 | 10135 | 2015-10-12 21:02:00 | 38 | 25 | 13930 | EV |
| 84 | 10135 | 2015-10-12 21:06:00 | -3 | 11 | 10397 | DL |
| 85 | 10135 | 2015-10-13 10:09:00 | 0 | 2 | 11433 | EV |
| 86 | 10135 | 2015-10-13 10:27:00 | -3 | -3 | 10397 | EV |
| 87 | 10135 | 2015-10-13 13:57:00 | -2 | 11 | 13930 | EV |
| 88 | 10135 | 2015-10-13 14:02:00 | -3 | -5 | 11433 | EV |
| 89 | 10135 | 2015-10-13 14:44:00 | -2 | -8 | 10397 | EV |
| 90 | 10135 | 2015-10-13 20:02:00 | 3 | 16 | 11433 | EV |
| 91 | 10135 | 2015-10-13 21:02:00 | -5 | -3 | 13930 | EV |
| 92 | 10135 | 2015-10-13 21:06:00 | -6 | -2 | 10397 | DL |
| 93 | 10135 | 2015-10-14 10:09:00 | -3 | -3 | 11433 | EV |
| 94 | 10135 | 2015-10-14 11:30:00 | 53 | 54 | 10397 | EV |
| 95 | 10135 | 2015-10-14 13:57:00 | -3 | 6 | 13930 | EV |
| 96 | 10135 | 2015-10-14 14:44:00 | -3 | -3 | 10397 | EV |
| 97 | 10135 | 2015-10-14 20:02:00 | 33 | 9 | 11433 | EV |
| 98 | 10135 | 2015-10-14 21:02:00 | -4 | -10 | 13930 | EV |
| 99 | 10135 | 2015-10-14 21:06:00 | 9 | 2 | 10397 | DL |
| 100 | 10135 | 2015-10-15 10:09:00 | -5 | -16 | 11433 | EV |
Rows: 1-100 | Columns: 6
In [2]:
# AVG delay using the 10 previous similar flights for the same airline
flights.rolling(func = "avg",
columns = "departure_delay",
window = (-10, -1),
by = ["origin_airport", "destination_airport", "airline"],
order_by = {"scheduled_departure": "asc"},)
Out[2]:
| Abc destination_airportVarchar(20) | 📅 scheduled_departureTimestamp | 123 departure_delayInt | 123 arrival_delayInt | Abc origin_airportVarchar(20) | Abc airlineVarchar(20) | 123 Float |
| 1 | 10135 | 2015-10-01 21:06:00 | -3 | -14 | 10397 | DL | |
| 2 | 10135 | 2015-10-02 21:06:00 | -2 | -14 | 10397 | DL | |
| 3 | 10135 | 2015-10-03 21:06:00 | -2 | -16 | 10397 | DL | |
| 4 | 10135 | 2015-10-04 21:06:00 | -7 | -13 | 10397 | DL | |
| 5 | 10135 | 2015-10-05 21:06:00 | 1 | 1 | 10397 | DL | |
| 6 | 10135 | 2015-10-06 21:06:00 | -12 | -19 | 10397 | DL | |
| 7 | 10135 | 2015-10-07 21:06:00 | -3 | -23 | 10397 | DL | |
| 8 | 10135 | 2015-10-08 21:06:00 | -2 | -13 | 10397 | DL | |
| 9 | 10135 | 2015-10-09 21:06:00 | -1 | 15 | 10397 | DL | |
| 10 | 10135 | 2015-10-10 21:06:00 | -3 | -16 | 10397 | DL | |
| 11 | 10135 | 2015-10-11 21:06:00 | -1 | -7 | 10397 | DL | |
| 12 | 10135 | 2015-10-12 21:06:00 | -3 | 11 | 10397 | DL | |
| 13 | 10135 | 2015-10-13 21:06:00 | -6 | -2 | 10397 | DL | |
| 14 | 10135 | 2015-10-14 21:06:00 | 9 | 2 | 10397 | DL | |
| 15 | 10135 | 2015-10-15 21:06:00 | 0 | -7 | 10397 | DL | |
| 16 | 10135 | 2015-10-16 21:06:00 | -1 | 7 | 10397 | DL | |
| 17 | 10135 | 2015-10-17 21:06:00 | -2 | -21 | 10397 | DL | |
| 18 | 10135 | 2015-10-18 21:06:00 | -2 | 5 | 10397 | DL | |
| 19 | 10135 | 2015-10-19 21:06:00 | 1 | 4 | 10397 | DL | |
| 20 | 10135 | 2015-10-20 21:06:00 | 9 | 0 | 10397 | DL | |
| 21 | 10135 | 2015-10-21 21:06:00 | -1 | -5 | 10397 | DL | |
| 22 | 10135 | 2015-10-22 21:06:00 | -2 | -8 | 10397 | DL | |
| 23 | 10135 | 2015-10-23 21:06:00 | 0 | -5 | 10397 | DL | |
| 24 | 10135 | 2015-10-24 21:06:00 | -2 | 0 | 10397 | DL | |
| 25 | 10135 | 2015-10-25 21:06:00 | 0 | -14 | 10397 | DL | |
| 26 | 10135 | 2015-10-26 21:06:00 | 4 | -1 | 10397 | DL | |
| 27 | 10135 | 2015-10-27 21:06:00 | -3 | -7 | 10397 | DL | |
| 28 | 10135 | 2015-10-28 21:06:00 | 0 | -12 | 10397 | DL | |
| 29 | 10135 | 2015-10-29 21:06:00 | -1 | -14 | 10397 | DL | |
| 30 | 10135 | 2015-10-30 21:06:00 | -4 | -14 | 10397 | DL | |
| 31 | 10135 | 2015-10-31 21:06:00 | -3 | -28 | 10397 | DL | |
| 32 | 10135 | 2015-10-01 10:27:00 | -3 | -14 | 10397 | EV | |
| 33 | 10135 | 2015-10-01 14:44:00 | 0 | -1 | 10397 | EV | |
| 34 | 10135 | 2015-10-02 10:27:00 | 12 | 4 | 10397 | EV | |
| 35 | 10135 | 2015-10-02 14:44:00 | -4 | -6 | 10397 | EV | |
| 36 | 10135 | 2015-10-03 10:27:00 | -4 | -2 | 10397 | EV | |
| 37 | 10135 | 2015-10-04 10:27:00 | 0 | 11 | 10397 | EV | |
| 38 | 10135 | 2015-10-04 14:44:00 | 18 | 18 | 10397 | EV | |
| 39 | 10135 | 2015-10-05 14:44:00 | 10 | 20 | 10397 | EV | |
| 40 | 10135 | 2015-10-06 10:27:00 | -8 | -2 | 10397 | EV | |
| 41 | 10135 | 2015-10-06 14:44:00 | -3 | -1 | 10397 | EV | |
| 42 | 10135 | 2015-10-07 11:30:00 | -5 | -6 | 10397 | EV | |
| 43 | 10135 | 2015-10-07 14:44:00 | -3 | -12 | 10397 | EV | |
| 44 | 10135 | 2015-10-08 10:27:00 | 6 | -2 | 10397 | EV | |
| 45 | 10135 | 2015-10-08 14:44:00 | -6 | -4 | 10397 | EV | |
| 46 | 10135 | 2015-10-09 10:27:00 | -4 | -4 | 10397 | EV | |
| 47 | 10135 | 2015-10-09 14:44:00 | 40 | 47 | 10397 | EV | |
| 48 | 10135 | 2015-10-10 10:27:00 | -2 | -4 | 10397 | EV | |
| 49 | 10135 | 2015-10-11 10:27:00 | -4 | 0 | 10397 | EV | |
| 50 | 10135 | 2015-10-11 14:44:00 | 1 | 35 | 10397 | EV | |
| 51 | 10135 | 2015-10-12 10:27:00 | -2 | 0 | 10397 | EV | |
| 52 | 10135 | 2015-10-12 14:44:00 | -7 | -10 | 10397 | EV | |
| 53 | 10135 | 2015-10-13 10:27:00 | -3 | -3 | 10397 | EV | |
| 54 | 10135 | 2015-10-13 14:44:00 | -2 | -8 | 10397 | EV | |
| 55 | 10135 | 2015-10-14 11:30:00 | 53 | 54 | 10397 | EV | |
| 56 | 10135 | 2015-10-14 14:44:00 | -3 | -3 | 10397 | EV | |
| 57 | 10135 | 2015-10-15 10:27:00 | -5 | -12 | 10397 | EV | |
| 58 | 10135 | 2015-10-15 14:44:00 | 9 | 23 | 10397 | EV | |
| 59 | 10135 | 2015-10-16 10:27:00 | -5 | -22 | 10397 | EV | |
| 60 | 10135 | 2015-10-16 14:44:00 | -2 | -4 | 10397 | EV | |
| 61 | 10135 | 2015-10-17 10:27:00 | -1 | -12 | 10397 | EV | |
| 62 | 10135 | 2015-10-18 10:27:00 | 55 | 69 | 10397 | EV | |
| 63 | 10135 | 2015-10-18 14:44:00 | -5 | -10 | 10397 | EV | |
| 64 | 10135 | 2015-10-19 10:27:00 | -5 | -5 | 10397 | EV | |
| 65 | 10135 | 2015-10-19 14:44:00 | 17 | 17 | 10397 | EV | |
| 66 | 10135 | 2015-10-20 10:27:00 | -2 | -2 | 10397 | EV | |
| 67 | 10135 | 2015-10-20 14:44:00 | -5 | -11 | 10397 | EV | |
| 68 | 10135 | 2015-10-21 11:30:00 | -6 | -17 | 10397 | EV | |
| 69 | 10135 | 2015-10-21 14:44:00 | -2 | -10 | 10397 | EV | |
| 70 | 10135 | 2015-10-22 14:44:00 | 24 | 24 | 10397 | EV | |
| 71 | 10135 | 2015-10-23 10:27:00 | -3 | 5 | 10397 | EV | |
| 72 | 10135 | 2015-10-23 14:44:00 | 68 | 55 | 10397 | EV | |
| 73 | 10135 | 2015-10-24 10:27:00 | -1 | -2 | 10397 | EV | |
| 74 | 10135 | 2015-10-25 10:27:00 | -6 | -5 | 10397 | EV | |
| 75 | 10135 | 2015-10-25 14:44:00 | -5 | -14 | 10397 | EV | |
| 76 | 10135 | 2015-10-26 10:27:00 | 62 | 56 | 10397 | EV | |
| 77 | 10135 | 2015-10-26 14:44:00 | 179 | 180 | 10397 | EV | |
| 78 | 10135 | 2015-10-27 10:27:00 | -2 | -9 | 10397 | EV | |
| 79 | 10135 | 2015-10-27 14:44:00 | -4 | -20 | 10397 | EV | |
| 80 | 10135 | 2015-10-28 10:27:00 | 58 | 66 | 10397 | EV | |
| 81 | 10135 | 2015-10-28 14:44:00 | 10 | -1 | 10397 | EV | |
| 82 | 10135 | 2015-10-29 10:27:00 | -3 | -2 | 10397 | EV | |
| 83 | 10135 | 2015-10-29 14:44:00 | 0 | -15 | 10397 | EV | |
| 84 | 10135 | 2015-10-30 10:27:00 | 29 | 24 | 10397 | EV | |
| 85 | 10135 | 2015-10-30 14:44:00 | -3 | -6 | 10397 | EV | |
| 86 | 10135 | 2015-10-31 10:27:00 | -4 | -13 | 10397 | EV | |
| 87 | 10135 | 2015-10-01 10:09:00 | -9 | -2 | 11433 | EV | |
| 88 | 10135 | 2015-10-01 14:02:00 | -3 | -8 | 11433 | EV | |
| 89 | 10135 | 2015-10-01 20:02:00 | -3 | -11 | 11433 | EV | |
| 90 | 10135 | 2015-10-02 10:09:00 | -7 | -14 | 11433 | EV | |
| 91 | 10135 | 2015-10-02 14:02:00 | -15 | -19 | 11433 | EV | |
| 92 | 10135 | 2015-10-02 20:02:00 | -3 | -3 | 11433 | EV | |
| 93 | 10135 | 2015-10-04 10:09:00 | 4 | 23 | 11433 | EV | |
| 94 | 10135 | 2015-10-04 14:02:00 | -6 | -10 | 11433 | EV | |
| 95 | 10135 | 2015-10-04 20:02:00 | 19 | 12 | 11433 | EV | |
| 96 | 10135 | 2015-10-05 10:09:00 | -8 | -3 | 11433 | EV | |
| 97 | 10135 | 2015-10-05 14:02:00 | -11 | -17 | 11433 | EV | |
| 98 | 10135 | 2015-10-05 20:02:00 | -3 | -11 | 11433 | EV | |
| 99 | 10135 | 2015-10-06 10:09:00 | -8 | -1 | 11433 | EV | |
| 100 | 10135 | 2015-10-06 14:02:00 | -6 | -7 | 11433 | EV |
Rows: 1-100 | Columns: 7
In [3]:
# Corr between arrival_delay and departure_delay using the 100 previous flights
# and the 10 following flights at the same airport
flights.rolling(func = "corr",
columns = ["departure_delay", "arrival_delay"],
window = (-100, 10),
by = ["origin_airport"],
order_by = {"scheduled_departure": "asc"},)
Out[3]:
| Abc destination_airportVarchar(20) | 📅 scheduled_departureTimestamp | 123 departure_delayInt | 123 arrival_delayInt | Abc origin_airportVarchar(20) | Abc airlineVarchar(20) | 123 Float | 123 Float |
| 1 | 10397 | 2015-10-01 12:00:00 | -6 | 10 | 10135 | EV | ||
| 2 | 13930 | 2015-10-01 12:05:00 | -8 | -3 | 10135 | EV | ||
| 3 | 11433 | 2015-10-01 12:55:00 | -7 | -10 | 10135 | EV | ||
| 4 | 10397 | 2015-10-01 16:00:00 | -5 | -1 | 10135 | EV | ||
| 5 | 11433 | 2015-10-01 17:11:00 | 0 | 1 | 10135 | EV | ||
| 6 | 13930 | 2015-10-01 17:22:00 | 4 | 12 | 10135 | EV | ||
| 7 | 10397 | 2015-10-02 12:00:00 | -3 | -3 | 10135 | EV | ||
| 8 | 13930 | 2015-10-02 12:05:00 | -4 | -4 | 10135 | EV | ||
| 9 | 11433 | 2015-10-02 12:55:00 | 7 | -3 | 10135 | EV | ||
| 10 | 10397 | 2015-10-02 16:00:00 | -5 | -5 | 10135 | EV | ||
| 11 | 11433 | 2015-10-02 17:11:00 | -1 | -2 | 10135 | EV | ||
| 12 | 13930 | 2015-10-02 17:22:00 | 1 | -4 | 10135 | EV | ||
| 13 | 10397 | 2015-10-03 14:00:00 | -9 | -14 | 10135 | EV | ||
| 14 | 10397 | 2015-10-04 12:00:00 | 21 | 17 | 10135 | EV | ||
| 15 | 11433 | 2015-10-04 12:55:00 | 20 | 10 | 10135 | EV | ||
| 16 | 10397 | 2015-10-04 16:00:00 | -8 | -8 | 10135 | EV | ||
| 17 | 11433 | 2015-10-04 17:11:00 | 13 | 7 | 10135 | EV | ||
| 18 | 13930 | 2015-10-04 17:22:00 | 12 | 19 | 10135 | EV | ||
| 19 | 10397 | 2015-10-05 12:00:00 | -2 | 8 | 10135 | EV | ||
| 20 | 13930 | 2015-10-05 12:05:00 | 0 | -1 | 10135 | EV | ||
| 21 | 11433 | 2015-10-05 12:55:00 | 173 | 158 | 10135 | EV | ||
| 22 | 10397 | 2015-10-05 16:00:00 | 50 | 52 | 10135 | EV | ||
| 23 | 11433 | 2015-10-05 17:11:00 | 22 | 9 | 10135 | EV | ||
| 24 | 13930 | 2015-10-05 17:22:00 | -6 | -12 | 10135 | EV | ||
| 25 | 10397 | 2015-10-06 12:00:00 | -1 | 2 | 10135 | EV | ||
| 26 | 13930 | 2015-10-06 12:05:00 | -7 | 0 | 10135 | EV | ||
| 27 | 11433 | 2015-10-06 12:55:00 | 1 | 7 | 10135 | EV | ||
| 28 | 10397 | 2015-10-06 16:00:00 | 2 | -12 | 10135 | EV | ||
| 29 | 11433 | 2015-10-06 17:11:00 | -3 | 5 | 10135 | EV | ||
| 30 | 13930 | 2015-10-06 17:22:00 | -10 | -16 | 10135 | EV | ||
| 31 | 10397 | 2015-10-07 12:00:00 | 1 | 10 | 10135 | EV | ||
| 32 | 13930 | 2015-10-07 12:05:00 | 175 | 166 | 10135 | EV | ||
| 33 | 10397 | 2015-10-07 15:48:00 | 18 | 4 | 10135 | EV | ||
| 34 | 11433 | 2015-10-07 17:11:00 | -6 | -19 | 10135 | EV | ||
| 35 | 13930 | 2015-10-07 17:22:00 | -10 | 16 | 10135 | EV | ||
| 36 | 10397 | 2015-10-08 12:00:00 | -1 | -1 | 10135 | EV | ||
| 37 | 13930 | 2015-10-08 12:05:00 | -2 | -10 | 10135 | EV | ||
| 38 | 11433 | 2015-10-08 12:55:00 | -2 | -5 | 10135 | EV | ||
| 39 | 10397 | 2015-10-08 16:00:00 | 195 | 202 | 10135 | EV | ||
| 40 | 11433 | 2015-10-08 17:11:00 | 0 | 10 | 10135 | EV | ||
| 41 | 13930 | 2015-10-08 17:22:00 | -2 | -16 | 10135 | EV | ||
| 42 | 10397 | 2015-10-09 12:00:00 | -2 | -3 | 10135 | EV | ||
| 43 | 13930 | 2015-10-09 12:05:00 | -10 | -6 | 10135 | EV | ||
| 44 | 11433 | 2015-10-09 12:55:00 | 5 | -6 | 10135 | EV | ||
| 45 | 10397 | 2015-10-09 16:00:00 | 104 | 104 | 10135 | EV | ||
| 46 | 11433 | 2015-10-09 17:11:00 | 45 | 40 | 10135 | EV | ||
| 47 | 13930 | 2015-10-09 17:22:00 | 3 | 16 | 10135 | EV | ||
| 48 | 10397 | 2015-10-10 14:00:00 | -1 | -19 | 10135 | EV | ||
| 49 | 10397 | 2015-10-11 12:00:00 | -1 | -9 | 10135 | EV | ||
| 50 | 11433 | 2015-10-11 12:55:00 | -2 | -8 | 10135 | EV | ||
| 51 | 10397 | 2015-10-11 16:00:00 | -10 | -23 | 10135 | EV | ||
| 52 | 11433 | 2015-10-11 17:11:00 | 31 | 23 | 10135 | EV | ||
| 53 | 13930 | 2015-10-11 17:22:00 | -8 | 4 | 10135 | EV | ||
| 54 | 10397 | 2015-10-12 12:00:00 | -2 | 0 | 10135 | EV | ||
| 55 | 13930 | 2015-10-12 12:05:00 | -3 | -1 | 10135 | EV | ||
| 56 | 11433 | 2015-10-12 12:55:00 | -1 | -1 | 10135 | EV | ||
| 57 | 10397 | 2015-10-12 16:00:00 | -1 | -12 | 10135 | EV | ||
| 58 | 11433 | 2015-10-12 17:11:00 | -1 | -5 | 10135 | EV | ||
| 59 | 13930 | 2015-10-12 17:22:00 | -3 | -8 | 10135 | EV | ||
| 60 | 10397 | 2015-10-13 12:00:00 | 0 | -6 | 10135 | EV | ||
| 61 | 13930 | 2015-10-13 12:05:00 | 36 | 48 | 10135 | EV | ||
| 62 | 11433 | 2015-10-13 12:55:00 | -4 | -8 | 10135 | EV | ||
| 63 | 10397 | 2015-10-13 16:00:00 | -4 | -15 | 10135 | EV | ||
| 64 | 11433 | 2015-10-13 17:11:00 | -2 | 4 | 10135 | EV | ||
| 65 | 13930 | 2015-10-13 17:22:00 | 4 | -10 | 10135 | EV | ||
| 66 | 10397 | 2015-10-14 12:00:00 | -3 | -7 | 10135 | EV | ||
| 67 | 13930 | 2015-10-14 12:05:00 | -12 | -21 | 10135 | EV | ||
| 68 | 10397 | 2015-10-14 16:00:00 | 3 | 17 | 10135 | EV | ||
| 69 | 11433 | 2015-10-14 17:11:00 | 1 | -10 | 10135 | EV | ||
| 70 | 13930 | 2015-10-14 17:22:00 | 1 | -1 | 10135 | EV | ||
| 71 | 10397 | 2015-10-15 12:00:00 | -4 | -14 | 10135 | EV | ||
| 72 | 13930 | 2015-10-15 12:05:00 | -7 | -8 | 10135 | EV | ||
| 73 | 11433 | 2015-10-15 12:55:00 | -6 | 5 | 10135 | EV | ||
| 74 | 10397 | 2015-10-15 16:00:00 | -3 | -8 | 10135 | EV | ||
| 75 | 11433 | 2015-10-15 17:11:00 | 18 | 33 | 10135 | EV | ||
| 76 | 13930 | 2015-10-15 17:22:00 | 412 | 415 | 10135 | EV | ||
| 77 | 10397 | 2015-10-16 12:00:00 | 76 | 87 | 10135 | EV | ||
| 78 | 13930 | 2015-10-16 12:05:00 | -6 | -3 | 10135 | EV | ||
| 79 | 11433 | 2015-10-16 12:55:00 | -11 | -3 | 10135 | EV | ||
| 80 | 10397 | 2015-10-16 16:00:00 | 2 | 5 | 10135 | EV | ||
| 81 | 11433 | 2015-10-16 17:11:00 | -2 | -2 | 10135 | EV | ||
| 82 | 13930 | 2015-10-16 17:22:00 | -11 | -14 | 10135 | EV | ||
| 83 | 10397 | 2015-10-17 14:00:00 | -8 | -17 | 10135 | EV | ||
| 84 | 10397 | 2015-10-18 12:00:00 | -5 | -7 | 10135 | EV | ||
| 85 | 11433 | 2015-10-18 12:55:00 | 63 | 62 | 10135 | EV | ||
| 86 | 10397 | 2015-10-18 16:00:00 | 80 | 67 | 10135 | EV | ||
| 87 | 11433 | 2015-10-18 17:11:00 | -5 | -18 | 10135 | EV | ||
| 88 | 13930 | 2015-10-18 17:22:00 | 18 | 9 | 10135 | EV | ||
| 89 | 10397 | 2015-10-19 12:00:00 | 2 | 0 | 10135 | EV | ||
| 90 | 13930 | 2015-10-19 12:05:00 | 3 | -15 | 10135 | EV | ||
| 91 | 11433 | 2015-10-19 12:55:00 | -1 | -8 | 10135 | EV | ||
| 92 | 10397 | 2015-10-19 16:00:00 | -6 | -9 | 10135 | EV | ||
| 93 | 11433 | 2015-10-19 17:11:00 | 25 | 20 | 10135 | EV | ||
| 94 | 13930 | 2015-10-19 17:22:00 | 0 | -5 | 10135 | EV | ||
| 95 | 10397 | 2015-10-20 12:00:00 | 3 | 1 | 10135 | EV | ||
| 96 | 13930 | 2015-10-20 12:05:00 | -3 | -14 | 10135 | EV | ||
| 97 | 11433 | 2015-10-20 12:55:00 | -1 | 0 | 10135 | EV | ||
| 98 | 10397 | 2015-10-20 16:00:00 | -5 | -15 | 10135 | EV | ||
| 99 | 11433 | 2015-10-20 17:11:00 | -13 | -12 | 10135 | EV | ||
| 100 | 13930 | 2015-10-20 17:22:00 | 4 | -12 | 10135 | EV |
Rows: 1-100 | Columns: 8
In [4]:
# Number of flights the airline has to manage 2 hours preceding
# the flight and 1 hour following
flights.rolling(func = "count",
columns = "scheduled_departure",
window = ("- 2 hours", "1 hour"),
by = ["origin_airport", "airline"],
order_by = {"scheduled_departure": "asc"},)
Out[4]:
| Abc destination_airportVarchar(20) | 📅 scheduled_departureTimestamp | 123 departure_delayInt | 123 arrival_delayInt | Abc origin_airportVarchar(20) | Abc airlineVarchar(20) | 123 Float | 123 Float | 123 Integer |
| 1 | 10397 | 2015-10-01 12:00:00 | -6 | 10 | 10135 | EV | |||
| 2 | 13930 | 2015-10-01 12:05:00 | -8 | -3 | 10135 | EV | |||
| 3 | 11433 | 2015-10-01 12:55:00 | -7 | -10 | 10135 | EV | |||
| 4 | 10397 | 2015-10-01 16:00:00 | -5 | -1 | 10135 | EV | |||
| 5 | 11433 | 2015-10-01 17:11:00 | 0 | 1 | 10135 | EV | |||
| 6 | 13930 | 2015-10-01 17:22:00 | 4 | 12 | 10135 | EV | |||
| 7 | 10397 | 2015-10-02 12:00:00 | -3 | -3 | 10135 | EV | |||
| 8 | 13930 | 2015-10-02 12:05:00 | -4 | -4 | 10135 | EV | |||
| 9 | 11433 | 2015-10-02 12:55:00 | 7 | -3 | 10135 | EV | |||
| 10 | 10397 | 2015-10-02 16:00:00 | -5 | -5 | 10135 | EV | |||
| 11 | 11433 | 2015-10-02 17:11:00 | -1 | -2 | 10135 | EV | |||
| 12 | 13930 | 2015-10-02 17:22:00 | 1 | -4 | 10135 | EV | |||
| 13 | 10397 | 2015-10-03 14:00:00 | -9 | -14 | 10135 | EV | |||
| 14 | 10397 | 2015-10-04 12:00:00 | 21 | 17 | 10135 | EV | |||
| 15 | 11433 | 2015-10-04 12:55:00 | 20 | 10 | 10135 | EV | |||
| 16 | 10397 | 2015-10-04 16:00:00 | -8 | -8 | 10135 | EV | |||
| 17 | 11433 | 2015-10-04 17:11:00 | 13 | 7 | 10135 | EV | |||
| 18 | 13930 | 2015-10-04 17:22:00 | 12 | 19 | 10135 | EV | |||
| 19 | 10397 | 2015-10-05 12:00:00 | -2 | 8 | 10135 | EV | |||
| 20 | 13930 | 2015-10-05 12:05:00 | 0 | -1 | 10135 | EV | |||
| 21 | 11433 | 2015-10-05 12:55:00 | 173 | 158 | 10135 | EV | |||
| 22 | 10397 | 2015-10-05 16:00:00 | 50 | 52 | 10135 | EV | |||
| 23 | 11433 | 2015-10-05 17:11:00 | 22 | 9 | 10135 | EV | |||
| 24 | 13930 | 2015-10-05 17:22:00 | -6 | -12 | 10135 | EV | |||
| 25 | 10397 | 2015-10-06 12:00:00 | -1 | 2 | 10135 | EV | |||
| 26 | 13930 | 2015-10-06 12:05:00 | -7 | 0 | 10135 | EV | |||
| 27 | 11433 | 2015-10-06 12:55:00 | 1 | 7 | 10135 | EV | |||
| 28 | 10397 | 2015-10-06 16:00:00 | 2 | -12 | 10135 | EV | |||
| 29 | 11433 | 2015-10-06 17:11:00 | -3 | 5 | 10135 | EV | |||
| 30 | 13930 | 2015-10-06 17:22:00 | -10 | -16 | 10135 | EV | |||
| 31 | 10397 | 2015-10-07 12:00:00 | 1 | 10 | 10135 | EV | |||
| 32 | 13930 | 2015-10-07 12:05:00 | 175 | 166 | 10135 | EV | |||
| 33 | 10397 | 2015-10-07 15:48:00 | 18 | 4 | 10135 | EV | |||
| 34 | 11433 | 2015-10-07 17:11:00 | -6 | -19 | 10135 | EV | |||
| 35 | 13930 | 2015-10-07 17:22:00 | -10 | 16 | 10135 | EV | |||
| 36 | 10397 | 2015-10-08 12:00:00 | -1 | -1 | 10135 | EV | |||
| 37 | 13930 | 2015-10-08 12:05:00 | -2 | -10 | 10135 | EV | |||
| 38 | 11433 | 2015-10-08 12:55:00 | -2 | -5 | 10135 | EV | |||
| 39 | 10397 | 2015-10-08 16:00:00 | 195 | 202 | 10135 | EV | |||
| 40 | 11433 | 2015-10-08 17:11:00 | 0 | 10 | 10135 | EV | |||
| 41 | 13930 | 2015-10-08 17:22:00 | -2 | -16 | 10135 | EV | |||
| 42 | 10397 | 2015-10-09 12:00:00 | -2 | -3 | 10135 | EV | |||
| 43 | 13930 | 2015-10-09 12:05:00 | -10 | -6 | 10135 | EV | |||
| 44 | 11433 | 2015-10-09 12:55:00 | 5 | -6 | 10135 | EV | |||
| 45 | 10397 | 2015-10-09 16:00:00 | 104 | 104 | 10135 | EV | |||
| 46 | 11433 | 2015-10-09 17:11:00 | 45 | 40 | 10135 | EV | |||
| 47 | 13930 | 2015-10-09 17:22:00 | 3 | 16 | 10135 | EV | |||
| 48 | 10397 | 2015-10-10 14:00:00 | -1 | -19 | 10135 | EV | |||
| 49 | 10397 | 2015-10-11 12:00:00 | -1 | -9 | 10135 | EV | |||
| 50 | 11433 | 2015-10-11 12:55:00 | -2 | -8 | 10135 | EV | |||
| 51 | 10397 | 2015-10-11 16:00:00 | -10 | -23 | 10135 | EV | |||
| 52 | 11433 | 2015-10-11 17:11:00 | 31 | 23 | 10135 | EV | |||
| 53 | 13930 | 2015-10-11 17:22:00 | -8 | 4 | 10135 | EV | |||
| 54 | 10397 | 2015-10-12 12:00:00 | -2 | 0 | 10135 | EV | |||
| 55 | 13930 | 2015-10-12 12:05:00 | -3 | -1 | 10135 | EV | |||
| 56 | 11433 | 2015-10-12 12:55:00 | -1 | -1 | 10135 | EV | |||
| 57 | 10397 | 2015-10-12 16:00:00 | -1 | -12 | 10135 | EV | |||
| 58 | 11433 | 2015-10-12 17:11:00 | -1 | -5 | 10135 | EV | |||
| 59 | 13930 | 2015-10-12 17:22:00 | -3 | -8 | 10135 | EV | |||
| 60 | 10397 | 2015-10-13 12:00:00 | 0 | -6 | 10135 | EV | |||
| 61 | 13930 | 2015-10-13 12:05:00 | 36 | 48 | 10135 | EV | |||
| 62 | 11433 | 2015-10-13 12:55:00 | -4 | -8 | 10135 | EV | |||
| 63 | 10397 | 2015-10-13 16:00:00 | -4 | -15 | 10135 | EV | |||
| 64 | 11433 | 2015-10-13 17:11:00 | -2 | 4 | 10135 | EV | |||
| 65 | 13930 | 2015-10-13 17:22:00 | 4 | -10 | 10135 | EV | |||
| 66 | 10397 | 2015-10-14 12:00:00 | -3 | -7 | 10135 | EV | |||
| 67 | 13930 | 2015-10-14 12:05:00 | -12 | -21 | 10135 | EV | |||
| 68 | 10397 | 2015-10-14 16:00:00 | 3 | 17 | 10135 | EV | |||
| 69 | 11433 | 2015-10-14 17:11:00 | 1 | -10 | 10135 | EV | |||
| 70 | 13930 | 2015-10-14 17:22:00 | 1 | -1 | 10135 | EV | |||
| 71 | 10397 | 2015-10-15 12:00:00 | -4 | -14 | 10135 | EV | |||
| 72 | 13930 | 2015-10-15 12:05:00 | -7 | -8 | 10135 | EV | |||
| 73 | 11433 | 2015-10-15 12:55:00 | -6 | 5 | 10135 | EV | |||
| 74 | 10397 | 2015-10-15 16:00:00 | -3 | -8 | 10135 | EV | |||
| 75 | 11433 | 2015-10-15 17:11:00 | 18 | 33 | 10135 | EV | |||
| 76 | 13930 | 2015-10-15 17:22:00 | 412 | 415 | 10135 | EV | |||
| 77 | 10397 | 2015-10-16 12:00:00 | 76 | 87 | 10135 | EV | |||
| 78 | 13930 | 2015-10-16 12:05:00 | -6 | -3 | 10135 | EV | |||
| 79 | 11433 | 2015-10-16 12:55:00 | -11 | -3 | 10135 | EV | |||
| 80 | 10397 | 2015-10-16 16:00:00 | 2 | 5 | 10135 | EV | |||
| 81 | 11433 | 2015-10-16 17:11:00 | -2 | -2 | 10135 | EV | |||
| 82 | 13930 | 2015-10-16 17:22:00 | -11 | -14 | 10135 | EV | |||
| 83 | 10397 | 2015-10-17 14:00:00 | -8 | -17 | 10135 | EV | |||
| 84 | 10397 | 2015-10-18 12:00:00 | -5 | -7 | 10135 | EV | |||
| 85 | 11433 | 2015-10-18 12:55:00 | 63 | 62 | 10135 | EV | |||
| 86 | 10397 | 2015-10-18 16:00:00 | 80 | 67 | 10135 | EV | |||
| 87 | 11433 | 2015-10-18 17:11:00 | -5 | -18 | 10135 | EV | |||
| 88 | 13930 | 2015-10-18 17:22:00 | 18 | 9 | 10135 | EV | |||
| 89 | 10397 | 2015-10-19 12:00:00 | 2 | 0 | 10135 | EV | |||
| 90 | 13930 | 2015-10-19 12:05:00 | 3 | -15 | 10135 | EV | |||
| 91 | 11433 | 2015-10-19 12:55:00 | -1 | -8 | 10135 | EV | |||
| 92 | 10397 | 2015-10-19 16:00:00 | -6 | -9 | 10135 | EV | |||
| 93 | 11433 | 2015-10-19 17:11:00 | 25 | 20 | 10135 | EV | |||
| 94 | 13930 | 2015-10-19 17:22:00 | 0 | -5 | 10135 | EV | |||
| 95 | 10397 | 2015-10-20 12:00:00 | 3 | 1 | 10135 | EV | |||
| 96 | 13930 | 2015-10-20 12:05:00 | -3 | -14 | 10135 | EV | |||
| 97 | 11433 | 2015-10-20 12:55:00 | -1 | 0 | 10135 | EV | |||
| 98 | 10397 | 2015-10-20 16:00:00 | -5 | -15 | 10135 | EV | |||
| 99 | 11433 | 2015-10-20 17:11:00 | -13 | -12 | 10135 | EV | |||
| 100 | 13930 | 2015-10-20 17:22:00 | 4 | -12 | 10135 | EV |
Rows: 1-100 | Columns: 9
See Also¶
| vDataFrame.analytic | Adds a new vcolumn to the vDataFrame by using an advanced analytical function on a specific vcolumn. |
| vDataFrame.eval | Evaluates a customized expression. |