Reading .res.csv files

Sometimes its useful to be able to read an existing .res.csv results file from an earlier Source run

Normally when working with Veneer, you retreive time series results directly from the running copy of Source. This data is transferred as JSON encoded text, but you see a Pandas Dataframe as the result of v.retrieve_multiple_timeseries.

This notebook demonstrates a provided function for reading .res.csv files into a Python session. The result is TWO dataframes - one dataframe containing the time series data (one column per timeseries, indexed by date/time) and one dataframe containing the metadata on the time series.


In [2]:
import veneer
from veneer import read_rescsv

In [3]:
metadata, data = read_rescsv('example.res.csv')

In [4]:
metadata


Out[4]:
Custom ElementName ElementType Field Name RunName ScenarioInputSetName ScenarioName Site Structure Units WaterFeatureType
0 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 1 Confluence: node #0: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #0 Downstream Flow ML.day^-1 Confluence
1 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 2 Confluence: node #0: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #0 Downstream Flow Volume ML Confluence
2 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 3 Confluence: node #0: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #0 Storage Volume ML Confluence
3 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 4 Confluence: node #0: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #0 Upstream Flow ML.day^-1 Confluence
4 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 5 Confluence: node #0: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #0 Upstream Flow Volume ML Confluence
5 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 6 Confluence: node #1: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #1 Downstream Flow ML.day^-1 Confluence
6 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 7 Confluence: node #1: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #1 Downstream Flow Volume ML Confluence
7 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 8 Confluence: node #1: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #1 Storage Volume ML Confluence
8 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 9 Confluence: node #1: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #1 Upstream Flow ML.day^-1 Confluence
9 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 10 Confluence: node #1: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #1 Upstream Flow Volume ML Confluence
10 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 11 Confluence: node #10: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #10 Downstream Flow ML.day^-1 Confluence
11 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 12 Confluence: node #10: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #10 Downstream Flow Volume ML Confluence
12 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 13 Confluence: node #10: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #10 Storage Volume ML Confluence
13 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 14 Confluence: node #10: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #10 Upstream Flow ML.day^-1 Confluence
14 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 15 Confluence: node #10: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #10 Upstream Flow Volume ML Confluence
15 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 16 Confluence: node #2: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #2 Downstream Flow ML.day^-1 Confluence
16 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 17 Confluence: node #2: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #2 Downstream Flow Volume ML Confluence
17 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 18 Confluence: node #2: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #2 Storage Volume ML Confluence
18 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 19 Confluence: node #2: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #2 Upstream Flow ML.day^-1 Confluence
19 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 20 Confluence: node #2: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #2 Upstream Flow Volume ML Confluence
20 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 21 Confluence: node #3: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #3 Downstream Flow ML.day^-1 Confluence
21 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 22 Confluence: node #3: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #3 Downstream Flow Volume ML Confluence
22 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 23 Confluence: node #3: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #3 Storage Volume ML Confluence
23 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 24 Confluence: node #3: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #3 Upstream Flow ML.day^-1 Confluence
24 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 25 Confluence: node #3: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #3 Upstream Flow Volume ML Confluence
25 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Node 26 Confluence: node #4: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #4 Downstream Flow ML.day^-1 Confluence
26 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Node 27 Confluence: node #4: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #4 Downstream Flow Volume ML Confluence
27 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Node 28 Confluence: node #4: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #4 Storage Volume ML Confluence
28 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Node 29 Confluence: node #4: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #4 Upstream Flow ML.day^-1 Confluence
29 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Node 30 Confluence: node #4: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 node #4 Upstream Flow Volume ML Confluence
... ... ... ... ... ... ... ... ... ... ... ... ...
177 7592b694-59a3-4f07-805b-0e9a4f29949b Time Series Flux Link 178 Storage Routing: link #7: Time Series Flux (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #7 Time Series Flux ML.day^-1 Storage Routing
178 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Link 179 Storage Routing: link #7: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #7 Upstream Flow ML.day^-1 Storage Routing
179 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Link 180 Storage Routing: link #7: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #7 Upstream Flow Volume ML Storage Routing
180 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow Link 181 Storage Routing: link #8: Catchment Inflow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Catchment Inflow ML.day^-1 Storage Routing
181 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow Applied Downstream Link 182 Storage Routing: link #8: Catchment Inflow App... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Catchment Inflow Applied Downstream ML.day^-1 Storage Routing
182 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow To End Of Link Link 183 Storage Routing: link #8: Catchment Inflow To ... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Catchment Inflow To End Of Link ML.day^-1 Storage Routing
183 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Link 184 Storage Routing: link #8: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Downstream Flow ML.day^-1 Storage Routing
184 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Link 185 Storage Routing: link #8: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Downstream Flow Volume ML Storage Routing
185 7592b694-59a3-4f07-805b-0e9a4f29949b Lateral Flow Link 186 Storage Routing: link #8: Lateral Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Lateral Flow ML.day^-1 Storage Routing
186 7592b694-59a3-4f07-805b-0e9a4f29949b Lateral Flow Applied Downstream Link 187 Storage Routing: link #8: Lateral Flow Applied... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Lateral Flow Applied Downstream ML.day^-1 Storage Routing
187 7592b694-59a3-4f07-805b-0e9a4f29949b Live Storage Volume Link 188 Storage Routing: link #8: Live Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Live Storage Volume ML Storage Routing
188 7592b694-59a3-4f07-805b-0e9a4f29949b Loss / Gain Flux Link 189 Storage Routing: link #8: Loss / Gain Flux (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Loss / Gain Flux ML.day^-1 Storage Routing
189 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Link 190 Storage Routing: link #8: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Storage Volume ML Storage Routing
190 7592b694-59a3-4f07-805b-0e9a4f29949b Time Series Flux Link 191 Storage Routing: link #8: Time Series Flux (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Time Series Flux ML.day^-1 Storage Routing
191 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Link 192 Storage Routing: link #8: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Upstream Flow ML.day^-1 Storage Routing
192 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Link 193 Storage Routing: link #8: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #8 Upstream Flow Volume ML Storage Routing
193 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow Link 194 Storage Routing: link #9: Catchment Inflow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Catchment Inflow ML.day^-1 Storage Routing
194 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow Applied Downstream Link 195 Storage Routing: link #9: Catchment Inflow App... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Catchment Inflow Applied Downstream ML.day^-1 Storage Routing
195 7592b694-59a3-4f07-805b-0e9a4f29949b Catchment Inflow To End Of Link Link 196 Storage Routing: link #9: Catchment Inflow To ... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Catchment Inflow To End Of Link ML.day^-1 Storage Routing
196 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Link 197 Storage Routing: link #9: Downstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Downstream Flow ML.day^-1 Storage Routing
197 7592b694-59a3-4f07-805b-0e9a4f29949b Downstream Flow Volume Link 198 Storage Routing: link #9: Downstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Downstream Flow Volume ML Storage Routing
198 7592b694-59a3-4f07-805b-0e9a4f29949b Lateral Flow Link 199 Storage Routing: link #9: Lateral Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Lateral Flow ML.day^-1 Storage Routing
199 7592b694-59a3-4f07-805b-0e9a4f29949b Lateral Flow Applied Downstream Link 200 Storage Routing: link #9: Lateral Flow Applied... (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Lateral Flow Applied Downstream ML.day^-1 Storage Routing
200 7592b694-59a3-4f07-805b-0e9a4f29949b Live Storage Volume Link 201 Storage Routing: link #9: Live Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Live Storage Volume ML Storage Routing
201 7592b694-59a3-4f07-805b-0e9a4f29949b Loss / Gain Flux Link 202 Storage Routing: link #9: Loss / Gain Flux (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Loss / Gain Flux ML.day^-1 Storage Routing
202 7592b694-59a3-4f07-805b-0e9a4f29949b Storage Volume Link 203 Storage Routing: link #9: Storage Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Storage Volume ML Storage Routing
203 7592b694-59a3-4f07-805b-0e9a4f29949b Time Series Flux Link 204 Storage Routing: link #9: Time Series Flux (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Time Series Flux ML.day^-1 Storage Routing
204 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Link 205 Storage Routing: link #9: Upstream Flow (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Upstream Flow ML.day^-1 Storage Routing
205 7592b694-59a3-4f07-805b-0e9a4f29949b Upstream Flow Volume Link 206 Storage Routing: link #9: Upstream Flow Volume (1) A test scenario with AWBM 0 Default Input Set A test scenario with AWBM 0 link #9 Upstream Flow Volume ML Storage Routing
206 11>node #10>Downstream Flow 7>node #1>Downstream Flow Volume 9>node #1>Upstream Flow Date 5>node #0>Upstream Flow Volume 2>node #0>Downstream Flow Volume 4>node #0>Upstream Flow 3>node #0>Storage Volume 6>node #1>Downstream Flow 10>node #1>Upstream Flow Volume 1>node #0>Downstream Flow 8>node #1>Storage Volume

207 rows × 12 columns


In [5]:
data


Out[5]:
Confluence: node #0: Downstream Flow Confluence: node #0: Downstream Flow Volume Confluence: node #0: Storage Volume Confluence: node #0: Upstream Flow Confluence: node #0: Upstream Flow Volume Confluence: node #1: Downstream Flow Confluence: node #1: Downstream Flow Volume Confluence: node #1: Storage Volume Confluence: node #1: Upstream Flow Confluence: node #1: Upstream Flow Volume ... Storage Routing: link #9: Downstream Flow Volume Storage Routing: link #9: Lateral Flow Storage Routing: link #9: Lateral Flow Applied Downstream Storage Routing: link #9: Live Storage Volume Storage Routing: link #9: Loss / Gain Flux Storage Routing: link #9: Storage Volume Storage Routing: link #9: Time Series Flux Storage Routing: link #9: Upstream Flow Storage Routing: link #9: Upstream Flow Volume 5>node #0>Upstream Flow Volume
Date
1900-01-01 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-02 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-03 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-04 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-05 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-06 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-07 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-08 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-09 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-10 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-11 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-12 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-13 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-14 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-15 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-16 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-17 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-18 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-19 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-20 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-21 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-22 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-23 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-24 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-25 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-26 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-27 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-28 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-29 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
1900-01-30 0 0 0 0 0 0.000000 0.000000 0 0.000000 0.000000 ... 0.000000 0 0.000000 0 0 0 0 0.000000 0.000000 NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1900-12-02 0 0 0 0 0 0.057863 0.057863 0 0.057863 0.057863 ... 0.520765 0 0.057863 0 0 0 0 0.462902 0.462902 NaN
1900-12-03 0 0 0 0 0 0.054970 0.054970 0 0.054970 0.054970 ... 0.494727 0 0.054970 0 0 0 0 0.439757 0.439757 NaN
1900-12-04 0 0 0 0 0 0.052221 0.052221 0 0.052221 0.052221 ... 0.469990 0 0.052221 0 0 0 0 0.417769 0.417769 NaN
1900-12-05 0 0 0 0 0 0.049610 0.049610 0 0.049610 0.049610 ... 0.446491 0 0.049610 0 0 0 0 0.396881 0.396881 NaN
1900-12-06 0 0 0 0 0 0.047130 0.047130 0 0.047130 0.047130 ... 0.424166 0 0.047130 0 0 0 0 0.377037 0.377037 NaN
1900-12-07 0 0 0 0 0 0.044773 0.044773 0 0.044773 0.044773 ... 0.402958 0 0.044773 0 0 0 0 0.358185 0.358185 NaN
1900-12-08 0 0 0 0 0 0.042534 0.042534 0 0.042534 0.042534 ... 0.382810 0 0.042534 0 0 0 0 0.340276 0.340276 NaN
1900-12-09 0 0 0 0 0 0.040408 0.040408 0 0.040408 0.040408 ... 0.363669 0 0.040408 0 0 0 0 0.323262 0.323262 NaN
1900-12-10 0 0 0 0 0 0.038387 0.038387 0 0.038387 0.038387 ... 0.345486 0 0.038387 0 0 0 0 0.307099 0.307099 NaN
1900-12-11 0 0 0 0 0 0.036468 0.036468 0 0.036468 0.036468 ... 0.328212 0 0.036468 0 0 0 0 0.291744 0.291744 NaN
1900-12-12 0 0 0 0 0 0.034645 0.034645 0 0.034645 0.034645 ... 0.311801 0 0.034645 0 0 0 0 0.277157 0.277157 NaN
1900-12-13 0 0 0 0 0 0.032912 0.032912 0 0.032912 0.032912 ... 0.296211 0 0.032912 0 0 0 0 0.263299 0.263299 NaN
1900-12-14 0 0 0 0 0 0.031267 0.031267 0 0.031267 0.031267 ... 0.281400 0 0.031267 0 0 0 0 0.250134 0.250134 NaN
1900-12-15 0 0 0 0 0 0.029703 0.029703 0 0.029703 0.029703 ... 0.267330 0 0.029703 0 0 0 0 0.237627 0.237627 NaN
1900-12-16 0 0 0 0 0 0.028218 0.028218 0 0.028218 0.028218 ... 0.253964 0 0.028218 0 0 0 0 0.225746 0.225746 NaN
1900-12-17 0 0 0 0 0 0.026807 0.026807 0 0.026807 0.026807 ... 0.241266 0 0.026807 0 0 0 0 0.214458 0.214458 NaN
1900-12-18 0 0 0 0 0 0.025467 0.025467 0 0.025467 0.025467 ... 0.229202 0 0.025467 0 0 0 0 0.203736 0.203736 NaN
1900-12-19 0 0 0 0 0 0.024194 0.024194 0 0.024194 0.024194 ... 0.217742 0 0.024194 0 0 0 0 0.193549 0.193549 NaN
1900-12-20 0 0 0 0 0 0.022984 0.022984 0 0.022984 0.022984 ... 0.206855 0 0.022984 0 0 0 0 0.183871 0.183871 NaN
1900-12-21 0 0 0 0 0 0.021835 0.021835 0 0.021835 0.021835 ... 0.196512 0 0.021835 0 0 0 0 0.174678 0.174678 NaN
1900-12-22 0 0 0 0 0 0.020743 0.020743 0 0.020743 0.020743 ... 0.186687 0 0.020743 0 0 0 0 0.165944 0.165944 NaN
1900-12-23 0 0 0 0 0 0.019706 0.019706 0 0.019706 0.019706 ... 0.177352 0 0.019706 0 0 0 0 0.157647 0.157647 NaN
1900-12-24 0 0 0 0 0 0.018721 0.018721 0 0.018721 0.018721 ... 0.168485 0 0.018721 0 0 0 0 0.149764 0.149764 NaN
1900-12-25 0 0 0 0 0 0.017785 0.017785 0 0.017785 0.017785 ... 0.160061 0 0.017785 0 0 0 0 0.142276 0.142276 NaN
1900-12-26 0 0 0 0 0 0.016895 0.016895 0 0.016895 0.016895 ... 0.152058 0 0.016895 0 0 0 0 0.135162 0.135162 NaN
1900-12-27 0 0 0 0 0 0.016051 0.016051 0 0.016051 0.016051 ... 0.144455 0 0.016051 0 0 0 0 0.128404 0.128404 NaN
1900-12-28 0 0 0 0 0 0.015248 0.015248 0 0.015248 0.015248 ... 0.137232 0 0.015248 0 0 0 0 0.121984 0.121984 NaN
1900-12-29 0 0 0 0 0 0.014486 0.014486 0 0.014486 0.014486 ... 0.130370 0 0.014486 0 0 0 0 0.115885 0.115885 NaN
1900-12-30 0 0 0 0 0 0.013761 0.013761 0 0.013761 0.013761 ... 0.123852 0 0.013761 0 0 0 0 0.110091 0.110091 NaN
1900-12-31 0 0 0 0 0 0.013073 0.013073 0 0.013073 0.013073 ... 0.117659 0 0.013073 0 0 0 0 0.104586 0.104586 NaN

365 rows × 207 columns


In [ ]: