In [1]:
import pandas as pd
import numpy as np
import datetime
import pyaf.ForecastEngine as autof
%matplotlib inline
In [2]:
df = pd.read_csv('http://www.mechanicalkern.com/static/birthdates-1968-1988.csv')
In [3]:
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 7305 entries, 0 to 7304
Data columns (total 6 columns):
year 7305 non-null int64
month 7305 non-null int64
day 7305 non-null int64
births 7305 non-null int64
day_of_year 7305 non-null int64
day_of_week 7305 non-null int64
dtypes: int64(6)
memory usage: 342.5 KB
In [4]:
df.head()
Out[4]:
year
month
day
births
day_of_year
day_of_week
0
1969
1
1
8486
1
3
1
1969
1
2
9002
2
4
2
1969
1
3
9542
3
5
3
1969
1
4
8960
4
6
4
1969
1
5
8390
5
7
In [5]:
df['date_str'] = df[['year', 'month', 'day']].apply(lambda r : str(r[0]) + "-" + str(r[1]) + "-" + str(r[2]) , axis = 1)
df['date'] = df['date_str'].apply(lambda x : datetime.datetime.strptime(x, "%Y-%m-%d"))
In [6]:
lEngine = autof.cForecastEngine()
lEngine
H = 31;
lEngine.train(df , 'date' , 'births', H);
lEngine.getModelInfo();
INFO:pyaf.std:START_TRAINING 'births'
INFO:pyaf.std:END_TRAINING_TIME_IN_SECONDS 'births' 33.15265130996704
INFO:pyaf.std:TIME_DETAIL TimeVariable='date' TimeMin=1969-01-01T00:00:00.000000 TimeMax=1984-12-06T00:00:00.000000 TimeDelta=1 days Estimation = (0 , 5819) Validation = (5819 , 7274) Test = (7274 , 7305) Horizon=31
INFO:pyaf.std:SIGNAL_DETAIL SignalVariable='_births' Min=6675 Max=12851 Mean=9648.94017796 StdDev=1127.2380662
INFO:pyaf.std:BEST_TRANSOFORMATION_TYPE '_'
INFO:pyaf.std:BEST_DECOMPOSITION '_births_ConstantTrend_residue_zeroCycle_residue_AR(64)' [ConstantTrend + NoCycle + AR(64)]
INFO:pyaf.std:TREND_DETAIL '_births_ConstantTrend' [ConstantTrend]
INFO:pyaf.std:CYCLE_DETAIL '_births_ConstantTrend_residue_zeroCycle' [NoCycle]
INFO:pyaf.std:AUTOREG_DETAIL '_births_ConstantTrend_residue_zeroCycle_residue_AR(64)' [AR(64)]
INFO:pyaf.std:MODEL_MAPE MAPE_Fit=0.0211 MAPE_Forecast=0.0243 MAPE_Test=0.0338
INFO:pyaf.std:MODEL_SMAPE SMAPE_Fit=0.0209 SMAPE_Forecast=0.024 SMAPE_Test=0.0332
INFO:pyaf.std:MODEL_MASE MASE_Fit=0.3079 MASE_Forecast=0.2761 MASE_Test=0.3438
INFO:pyaf.std:MODEL_L1 L1_Fit=196.232734395 L1_Forecast=247.55824393 L1_Test=348.70860174
INFO:pyaf.std:MODEL_L2 L2_Fit=298.036027616 L2_Forecast=392.313942793 L2_Test=526.268852336
INFO:pyaf.std:MODEL_COMPLEXITY 64
INFO:pyaf.std:AR_MODEL_DETAIL_START
INFO:pyaf.std:AR_MODEL_COEFF 1 _births_ConstantTrend_residue_zeroCycle_residue_Lag1 0.492265981047
INFO:pyaf.std:AR_MODEL_COEFF 2 _births_ConstantTrend_residue_zeroCycle_residue_Lag7 0.241619777114
INFO:pyaf.std:AR_MODEL_COEFF 3 _births_ConstantTrend_residue_zeroCycle_residue_Lag28 0.12162034339
INFO:pyaf.std:AR_MODEL_COEFF 4 _births_ConstantTrend_residue_zeroCycle_residue_Lag35 0.11822064158
INFO:pyaf.std:AR_MODEL_COEFF 5 _births_ConstantTrend_residue_zeroCycle_residue_Lag14 0.101531498873
INFO:pyaf.std:AR_MODEL_COEFF 6 _births_ConstantTrend_residue_zeroCycle_residue_Lag56 0.0899657833106
INFO:pyaf.std:AR_MODEL_COEFF 7 _births_ConstantTrend_residue_zeroCycle_residue_Lag63 0.0871390984125
INFO:pyaf.std:AR_MODEL_COEFF 8 _births_ConstantTrend_residue_zeroCycle_residue_Lag64 -0.0823971348551
INFO:pyaf.std:AR_MODEL_COEFF 9 _births_ConstantTrend_residue_zeroCycle_residue_Lag50 -0.0819688788485
INFO:pyaf.std:AR_MODEL_COEFF 10 _births_ConstantTrend_residue_zeroCycle_residue_Lag57 -0.0784362084984
INFO:pyaf.std:AR_MODEL_DETAIL_END
In [7]:
lEngine.standardPlots()
INFO:pyaf.std:START_PLOTTING
/home/antoine/dev/python/packages/pyaf/TS/Plots.py:31: UserWarning:
This call to matplotlib.use() has no effect because the backend has already
been chosen; matplotlib.use() must be called *before* pylab, matplotlib.pyplot,
or matplotlib.backends is imported for the first time.
The backend was *originally* set to 'module://ipykernel.pylab.backend_inline' by the following code:
File "/usr/lib/python3.6/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/usr/lib/python3.6/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py", line 16, in <module>
app.launch_new_instance()
File "/home/antoine/.local/lib/python3.6/site-packages/traitlets/config/application.py", line 658, in launch_instance
app.start()
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelapp.py", line 477, in start
ioloop.IOLoop.instance().start()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/ioloop.py", line 177, in start
super(ZMQIOLoop, self).start()
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/ioloop.py", line 888, in start
handler_func(fd_obj, events)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 440, in _handle_events
self._handle_recv()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 472, in _handle_recv
self._run_callback(callback, msg)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 414, in _run_callback
callback(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 283, in dispatcher
return self.dispatch_shell(stream, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 235, in dispatch_shell
handler(stream, idents, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 399, in execute_request
user_expressions, allow_stdin)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/ipkernel.py", line 196, in do_execute
res = shell.run_cell(code, store_history=store_history, silent=silent)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/zmqshell.py", line 533, in run_cell
return super(ZMQInteractiveShell, self).run_cell(*args, **kwargs)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2718, in run_cell
interactivity=interactivity, compiler=compiler, result=result)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2828, in run_ast_nodes
if self.run_code(code, result):
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2882, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "<ipython-input-1-d16c7dd4344a>", line 7, in <module>
get_ipython().magic('matplotlib inline')
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2160, in magic
return self.run_line_magic(magic_name, magic_arg_s)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2081, in run_line_magic
result = fn(*args,**kwargs)
File "<decorator-gen-105>", line 2, in matplotlib
File "/usr/lib/python3/dist-packages/IPython/core/magic.py", line 188, in <lambda>
call = lambda f, *a, **k: f(*a, **k)
File "/usr/lib/python3/dist-packages/IPython/core/magics/pylab.py", line 100, in matplotlib
gui, backend = self.shell.enable_matplotlib(args.gui)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2950, in enable_matplotlib
pt.activate_matplotlib(backend)
File "/usr/lib/python3/dist-packages/IPython/core/pylabtools.py", line 309, in activate_matplotlib
matplotlib.pyplot.switch_backend(backend)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/pyplot.py", line 229, in switch_backend
matplotlib.use(newbackend, warn=False, force=True)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/__init__.py", line 1305, in use
reload(sys.modules['matplotlib.backends'])
File "/usr/lib/python3.6/importlib/__init__.py", line 166, in reload
_bootstrap._exec(spec, module)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/backends/__init__.py", line 14, in <module>
line for line in traceback.format_stack()
matplotlib.use('Agg')
/home/antoine/dev/python/packages/pyaf/TS/Plots.py:31: UserWarning:
This call to matplotlib.use() has no effect because the backend has already
been chosen; matplotlib.use() must be called *before* pylab, matplotlib.pyplot,
or matplotlib.backends is imported for the first time.
The backend was *originally* set to 'module://ipykernel.pylab.backend_inline' by the following code:
File "/usr/lib/python3.6/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/usr/lib/python3.6/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py", line 16, in <module>
app.launch_new_instance()
File "/home/antoine/.local/lib/python3.6/site-packages/traitlets/config/application.py", line 658, in launch_instance
app.start()
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelapp.py", line 477, in start
ioloop.IOLoop.instance().start()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/ioloop.py", line 177, in start
super(ZMQIOLoop, self).start()
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/ioloop.py", line 888, in start
handler_func(fd_obj, events)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 440, in _handle_events
self._handle_recv()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 472, in _handle_recv
self._run_callback(callback, msg)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 414, in _run_callback
callback(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 283, in dispatcher
return self.dispatch_shell(stream, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 235, in dispatch_shell
handler(stream, idents, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 399, in execute_request
user_expressions, allow_stdin)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/ipkernel.py", line 196, in do_execute
res = shell.run_cell(code, store_history=store_history, silent=silent)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/zmqshell.py", line 533, in run_cell
return super(ZMQInteractiveShell, self).run_cell(*args, **kwargs)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2718, in run_cell
interactivity=interactivity, compiler=compiler, result=result)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2828, in run_ast_nodes
if self.run_code(code, result):
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2882, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "<ipython-input-1-d16c7dd4344a>", line 7, in <module>
get_ipython().magic('matplotlib inline')
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2160, in magic
return self.run_line_magic(magic_name, magic_arg_s)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2081, in run_line_magic
result = fn(*args,**kwargs)
File "<decorator-gen-105>", line 2, in matplotlib
File "/usr/lib/python3/dist-packages/IPython/core/magic.py", line 188, in <lambda>
call = lambda f, *a, **k: f(*a, **k)
File "/usr/lib/python3/dist-packages/IPython/core/magics/pylab.py", line 100, in matplotlib
gui, backend = self.shell.enable_matplotlib(args.gui)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2950, in enable_matplotlib
pt.activate_matplotlib(backend)
File "/usr/lib/python3/dist-packages/IPython/core/pylabtools.py", line 309, in activate_matplotlib
matplotlib.pyplot.switch_backend(backend)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/pyplot.py", line 229, in switch_backend
matplotlib.use(newbackend, warn=False, force=True)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/__init__.py", line 1305, in use
reload(sys.modules['matplotlib.backends'])
File "/usr/lib/python3.6/importlib/__init__.py", line 166, in reload
_bootstrap._exec(spec, module)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/backends/__init__.py", line 14, in <module>
line for line in traceback.format_stack()
matplotlib.use('Agg')
/home/antoine/dev/python/packages/pyaf/TS/Plots.py:107: UserWarning:
This call to matplotlib.use() has no effect because the backend has already
been chosen; matplotlib.use() must be called *before* pylab, matplotlib.pyplot,
or matplotlib.backends is imported for the first time.
The backend was *originally* set to 'module://ipykernel.pylab.backend_inline' by the following code:
File "/usr/lib/python3.6/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/usr/lib/python3.6/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py", line 16, in <module>
app.launch_new_instance()
File "/home/antoine/.local/lib/python3.6/site-packages/traitlets/config/application.py", line 658, in launch_instance
app.start()
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelapp.py", line 477, in start
ioloop.IOLoop.instance().start()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/ioloop.py", line 177, in start
super(ZMQIOLoop, self).start()
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/ioloop.py", line 888, in start
handler_func(fd_obj, events)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 440, in _handle_events
self._handle_recv()
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 472, in _handle_recv
self._run_callback(callback, msg)
File "/home/antoine/.local/lib/python3.6/site-packages/zmq/eventloop/zmqstream.py", line 414, in _run_callback
callback(*args, **kwargs)
File "/home/antoine/.local/lib/python3.6/site-packages/tornado/stack_context.py", line 277, in null_wrapper
return fn(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 283, in dispatcher
return self.dispatch_shell(stream, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 235, in dispatch_shell
handler(stream, idents, msg)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/kernelbase.py", line 399, in execute_request
user_expressions, allow_stdin)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/ipkernel.py", line 196, in do_execute
res = shell.run_cell(code, store_history=store_history, silent=silent)
File "/usr/local/lib/python3.6/dist-packages/ipykernel/zmqshell.py", line 533, in run_cell
return super(ZMQInteractiveShell, self).run_cell(*args, **kwargs)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2718, in run_cell
interactivity=interactivity, compiler=compiler, result=result)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2828, in run_ast_nodes
if self.run_code(code, result):
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2882, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "<ipython-input-1-d16c7dd4344a>", line 7, in <module>
get_ipython().magic('matplotlib inline')
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2160, in magic
return self.run_line_magic(magic_name, magic_arg_s)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2081, in run_line_magic
result = fn(*args,**kwargs)
File "<decorator-gen-105>", line 2, in matplotlib
File "/usr/lib/python3/dist-packages/IPython/core/magic.py", line 188, in <lambda>
call = lambda f, *a, **k: f(*a, **k)
File "/usr/lib/python3/dist-packages/IPython/core/magics/pylab.py", line 100, in matplotlib
gui, backend = self.shell.enable_matplotlib(args.gui)
File "/usr/lib/python3/dist-packages/IPython/core/interactiveshell.py", line 2950, in enable_matplotlib
pt.activate_matplotlib(backend)
File "/usr/lib/python3/dist-packages/IPython/core/pylabtools.py", line 309, in activate_matplotlib
matplotlib.pyplot.switch_backend(backend)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/pyplot.py", line 229, in switch_backend
matplotlib.use(newbackend, warn=False, force=True)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/__init__.py", line 1305, in use
reload(sys.modules['matplotlib.backends'])
File "/usr/lib/python3.6/importlib/__init__.py", line 166, in reload
_bootstrap._exec(spec, module)
File "/home/antoine/.local/lib/python3.6/site-packages/matplotlib/backends/__init__.py", line 14, in <module>
line for line in traceback.format_stack()
matplotlib.use('Agg')
INFO:pyaf.std:END_PLOTTING_TIME_IN_SECONDS 30.110551118850708
In [8]:
dfapp_out = lEngine.forecast(df, H);
#dfapp_out.to_csv("births.csv")
dfapp_out.tail(2 * H)
INFO:pyaf.std:START_FORECASTING
INFO:pyaf.std:END_FORECAST_TIME_IN_SECONDS 14.801409721374512
Out[8]:
_births
births
date
row_number
date_Normalized
_births_ConstantTrend
_births_ConstantTrend_residue
_births_ConstantTrend_residue_zeroCycle
_births_ConstantTrend_residue_zeroCycle_residue
_births_ConstantTrend_residue_zeroCycle_residue_AR(64)
...
_births_Cycle
_births_Cycle_residue
_births_AR
_births_AR_residue
_births_TransformedForecast
births_Forecast
_births_TransformedResidue
births_Residue
births_Forecast_Lower_Bound
births_Forecast_Upper_Bound
7274
11227.0
11227.0
1988-12-01
7274
1.250258
9449.814057
1777.185943
0.0
1777.185943
1116.078624
...
0.0
1777.185943
1116.078624
661.107319
10565.892681
10565.892681
661.107319
661.107319
NaN
NaN
7275
10899.0
10899.0
1988-12-02
7275
1.250430
9449.814057
1449.185943
0.0
1449.185943
1499.145440
...
0.0
1449.185943
1499.145440
-49.959497
10948.959497
10948.959497
-49.959497
-49.959497
NaN
NaN
7276
8870.0
8870.0
1988-12-03
7276
1.250602
9449.814057
-579.814057
0.0
-579.814057
-757.067027
...
0.0
-579.814057
-757.067027
177.252969
8692.747031
8692.747031
177.252969
177.252969
NaN
NaN
7277
8324.0
8324.0
1988-12-04
7277
1.250773
9449.814057
-1125.814057
0.0
-1125.814057
-1064.678738
...
0.0
-1125.814057
-1064.678738
-61.135319
8385.135319
8385.135319
-61.135319
-61.135319
NaN
NaN
7278
10651.0
10651.0
1988-12-05
7278
1.250945
9449.814057
1201.185943
0.0
1201.185943
1137.690845
...
0.0
1201.185943
1137.690845
63.495097
10587.504903
10587.504903
63.495097
63.495097
NaN
NaN
7279
11297.0
11297.0
1988-12-06
7279
1.251117
9449.814057
1847.185943
0.0
1847.185943
1814.413711
...
0.0
1847.185943
1814.413711
32.772232
11264.227768
11264.227768
32.772232
32.772232
NaN
NaN
7280
11095.0
11095.0
1988-12-07
7280
1.251289
9449.814057
1645.185943
0.0
1645.185943
1279.868191
...
0.0
1645.185943
1279.868191
365.317752
10729.682248
10729.682248
365.317752
365.317752
NaN
NaN
7281
11131.0
11131.0
1988-12-08
7281
1.251461
9449.814057
1681.185943
0.0
1681.185943
1418.227348
...
0.0
1681.185943
1418.227348
262.958595
10868.041405
10868.041405
262.958595
262.958595
NaN
NaN
7282
10878.0
10878.0
1988-12-09
7282
1.251633
9449.814057
1428.185943
0.0
1428.185943
1587.522525
...
0.0
1428.185943
1587.522525
-159.336583
11037.336583
11037.336583
-159.336583
-159.336583
NaN
NaN
7283
8825.0
8825.0
1988-12-10
7283
1.251805
9449.814057
-624.814057
0.0
-624.814057
-614.465444
...
0.0
-624.814057
-614.465444
-10.348614
8835.348614
8835.348614
-10.348614
-10.348614
NaN
NaN
7284
8452.0
8452.0
1988-12-11
7284
1.251977
9449.814057
-997.814057
0.0
-997.814057
-987.814158
...
0.0
-997.814057
-987.814158
-9.999899
8461.999899
8461.999899
-9.999899
-9.999899
NaN
NaN
7285
10959.0
10959.0
1988-12-12
7285
1.252149
9449.814057
1509.185943
0.0
1509.185943
1387.225135
...
0.0
1509.185943
1387.225135
121.960807
10837.039193
10837.039193
121.960807
121.960807
NaN
NaN
7286
11283.0
11283.0
1988-12-13
7286
1.252320
9449.814057
1833.185943
0.0
1833.185943
2050.910759
...
0.0
1833.185943
2050.910759
-217.724817
11500.724817
11500.724817
-217.724817
-217.724817
NaN
NaN
7287
11362.0
11362.0
1988-12-14
7287
1.252492
9449.814057
1912.185943
0.0
1912.185943
1562.416543
...
0.0
1912.185943
1562.416543
349.769399
11012.230601
11012.230601
349.769399
349.769399
NaN
NaN
7288
11364.0
11364.0
1988-12-15
7288
1.252664
9449.814057
1914.185943
0.0
1914.185943
1635.178584
...
0.0
1914.185943
1635.178584
279.007358
11084.992642
11084.992642
279.007358
279.007358
NaN
NaN
7289
11463.0
11463.0
1988-12-16
7289
1.252836
9449.814057
2013.185943
0.0
2013.185943
1820.689375
...
0.0
2013.185943
1820.689375
192.496567
11270.503433
11270.503433
192.496567
192.496567
NaN
NaN
7290
8756.0
8756.0
1988-12-17
7290
1.253008
9449.814057
-693.814057
0.0
-693.814057
-381.633329
...
0.0
-693.814057
-381.633329
-312.180728
9068.180728
9068.180728
-312.180728
-312.180728
NaN
NaN
7291
8431.0
8431.0
1988-12-18
7291
1.253180
9449.814057
-1018.814057
0.0
-1018.814057
-1075.119919
...
0.0
-1018.814057
-1075.119919
56.305862
8374.694138
8374.694138
56.305862
56.305862
NaN
NaN
7292
11716.0
11716.0
1988-12-19
7292
1.253352
9449.814057
2266.185943
0.0
2266.185943
1563.906251
...
0.0
2266.185943
1563.906251
702.279692
11013.720308
11013.720308
702.279692
702.279692
NaN
NaN
7293
12435.0
12435.0
1988-12-20
7293
1.253524
9449.814057
2985.185943
0.0
2985.185943
2428.148879
...
0.0
2985.185943
2428.148879
557.037064
11877.962936
11877.962936
557.037064
557.037064
NaN
NaN
7294
11323.0
11323.0
1988-12-21
7294
1.253695
9449.814057
1873.185943
0.0
1873.185943
1877.165355
...
0.0
1873.185943
1877.165355
-3.979412
11326.979412
11326.979412
-3.979412
-3.979412
NaN
NaN
7295
10729.0
10729.0
1988-12-22
7295
1.253867
9449.814057
1279.185943
0.0
1279.185943
1526.914423
...
0.0
1279.185943
1526.914423
-247.728480
10976.728480
10976.728480
-247.728480
-247.728480
NaN
NaN
7296
9997.0
9997.0
1988-12-23
7296
1.254039
9449.814057
547.185943
0.0
547.185943
1472.944034
...
0.0
547.185943
1472.944034
-925.758092
10922.758092
10922.758092
-925.758092
-925.758092
NaN
NaN
7297
8293.0
8293.0
1988-12-24
7297
1.254211
9449.814057
-1156.814057
0.0
-1156.814057
-959.065392
...
0.0
-1156.814057
-959.065392
-197.748665
8490.748665
8490.748665
-197.748665
-197.748665
NaN
NaN
7298
7835.0
7835.0
1988-12-25
7298
1.254383
9449.814057
-1614.814057
0.0
-1614.814057
-1247.524804
...
0.0
-1614.814057
-1247.524804
-367.289253
8202.289253
8202.289253
-367.289253
-367.289253
NaN
NaN
7299
8683.0
8683.0
1988-12-26
7299
1.254555
9449.814057
-766.814057
0.0
-766.814057
1262.035224
...
0.0
-766.814057
1262.035224
-2028.849282
10711.849282
10711.849282
-2028.849282
-2028.849282
NaN
NaN
7300
11528.0
11528.0
1988-12-27
7300
1.254727
9449.814057
2078.185943
0.0
2078.185943
1328.413909
...
0.0
2078.185943
1328.413909
749.772034
10778.227966
10778.227966
749.772034
749.772034
NaN
NaN
7301
11847.0
11847.0
1988-12-28
7301
1.254899
9449.814057
2397.185943
0.0
2397.185943
1856.882652
...
0.0
2397.185943
1856.882652
540.303290
11306.696710
11306.696710
540.303290
540.303290
NaN
NaN
7302
11704.0
11704.0
1988-12-29
7302
1.255070
9449.814057
2254.185943
0.0
2254.185943
1711.392582
...
0.0
2254.185943
1711.392582
542.793361
11161.206639
11161.206639
542.793361
542.793361
NaN
NaN
7303
11837.0
11837.0
1988-12-30
7303
1.255242
9449.814057
2387.185943
0.0
2387.185943
1824.411372
...
0.0
2387.185943
1824.411372
562.774570
11274.225430
11274.225430
562.774570
562.774570
NaN
NaN
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
7306
NaN
NaN
1989-01-02
7306
1.255758
9449.814057
NaN
0.0
NaN
669.389387
...
0.0
NaN
669.389387
NaN
10119.203444
10119.203444
NaN
NaN
9.239051e+03
1.099936e+04
7307
NaN
NaN
1989-01-03
7307
1.255930
9449.814057
NaN
0.0
NaN
1528.447100
...
0.0
NaN
1528.447100
NaN
10978.261157
10978.261157
NaN
NaN
1.001228e+04
1.194424e+04
7308
NaN
NaN
1989-01-04
7308
1.256102
9449.814057
NaN
0.0
NaN
1356.819425
...
0.0
NaN
1356.819425
NaN
10806.633482
10806.633482
NaN
NaN
9.746209e+03
1.186706e+04
7309
NaN
NaN
1989-01-05
7309
1.256274
9449.814057
NaN
0.0
NaN
1266.094670
...
0.0
NaN
1266.094670
NaN
10715.908727
10715.908727
NaN
NaN
9.558453e+03
1.187336e+04
7310
NaN
NaN
1989-01-06
7310
1.256446
9449.814057
NaN
0.0
NaN
1460.290062
...
0.0
NaN
1460.290062
NaN
10910.104119
10910.104119
NaN
NaN
9.627951e+03
1.219226e+04
7311
NaN
NaN
1989-01-07
7311
1.256617
9449.814057
NaN
0.0
NaN
-624.983781
...
0.0
NaN
-624.983781
NaN
8824.830277
8824.830277
NaN
NaN
7.373621e+03
1.027604e+04
7312
NaN
NaN
1989-01-08
7312
1.256789
9449.814057
NaN
0.0
NaN
-1155.412060
...
0.0
NaN
-1155.412060
NaN
8294.401997
8294.401997
NaN
NaN
6.599698e+03
9.989106e+03
7313
NaN
NaN
1989-01-09
7313
1.256961
9449.814057
NaN
0.0
NaN
1141.838929
...
0.0
NaN
1141.838929
NaN
10591.652987
10591.652987
NaN
NaN
8.551201e+03
1.263211e+04
7314
NaN
NaN
1989-01-10
7314
1.257133
9449.814057
NaN
0.0
NaN
1860.078042
...
0.0
NaN
1860.078042
NaN
11309.892099
11309.892099
NaN
NaN
8.789025e+03
1.383076e+04
7315
NaN
NaN
1989-01-11
7315
1.257305
9449.814057
NaN
0.0
NaN
1641.450903
...
0.0
NaN
1641.450903
NaN
11091.264961
11091.264961
NaN
NaN
7.835582e+03
1.434695e+04
7316
NaN
NaN
1989-01-12
7316
1.257477
9449.814057
NaN
0.0
NaN
1557.925744
...
0.0
NaN
1557.925744
NaN
11007.739801
11007.739801
NaN
NaN
6.707366e+03
1.530811e+04
7317
NaN
NaN
1989-01-13
7317
1.257649
9449.814057
NaN
0.0
NaN
1592.398739
...
0.0
NaN
1592.398739
NaN
11042.212797
11042.212797
NaN
NaN
5.280683e+03
1.680374e+04
7318
NaN
NaN
1989-01-14
7318
1.257821
9449.814057
NaN
0.0
NaN
-637.460509
...
0.0
NaN
-637.460509
NaN
8812.353548
8812.353548
NaN
NaN
8.759155e+02
1.674879e+04
7319
NaN
NaN
1989-01-15
7319
1.257992
9449.814057
NaN
0.0
NaN
-1099.899056
...
0.0
NaN
-1099.899056
NaN
8349.915001
8349.915001
NaN
NaN
-2.753284e+03
1.945311e+04
7320
NaN
NaN
1989-01-16
7320
1.258164
9449.814057
NaN
0.0
NaN
1227.994679
...
0.0
NaN
1227.994679
NaN
10677.808736
10677.808736
NaN
NaN
-4.876368e+03
2.623199e+04
7321
NaN
NaN
1989-01-17
7321
1.258336
9449.814057
NaN
0.0
NaN
2056.983285
...
0.0
NaN
2056.983285
NaN
11506.797343
11506.797343
NaN
NaN
-1.034304e+04
3.335664e+04
7322
NaN
NaN
1989-01-18
7322
1.258508
9449.814057
NaN
0.0
NaN
1613.989166
...
0.0
NaN
1613.989166
NaN
11063.803223
11063.803223
NaN
NaN
-1.968077e+04
4.180838e+04
7323
NaN
NaN
1989-01-19
7323
1.258680
9449.814057
NaN
0.0
NaN
1277.290625
...
0.0
NaN
1277.290625
NaN
10727.104683
10727.104683
NaN
NaN
-3.253344e+04
5.398765e+04
7324
NaN
NaN
1989-01-20
7324
1.258852
9449.814057
NaN
0.0
NaN
1505.648633
...
0.0
NaN
1505.648633
NaN
10955.462690
10955.462690
NaN
NaN
-4.988817e+04
7.179910e+04
7325
NaN
NaN
1989-01-21
7325
1.259024
9449.814057
NaN
0.0
NaN
-793.278201
...
0.0
NaN
-793.278201
NaN
8656.535857
8656.535857
NaN
NaN
-7.693041e+04
9.424348e+04
7326
NaN
NaN
1989-01-22
7326
1.259196
9449.814057
NaN
0.0
NaN
-1301.362305
...
0.0
NaN
-1301.362305
NaN
8148.451752
8148.451752
NaN
NaN
-1.123883e+05
1.286852e+05
7327
NaN
NaN
1989-01-23
7327
1.259367
9449.814057
NaN
0.0
NaN
1036.540281
...
0.0
NaN
1036.540281
NaN
10486.354338
10486.354338
NaN
NaN
-1.594547e+05
1.804274e+05
7328
NaN
NaN
1989-01-24
7328
1.259539
9449.814057
NaN
0.0
NaN
1904.842548
...
0.0
NaN
1904.842548
NaN
11354.656606
11354.656606
NaN
NaN
-2.283768e+05
2.510861e+05
7329
NaN
NaN
1989-01-25
7329
1.259711
9449.814057
NaN
0.0
NaN
1646.063163
...
0.0
NaN
1646.063163
NaN
11095.877220
11095.877220
NaN
NaN
-3.275407e+05
3.497324e+05
7330
NaN
NaN
1989-01-26
7330
1.259883
9449.814057
NaN
0.0
NaN
1318.249736
...
0.0
NaN
1318.249736
NaN
10768.063794
10768.063794
NaN
NaN
-4.672784e+05
4.888145e+05
7331
NaN
NaN
1989-01-27
7331
1.260055
9449.814057
NaN
0.0
NaN
1511.350136
...
0.0
NaN
1511.350136
NaN
10961.164193
10961.164193
NaN
NaN
-6.655745e+05
6.874968e+05
7332
NaN
NaN
1989-01-28
7332
1.260227
9449.814057
NaN
0.0
NaN
-491.857198
...
0.0
NaN
-491.857198
NaN
8957.956859
8957.956859
NaN
NaN
-9.486709e+05
9.665868e+05
7333
NaN
NaN
1989-01-29
7333
1.260399
9449.814057
NaN
0.0
NaN
-1095.317114
...
0.0
NaN
-1095.317114
NaN
8354.496943
8354.496943
NaN
NaN
-1.352015e+06
1.368724e+06
7334
NaN
NaN
1989-01-30
7334
1.260571
9449.814057
NaN
0.0
NaN
942.127070
...
0.0
NaN
942.127070
NaN
10391.941128
10391.941128
NaN
NaN
-1.928111e+06
1.948895e+06
7335
NaN
NaN
1989-01-31
7335
1.260743
9449.814057
NaN
0.0
NaN
1744.454728
...
0.0
NaN
1744.454728
NaN
11194.268785
11194.268785
NaN
NaN
-2.762340e+06
2.784729e+06
62 rows × 23 columns
In [ ]:
Content source: antoinecarme/pyaf
Similar notebooks: