Created
January 25, 2012 22:33
-
-
Save adamgreenhall/1679296 to your computer and use it in GitHub Desktop.
fitting parameters for an ARMA model using statsmodels
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| time | wind | |
|---|---|---|
| 2010-01-01 00:00:00 | 1367 | |
| 2010-01-01 01:00:00 | 1187 | |
| 2010-01-01 02:00:00 | 1090 | |
| 2010-01-01 03:00:00 | 1439 | |
| 2010-01-01 04:00:00 | 2362 | |
| 2010-01-01 05:00:00 | 2783 | |
| 2010-01-01 06:00:00 | 2869 | |
| 2010-01-01 07:00:00 | 2512 | |
| 2010-01-01 08:00:00 | 1804 | |
| 2010-01-01 09:00:00 | 1544 | |
| 2010-01-01 10:00:00 | 1028 | |
| 2010-01-01 11:00:00 | 869 | |
| 2010-01-01 12:00:00 | 1737 | |
| 2010-01-01 13:00:00 | 2055 | |
| 2010-01-01 14:00:00 | 1947 | |
| 2010-01-01 15:00:00 | 1618 | |
| 2010-01-01 16:00:00 | 1196 | |
| 2010-01-01 17:00:00 | 867 | |
| 2010-01-01 18:00:00 | 997 | |
| 2010-01-01 19:00:00 | 1862 | |
| 2010-01-01 20:00:00 | 2525 | |
| 2010-01-01 21:00:00 | 3250 | |
| 2010-01-01 22:00:00 | 4023 | |
| 2010-01-01 23:00:00 | 4018 | |
| 2010-01-02 00:00:00 | 3585 | |
| 2010-01-02 01:00:00 | 3004 | |
| 2010-01-02 02:00:00 | 2500 | |
| 2010-01-02 03:00:00 | 2441 | |
| 2010-01-02 04:00:00 | 2749 | |
| 2010-01-02 05:00:00 | 2466 | |
| 2010-01-02 06:00:00 | 2157 | |
| 2010-01-02 07:00:00 | 1847 | |
| 2010-01-02 08:00:00 | 1463 | |
| 2010-01-02 09:00:00 | 1146 | |
| 2010-01-02 10:00:00 | 851 | |
| 2010-01-02 11:00:00 | 993 | |
| 2010-01-02 12:00:00 | 1448 | |
| 2010-01-02 13:00:00 | 1719 | |
| 2010-01-02 14:00:00 | 1709 | |
| 2010-01-02 15:00:00 | 1455 | |
| 2010-01-02 16:00:00 | 1950 | |
| 2010-01-02 17:00:00 | 1763 | |
| 2010-01-02 18:00:00 | 2075 | |
| 2010-01-02 19:00:00 | 2343 | |
| 2010-01-02 20:00:00 | 3570 | |
| 2010-01-02 21:00:00 | 4690 | |
| 2010-01-02 22:00:00 | 3700 | |
| 2010-01-02 23:00:00 | 2339 | |
| 2010-01-03 00:00:00 | 1679 | |
| 2010-01-03 01:00:00 | 1466 | |
| 2010-01-03 02:00:00 | 998 | |
| 2010-01-03 03:00:00 | 853 | |
| 2010-01-03 04:00:00 | 835 | |
| 2010-01-03 05:00:00 | 922 | |
| 2010-01-03 06:00:00 | 851 | |
| 2010-01-03 07:00:00 | 1125 | |
| 2010-01-03 08:00:00 | 1299 | |
| 2010-01-03 09:00:00 | 1105 | |
| 2010-01-03 10:00:00 | 860 | |
| 2010-01-03 11:00:00 | 701 | |
| 2010-01-03 12:00:00 | 689 | |
| 2010-01-03 13:00:00 | 774 | |
| 2010-01-03 14:00:00 | 582 | |
| 2010-01-03 15:00:00 | 419 | |
| 2010-01-03 16:00:00 | 846 | |
| 2010-01-03 17:00:00 | 1132 | |
| 2010-01-03 18:00:00 | 902 | |
| 2010-01-03 19:00:00 | 1058 | |
| 2010-01-03 20:00:00 | 1341 | |
| 2010-01-03 21:00:00 | 1551 | |
| 2010-01-03 22:00:00 | 1167 | |
| 2010-01-03 23:00:00 | 975 | |
| 2010-01-04 00:00:00 | 786 | |
| 2010-01-04 01:00:00 | 759 | |
| 2010-01-04 02:00:00 | 751 | |
| 2010-01-04 03:00:00 | 649 | |
| 2010-01-04 04:00:00 | 876 | |
| 2010-01-04 05:00:00 | 720 | |
| 2010-01-04 06:00:00 | 498 | |
| 2010-01-04 07:00:00 | 553 | |
| 2010-01-04 08:00:00 | 459 | |
| 2010-01-04 09:00:00 | 543 | |
| 2010-01-04 10:00:00 | 447 | |
| 2010-01-04 11:00:00 | 415 | |
| 2010-01-04 12:00:00 | 377 | |
| 2010-01-04 13:00:00 | 373 | |
| 2010-01-04 14:00:00 | 324 | |
| 2010-01-04 15:00:00 | 320 | |
| 2010-01-04 16:00:00 | 306 | |
| 2010-01-04 17:00:00 | 259 | |
| 2010-01-04 18:00:00 | 220 | |
| 2010-01-04 19:00:00 | 342 | |
| 2010-01-04 20:00:00 | 558 | |
| 2010-01-04 21:00:00 | 825 | |
| 2010-01-04 22:00:00 | 994 | |
| 2010-01-04 23:00:00 | 1267 | |
| 2010-01-05 00:00:00 | 1473 | |
| 2010-01-05 01:00:00 | 1601 | |
| 2010-01-05 02:00:00 | 1896 | |
| 2010-01-05 03:00:00 | 1890 | |
| 2010-01-05 04:00:00 | 2012 | |
| 2010-01-05 05:00:00 | 2198 | |
| 2010-01-05 06:00:00 | 2393 | |
| 2010-01-05 07:00:00 | 2825 | |
| 2010-01-05 08:00:00 | 3411 | |
| 2010-01-05 09:00:00 | 3406 | |
| 2010-01-05 10:00:00 | 2464 | |
| 2010-01-05 11:00:00 | 2891 | |
| 2010-01-05 12:00:00 | 3685 | |
| 2010-01-05 13:00:00 | 3638 | |
| 2010-01-05 14:00:00 | 3746 | |
| 2010-01-05 15:00:00 | 3373 | |
| 2010-01-05 16:00:00 | 3190 | |
| 2010-01-05 17:00:00 | 2681 | |
| 2010-01-05 18:00:00 | 2846 | |
| 2010-01-05 19:00:00 | 4129 | |
| 2010-01-05 20:00:00 | 5054 | |
| 2010-01-05 21:00:00 | 5002 | |
| 2010-01-05 22:00:00 | 4801 | |
| 2010-01-05 23:00:00 | 4934 | |
| 2010-01-06 00:00:00 | 4903 | |
| 2010-01-06 01:00:00 | 4713 | |
| 2010-01-06 02:00:00 | 4745 | |
| 2010-01-06 03:00:00 | 4736 | |
| 2010-01-06 04:00:00 | 4622 | |
| 2010-01-06 05:00:00 | 4642 | |
| 2010-01-06 06:00:00 | 4478 | |
| 2010-01-06 07:00:00 | 4510 | |
| 2010-01-06 08:00:00 | 4758 | |
| 2010-01-06 09:00:00 | 4457 | |
| 2010-01-06 10:00:00 | 4356 | |
| 2010-01-06 11:00:00 | 4170 | |
| 2010-01-06 12:00:00 | 4658 | |
| 2010-01-06 13:00:00 | 4546 | |
| 2010-01-06 14:00:00 | 4402 | |
| 2010-01-06 15:00:00 | 4183 | |
| 2010-01-06 16:00:00 | 3574 | |
| 2010-01-06 17:00:00 | 2586 | |
| 2010-01-06 18:00:00 | 3326 | |
| 2010-01-06 19:00:00 | 3948 | |
| 2010-01-06 20:00:00 | 3983 | |
| 2010-01-06 21:00:00 | 3997 | |
| 2010-01-06 22:00:00 | 4422 | |
| 2010-01-06 23:00:00 | 4496 | |
| 2010-01-07 00:00:00 | 4276 | |
| 2010-01-07 01:00:00 | 3467 | |
| 2010-01-07 02:00:00 | 2753 | |
| 2010-01-07 03:00:00 | 2582 | |
| 2010-01-07 04:00:00 | 2921 | |
| 2010-01-07 05:00:00 | 2768 | |
| 2010-01-07 06:00:00 | 2789 | |
| 2010-01-07 07:00:00 | 2824 | |
| 2010-01-07 08:00:00 | 2482 | |
| 2010-01-07 09:00:00 | 2773 | |
| 2010-01-07 10:00:00 | 3005 | |
| 2010-01-07 11:00:00 | 3641 | |
| 2010-01-07 12:00:00 | 3699 | |
| 2010-01-07 13:00:00 | 3774 | |
| 2010-01-07 14:00:00 | 3698 | |
| 2010-01-07 15:00:00 | 3628 | |
| 2010-01-07 16:00:00 | 3180 | |
| 2010-01-07 17:00:00 | 3306 | |
| 2010-01-07 18:00:00 | 2841 | |
| 2010-01-07 19:00:00 | 2014 | |
| 2010-01-07 20:00:00 | 1910 | |
| 2010-01-07 21:00:00 | 2560 | |
| 2010-01-07 22:00:00 | 2980 | |
| 2010-01-07 23:00:00 | 3012 | |
| 2010-01-08 00:00:00 | 3210 | |
| 2010-01-08 01:00:00 | 3457 | |
| 2010-01-08 02:00:00 | 3158 | |
| 2010-01-08 03:00:00 | 3344 | |
| 2010-01-08 04:00:00 | 3609 | |
| 2010-01-08 05:00:00 | 3327 | |
| 2010-01-08 06:00:00 | 2913 | |
| 2010-01-08 07:00:00 | 2264 | |
| 2010-01-08 08:00:00 | 2326 | |
| 2010-01-08 09:00:00 | 2596 | |
| 2010-01-08 10:00:00 | 2225 | |
| 2010-01-08 11:00:00 | 1767 | |
| 2010-01-08 12:00:00 | 1190 | |
| 2010-01-08 13:00:00 | 792 | |
| 2010-01-08 14:00:00 | 669 | |
| 2010-01-08 15:00:00 | 589 | |
| 2010-01-08 16:00:00 | 496 | |
| 2010-01-08 17:00:00 | 354 | |
| 2010-01-08 18:00:00 | 246 | |
| 2010-01-08 19:00:00 | 250 | |
| 2010-01-08 20:00:00 | 323 | |
| 2010-01-08 21:00:00 | 495 | |
| 2010-01-08 22:00:00 | 924 | |
| 2010-01-08 23:00:00 | 1536 | |
| 2010-01-09 00:00:00 | 2081 | |
| 2010-01-09 01:00:00 | 2660 | |
| 2010-01-09 02:00:00 | 2814 | |
| 2010-01-09 03:00:00 | 2992 | |
| 2010-01-09 04:00:00 | 3115 | |
| 2010-01-09 05:00:00 | 2962 | |
| 2010-01-09 06:00:00 | 2272 | |
| 2010-01-09 07:00:00 | 2151 | |
| 2010-01-09 08:00:00 | 1889 | |
| 2010-01-09 09:00:00 | 1481 | |
| 2010-01-09 10:00:00 | 955 | |
| 2010-01-09 11:00:00 | 631 | |
| 2010-01-09 12:00:00 | 288 | |
| 2010-01-09 13:00:00 | 103 | |
| 2010-01-09 14:00:00 | 60 | |
| 2010-01-09 15:00:00 | 82 | |
| 2010-01-09 16:00:00 | 107 | |
| 2010-01-09 17:00:00 | 185 | |
| 2010-01-09 18:00:00 | 618 | |
| 2010-01-09 19:00:00 | 1526 | |
| 2010-01-09 20:00:00 | 2046 | |
| 2010-01-09 21:00:00 | 2348 | |
| 2010-01-09 22:00:00 | 2584 | |
| 2010-01-09 23:00:00 | 2600 | |
| 2010-01-10 00:00:00 | 2515 | |
| 2010-01-10 01:00:00 | 2345 | |
| 2010-01-10 02:00:00 | 2351 | |
| 2010-01-10 03:00:00 | 2355 | |
| 2010-01-10 04:00:00 | 2409 | |
| 2010-01-10 05:00:00 | 2449 | |
| 2010-01-10 06:00:00 | 2645 | |
| 2010-01-10 07:00:00 | 2918 | |
| 2010-01-10 08:00:00 | 3187 | |
| 2010-01-10 09:00:00 | 2888 | |
| 2010-01-10 10:00:00 | 2610 | |
| 2010-01-10 11:00:00 | 2740 | |
| 2010-01-10 12:00:00 | 2526 | |
| 2010-01-10 13:00:00 | 2383 | |
| 2010-01-10 14:00:00 | 2936 | |
| 2010-01-10 15:00:00 | 2968 | |
| 2010-01-10 16:00:00 | 2635 | |
| 2010-01-10 17:00:00 | 2617 | |
| 2010-01-10 18:00:00 | 2790 | |
| 2010-01-10 19:00:00 | 3906 | |
| 2010-01-10 20:00:00 | 4018 | |
| 2010-01-10 21:00:00 | 4797 | |
| 2010-01-10 22:00:00 | 4919 | |
| 2010-01-10 23:00:00 | 4942 | |
| 2010-01-11 00:00:00 | 4656 | |
| 2010-01-11 01:00:00 | 4444 | |
| 2010-01-11 02:00:00 | 3898 | |
| 2010-01-11 03:00:00 | 3908 | |
| 2010-01-11 04:00:00 | 3678 | |
| 2010-01-11 05:00:00 | 3605 | |
| 2010-01-11 06:00:00 | 3186 | |
| 2010-01-11 07:00:00 | 2139 | |
| 2010-01-11 08:00:00 | 2002 | |
| 2010-01-11 09:00:00 | 1559 | |
| 2010-01-11 10:00:00 | 1235 | |
| 2010-01-11 11:00:00 | 1183 | |
| 2010-01-11 12:00:00 | 1096 | |
| 2010-01-11 13:00:00 | 673 | |
| 2010-01-11 14:00:00 | 389 | |
| 2010-01-11 15:00:00 | 223 | |
| 2010-01-11 16:00:00 | 352 | |
| 2010-01-11 17:00:00 | 308 | |
| 2010-01-11 18:00:00 | 365 | |
| 2010-01-11 19:00:00 | 525 | |
| 2010-01-11 20:00:00 | 779 | |
| 2010-01-11 21:00:00 | 894 | |
| 2010-01-11 22:00:00 | 901 | |
| 2010-01-11 23:00:00 | 1025 | |
| 2010-01-12 00:00:00 | 1047 | |
| 2010-01-12 01:00:00 | 981 | |
| 2010-01-12 02:00:00 | 902 | |
| 2010-01-12 03:00:00 | 759 | |
| 2010-01-12 04:00:00 | 569 | |
| 2010-01-12 05:00:00 | 519 | |
| 2010-01-12 06:00:00 | 408 | |
| 2010-01-12 07:00:00 | 263 | |
| 2010-01-12 08:00:00 | 156 | |
| 2010-01-12 09:00:00 | 72 | |
| 2010-01-12 10:00:00 | 49 | |
| 2010-01-12 11:00:00 | 31 | |
| 2010-01-12 12:00:00 | 41 | |
| 2010-01-12 13:00:00 | 192 | |
| 2010-01-12 14:00:00 | 423 | |
| 2010-01-12 15:00:00 | 492 | |
| 2010-01-12 16:00:00 | 552 | |
| 2010-01-12 17:00:00 | 564 | |
| 2010-01-12 18:00:00 | 723 | |
| 2010-01-12 19:00:00 | 921 | |
| 2010-01-12 20:00:00 | 1525 | |
| 2010-01-12 21:00:00 | 2768 | |
| 2010-01-12 22:00:00 | 3531 | |
| 2010-01-12 23:00:00 | 3824 | |
| 2010-01-13 00:00:00 | 3835 | |
| 2010-01-13 01:00:00 | 4294 | |
| 2010-01-13 02:00:00 | 4533 | |
| 2010-01-13 03:00:00 | 4173 | |
| 2010-01-13 04:00:00 | 4221 | |
| 2010-01-13 05:00:00 | 4064 | |
| 2010-01-13 06:00:00 | 4641 | |
| 2010-01-13 07:00:00 | 4685 | |
| 2010-01-13 08:00:00 | 4026 | |
| 2010-01-13 09:00:00 | 4323 | |
| 2010-01-13 10:00:00 | 4585 | |
| 2010-01-13 11:00:00 | 4836 | |
| 2010-01-13 12:00:00 | 4822 | |
| 2010-01-13 13:00:00 | 4631 | |
| 2010-01-13 14:00:00 | 4614 | |
| 2010-01-13 15:00:00 | 4326 | |
| 2010-01-13 16:00:00 | 4790 | |
| 2010-01-13 17:00:00 | 4736 | |
| 2010-01-13 18:00:00 | 4104 | |
| 2010-01-13 19:00:00 | 5099 | |
| 2010-01-13 20:00:00 | 5154 | |
| 2010-01-13 21:00:00 | 5121 | |
| 2010-01-13 22:00:00 | 5384 | |
| 2010-01-13 23:00:00 | 5274 | |
| 2010-01-14 00:00:00 | 5225 | |
| 2010-01-14 01:00:00 | 4899 | |
| 2010-01-14 02:00:00 | 5382 | |
| 2010-01-14 03:00:00 | 5295 | |
| 2010-01-14 04:00:00 | 5349 | |
| 2010-01-14 05:00:00 | 4977 | |
| 2010-01-14 06:00:00 | 4597 | |
| 2010-01-14 07:00:00 | 4069 | |
| 2010-01-14 08:00:00 | 3733 | |
| 2010-01-14 09:00:00 | 3439 | |
| 2010-01-14 10:00:00 | 3052 | |
| 2010-01-14 11:00:00 | 2626 | |
| 2010-01-14 12:00:00 | 1939 | |
| 2010-01-14 13:00:00 | 1064 | |
| 2010-01-14 14:00:00 | 713 | |
| 2010-01-14 15:00:00 | 916 | |
| 2010-01-14 16:00:00 | 832 | |
| 2010-01-14 17:00:00 | 658 | |
| 2010-01-14 18:00:00 | 817 | |
| 2010-01-14 19:00:00 | 921 | |
| 2010-01-14 20:00:00 | 772 | |
| 2010-01-14 21:00:00 | 764 | |
| 2010-01-14 22:00:00 | 824 | |
| 2010-01-14 23:00:00 | 967 | |
| 2010-01-15 00:00:00 | 1127 | |
| 2010-01-15 01:00:00 | 1153 | |
| 2010-01-15 02:00:00 | 824 | |
| 2010-01-15 03:00:00 | 912 | |
| 2010-01-15 04:00:00 | 957 | |
| 2010-01-15 05:00:00 | 990 | |
| 2010-01-15 06:00:00 | 1218 | |
| 2010-01-15 07:00:00 | 1684 | |
| 2010-01-15 08:00:00 | 2030 | |
| 2010-01-15 09:00:00 | 2119 | |
| 2010-01-15 10:00:00 | 2233 | |
| 2010-01-15 11:00:00 | 2657 | |
| 2010-01-15 12:00:00 | 2652 | |
| 2010-01-15 13:00:00 | 2682 | |
| 2010-01-15 14:00:00 | 2498 | |
| 2010-01-15 15:00:00 | 2429 | |
| 2010-01-15 16:00:00 | 2346 | |
| 2010-01-15 17:00:00 | 2298 | |
| 2010-01-15 18:00:00 | 2129 | |
| 2010-01-15 19:00:00 | 1829 | |
| 2010-01-15 20:00:00 | 1816 | |
| 2010-01-15 21:00:00 | 1225 | |
| 2010-01-15 22:00:00 | 1010 | |
| 2010-01-15 23:00:00 | 748 | |
| 2010-01-16 00:00:00 | 627 | |
| 2010-01-16 01:00:00 | 469 | |
| 2010-01-16 02:00:00 | 576 | |
| 2010-01-16 03:00:00 | 532 | |
| 2010-01-16 04:00:00 | 475 | |
| 2010-01-16 05:00:00 | 582 | |
| 2010-01-16 06:00:00 | 641 | |
| 2010-01-16 07:00:00 | 605 | |
| 2010-01-16 08:00:00 | 699 | |
| 2010-01-16 09:00:00 | 680 | |
| 2010-01-16 10:00:00 | 714 | |
| 2010-01-16 11:00:00 | 670 | |
| 2010-01-16 12:00:00 | 666 | |
| 2010-01-16 13:00:00 | 636 | |
| 2010-01-16 14:00:00 | 672 | |
| 2010-01-16 15:00:00 | 679 | |
| 2010-01-16 16:00:00 | 446 | |
| 2010-01-16 17:00:00 | 248 | |
| 2010-01-16 18:00:00 | 134 | |
| 2010-01-16 19:00:00 | 160 | |
| 2010-01-16 20:00:00 | 178 | |
| 2010-01-16 21:00:00 | 286 | |
| 2010-01-16 22:00:00 | 413 | |
| 2010-01-16 23:00:00 | 676 | |
| 2010-01-17 00:00:00 | 1025 | |
| 2010-01-17 01:00:00 | 1159 | |
| 2010-01-17 02:00:00 | 952 | |
| 2010-01-17 03:00:00 | 1398 | |
| 2010-01-17 04:00:00 | 1833 | |
| 2010-01-17 05:00:00 | 2045 | |
| 2010-01-17 06:00:00 | 2072 | |
| 2010-01-17 07:00:00 | 1798 | |
| 2010-01-17 08:00:00 | 1799 | |
| 2010-01-17 09:00:00 | 1358 | |
| 2010-01-17 10:00:00 | 727 | |
| 2010-01-17 11:00:00 | 353 | |
| 2010-01-17 12:00:00 | 347 | |
| 2010-01-17 13:00:00 | 844 | |
| 2010-01-17 14:00:00 | 1377 | |
| 2010-01-17 15:00:00 | 1829 | |
| 2010-01-17 16:00:00 | 2118 | |
| 2010-01-17 17:00:00 | 2272 | |
| 2010-01-17 18:00:00 | 2745 | |
| 2010-01-17 19:00:00 | 4263 | |
| 2010-01-17 20:00:00 | 4314 | |
| 2010-01-17 21:00:00 | 4530 | |
| 2010-01-17 22:00:00 | 4354 | |
| 2010-01-17 23:00:00 | 4645 | |
| 2010-01-18 00:00:00 | 4547 | |
| 2010-01-18 01:00:00 | 5391 | |
| 2010-01-18 02:00:00 | 4855 | |
| 2010-01-18 03:00:00 | 4739 | |
| 2010-01-18 04:00:00 | 4520 | |
| 2010-01-18 05:00:00 | 4573 | |
| 2010-01-18 06:00:00 | 4305 | |
| 2010-01-18 07:00:00 | 4196 | |
| 2010-01-18 08:00:00 | 3773 | |
| 2010-01-18 09:00:00 | 3368 | |
| 2010-01-18 10:00:00 | 2596 | |
| 2010-01-18 11:00:00 | 2596 | |
| 2010-01-18 12:00:00 | 2305 | |
| 2010-01-18 13:00:00 | 2756 | |
| 2010-01-18 14:00:00 | 3747 | |
| 2010-01-18 15:00:00 | 4078 | |
| 2010-01-18 16:00:00 | 3415 | |
| 2010-01-18 17:00:00 | 2369 | |
| 2010-01-18 18:00:00 | 2210 | |
| 2010-01-18 19:00:00 | 2316 | |
| 2010-01-18 20:00:00 | 2263 | |
| 2010-01-18 21:00:00 | 2672 | |
| 2010-01-18 22:00:00 | 3571 | |
| 2010-01-18 23:00:00 | 4131 | |
| 2010-01-19 00:00:00 | 4167 | |
| 2010-01-19 01:00:00 | 4077 | |
| 2010-01-19 02:00:00 | 3924 | |
| 2010-01-19 03:00:00 | 3738 | |
| 2010-01-19 04:00:00 | 3712 | |
| 2010-01-19 05:00:00 | 3510 | |
| 2010-01-19 06:00:00 | 3182 | |
| 2010-01-19 07:00:00 | 3179 | |
| 2010-01-19 08:00:00 | 2951 | |
| 2010-01-19 09:00:00 | 2453 | |
| 2010-01-19 10:00:00 | 2078 | |
| 2010-01-19 11:00:00 | 1999 | |
| 2010-01-19 12:00:00 | 2486 | |
| 2010-01-19 13:00:00 | 2581 | |
| 2010-01-19 14:00:00 | 1891 | |
| 2010-01-19 15:00:00 | 1997 | |
| 2010-01-19 16:00:00 | 1366 | |
| 2010-01-19 17:00:00 | 1294 | |
| 2010-01-19 18:00:00 | 1536 | |
| 2010-01-19 19:00:00 | 2794 | |
| 2010-01-19 20:00:00 | 3211 | |
| 2010-01-19 21:00:00 | 3242 | |
| 2010-01-19 22:00:00 | 3406 | |
| 2010-01-19 23:00:00 | 3121 | |
| 2010-01-20 00:00:00 | 2425 | |
| 2010-01-20 01:00:00 | 2016 | |
| 2010-01-20 02:00:00 | 1787 | |
| 2010-01-20 03:00:00 | 1508 | |
| 2010-01-20 04:00:00 | 1304 | |
| 2010-01-20 05:00:00 | 1060 | |
| 2010-01-20 06:00:00 | 1342 | |
| 2010-01-20 07:00:00 | 1589 | |
| 2010-01-20 08:00:00 | 2361 | |
| 2010-01-20 09:00:00 | 3452 | |
| 2010-01-20 10:00:00 | 2659 | |
| 2010-01-20 11:00:00 | 2857 | |
| 2010-01-20 12:00:00 | 3255 | |
| 2010-01-20 13:00:00 | 3322 | |
| 2010-01-20 14:00:00 | 2852 | |
| 2010-01-20 15:00:00 | 2964 | |
| 2010-01-20 16:00:00 | 3132 | |
| 2010-01-20 17:00:00 | 3033 | |
| 2010-01-20 18:00:00 | 2931 | |
| 2010-01-20 19:00:00 | 2636 | |
| 2010-01-20 20:00:00 | 2818 | |
| 2010-01-20 21:00:00 | 3310 | |
| 2010-01-20 22:00:00 | 3396 | |
| 2010-01-20 23:00:00 | 3179 | |
| 2010-01-21 00:00:00 | 3232 | |
| 2010-01-21 01:00:00 | 3543 | |
| 2010-01-21 02:00:00 | 3759 | |
| 2010-01-21 03:00:00 | 3503 | |
| 2010-01-21 04:00:00 | 3758 | |
| 2010-01-21 05:00:00 | 3658 | |
| 2010-01-21 06:00:00 | 3425 | |
| 2010-01-21 07:00:00 | 3053 | |
| 2010-01-21 08:00:00 | 2620 | |
| 2010-01-21 09:00:00 | 1837 | |
| 2010-01-21 10:00:00 | 923 | |
| 2010-01-21 11:00:00 | 712 | |
| 2010-01-21 12:00:00 | 1054 | |
| 2010-01-21 13:00:00 | 1376 | |
| 2010-01-21 14:00:00 | 1556 | |
| 2010-01-21 15:00:00 | 1498 | |
| 2010-01-21 16:00:00 | 1523 | |
| 2010-01-21 17:00:00 | 1088 | |
| 2010-01-21 18:00:00 | 728 | |
| 2010-01-21 19:00:00 | 890 | |
| 2010-01-21 20:00:00 | 1413 | |
| 2010-01-21 21:00:00 | 2524 | |
| 2010-01-21 22:00:00 | 3295 | |
| 2010-01-21 23:00:00 | 4097 | |
| 2010-01-22 00:00:00 | 3993 | |
| 2010-01-22 01:00:00 | 4116 | |
| 2010-01-22 02:00:00 | 3874 | |
| 2010-01-22 03:00:00 | 4074 | |
| 2010-01-22 04:00:00 | 4142 | |
| 2010-01-22 05:00:00 | 3975 | |
| 2010-01-22 06:00:00 | 3908 | |
| 2010-01-22 07:00:00 | 3907 | |
| 2010-01-22 08:00:00 | 3918 | |
| 2010-01-22 09:00:00 | 3755 | |
| 2010-01-22 10:00:00 | 3648 | |
| 2010-01-22 11:00:00 | 3778 | |
| 2010-01-22 12:00:00 | 4293 | |
| 2010-01-22 13:00:00 | 4385 | |
| 2010-01-22 14:00:00 | 4360 | |
| 2010-01-22 15:00:00 | 4352 | |
| 2010-01-22 16:00:00 | 4528 | |
| 2010-01-22 17:00:00 | 4365 | |
| 2010-01-22 18:00:00 | 3846 | |
| 2010-01-22 19:00:00 | 4098 | |
| 2010-01-22 20:00:00 | 3860 | |
| 2010-01-22 21:00:00 | 3230 | |
| 2010-01-22 22:00:00 | 2820 | |
| 2010-01-22 23:00:00 | 2916 | |
| 2010-01-23 00:00:00 | 3201 | |
| 2010-01-23 01:00:00 | 3721 | |
| 2010-01-23 02:00:00 | 3397 | |
| 2010-01-23 03:00:00 | 3055 | |
| 2010-01-23 04:00:00 | 2141 | |
| 2010-01-23 05:00:00 | 1623 | |
| 2010-01-23 06:00:00 | 1825 | |
| 2010-01-23 07:00:00 | 1716 | |
| 2010-01-23 08:00:00 | 2232 | |
| 2010-01-23 09:00:00 | 2939 | |
| 2010-01-23 10:00:00 | 3735 | |
| 2010-01-23 11:00:00 | 4838 | |
| 2010-01-23 12:00:00 | 4560 | |
| 2010-01-23 13:00:00 | 4307 | |
| 2010-01-23 14:00:00 | 4975 | |
| 2010-01-23 15:00:00 | 5173 | |
| 2010-01-23 16:00:00 | 4859 | |
| 2010-01-23 17:00:00 | 5268 | |
| 2010-01-23 18:00:00 | 4992 | |
| 2010-01-23 19:00:00 | 5100 | |
| 2010-01-23 20:00:00 | 5070 | |
| 2010-01-23 21:00:00 | 5270 | |
| 2010-01-23 22:00:00 | 4760 | |
| 2010-01-23 23:00:00 | 5135 | |
| 2010-01-24 00:00:00 | 5059 | |
| 2010-01-24 01:00:00 | 4682 | |
| 2010-01-24 02:00:00 | 4492 | |
| 2010-01-24 03:00:00 | 4933 | |
| 2010-01-24 04:00:00 | 4737 | |
| 2010-01-24 05:00:00 | 4611 | |
| 2010-01-24 06:00:00 | 4634 | |
| 2010-01-24 07:00:00 | 4789 | |
| 2010-01-24 08:00:00 | 4811 | |
| 2010-01-24 09:00:00 | 4379 | |
| 2010-01-24 10:00:00 | 4689 | |
| 2010-01-24 11:00:00 | 4284 | |
| 2010-01-24 12:00:00 | 4191 | |
| 2010-01-24 13:00:00 | 3313 | |
| 2010-01-24 14:00:00 | 2770 | |
| 2010-01-24 15:00:00 | 2543 | |
| 2010-01-24 16:00:00 | 3105 | |
| 2010-01-24 17:00:00 | 2967 | |
| 2010-01-24 18:00:00 | 2420 | |
| 2010-01-24 19:00:00 | 1996 | |
| 2010-01-24 20:00:00 | 2247 | |
| 2010-01-24 21:00:00 | 2564 | |
| 2010-01-24 22:00:00 | 2726 | |
| 2010-01-24 23:00:00 | 3021 | |
| 2010-01-25 00:00:00 | 3427 | |
| 2010-01-25 01:00:00 | 3509 | |
| 2010-01-25 02:00:00 | 3759 | |
| 2010-01-25 03:00:00 | 3324 | |
| 2010-01-25 04:00:00 | 2988 | |
| 2010-01-25 05:00:00 | 2849 | |
| 2010-01-25 06:00:00 | 2340 | |
| 2010-01-25 07:00:00 | 2443 | |
| 2010-01-25 08:00:00 | 2364 | |
| 2010-01-25 09:00:00 | 1252 | |
| 2010-01-25 10:00:00 | 623 | |
| 2010-01-25 11:00:00 | 742 | |
| 2010-01-25 12:00:00 | 867 | |
| 2010-01-25 13:00:00 | 684 | |
| 2010-01-25 14:00:00 | 488 | |
| 2010-01-25 15:00:00 | 348 | |
| 2010-01-25 16:00:00 | 241 | |
| 2010-01-25 17:00:00 | 187 | |
| 2010-01-25 18:00:00 | 279 | |
| 2010-01-25 19:00:00 | 355 | |
| 2010-01-25 20:00:00 | 423 | |
| 2010-01-25 21:00:00 | 678 | |
| 2010-01-25 22:00:00 | 1375 | |
| 2010-01-25 23:00:00 | 1497 | |
| 2010-01-26 00:00:00 | 1434 | |
| 2010-01-26 01:00:00 | 2116 | |
| 2010-01-26 02:00:00 | 2411 | |
| 2010-01-26 03:00:00 | 1929 | |
| 2010-01-26 04:00:00 | 1628 | |
| 2010-01-26 05:00:00 | 1635 | |
| 2010-01-26 06:00:00 | 1609 | |
| 2010-01-26 07:00:00 | 1757 | |
| 2010-01-26 08:00:00 | 2090 | |
| 2010-01-26 09:00:00 | 2085 | |
| 2010-01-26 10:00:00 | 1790 | |
| 2010-01-26 11:00:00 | 1846 | |
| 2010-01-26 12:00:00 | 2038 | |
| 2010-01-26 13:00:00 | 2360 | |
| 2010-01-26 14:00:00 | 2342 | |
| 2010-01-26 15:00:00 | 2401 | |
| 2010-01-26 16:00:00 | 2920 | |
| 2010-01-26 17:00:00 | 3030 | |
| 2010-01-26 18:00:00 | 3132 | |
| 2010-01-26 19:00:00 | 4385 | |
| 2010-01-26 20:00:00 | 5483 | |
| 2010-01-26 21:00:00 | 5865 | |
| 2010-01-26 22:00:00 | 5595 | |
| 2010-01-26 23:00:00 | 5485 | |
| 2010-01-27 00:00:00 | 5727 | |
| 2010-01-27 01:00:00 | 5553 | |
| 2010-01-27 02:00:00 | 5560 | |
| 2010-01-27 03:00:00 | 5233 | |
| 2010-01-27 04:00:00 | 5478 | |
| 2010-01-27 05:00:00 | 5159 | |
| 2010-01-27 06:00:00 | 5155 | |
| 2010-01-27 07:00:00 | 5312 | |
| 2010-01-27 08:00:00 | 5079 | |
| 2010-01-27 09:00:00 | 4510 | |
| 2010-01-27 10:00:00 | 4628 | |
| 2010-01-27 11:00:00 | 4535 | |
| 2010-01-27 12:00:00 | 3656 | |
| 2010-01-27 13:00:00 | 3698 | |
| 2010-01-27 14:00:00 | 3443 | |
| 2010-01-27 15:00:00 | 3146 | |
| 2010-01-27 16:00:00 | 2562 | |
| 2010-01-27 17:00:00 | 2304 | |
| 2010-01-27 18:00:00 | 2181 | |
| 2010-01-27 19:00:00 | 2293 | |
| 2010-01-27 20:00:00 | 1950 | |
| 2010-01-27 21:00:00 | 1930 | |
| 2010-01-27 22:00:00 | 2197 | |
| 2010-01-27 23:00:00 | 2796 | |
| 2010-01-28 00:00:00 | 3441 | |
| 2010-01-28 01:00:00 | 3649 | |
| 2010-01-28 02:00:00 | 3815 | |
| 2010-01-28 03:00:00 | 2850 | |
| 2010-01-28 04:00:00 | 4005 | |
| 2010-01-28 05:00:00 | 5305 | |
| 2010-01-28 06:00:00 | 5550 | |
| 2010-01-28 07:00:00 | 5641 | |
| 2010-01-28 08:00:00 | 4717 | |
| 2010-01-28 09:00:00 | 5131 | |
| 2010-01-28 10:00:00 | 2831 | |
| 2010-01-28 11:00:00 | 3518 | |
| 2010-01-28 12:00:00 | 3354 | |
| 2010-01-28 13:00:00 | 3115 | |
| 2010-01-28 14:00:00 | 3515 | |
| 2010-01-28 15:00:00 | 3552 | |
| 2010-01-28 16:00:00 | 3244 | |
| 2010-01-28 17:00:00 | 3658 | |
| 2010-01-28 18:00:00 | 4407 | |
| 2010-01-28 19:00:00 | 4935 | |
| 2010-01-28 20:00:00 | 4299 | |
| 2010-01-28 21:00:00 | 3166 | |
| 2010-01-28 22:00:00 | 3335 | |
| 2010-01-28 23:00:00 | 2728 | |
| 2010-01-29 00:00:00 | 2488 | |
| 2010-01-29 01:00:00 | 2573 | |
| 2010-01-29 02:00:00 | 2002 | |
| 2010-01-29 03:00:00 | 1717 | |
| 2010-01-29 04:00:00 | 1645 | |
| 2010-01-29 05:00:00 | 1977 | |
| 2010-01-29 06:00:00 | 2049 | |
| 2010-01-29 07:00:00 | 2125 | |
| 2010-01-29 08:00:00 | 2376 | |
| 2010-01-29 09:00:00 | 2551 | |
| 2010-01-29 10:00:00 | 2578 | |
| 2010-01-29 11:00:00 | 2629 | |
| 2010-01-29 12:00:00 | 2750 | |
| 2010-01-29 13:00:00 | 3150 | |
| 2010-01-29 14:00:00 | 3699 | |
| 2010-01-29 15:00:00 | 4062 | |
| 2010-01-29 16:00:00 | 3959 | |
| 2010-01-29 17:00:00 | 3264 | |
| 2010-01-29 18:00:00 | 2671 | |
| 2010-01-29 19:00:00 | 2205 | |
| 2010-01-29 20:00:00 | 2128 | |
| 2010-01-29 21:00:00 | 2133 | |
| 2010-01-29 22:00:00 | 2095 | |
| 2010-01-29 23:00:00 | 1964 | |
| 2010-01-30 00:00:00 | 2006 | |
| 2010-01-30 01:00:00 | 2074 | |
| 2010-01-30 02:00:00 | 2201 | |
| 2010-01-30 03:00:00 | 2506 | |
| 2010-01-30 04:00:00 | 2449 | |
| 2010-01-30 05:00:00 | 2465 | |
| 2010-01-30 06:00:00 | 2064 | |
| 2010-01-30 07:00:00 | 1446 | |
| 2010-01-30 08:00:00 | 1382 | |
| 2010-01-30 09:00:00 | 983 | |
| 2010-01-30 10:00:00 | 898 | |
| 2010-01-30 11:00:00 | 489 | |
| 2010-01-30 12:00:00 | 319 | |
| 2010-01-30 13:00:00 | 383 | |
| 2010-01-30 14:00:00 | 332 | |
| 2010-01-30 15:00:00 | 276 | |
| 2010-01-30 16:00:00 | 224 | |
| 2010-01-30 17:00:00 | 144 | |
| 2010-01-30 18:00:00 | 101 | |
| 2010-01-30 19:00:00 | 232 | |
| 2010-01-30 20:00:00 | 429 | |
| 2010-01-30 21:00:00 | 597 | |
| 2010-01-30 22:00:00 | 750 | |
| 2010-01-30 23:00:00 | 908 | |
| 2010-01-31 00:00:00 | 960 | |
| 2010-01-31 01:00:00 | 1076 | |
| 2010-01-31 02:00:00 | 951 | |
| 2010-01-31 03:00:00 | 1062 | |
| 2010-01-31 04:00:00 | 1183 | |
| 2010-01-31 05:00:00 | 1404 | |
| 2010-01-31 06:00:00 | 1391 | |
| 2010-01-31 07:00:00 | 1419 | |
| 2010-01-31 08:00:00 | 1497 | |
| 2010-01-31 09:00:00 | 1267 | |
| 2010-01-31 10:00:00 | 963 | |
| 2010-01-31 11:00:00 | 682 | |
| 2010-01-31 12:00:00 | 777 | |
| 2010-01-31 13:00:00 | 906 | |
| 2010-01-31 14:00:00 | 1149 | |
| 2010-01-31 15:00:00 | 1439 | |
| 2010-01-31 16:00:00 | 1600 | |
| 2010-01-31 17:00:00 | 1876 | |
| 2010-01-31 18:00:00 | 1885 | |
| 2010-01-31 19:00:00 | 1962 | |
| 2010-01-31 20:00:00 | 2280 | |
| 2010-01-31 21:00:00 | 2711 | |
| 2010-01-31 22:00:00 | 2591 | |
| 2010-01-31 23:00:00 | 2411 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # from scikits.statsmodels.tsa.stattools import acf,pacf | |
| # from scikits.statsmodels.tsa.arima_model import ARMA | |
| from scikits.statsmodels.tsa.arima_model import ARMA | |
| from numpy import array | |
| import csv | |
| def csv2dicts(filename): | |
| def convert_str2num(s): | |
| s=s.strip() | |
| try: return int(s) | |
| except ValueError: | |
| try: return float(s) | |
| except ValueError: return s | |
| def valid_cell(name,val): return name is not None and val.strip()!='' | |
| with open(filename,'r') as csvfile: | |
| try: dialect = csv.Sniffer().sniff(csvfile.read(4048)) | |
| except: dialect = csv.excel | |
| csvfile.seek(0) | |
| raw_data=list(csv.DictReader(csvfile, dialect=dialect)) | |
| data=[{name:convert_str2num(val) for name,val in row.items() if valid_cell(name,val)} for row in raw_data] | |
| return data | |
| filename='ercot2010_01.csv' | |
| data=csv2dicts(filename) | |
| actual=array([row['wind'] for row in data]) | |
| model=ARMA(actual) | |
| # fit=model.fit(order=(3, 1)) #works just fine | |
| fit=model.fit(order=(4, 1)) | |
| print 'AR params:',fit.arparams | |
| print 'MA params:', fit.maparams | |
| print fit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment