#Q1: 將台股2019年日收盤價格讀入(2019_daily_closing1.txt)
m.price <- read.table("~/2019_daily_closing1.txt")
m.price <- m.price[-1,]
colnames(m.price) <- c("id","name","date","close")
head(m.price)## id name date close
## 2 1101 台泥 20190102 30.6778
## 3 1102 亞泥 20190102 31.7778
## 4 1103 嘉泥 20190102 12.7707
## 5 1104 環泥 20190102 17.9550
## 6 1108 幸福 20190102 7.4100
## 7 1109 信大 20190102 12.9375#Q2: 只保留資料中id, date, close
library(reshape2)
mprice.reorder <- dcast(m.price, date~id)## Using close as value column: use value.var to override.head(mprice.reorder)## date 1101 1102 1103 1104 1108 1109 1110 1201
## 1 20190102 30.6778 31.7778 12.7707 17.9550 7.4100 12.9375 16.7006 21.4258
## 2 20190103 30.3754 31.8718 12.7707 17.9550 7.4000 12.8896 16.3030 21.4745
## 3 20190104 30.6346 31.8248 12.7707 17.8125 7.4100 12.9854 16.4024 21.3771
## 4 20190107 31.1099 32.7650 13.0055 17.9075 7.4100 12.9375 16.7006 22.0588
## 5 20190108 30.7210 32.5769 13.0055 17.8125 7.4100 12.9375 16.3527 21.6693
## 6 20190109 31.4124 33.1410 13.0994 18.0025 7.4100 12.9854 16.2533 21.9614
## 1203 1210 1213 1215 1216 1217 1218 1219 1220
## 1 25.0388 30.9627 10.2000 52.0484 66.1867 6.8100 17.3454 18.0492 10.4064
## 2 25.2314 31.2375 10.1000 52.7181 65.4115 6.8300 16.9600 18.2978 10.3584
## 3 25.2314 31.8787 10.1000 53.1008 65.7991 6.8300 16.9118 18.0989 10.5023
## 4 25.0388 32.2452 10.1500 53.1008 68.2218 6.8400 17.2009 18.1983 10.6941
## 5 25.1833 31.8329 10.1500 51.7614 68.0279 6.8400 17.3454 18.1486 10.6461
## 6 25.0388 32.2452 10.2000 52.4311 69.8692 6.8800 17.3936 17.9994 10.6941
## 1225 1227 1229 1231 1232 1233 1234 1235 1236
## 1 73.3121 46.3846 26.9807 33.9465 94.6153 36.1768 28.2254 22.7556 13.3015
## 2 75.1694 46.6244 26.7987 33.9465 94.2307 36.1768 28.3206 22.7111 13.2044
## 3 75.1694 46.5285 26.2982 33.7635 94.4230 35.6055 28.4634 22.7556 13.2044
## 4 74.2896 47.8716 26.8442 33.9922 94.4230 36.0816 28.5586 23.3778 13.3015
## 5 72.5301 47.7756 26.6622 34.1753 94.2307 36.1292 28.4158 23.5556 13.1558
## 6 72.5301 48.7350 27.1172 34.3125 94.6153 36.1768 28.4634 23.4667 13.3015
## 1301 1303 1304 1305 1307 1308 1309 1310 1312
## 1 92.6775 68.3384 11.5062 19.6967 23.9051 12.7263 9.3939 20.9847 21.8000
## 2 91.1582 68.6193 11.3600 19.2459 23.4642 12.6774 9.1823 20.6633 21.7000
## 3 90.4935 68.4321 11.3600 18.9304 22.8274 12.6774 8.9035 20.7551 21.2000
## 4 94.4817 70.3043 11.4575 19.2910 23.5132 12.8242 9.0766 21.0306 21.8000
## 5 96.8556 69.4618 11.4575 19.9220 23.2193 12.8732 9.2304 20.6633 21.9000
## 6 97.3304 69.7427 11.5550 20.6432 23.3662 13.1179 9.5285 20.7092 22.7000
## 1313 1314 1315 1316 1319 1321 1323 1324 1325
## 1 10.8362 9.9322 25.6348 10.6237 35.6814 25.8500 33.3500 10.5900 15.9860
## 2 10.8827 9.7044 25.5867 10.6237 35.4885 26.0000 33.1602 10.5900 15.9860
## 3 10.7897 9.5221 25.3943 10.4920 34.9099 25.7500 32.9230 10.6872 15.8891
## 4 10.9758 9.8866 25.3462 10.5798 36.5493 26.0000 33.3500 10.5900 15.9375
## 5 11.2083 9.7499 25.1057 10.6237 36.1153 25.8500 33.9667 10.4929 15.8891
## 6 11.3943 10.0233 25.3462 10.6237 36.6457 26.0500 34.0616 10.5900 15.9375
## 1326 1339 1402 1409 1410 1413 1414 1416 1417 1418
## 1 94.0805 32.9489 26.5606 10.7646 24.9535 10.8500 6.8794 13.1213 6.6960 7.7700
## 2 94.3636 32.5185 26.7027 10.6714 24.9015 10.9000 6.8794 13.0752 6.6546 7.3800
## 3 94.1749 32.7576 26.7500 10.6714 24.8495 10.6500 6.8794 13.1213 6.5718 7.3800
## 4 98.6100 32.9967 27.1761 10.8112 24.9535 10.7500 6.9377 13.1213 6.5856 7.3800
## 5 100.9691 33.1880 27.3182 10.8112 24.7975 10.7000 6.8697 13.1673 6.5165 7.8200
## 6 102.3845 33.4271 27.7443 11.1374 25.0055 10.7500 6.8989 13.1673 6.5580 7.2000
## 1419 1423 1432 1434 1435 1436 1437 1438 1439 1440
## 1 44.0876 10.3500 8.4100 32.0458 5.3900 29.0242 17.5745 8.0000 33.0500 11.6033
## 2 42.4220 10.3500 8.3300 32.2352 5.3800 29.1432 17.5745 7.8000 32.6000 11.4099
## 3 42.3731 10.3000 8.0600 32.0932 5.4000 29.1035 17.5745 7.4100 32.8000 11.2165
## 4 42.5690 10.3500 8.0300 33.1345 5.4100 29.2225 17.7209 7.4100 32.8000 11.2649
## 5 42.0302 10.4500 7.9000 32.4718 5.4200 29.1828 17.8186 7.3000 32.9500 11.2165
## 6 43.0099 10.4000 7.9200 33.2765 5.4100 29.2621 17.9162 7.5000 33.0000 11.4583
## 1441 1442 1443 1444 1445 1446 1447 1449 1451 1452
## 1 9.7451 14.5634 6.9000 9.5195 7.7363 23.4673 7.7078 4.7201 23.5246 15.7679
## 2 9.7827 14.5634 6.8000 9.3369 7.6876 23.4673 7.6105 4.6241 23.1991 15.6280
## 3 9.7451 14.5165 6.7500 9.2217 7.6001 23.2692 7.5423 4.7201 23.2456 15.6746
## 4 9.7827 14.4695 6.8500 9.5579 7.6487 23.6653 7.6494 4.7680 23.2456 15.8612
## 5 9.7827 14.5634 6.9000 9.4426 7.6876 23.6653 7.5910 4.7488 23.0597 15.9079
## 6 9.7075 14.4695 6.9000 9.4906 7.6292 23.7148 7.6591 4.7297 23.2921 15.9545
## 1453 1454 1455 1456 1457 1459 1460 1463 1464 1465
## 1 8.4708 8.1346 8.6867 6.8500 11.0792 8.1500 11.2644 11.5077 18.3716 13.8651
## 2 8.4072 8.1443 8.6085 6.8500 11.1232 8.1100 11.0195 11.5534 18.4649 13.8651
## 3 8.3981 8.0468 8.4715 6.8500 11.0792 8.0600 10.8726 11.4621 18.5582 13.7671
## 4 8.2891 8.0468 8.6476 6.8500 11.1232 8.1300 11.3134 11.5534 18.6980 13.8651
## 5 8.2982 8.0078 8.6183 6.7900 11.1671 8.1000 11.3134 11.5077 18.5582 13.8161
## 6 8.2709 8.0956 8.6867 6.7900 11.2111 8.1400 11.3134 11.5534 18.6980 13.8651
## 1466 1467 1468 1470 1471 1472 1473 1474 1475
## 1 10.1500 9.0900 10.1500 17.1910 4.9900 30.0649 16.9239 10.1670 10.1500
## 2 10.0500 9.1100 9.9900 16.7980 5.0100 30.0649 16.9239 10.2154 10.1500
## 3 10.0000 9.1100 9.9400 16.7980 4.9300 30.0649 17.0220 10.1670 10.1500
## 4 9.9500 9.1400 9.9200 17.5839 5.0400 30.2595 16.9730 10.2154 10.5500
## 5 9.8000 9.1200 10.0500 16.6015 4.9300 30.1622 16.8749 10.2154 10.5500
## 6 9.8000 9.1800 10.2500 16.6998 5.0100 30.1622 16.9730 10.2154 10.5000
## 1476 1477 1503 1504 1506 1507 1512 1513 1514
## 1 342.2714 160.6705 39.2434 16.7686 20.3147 57.6213 8.4100 18.3267 12.4756
## 2 340.3267 164.8139 39.0982 16.5765 20.2186 58.0106 8.4100 18.2315 12.1497
## 3 339.3543 165.7346 39.0982 16.3362 20.3627 58.2053 8.4000 18.1363 12.1497
## 4 350.0503 168.0365 39.2917 16.3362 20.4587 58.1080 8.4300 18.6123 12.2894
## 5 346.6471 164.3535 39.0014 16.5284 20.1706 58.1080 8.3100 18.6123 12.3359
## 6 352.9674 165.7346 39.2434 16.8167 20.3627 58.2053 8.3400 18.6599 12.4756
## 1515 1516 1517 1519 1521 1522 1524 1525 1526 1527
## 1 69.5461 15.0580 9.6909 18.8939 49.9716 22.7982 9.0811 54.4085 30.4966 41.8378
## 2 72.1834 15.0102 9.9831 18.3004 49.5011 22.7028 9.0811 53.3417 32.6715 41.8842
## 3 69.6438 15.0580 9.8370 18.3004 49.1246 22.2259 9.0902 52.6628 31.4632 41.6522
## 4 71.8903 15.1536 9.7883 18.7950 49.1246 22.7982 9.1357 52.7598 31.5598 41.3276
## 5 72.0857 15.0580 9.8370 18.9434 49.0305 22.7028 9.1357 52.7598 30.9316 40.5390
## 6 71.4996 14.9624 9.7298 18.9928 49.6893 22.7982 9.1811 54.0206 31.3182 40.7710
## 1528 1529 1530 1531 1532 1533 1535 1536 1537
## 1 9.7590 14.9982 27.5998 15.6484 35.2739 35.5287 28.4332 116.6129 136.3491
## 2 9.7492 14.9982 27.5998 15.4062 35.5979 35.0883 28.4332 115.1613 136.3491
## 3 9.6905 14.1160 27.4127 15.3093 35.3202 34.7946 28.6266 114.6774 137.7547
## 4 9.7786 14.1160 27.6466 15.4062 35.6442 34.8925 28.4815 117.5807 142.4403
## 5 9.7884 14.1601 27.5531 15.3578 35.2739 34.9414 29.2069 116.6129 143.8459
## 6 9.8373 15.0423 27.5063 15.4062 35.8294 34.9414 29.0618 118.0645 145.7201
## 1538 1539 1540 1541 1558 1560 1568 1582 1583
## 1 5.1300 20.2506 14.6786 32.0909 124.9663 54.7773 19.5919 60.2082 48.2233
## 2 5.1300 20.0195 14.5854 31.1671 124.9663 54.4001 18.7695 60.1159 47.7505
## 3 4.9900 19.3259 14.9116 30.3405 125.8919 53.4573 18.7695 60.0235 48.2233
## 4 4.9900 19.8807 14.9582 31.2643 125.8919 54.3059 18.8663 60.9470 48.2233
## 5 4.9300 19.5571 14.8184 30.4864 126.3548 54.2116 18.5760 60.9470 47.4668
## 6 4.9900 19.9270 14.8184 30.4377 126.8176 54.5887 18.5760 61.6857 47.2777
## 1587 1598 1603 1604 1605 1608 1609 1611 1612 1614
## 1 17.8376 32.1641 23.0636 12.7038 15.4475 9.1300 9.3965 9.0144 9.1632 21.6884
## 2 17.7401 31.8778 23.0636 12.6576 15.3550 9.0200 9.2656 9.0144 9.1535 21.7852
## 3 17.4477 31.7824 23.0636 12.4266 14.8925 9.0300 9.1534 8.9549 9.0857 21.6400
## 4 17.3502 31.9732 23.3568 12.5652 15.4475 9.2200 9.2376 9.4210 9.2020 21.5916
## 5 17.5452 31.9255 23.3080 12.6576 15.4012 9.2000 9.2843 9.3417 9.2020 21.7368
## 6 17.5939 32.2596 23.3080 12.7500 15.8175 9.2900 9.4900 9.3417 9.2116 21.8336
## 1615 1616 1617 1618 1701 1702 1707 1708 1709
## 1 14.7504 4.4500 11.5637 8.2096 17.2634 44.6667 180.5046 23.5710 14.5110
## 2 14.7042 4.4300 11.5637 8.1228 17.4552 44.8095 175.6524 23.8516 14.5110
## 3 14.7042 4.4700 11.5637 8.0553 17.5991 44.8095 174.1967 23.7113 14.4136
## 4 14.8429 4.4900 11.7024 8.2675 17.6950 45.2381 173.7114 23.6645 14.6084
## 5 14.8429 4.4800 11.7949 8.2000 18.0786 45.2857 180.5046 23.6645 14.5597
## 6 14.9354 4.5000 12.0725 8.2965 18.0786 46.0000 184.8717 23.7581 14.7058
## 1710 1711 1712 1713 1714 1717 1718 1720 1721 1722
## 1 23.9500 15.5294 14.6140 18.3748 6.2899 22.6581 9.3321 29.9504 10.0000 40.8840
## 2 23.5772 15.5779 14.5703 18.4229 6.2703 22.8513 9.2857 29.9982 9.8500 41.2179
## 3 23.2045 15.3838 14.5703 18.1824 6.1821 22.7547 9.2671 30.1415 9.8000 41.2656
## 4 23.6704 15.5779 14.6578 18.4710 6.2507 23.1895 9.4250 30.1893 9.9700 41.5996
## 5 23.3443 15.4809 14.6140 18.2305 6.2311 23.0446 9.3786 30.3326 10.0000 41.9812
## 6 24.0898 15.6265 14.7015 18.3748 6.3291 23.3827 9.4714 30.5237 10.0500 41.9812
## 1723 1724 1725 1726 1727 1730 1731 1732 1733
## 1 130.1804 12.3294 13.5748 67.3583 13.4687 60.5056 11.8976 11.2000 29.0402
## 2 129.7000 12.3776 13.6221 66.8826 13.4209 60.6977 11.9458 11.1000 29.7212
## 3 128.2589 12.3776 13.7167 67.0729 13.2776 60.3136 11.9458 11.7000 29.5753
## 4 130.1804 12.3776 13.7167 66.7875 13.3731 60.6017 12.0421 11.6500 30.3536
## 5 129.7000 12.4257 13.6694 66.6924 13.3731 61.6581 12.2830 11.4000 30.6454
## 6 130.1804 12.5221 13.6694 66.7875 13.4209 62.0423 12.2830 11.1500 29.8185
## 1734 1735 1736 1737 1760 1762 1773 1776 1783
## 1 19.2025 15.5046 31.8359 28.1253 88.2525 22.2136 80.0094 14.4255 22.5284
## 2 19.5010 15.0093 33.1748 28.3621 86.9777 22.5524 79.4440 14.3780 23.4061
## 3 19.4015 15.1084 33.6211 28.1253 86.5855 22.6492 78.0304 14.4729 22.9185
## 4 19.4015 15.1084 34.2161 28.1727 88.7428 22.6492 78.8785 14.3306 23.1623
## 5 19.7497 15.1084 34.5137 28.2674 92.1748 23.3267 78.3131 13.9510 24.0400
## 6 19.7000 15.2074 35.1087 28.3147 91.1942 23.5203 78.5958 14.1408 23.7475
## 1786 1789 1795 1802 1805 1806 1808 1809 1810 1817
## 1 63.8399 23.6859 77.3000 12.6329 9.2000 7.0900 47.2427 10.3366 7.6315 34.7350
## 2 64.6962 24.0782 77.2000 12.6816 9.2100 7.0500 47.6842 10.2874 7.6218 34.7350
## 3 65.6476 25.9417 75.7000 12.4865 9.2200 7.0100 47.6842 10.2381 7.6023 34.5467
## 4 69.1747 26.5792 76.2000 12.6816 9.2800 7.0400 49.0971 10.2381 7.6705 34.6408
## 5 69.1747 26.7754 77.5000 12.5353 9.3100 7.0400 48.8322 10.2381 7.6608 34.7350
## 6 67.3183 26.8244 76.0000 12.8767 9.3100 7.0500 49.0088 10.2874 7.6705 34.7350
## 1902 1903 1904 1905 1906 1907 1909 2002 2006 2007
## 1 17.6866 29.9000 17.7961 9.2903 13.9168 10.6645 13.5052 23.0400 17.9410 5.5000
## 2 18.0305 29.9000 17.8434 9.2613 13.8686 10.6645 13.2158 23.1840 17.8936 5.4100
## 3 18.3744 30.2500 17.7961 9.2129 13.7723 10.6169 12.9747 23.2320 17.7037 5.3300
## 4 18.4726 30.1000 17.8434 9.2710 14.0131 10.7121 13.1676 23.4720 17.8936 5.4800
## 5 18.1779 29.8000 17.6541 9.2226 14.0613 10.6645 13.6499 23.5200 17.8461 5.4600
## 6 18.7674 30.1000 17.8434 9.2806 14.1576 10.7598 13.8429 23.9520 18.0834 5.4800
## 2008 2009 2010 2012 2013 2014 2015 2017 2020 2022
## 1 12.3500 9.9800 9.5289 18.7275 25.3188 10.8472 54.3116 7.7150 12.8651 6.6800
## 2 12.3500 9.9000 9.5289 18.9167 25.1716 10.5995 54.2180 7.7340 12.9566 6.5900
## 3 12.3500 9.7700 9.4815 18.9167 24.7791 10.2528 53.9370 7.6390 13.0024 6.5100
## 4 12.3500 9.9900 9.5763 19.0112 25.0735 10.6491 54.4052 7.7055 12.9566 6.4900
## 5 12.3500 10.0000 9.5289 18.9167 25.3188 10.5995 53.9370 7.6865 12.9566 6.4500
## 6 12.4000 9.9800 9.6237 19.0585 25.3679 11.0948 55.2480 7.7245 13.0024 6.4800
## 2023 2024 2025 2027 2028 2029 2030 2031 2032 2033
## 1 9.7875 8.9717 <NA> 39.5983 7.8700 18.9057 11.5209 29.6143 8.8747 9.3437
## 2 9.7391 8.9811 <NA> 40.4388 8.0000 18.8070 11.4746 29.1382 8.8058 9.1380
## 3 9.6422 8.9717 <NA> 40.9057 8.0900 18.8070 11.3821 28.6621 8.8649 9.1380
## 4 9.6906 9.0000 <NA> 42.0264 8.0300 19.0538 11.5672 29.6619 8.8649 9.3339
## 5 9.7875 8.9151 <NA> 43.7075 8.0500 18.7577 11.5672 30.1380 8.8255 9.2556
## 6 9.7875 9.0189 <NA> 44.0811 8.0500 19.1032 11.7060 30.0428 8.8550 9.2849
## 2034 2038 2049 2059 2062 2069 2101 2102 2103
## 1 22.7297 7.7800 207.1145 305.2265 32.9251 21.7955 25.0057 10.8500 25.7473
## 2 22.7297 7.7600 198.1505 314.9471 33.0736 21.7057 24.6684 10.9000 25.9395
## 3 22.7764 7.6400 196.7352 324.6677 32.6280 21.5259 24.7166 10.8500 26.0836
## 4 22.8697 7.8300 197.6788 330.5001 32.8261 21.5708 24.7648 10.9500 26.6120
## 5 22.9164 7.7700 191.5455 334.8743 32.9251 22.0652 24.4757 10.8500 26.4198
## 6 23.1497 7.8300 202.8684 339.2486 33.8163 22.0652 24.5721 11.0500 26.7561
## 2104 2105 2106 2107 2108 2109 2114 2201 2204
## 1 33.0229 39.1054 28.0865 15.0090 26.4888 12.6000 72.5486 17.4316 42.2244
## 2 32.7258 39.9323 28.2315 15.0090 26.2996 12.6000 72.5486 17.2860 42.0466
## 3 32.0467 40.0782 28.1832 14.9609 26.2522 12.3500 72.8183 17.1888 42.0466
## 4 33.1078 40.7591 28.3282 15.0090 26.9618 12.5000 72.8183 17.3831 42.7577
## 5 33.3625 40.6619 28.2799 15.0090 27.1037 12.4000 73.2678 17.2860 42.1355
## 6 33.9143 41.4887 28.5699 15.0571 27.5294 12.4000 74.4365 17.3831 42.7577
## 2206 2207 2208 2227 2228 2231 2233 2301 2302
## 1 18.9219 240.9757 24.9000 213.5460 73.8495 221.1656 65.8731 38.1299 7.4400
## 2 19.0175 244.8781 24.1500 213.5460 73.6587 217.4641 65.5900 38.9272 7.4500
## 3 19.2086 243.9025 23.6000 212.6115 72.7046 205.8968 63.8913 38.1299 7.3900
## 4 19.3998 250.7318 24.6000 214.0133 76.6165 213.2999 64.6463 38.8803 8.1200
## 5 19.3042 247.8049 24.8000 214.4806 77.2844 220.2402 64.7406 39.0210 8.6300
## 6 19.3520 253.6586 24.4000 214.4806 79.5743 227.6432 65.2125 40.6156 8.7000
## 2303 2305 2308 2312 2313 2314 2316 2317 2321 2323
## 1 10.6606 6.0400 123.0436 9.7170 19.2462 20.4887 14.8824 66.6511 3.2200 10.0667
## 2 10.4685 6.1000 125.9501 9.6878 19.1977 19.9926 14.9344 65.5101 3.2200 10.2305
## 3 10.2764 6.0500 126.9190 9.6587 18.6160 19.4965 14.7783 64.2741 3.3900 10.2752
## 4 10.5645 6.0600 133.7009 9.8141 19.2947 19.9430 14.9344 65.8904 3.4700 10.3347
## 5 10.5165 6.0500 136.1230 9.7656 19.4401 19.8934 15.0385 65.2249 3.4000 10.2901
## 6 10.6606 6.0000 139.9984 9.9113 19.2947 19.9430 15.1426 66.4609 3.3000 10.3496
## 2324 2327 2328 2329 2330 2331 2332 2337 2338
## 1 16.4260 259.4334 18.4209 12.0500 207.2998 12.2000 11.8595 16.9973 17.4481
## 2 16.3790 250.3450 18.2777 12.0000 203.5221 12.2000 11.7119 16.7100 17.1573
## 3 16.0966 239.1910 17.8960 12.0000 196.4389 12.0000 11.8103 16.7579 17.5935
## 4 16.4260 244.9745 18.3255 12.3000 201.1610 12.1500 11.7611 17.1888 17.8358
## 5 16.3319 242.9090 18.3255 12.2500 199.2722 12.2500 11.8103 17.3803 18.0297
## 6 16.5672 250.7581 18.5163 12.1500 203.5221 12.2500 12.8929 17.4282 18.0297
## 2340 2342 2344 2345 2347 2348 2349 2351 2352
## 1 19.5837 19.2528 12.4637 95.2478 33.7104 43.0904 11.2500 65.0411 18.8731
## 2 19.1008 18.8085 12.1344 96.8967 33.8053 41.8434 11.5000 63.9874 19.0168
## 3 18.7789 18.3642 12.1344 97.9636 33.8527 41.5663 11.2000 62.7421 19.4000
## 4 19.1545 18.7098 12.3696 96.7027 34.4690 41.3354 11.4500 63.7958 19.3042
## 5 19.1545 18.6604 12.2755 98.9336 34.0423 41.0121 11.4000 65.6158 19.2084
## 6 20.2276 19.1541 12.6048 99.4185 34.8483 41.9819 11.4500 66.5737 19.1605
## 2353 2354 2355 2356 2357 2358 2359 2360 2362
## 1 18.3380 57.2166 35.6144 20.7529 190.3427 18.2500 16.8665 114.9092 29.4833
## 2 17.7139 57.1214 36.0085 20.9412 190.8104 17.9500 17.1516 113.4485 29.1444
## 3 16.8018 56.0742 35.8607 20.5176 195.9548 17.9500 16.7240 111.0140 28.6119
## 4 17.5699 56.0742 36.5504 20.8470 202.0345 17.9500 16.7715 119.2914 28.6603
## 5 17.6659 55.8838 36.5504 20.3765 202.0345 17.9000 17.2941 115.3961 28.5151
## 6 18.1460 56.3598 36.8459 20.6588 206.7112 17.8000 17.4842 113.9354 28.8540
## 2363 2364 2365 2367 2368 2369 2371 2373 2374 2375
## 1 9.4500 4.4500 8.5719 13.3757 13.1500 8.7858 26.0000 90.0056 13.5706 37.3799
## 2 9.2000 4.7900 8.5134 13.4248 13.4500 8.7077 25.9000 89.2540 13.4252 36.2118
## 3 9.3300 4.7900 8.2501 13.1790 13.1000 8.6980 25.3500 88.2206 13.2798 36.4454
## 4 9.4300 4.9000 8.3768 13.4740 14.4000 8.7956 26.5000 88.3145 13.2798 37.0528
## 5 9.2400 4.7100 8.6401 13.9658 14.5500 8.8639 26.4500 87.4689 13.1828 37.6603
## 6 9.2400 4.7100 8.6499 14.2608 14.0000 9.0006 27.0500 87.5629 13.5706 37.8472
## 2376 2377 2379 2380 2382 2383 2385 2387 2388
## 1 37.1906 72.6644 133.1250 5.5378 49.0926 64.6351 56.0356 16.9636 25.9500
## 2 36.4827 70.3052 135.0614 5.5634 49.4695 64.7323 56.1240 16.8667 25.2000
## 3 37.0019 70.5883 135.0614 5.5506 48.9984 63.4687 55.7705 16.7697 24.0000
## 4 38.8425 74.9293 135.0614 5.5506 49.4695 66.6762 57.1846 16.7697 24.6000
## 5 38.5593 73.0419 135.0614 5.4866 49.7522 67.0650 57.4498 16.6243 24.6500
## 6 37.5682 73.4194 139.9023 5.5122 50.0349 66.5790 57.4498 16.8182 25.0000
## 2390 2392 2393 2395 2397 2399 2401 2402 2404
## 1 10.7000 22.3057 27.8376 205.5686 59.7797 9.6600 10.8436 12.5466 85.2222
## 2 11.1500 22.1142 27.6951 208.4914 59.7797 9.5100 10.8436 12.6435 85.9714
## 3 12.1000 21.5398 27.4576 212.3885 59.6857 9.2400 10.6005 12.3044 84.4730
## 4 11.9500 22.1621 27.8376 211.4142 60.3436 9.3200 10.6977 12.4497 87.3762
## 5 13.1000 21.9706 27.8376 212.3885 59.8737 9.3100 10.7463 12.4981 87.0016
## 6 12.6500 22.4014 28.4077 216.2855 60.3436 9.5000 11.0381 12.9341 87.0016
## 2405 2406 2408 2409 2412 2413 2414 2415 2417
## 1 11.4000 11.9920 49.0019 11.3075 102.7210 20.6500 17.6188 22.8718 10.0594
## 2 11.3000 11.8937 45.8836 11.2602 102.7210 20.4500 17.6188 22.2157 10.2080
## 3 11.2000 11.7790 45.9727 11.2602 103.2010 20.4000 17.5253 21.7001 10.0098
## 4 11.4500 11.9264 46.1508 11.4495 103.6810 21.0000 17.6188 22.1219 10.1585
## 5 11.9500 11.8773 46.0618 11.4968 102.7210 20.6500 17.5253 21.8876 10.3071
## 6 12.1000 12.0084 46.7745 11.7807 103.2010 20.8000 17.5721 22.0282 10.3071
## 2419 2420 2421 2423 2424 2425 2426 2427 2428
## 1 18.7552 29.3541 34.8950 21.5709 38.9500 35.6190 15.6737 10.5810 71.6369
## 2 18.8033 29.4469 34.6128 22.0388 38.9500 35.2381 15.5804 10.5329 70.4937
## 3 19.1399 29.2150 33.2490 22.9278 38.8000 33.8571 15.8137 10.4367 70.0174
## 4 19.2361 29.3078 34.2836 23.2086 38.5000 34.7143 16.0469 10.4848 72.3037
## 5 20.0537 29.5396 34.8479 23.5361 38.4000 34.9524 15.9536 10.6291 72.0179
## 6 19.7651 29.6788 35.3652 24.1444 38.4000 35.4286 16.0003 10.7252 74.7805
## 2429 2430 2431 2433 2434 2436 2438 2439 2440 2441
## 1 15.0000 18.3752 8.8800 39.2519 9.3500 21.7486 6.9500 119.4512 9.0000 38.7336
## 2 14.5000 18.4709 8.8100 38.8333 9.2000 22.5185 7.0000 117.5626 9.0600 38.6398
## 3 15.5000 18.6144 8.6300 38.9729 9.0000 22.5185 7.0000 113.3134 9.1000 37.6551
## 4 14.5000 18.7580 8.7400 39.1589 9.2800 22.6628 7.0900 119.9233 9.2500 37.6551
## 5 14.5000 18.6623 8.7300 39.0659 9.1500 23.3846 7.1100 120.8676 9.3000 37.4206
## 6 15.3000 18.8059 8.8500 39.1589 9.1800 23.1440 7.0900 119.9233 9.4000 37.7489
## 2442 2443 2444 2448 2449 2450 2451 2453 2454
## 1 10.6746 4.4600 20.9500 24.9421 22.0940 33.4417 62.1156 10.8686 214.3178
## 2 10.5868 4.4800 21.2000 24.3000 21.4710 33.3940 62.3016 10.8686 217.2337
## 3 10.5429 4.4700 22.0000 23.5591 20.4645 33.3463 62.2086 10.8686 210.9160
## 4 10.7625 4.5100 21.4000 24.2012 20.7041 33.3463 62.0226 10.8203 212.8599
## 5 11.6850 4.4800 20.7500 23.7073 20.8958 33.2986 61.3717 10.8686 215.7758
## 6 11.2018 4.5000 20.3500 24.3988 20.8958 33.3940 63.0455 10.8686 219.6636
## 2455 2456 2457 2458 2459 2460 2461 2462 2464
## 1 63.7514 71.9013 10.3000 71.0327 32.9098 9.6500 13.2095 26.5221 38.7955
## 2 60.4573 70.5292 10.2500 71.9698 33.1871 9.6500 13.1605 26.3748 38.3758
## 3 61.0386 68.4252 10.1000 71.2201 32.8636 9.6300 13.1605 26.3257 37.3500
## 4 62.0075 70.0718 10.2500 70.0956 33.2796 9.6400 13.1605 26.5221 37.4899
## 5 62.0075 71.3525 10.2500 68.5962 33.1409 9.6400 13.2095 26.5221 37.6298
## 6 63.6546 73.1820 10.3000 70.2830 33.2334 9.8400 13.2584 26.6204 38.0494
## 2465 2466 2467 2468 2471 2472 2474 2476 2477
## 1 10.7000 33.2500 24.0221 10.3798 13.8477 37.4729 216.3574 20.8639 19.5206
## 2 10.3500 33.1500 23.6518 10.3317 13.8945 36.8122 204.0212 21.0062 19.4726
## 3 10.2000 33.1500 23.6981 10.1875 13.8945 35.9155 189.3127 21.0062 19.2808
## 4 10.3500 33.4000 23.8832 10.3317 13.8945 36.4346 200.7000 21.0062 19.3287
## 5 10.3500 33.5000 23.9295 10.4759 13.9413 36.4346 195.4808 21.0062 19.7124
## 6 11.3500 33.7500 24.4386 10.4759 14.0349 38.0864 202.5978 21.0062 19.7604
## 2478 2480 2481 2482 2483 2484 2485 2486 2488
## 1 58.4191 36.7491 26.9836 10.8000 16.4810 16.7478 19.7062 9.3400 27.4758
## 2 56.0119 36.7491 26.7211 11.0000 16.4810 16.7945 20.0974 9.1700 29.6757
## 3 56.6578 36.9366 25.6712 11.0000 16.5254 16.4679 19.7062 9.0800 30.1906
## 4 57.7733 37.3116 28.1910 11.0000 16.5698 16.7011 20.4886 9.1300 31.8289
## 5 58.1843 37.3585 28.0860 11.0500 16.6143 16.6545 20.2930 9.1600 32.3437
## 6 60.8264 37.6866 27.7185 11.1000 16.5698 16.6078 20.5375 9.1900 32.0161
## 2489 2491 2492 2493 2495 2496 2497 2498 2499
## 1 11.2000 5.7700 138.8033 22.4814 11.4517 86.6092 16.3500 35.6989 9.0000
## 2 11.3500 5.5600 130.2407 22.5274 11.4031 86.6092 16.3000 35.6989 8.9800
## 3 11.4000 5.9400 126.1848 22.3435 11.3546 86.8947 16.4500 36.0944 8.8000
## 4 11.6500 6.0000 133.3954 22.5274 11.3061 86.7043 16.5000 36.2922 8.9000
## 5 11.5500 6.1200 131.5927 22.5734 11.2576 86.7043 16.5500 36.5889 8.9100
## 6 11.7000 5.9000 141.9579 22.6653 11.2090 86.4188 16.5500 34.9572 9.0300
## 2501 2504 2505 2506 2509 2511 2514 2515 2516 2520
## 1 18.1221 8.0978 11.9040 11.3393 24.2755 9.5483 18.7839 6.8737 6.3500 20.0932
## 2 18.2608 8.0881 11.6640 11.2900 24.4830 9.5956 18.6234 6.8737 6.3400 20.4305
## 3 18.2145 8.0202 11.4720 11.3393 24.4000 9.5483 18.5163 6.8543 6.3400 20.5750
## 4 18.2608 8.1367 11.5200 11.3393 24.9810 9.8319 18.9980 6.9810 6.4000 20.4787
## 5 17.9834 8.0978 11.5200 11.2407 25.0639 9.7847 18.9980 6.9517 6.4300 20.2859
## 6 18.0759 8.2046 11.4240 11.2407 26.1429 9.8792 19.1050 7.0590 6.4300 20.5269
## 2524 2527 2528 2530 2534 2535 2536 2537 2538
## 1 26.1000 21.0517 13.5500 15.6055 28.7297 18.1061 18.4956 6.0600 11.7500
## 2 25.8500 21.4310 13.3500 15.5565 28.6728 18.0135 18.4479 6.0000 11.9403
## 3 25.9000 21.6207 13.3500 15.4583 28.6728 17.8746 18.5909 5.9700 11.8451
## 4 26.2000 21.9526 13.4500 15.5565 29.2417 18.0598 18.7339 6.0300 11.7976
## 5 25.9500 21.7155 13.3500 15.4583 28.9003 18.1524 18.7339 6.0700 11.8451
## 6 26.2000 21.9052 13.5000 15.4093 29.3554 18.5229 18.7816 6.1300 11.8451
## 2539 2540 2542 2543 2545 2546 2547 2548 2597
## 1 23.7281 28.1000 39.6146 7.8900 24.0073 25.7483 12.6305 63.8117 44.3520
## 2 23.7281 28.1000 40.1042 7.6600 24.0544 25.7022 12.6766 64.4706 43.7987
## 3 23.8160 27.3000 40.2822 7.7100 23.9602 25.7483 12.7227 64.7529 44.9052
## 4 23.8160 26.8000 40.5938 7.8100 24.1956 25.8868 12.7688 65.6000 46.6571
## 5 23.8160 26.5500 40.1932 7.8200 24.8076 25.8406 12.5844 65.8823 47.0260
## 6 23.6841 26.9000 41.0389 7.7600 25.2783 25.8868 12.6766 67.4823 47.3026
## 2601 2603 2605 2606 2607 2608 2609 2610 2611 2612
## 1 10.7621 11.7884 15.2049 29.8613 13.0186 34.1230 8.8100 10.7179 6.3997 29.5602
## 2 10.7126 11.7389 15.2529 29.9087 13.1161 34.2668 8.8000 10.7179 6.3333 29.6079
## 3 10.6134 11.4912 15.3488 29.8613 13.0674 34.1709 8.6000 10.5711 6.3333 29.6079
## 4 10.6134 11.8380 15.4448 30.0983 13.0674 34.3147 8.7000 10.8158 6.3523 29.6556
## 5 10.8117 11.7389 15.3968 29.9087 13.0674 34.2668 8.8000 10.9626 6.3238 29.5602
## 6 10.8117 11.9370 15.3968 30.1457 13.1161 34.5543 8.8700 10.9137 6.3618 29.7509
## 2613 2614 2615 2616 2617 2618 2630 2633 2634
## 1 11.8048 12.0895 15.1627 27.1167 17.6389 14.7084 24.2295 29.4215 29.8405
## 2 11.7108 12.1355 15.1627 27.2115 17.4982 14.5679 23.8479 29.4215 29.6002
## 3 11.7108 12.1815 15.1627 27.3063 17.1698 14.5211 23.1802 29.6164 29.2639
## 4 11.7108 12.1815 15.2111 27.4959 17.4044 14.6616 23.7525 29.8599 29.5522
## 5 11.7108 12.1815 15.2111 27.5434 17.3575 14.6616 22.8940 29.7138 29.6483
## 6 11.8519 12.2734 15.4049 27.4959 17.5451 14.7084 21.9401 30.0061 29.6964
## 2636 2642 2701 2702 2704 2705 2706 2707 2712
## 1 22.3781 21.2301 12.3680 21.5328 22.6692 11.5805 13.7740 121.8887 43.0000
## 2 22.2864 21.0840 12.3195 20.6624 22.2767 11.6351 13.7740 122.3419 38.9000
## 3 22.3323 20.5484 12.2710 19.9751 21.9823 11.3442 13.6770 120.9825 39.4000
## 4 22.4699 20.7431 12.3195 19.9751 21.9332 11.5623 13.7255 121.8887 40.0000
## 5 22.5157 20.7431 12.3195 19.4254 21.9332 11.6169 13.7255 121.8887 39.9000
## 6 22.5616 20.7918 12.3195 18.9214 21.9332 11.5442 13.7740 120.9825 40.0000
## 2722 2727 2731 2739 2748 2801 2809 2812 2816
## 1 28.9645 74.2291 82.3689 28.6276 59.7278 16.3936 27.4467 9.4244 18.7310
## 2 28.9645 73.5655 82.0823 28.3862 60.0145 16.3936 26.8251 9.4244 19.0655
## 3 28.7661 72.6175 81.4134 28.3862 60.0145 16.3936 26.9686 9.3780 18.7788
## 4 28.8653 74.2291 82.4645 28.5310 60.2056 16.8688 27.2555 9.4708 18.8744
## 5 28.9645 74.4187 82.2734 28.7241 60.7790 16.6312 27.1598 9.4244 18.7310
## 6 28.7661 74.8927 83.1334 28.6759 61.0657 17.0589 27.2076 9.5173 18.8266
## 2820 2823 2832 2834 2836 2838 2841 2845 2849 2850
## 1 12.8837 27.4048 18.6979 9.5851 8.6674 8.8720 8.1300 9.3727 12.2469 32.5850
## 2 12.9785 27.4048 18.7936 9.6782 8.6769 8.8813 8.1500 9.3540 12.2000 32.5850
## 3 13.0732 27.1588 18.7458 9.6317 8.6579 8.8720 8.1100 9.3446 12.2000 32.5850
## 4 13.0732 27.6016 18.8414 9.8643 8.8196 8.9747 8.1500 9.4290 12.1531 32.8184
## 5 13.0732 27.3556 18.9370 9.8643 8.8006 8.9654 8.1500 9.4290 12.1062 32.8184
## 6 13.2153 27.6508 19.0327 10.0039 8.8387 9.0961 8.2100 9.5228 12.2469 33.1452
## 2851 2852 2855 2867 2880 2881 2882 2883 2884
## 1 16.2748 14.0763 11.2475 11.3000 16.0808 44.1000 44.0476 9.3743 18.2903
## 2 16.2272 14.0763 11.3899 11.3500 16.1733 43.8130 43.3278 9.3259 18.2903
## 3 16.2272 14.0279 11.5797 11.4000 16.0808 43.3347 42.7521 9.1516 18.3813
## 4 16.3224 14.1730 11.8645 11.4000 16.4505 43.9565 43.3758 9.4421 18.4723
## 5 16.3224 14.0763 11.8645 11.3000 16.3581 43.7174 43.3278 9.3937 18.4723
## 6 16.3700 14.1730 12.0069 11.4000 16.5891 45.0088 44.0955 9.5874 18.8363
## 2885 2886 2887 2888 2889 2890 2891 2892 2897 2901
## 1 14.4781 24.0589 12.3763 8.4806 9.0638 9.6534 18.9787 18.7442 7.9900 24.5815
## 2 14.3829 24.0589 12.3763 8.2964 9.0922 9.7010 19.0741 18.8388 7.9800 24.4340
## 3 14.3829 23.8698 12.2818 8.0444 9.0543 9.5583 18.8833 18.7915 7.9200 24.4340
## 4 14.7639 24.2007 12.6125 8.6550 9.1397 9.8912 19.1695 18.9335 7.9300 24.3848
## 5 14.8115 24.1061 12.5180 8.5969 9.1112 9.7485 19.0264 18.8862 7.8900 24.3357
## 6 14.9544 24.4370 12.7070 8.6356 9.2441 9.9863 19.3125 19.1228 7.9500 24.3357
## 2903 2904 2905 2906 2908 2910 2911 2912 2913
## 1 14.9923 18.5090 17.4582 9.1490 20.8934 25.4110 9.9500 291.8723 15.2029
## 2 14.9923 18.5090 17.2151 9.1393 20.7051 24.9223 9.9200 290.9011 15.1538
## 3 15.0887 18.6029 16.7774 9.1780 20.7051 24.9712 9.9000 293.3293 14.9086
## 4 15.2333 18.6499 16.8747 9.3615 20.7051 24.9712 9.8300 304.0135 15.0558
## 5 14.9923 18.6029 16.8260 10.0958 20.7522 24.9712 9.8100 304.0135 15.1048
## 6 15.2333 18.6029 16.9719 9.6610 20.7992 25.2644 9.7200 310.3268 15.1048
## 2915 3002 3003 3004 3005 3006 3008 3010 3011
## 1 72.0770 9.4300 41.1439 55.7427 35.0018 28.7498 3006.3031 46.6723 7.2200
## 2 71.9842 9.5400 40.4263 55.5578 35.1772 28.4638 2976.8296 46.7665 7.1900
## 3 72.1698 9.5000 38.8953 56.3898 35.9229 27.8916 2854.0231 46.5310 6.9600
## 4 72.7263 9.6200 39.6608 62.0288 37.2826 28.3684 3050.5135 46.8607 7.0800
## 5 72.7263 9.3500 40.3306 62.3061 37.1071 28.4161 3089.8115 46.5310 7.1100
## 6 75.1382 9.3700 40.6176 67.6678 38.1598 28.8929 3276.4774 46.6252 7.1400
## 3013 3014 3015 3016 3017 3018 3019 3021 3022
## 1 13.9669 28.0060 16.7066 42.9549 25.0174 33.8000 65.2287 13.6918 49.4973
## 2 14.1139 27.9597 16.7066 39.7748 24.3347 34.1500 63.5737 13.7393 49.0718
## 3 14.0649 28.0060 16.5658 40.0195 23.6032 34.3500 62.3080 13.5967 49.2137
## 4 14.3099 28.6541 16.6597 40.7044 24.4810 34.5500 64.6446 13.6918 49.7100
## 5 14.4079 28.4689 17.4106 41.1936 25.1150 34.5000 66.6891 13.6918 49.7810
## 6 14.4569 28.4689 17.4106 41.3893 24.9687 33.2500 65.8129 13.8344 50.4901
## 3023 3024 3025 3026 3027 3028 3029 3030 3031
## 1 80.0128 5.8116 17.5000 96.7084 8.6200 19.4776 18.7511 42.5765 10.0579
## 2 78.8532 5.7830 17.2500 93.5000 8.5500 19.4312 18.7511 42.5301 9.9142
## 3 77.4037 5.7734 16.8000 93.5000 8.5600 19.3849 18.5137 42.2055 9.7226
## 4 79.2397 5.7830 17.3000 95.3334 8.5500 19.4312 19.3682 43.2258 9.8663
## 5 78.3700 5.7830 19.0000 97.1667 8.5000 19.5704 19.1783 44.0143 9.9142
## 6 79.4330 5.7639 20.0000 101.2917 8.5100 19.5704 19.1783 44.4781 10.2495
## 3032 3033 3034 3035 3036 3037 3038 3040 3041
## 1 23.6172 16.6859 131.8400 41.9747 36.4752 22.6509 9.2314 28.9249 18.2234
## 2 23.4327 16.5517 127.5563 40.0533 36.3811 23.7295 9.3190 29.1593 17.9092
## 3 23.0637 16.5069 127.0804 38.5261 36.2399 23.4353 9.4162 29.1593 18.3805
## 4 23.1098 16.5964 133.2678 39.5114 36.3811 23.6314 9.5816 29.1593 18.7732
## 5 23.0175 16.5964 135.1716 40.4967 36.3811 23.9746 9.7081 29.1593 18.4590
## 6 23.2482 16.6859 138.9793 41.3835 36.8988 21.6213 9.8734 29.2531 18.4590
## 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051
## 1 30.5717 2.4700 76.1646 102.1333 18.3646 9.2000 12.4282 7.3437 9.5335 3.1000
## 2 30.6666 2.3600 76.1646 101.6561 18.5127 9.0800 12.3333 7.3238 9.5335 3.0100
## 3 30.3343 2.3300 75.8804 101.6561 18.1671 9.0100 12.1436 7.2442 9.5432 2.9900
## 4 30.3343 2.3300 76.3541 103.0878 18.4633 9.2900 12.3333 7.3139 9.5043 3.0100
## 5 30.5242 2.4300 77.0172 102.6106 18.6608 9.1800 12.4282 7.2840 9.4653 3.0600
## 6 30.6666 2.3500 78.2487 103.0878 19.0557 9.3500 12.5231 7.2641 9.5335 3.1100
## 3052 3054 3055 3056 3057 3058 3059 3060 3062 3090
## 1 8.5700 26.6000 25.1519 15.7972 8.0300 7.6336 24.0596 14.4500 14.9365 47.1977
## 2 8.5500 26.8500 24.9114 15.8436 7.9700 7.6044 23.7166 14.4500 14.6446 45.7702
## 3 8.5000 26.8500 23.9977 15.7507 7.9400 7.5752 23.7166 14.4500 14.4987 45.0564
## 4 8.4700 26.8500 24.0458 16.2153 8.0700 7.5752 25.5297 15.0500 14.9852 46.6624
## 5 8.5500 26.8000 24.1420 16.1224 8.0300 7.6239 25.9217 14.8500 14.7906 46.6624
## 6 8.5600 26.7500 24.4305 15.9830 8.0000 7.6433 26.4117 14.8500 14.9852 47.8222
## 3094 3130 3149 3164 3167 3189 3209 3229 3231
## 1 17.2478 144.5444 8.6000 24.8162 36.2195 41.5896 16.0132 20.1000 17.7885
## 2 17.4389 144.5444 8.6500 24.7215 35.7165 40.1489 16.0132 19.5000 17.8355
## 3 17.2000 144.5444 8.4500 25.1951 35.3049 39.0923 15.9666 18.0000 17.6473
## 4 17.4389 144.5444 8.7800 25.2898 35.9451 41.8778 15.9201 18.3500 18.0238
## 5 17.5822 144.5444 8.7100 26.0475 35.9451 41.0613 15.8736 18.2000 17.8826
## 6 17.5345 146.4463 8.6700 25.9528 36.4024 40.9653 15.9201 18.1000 18.2590
## 3257 3266 3296 3305 3308 3311 3312 3321 3338 3346
## 1 41.7800 10.8621 13.1489 18.0118 6.1500 19.7303 9.3985 11.7597 31.0981 32.0664
## 2 42.0585 10.8621 13.1959 18.1544 6.2800 19.7303 9.3985 11.8179 29.5285 32.2525
## 3 42.2442 10.7655 12.8672 18.0594 6.2400 19.6495 9.3535 11.5850 28.9399 31.1821
## 4 44.1011 10.8138 13.4307 17.9643 6.2400 19.8112 9.4884 11.7597 31.1962 32.0198
## 5 44.1939 10.7655 13.3837 17.9643 6.3100 19.7303 9.5334 11.5967 34.2864 32.0198
## 6 45.0295 10.8138 13.3837 18.0118 6.3100 20.1347 9.5334 11.5501 34.2374 32.3922
## 3356 3376 3380 3383 3406 3413 3416 3419 3432
## 1 29.2500 80.5765 15.8511 6.9396 173.7153 124.9195 48.8837 17.6500 14.3790
## 2 29.2000 80.9634 15.8511 7.1592 167.8761 122.5536 48.7884 17.8500 14.4755
## 3 29.1000 81.0602 15.9939 7.0275 160.5772 118.7682 48.5978 17.7500 14.4755
## 4 29.2500 80.4798 16.8032 7.0275 169.3359 125.8659 48.4073 18.0500 14.5238
## 5 29.6500 80.1896 16.7556 7.0275 173.2287 124.4463 48.6931 18.1500 14.4755
## 6 29.1000 80.1896 17.4696 6.9396 184.9070 123.9732 48.6931 17.9500 14.4755
## 3437 3443 3450 3454 3481 3494 3501 3504 3515
## 1 16.7000 199.0470 62.8789 88.3172 9.4231 7.7900 47.5436 72.4216 51.1162
## 2 16.2000 179.4847 61.8341 87.4589 9.5619 7.7900 47.2628 69.6361 50.0864
## 3 15.8000 178.9956 60.5044 88.6034 9.6215 7.7600 47.2628 68.6413 49.8991
## 4 16.1000 178.9956 62.2141 91.5600 9.8198 7.6600 47.8243 71.4268 50.9290
## 5 15.9500 179.9737 62.6890 91.0831 9.8099 7.6100 47.6372 72.5211 51.2098
## 6 16.1000 181.4409 65.1585 92.2276 10.1174 7.5800 48.1987 74.1127 51.4907
## 3518 3528 3530 3532 3533 3535 3536 3545 3550
## 1 15.5000 30.2242 73.6641 107.7987 196.8969 16.1500 8.2400 25.3292 15.0342
## 2 15.4500 30.0368 72.3958 104.5601 192.5642 15.9000 8.2500 24.2535 15.0342
## 3 15.0000 29.6151 70.2492 104.5601 194.4898 15.4000 8.1100 23.5200 14.8468
## 4 15.1000 30.4585 73.1763 106.4108 198.3411 15.9000 8.1600 23.5689 14.9873
## 5 15.0500 30.4585 72.3958 106.4108 191.1200 15.8500 8.0100 23.5689 15.0810
## 6 15.0000 30.4585 74.4447 109.1867 191.1200 15.7000 8.0500 23.7645 15.1279
## 3557 3563 3576 3583 3588 3591 3593 3596 3605
## 1 21.8916 344.5729 7.7964 48.9543 19.9479 13.5135 8.0000 70.5850 22.2376
## 2 21.8916 342.2353 7.8362 47.8483 19.5606 13.5135 7.9900 70.9650 21.9953
## 3 21.5725 343.6379 7.7666 46.8384 19.5606 13.5135 7.8800 71.5350 22.1407
## 4 21.8916 367.4821 7.8461 46.7422 19.8511 13.7583 8.0000 70.9650 22.2376
## 5 21.8916 368.8847 7.9555 49.4352 19.9963 13.5135 8.0200 73.1500 22.3829
## 6 21.8278 370.2873 8.0549 52.0320 20.0932 13.7093 8.1700 72.4850 22.5283
## 3607 3617 3622 3645 3653 3669 3679 3682 3686
## 1 15.4508 72.0663 14.9792 40.3279 77.5000 16.0048 53.3153 10.7373 10.4647
## 2 15.4508 72.1609 15.0279 38.9867 75.6000 15.9560 53.8785 10.8440 10.5878
## 3 15.4995 71.6880 14.9792 40.5591 75.4000 15.9560 52.4705 10.6610 10.4647
## 4 15.4995 71.6880 15.0765 40.0504 78.7000 16.2488 53.1276 10.7373 10.5878
## 5 15.4508 71.4989 14.9306 40.4204 81.6000 16.0536 53.1276 10.7068 10.5262
## 6 15.4995 74.4307 14.9792 40.9754 83.7000 16.0536 53.6908 10.7525 10.5262
## 3694 3698 3701 3702 3703 3704 3705 3706 3708
## 1 20.4500 17.2732 12.4000 34.5149 13.2759 12.4500 37.4411 20.1669 66.8137
## 2 20.4500 17.5693 12.7500 34.4683 13.2759 12.4500 37.8687 20.1669 65.3080
## 3 20.1500 18.1615 12.7500 34.4683 13.1810 12.5500 37.8212 20.0841 64.0847
## 4 20.4000 18.5563 12.7500 34.8881 13.3233 12.5500 37.9163 20.4568 67.7547
## 5 20.4000 18.1121 12.5000 34.7948 13.3233 12.5500 37.9163 20.4568 67.9429
## 6 20.8000 18.0134 12.2000 35.3545 13.3707 12.9500 38.2013 20.9537 68.6958
## 3711 3712 4104 4106 4108 4119 4133 4142 4155
## 1 54.4510 17.2727 42.8021 23.9655 18.0000 68.6104 28.6831 18.8155 22.8692
## 2 53.9692 17.0042 42.7090 24.1607 18.0000 68.6104 28.7321 18.9096 22.7770
## 3 53.1982 16.6462 43.4534 24.0143 18.0000 73.5111 28.7810 18.6744 22.7309
## 4 53.0054 16.9595 43.4999 24.2095 18.0000 74.2799 28.7321 18.8625 22.9614
## 5 53.1982 16.7805 43.7326 24.7952 19.2000 75.0486 28.6831 19.3799 23.1458
## 6 54.2583 17.0489 43.9187 24.8928 19.0000 74.7604 28.8789 19.1918 23.2842
## 4164 4306 4414 4426 4438 4526 4532 4536 4540
## 1 29.2841 13.2869 14.1500 36.2202 104.8868 17.0656 23.4234 106.6388 55.2735
## 2 29.3802 13.1435 14.3500 36.5869 102.9622 16.9672 23.5665 105.1847 54.7978
## 3 29.7642 13.0480 14.5000 36.1743 103.9245 16.9672 23.3757 105.1847 53.6562
## 4 30.5803 13.1913 14.5000 36.8620 104.4056 17.2131 23.4234 105.1847 54.8930
## 5 30.8684 13.0480 14.5000 36.7245 104.4056 17.2131 24.1390 108.0930 53.7513
## 6 30.8204 13.2391 14.6000 36.9537 103.4434 17.1639 24.3298 105.6694 55.5589
## 4545 4551 4555 4562 4564 4566 4572 4576 4720 4722
## 1 24.3615 104.3570 55.3427 34.3881 <NA> 40.7121 <NA> <NA> 13.5511 24.5392
## 2 24.3615 103.3817 55.1498 35.3433 <NA> 40.7599 <NA> <NA> 13.7489 24.6332
## 3 24.3123 103.3817 55.1498 34.8657 <NA> 40.0432 <NA> <NA> 13.4027 24.4452
## 4 24.1155 102.4064 55.9212 35.1522 <NA> 40.3299 <NA> <NA> 13.5511 25.1503
## 5 24.1155 99.9681 54.9570 34.8657 <NA> 40.8077 <NA> <NA> 13.4522 24.8213
## 6 24.7061 99.9681 55.9212 34.6269 <NA> 40.8077 <NA> <NA> 13.6005 25.2914
## 4725 4737 4739 4746 4755 4764 4766 4904 4906
## 1 22.4000 45.8755 87.7339 37.0000 36.9807 66.4817 108.8272 68.8276 23.0000
## 2 22.2000 45.1550 84.2708 37.1952 36.7452 66.3963 104.9405 68.7326 22.7500
## 3 21.6500 44.5785 81.2886 37.0976 36.4625 65.8843 108.8272 68.7326 22.7000
## 4 23.0000 45.2510 82.9240 38.5132 36.6510 66.3963 108.8272 70.0635 24.5000
## 5 22.7000 44.8667 83.1164 38.4156 36.8394 67.4204 111.7422 69.4931 25.4500
## 6 22.9500 45.2510 89.3693 38.4644 36.8394 68.1885 109.3130 69.3030 25.5000
## 4915 4916 4919 4930 4934 4938 4942 4952 4956 4960
## 1 42.3602 26.9232 35.7727 10.5500 8.9797 47.0617 32.6331 27.7289 15.2000 8.6900
## 2 42.5990 26.7835 34.3636 10.6500 8.9084 46.4992 31.9308 27.4493 15.0500 8.7000
## 3 41.5961 26.2245 35.2272 10.7000 8.7302 45.4680 31.3690 27.1697 14.9000 8.5600
## 4 42.7900 26.5040 35.7272 10.8500 8.8015 45.4680 32.0713 27.7289 15.1000 8.8900
## 5 43.2676 26.5506 36.9545 10.7500 8.8015 44.4367 32.6331 27.7289 15.1000 9.1400
## 6 46.2763 27.0164 38.3636 10.9000 8.7302 44.9992 31.4158 28.5212 15.2500 9.3800
## 4961 4967 4968 4976 4989 4994 4999 5007 5203 5234
## 1 35.8174 <NA> 46.0435 31.2000 23.3438 63.2000 42.4038 49.8307 67.1515 88.3055
## 2 35.8174 <NA> 44.6169 30.6000 22.4062 62.6000 42.4964 49.1688 67.3445 85.5666
## 3 35.3334 <NA> 42.9444 30.1000 21.4688 62.3000 42.2186 49.1688 67.5375 88.3055
## 4 35.4302 <NA> 44.8629 31.0000 23.5781 63.4000 42.7741 49.1688 66.6691 88.0222
## 5 35.3334 <NA> 44.9613 31.2500 23.6719 63.3000 42.6815 48.3178 66.1867 86.8888
## 6 35.4302 <NA> 49.3885 31.9000 23.4844 62.9000 42.9593 48.4124 65.7043 87.5500
## 5258 5269 5283 5285 5305 5388 5434 5469 5471 5484
## 1 13.3500 488.2301 <NA> 64.3118 25.1088 62.5028 65.1770 21.4421 27.1735 8.3931
## 2 13.2000 458.8776 <NA> 63.8396 23.9845 62.9843 64.5196 21.4421 27.1267 8.4100
## 3 13.1000 470.6186 <NA> 64.2174 24.0782 63.7548 63.7683 21.1587 26.8929 8.3422
## 4 13.2000 471.1078 <NA> 63.7452 24.7341 63.8511 64.8013 21.6783 27.1735 8.2574
## 5 13.2000 481.8704 <NA> 64.2174 24.9683 63.7548 64.5196 21.4421 27.0332 8.1896
## 6 13.2500 496.0574 <NA> 64.2174 25.1088 62.4065 65.3648 22.3867 27.1267 8.2405
## 5515 5519 5521 5522 5525 5531 5533 5534 5607 5608
## 1 9.3395 11.4127 8.0187 31.6049 17.5131 10.0446 15.1194 71.8235 16.2612 11.2332
## 2 9.3588 11.3183 8.0187 32.0683 17.5131 10.1436 15.3586 72.2839 16.2159 11.2938
## 3 9.2819 11.2712 7.8913 31.8366 17.3443 10.0941 15.1194 73.0206 16.2612 11.2938
## 4 9.3299 11.5070 7.9893 31.8366 17.4287 10.1930 15.4543 73.2968 16.5330 11.2938
## 5 9.2819 11.5070 7.9893 31.7439 17.7241 10.0941 15.1672 71.9156 16.4877 11.2180
## 6 9.2819 11.6956 7.9403 32.3463 17.7663 10.2920 15.2629 73.1126 16.4877 11.2180
## 5706 5876 5880 6005 6024 6108 6112 6115 6116 6117
## 1 32.1769 37.6424 16.4607 8.5192 40.9898 23.6038 26.1626 37.3597 6.6691 12.1000
## 2 32.1769 37.6424 16.5542 8.5767 42.2861 23.3741 25.9882 37.1734 6.7457 12.0500
## 3 31.7662 37.5954 16.5074 8.5097 41.9732 22.9609 25.8574 37.2665 6.7840 12.1000
## 4 31.7662 37.7362 16.5542 8.5767 42.1520 23.0527 26.0754 37.2665 6.7840 12.3000
## 5 31.7662 37.5015 16.6477 8.5863 41.3027 23.1445 26.0754 37.2199 6.6500 12.4500
## 6 31.7662 38.2056 16.8348 8.7490 41.6603 23.5578 26.8167 37.2199 6.7361 12.7000
## 6120 6128 6131 6133 6136 6139 6141 6142 6152 6153
## 1 15.8449 26.9255 <NA> 8.3288 16.7294 24.4348 15.3216 8.2900 4.4000 24.4249
## 2 15.8940 27.1142 <NA> 8.4162 16.9153 24.1040 15.0729 8.5800 4.3300 22.4055
## 3 15.3053 26.9727 <NA> 8.4162 16.8224 23.7732 15.0232 8.5000 4.2900 23.5114
## 4 16.0902 26.9727 <NA> 8.3968 16.9618 24.1985 15.0729 8.5700 4.4700 23.9922
## 5 15.9921 27.0670 <NA> 8.2997 17.0082 24.1040 14.7744 8.6100 4.4300 23.8479
## 6 16.0902 27.0198 <NA> 8.3288 17.1477 24.5294 14.9237 8.6300 4.4000 23.9441
## 6155 6164 6165 6166 6168 6172 6176 6177 6183 6184
## 1 18.9787 8.1751 8.1100 30.4901 11.9018 12.9500 76.5740 26.4080 31.0419 31.8297
## 2 18.6926 8.1654 8.1900 30.3449 11.5298 11.8500 76.9471 26.2676 31.0419 31.8297
## 3 18.4065 8.1264 8.1600 30.0061 11.3439 11.9000 75.5481 26.0803 31.0419 31.8764
## 4 18.6926 8.1751 8.1200 30.6837 11.4833 11.9000 76.8538 26.3144 31.0896 32.1097
## 5 18.8833 8.1556 8.2800 31.7968 11.4368 11.8000 77.6000 26.4080 31.0896 32.1097
## 6 19.3602 8.2822 8.2900 34.3135 11.6693 12.2000 76.7606 26.5953 31.1852 32.2964
## 6189 6191 6192 6196 6197 6201 6202 6205 6206
## 1 26.2751 12.2612 60.4646 44.3946 25.2497 27.5150 54.7426 20.8151 63.0312
## 2 26.2751 12.1631 59.2169 43.6869 24.8281 27.4687 53.6216 20.9097 62.9375
## 3 26.2751 11.9669 58.9290 42.7434 24.6407 27.3760 53.5282 20.7205 62.9375
## 4 26.4138 12.3102 60.0807 43.5926 24.8749 27.3760 54.8360 21.0989 63.3126
## 5 26.3676 12.2612 59.6968 44.1587 24.6876 27.3297 54.0887 21.0989 63.3126
## 6 26.3676 12.5064 60.6566 44.6305 24.8749 27.3760 55.3031 20.8624 62.8437
## 6209 6213 6214 6215 6216 6224 6225 6226 6230
## 1 27.7500 49.0596 57.8026 13.8744 25.7518 47.9466 3.3000 8.7316 128.4971
## 2 27.4000 47.7311 57.5220 13.6804 25.7984 48.1226 3.2000 8.5741 131.4398
## 3 26.8000 48.3005 57.5220 13.2923 25.6121 48.2106 3.1000 8.3969 133.4016
## 4 28.0000 49.8188 58.0832 13.6804 25.7984 48.4745 3.0300 8.3772 131.4398
## 5 27.9000 50.2932 57.6155 13.6804 25.7053 48.4745 3.2300 8.4067 144.1914
## 6 28.5500 50.5779 58.0832 13.7774 25.8915 48.9144 3.2300 8.4461 141.7392
## 6235 6239 6243 6251 6257 6269 6271 6277 6278
## 1 16.9897 62.4878 10.1000 8.9200 24.7985 71.3983 102.6866 82.5738 37.2943
## 2 16.9897 62.4878 10.0500 9.1400 24.7061 66.9418 101.7314 82.7567 37.8832
## 3 16.6528 60.5056 9.6000 8.4500 24.4290 66.3729 96.9552 83.2139 36.8036
## 4 16.7972 62.6766 9.6500 8.6000 24.7523 67.3211 101.2537 86.3230 38.2757
## 5 17.1341 60.9776 9.5500 8.5100 24.7523 65.2351 103.1642 85.5000 37.2452
## 6 17.4710 62.6766 9.5500 8.2600 25.3526 66.3729 100.7761 85.4086 36.3129
## 6281 6282 6283 6285 6288 6289 6405 6409 6412
## 1 59.0451 18.0923 34.2500 77.1138 16.9713 3.9287 13.7356 489.7200 40.9406
## 2 58.9511 18.0923 34.1000 78.3530 16.7282 4.0952 13.5428 493.4160 39.9807
## 3 58.9511 17.8051 33.4500 79.2108 15.9015 4.1618 12.8199 488.7960 39.7887
## 4 59.1391 18.3795 33.9000 78.1623 16.2419 4.1618 12.9162 498.9600 40.1727
## 5 59.1391 18.4274 34.0000 78.6389 16.0474 3.9953 12.9644 501.7320 40.3166
## 6 59.2332 18.4752 34.5000 76.8278 16.2419 3.6624 13.0126 506.3520 40.4606
## 6414 6416 6442 6443 6449 6464 6477 6491 6504
## 1 236.1201 86.6755 34.4541 9.3339 30.0615 107.2119 19.2794 <NA> 152.3863
## 2 237.0800 86.6755 34.8664 9.5846 29.9165 107.2119 19.4244 <NA> 152.8701
## 3 231.8009 84.3794 34.8664 9.5404 29.5782 107.2119 19.2794 <NA> 153.8376
## 4 238.9997 85.3361 35.3704 9.6141 29.9648 107.2119 19.5210 <NA> 154.3214
## 5 238.5197 83.7098 37.2947 9.4519 30.5448 106.7416 19.6177 <NA> 155.2889
## 6 239.4796 87.0582 37.6612 9.4519 30.4965 105.8012 19.7626 <NA> 156.2564
## 6505 6531 6533 6552 6558 6579 6581 6582 6592 6605
## 1 98.8279 42.3325 80.8555 96.1380 44.5488 69.0981 80.3453 44.8872 <NA> 65.3597
## 2 99.7874 41.6904 78.5681 95.0600 42.7826 68.7174 79.7768 45.0275 <NA> 65.1663
## 3 100.2671 41.8879 78.4687 92.1200 41.8995 69.4788 79.5873 44.8405 <NA> 64.3928
## 4 104.5848 42.1349 80.4577 93.1000 45.3338 69.6692 79.5873 44.8405 <NA> 65.3597
## 5 103.1456 42.0855 80.2588 89.1800 44.1563 69.3837 81.4822 44.6535 <NA> 65.5530
## 6 109.3823 42.7771 80.1594 90.8460 45.1867 69.3837 83.7562 45.2613 <NA> 65.8431
## 6625 6655 6668 6669 6670 6674 6698 6706 6715 8011 8016
## 1 50.7964 45.4085 87.9873 <NA> 148.3217 41.3834 <NA> <NA> <NA> 18.5000 95.1151
## 2 50.6117 45.9778 85.1331 <NA> 150.2111 40.8644 <NA> <NA> <NA> 18.3500 99.4605
## 3 49.7805 45.7406 80.8027 <NA> 153.5177 39.7319 <NA> <NA> <NA> 18.1500 92.3148
## 4 49.5034 46.0253 83.1647 <NA> 152.5729 39.8263 <NA> <NA> <NA> 18.4500 96.1773
## 5 49.7805 46.9743 85.6252 <NA> 151.1558 39.4959 <NA> <NA> <NA> 18.4000 95.6945
## 6 50.0575 46.9743 85.8221 <NA> 151.6282 39.6375 <NA> <NA> <NA> 18.2500 98.9777
## 8021 8028 8033 8039 8046 8070 8072 8081 8101
## 1 16.7922 37.5092 8.0600 32.4564 33.5091 121.7984 21.5135 60.6036 3.1900
## 2 16.6511 36.6413 8.0500 32.9746 34.0988 121.3439 21.6599 60.1287 3.1700
## 3 16.6511 35.4843 8.1200 33.9167 32.9195 119.0715 21.5623 59.5587 3.1800
## 4 16.7922 36.0146 8.2900 33.6340 34.0988 119.0715 21.5623 60.4136 3.1900
## 5 16.8863 35.7253 8.1800 33.5398 34.5901 116.7992 21.3672 60.3186 3.2000
## 6 17.0274 35.9664 8.4700 33.6811 32.9195 118.6171 21.2696 60.5086 3.2300
## 8103 8104 8105 8110 8112 8114 8131 8150 8163 8201
## 1 22.9324 <NA> 9.6200 10.4914 22.6129 95.1285 29.6951 26.3000 35.9720 12.7500
## 2 23.0283 <NA> 9.5500 10.2971 22.5293 94.4659 29.6484 25.8500 35.6021 12.6000
## 3 22.8844 <NA> 9.3500 10.1514 22.7801 93.7086 29.6951 25.2000 34.8624 12.3500
## 4 23.1723 <NA> 9.4600 10.3943 23.1981 94.5605 29.8349 24.6000 36.0645 12.5500
## 5 23.2202 <NA> 9.4200 10.4914 23.0727 94.6552 30.0214 24.8500 36.8043 12.5000
## 6 23.4121 <NA> 9.5200 10.5886 23.5325 95.6018 30.2545 25.0500 38.3763 12.6000
## 8210 8213 8215 8222 8249 8261 8271 8341 8367
## 1 40.4780 26.1593 16.1430 16.0488 18.6881 29.5338 26.2881 196.3004 21.9323
## 2 40.6192 25.9228 16.1430 16.0488 18.8297 29.0995 26.3343 197.2770 21.7411
## 3 39.9132 25.7809 16.3381 15.9512 18.8769 29.0995 26.0571 195.8121 21.9800
## 4 40.5721 26.3012 16.3869 16.1951 18.9713 29.0995 26.4267 195.3238 22.2667
## 5 40.5251 26.3958 16.6795 16.1951 19.1128 29.2443 26.6577 197.2770 21.9800
## 6 41.0428 26.5377 16.9721 16.0976 19.4432 29.1477 26.5653 200.2069 22.2190
## 8374 8422 8443 8454 8462 8463 8464 8473 8478
## 1 18.3252 156.1774 11.5406 181.0592 140.3611 25.6652 228.0568 53.4401 41.1519
## 2 18.0816 156.1774 11.4923 181.0592 140.3611 25.2763 230.9375 53.8211 41.2472
## 3 17.5454 155.7070 11.3957 183.9561 137.6791 24.4986 240.0597 55.3452 40.7709
## 4 17.8379 157.1183 11.5406 186.8531 139.4671 24.5958 248.7019 56.2026 41.3424
## 5 17.6917 157.5887 11.5406 188.3016 139.4671 24.2070 263.5856 55.8215 41.1996
## 6 17.9841 160.4112 11.4923 191.1985 139.4671 24.5472 277.0290 55.7263 44.2955
## 8481 8497 8926 8940 8996 9902 9904 9905 9906
## 1 46.9824 45.7763 23.6861 12.7000 35.1002 9.1055 30.9647 23.3357 11.5000
## 2 47.5530 45.6829 23.7807 12.5000 34.8137 9.0861 31.7340 23.2877 11.1500
## 3 47.1726 45.5428 23.6861 12.4500 34.1928 9.0182 32.1187 23.2877 10.9000
## 4 47.2677 45.6362 23.7807 12.5000 34.6226 9.0958 32.5995 23.2877 10.8000
## 5 47.0775 45.7296 23.7334 12.5000 34.4794 9.0764 32.8880 23.3357 10.7500
## 6 47.1726 45.5428 23.7807 12.5000 34.2406 9.1636 33.3688 23.3837 10.7500
## 9907 9908 9910 9911 9912 9914 9917 9918 9919
## 1 11.6708 27.9831 165.6330 34.0491 9.1100 135.9283 83.5112 32.1916 10.2556
## 2 11.7190 27.9349 168.2831 34.3328 9.0900 142.7984 83.0335 32.3850 10.2556
## 3 11.6708 27.9831 170.9333 34.2382 9.0500 144.2705 82.8424 32.5300 10.1574
## 4 11.8155 28.0312 174.0251 34.5693 9.0700 145.7427 82.9379 32.5300 10.1574
## 5 11.7672 28.0312 174.0251 35.0422 9.0300 145.2519 82.2691 32.3366 10.1574
## 6 12.0084 28.0794 175.7918 35.4678 8.8800 143.7798 82.0780 32.3366 10.1574
## 9921 9924 9925 9926 9927 9928 9929 9930 9931
## 1 141.1632 32.3057 35.4697 38.3921 29.1722 5.1200 14.1000 48.6051 30.4680
## 2 152.9268 32.3532 35.5171 38.1031 29.2679 5.1200 14.0000 48.9901 30.7564
## 3 150.4760 32.4480 35.6119 38.2476 29.4114 5.1900 13.9000 48.7976 30.5641
## 4 157.3381 32.5429 35.7542 38.2476 29.7939 5.1900 14.1000 49.0863 30.5641
## 5 152.9268 32.5429 35.7068 38.2476 29.7461 5.1100 13.9500 48.9901 30.5641
## 6 156.8480 32.8275 35.6594 38.1994 30.0331 5.0000 13.9500 49.6638 30.5641
## 9933 9934 9935 9937 9938 9939 9940 9941 9942
## 1 42.2698 15.1676 17.5726 38.4471 47.9202 45.1894 28.2383 79.5417 66.0800
## 2 42.2698 15.1676 17.4733 39.1149 49.1839 45.1894 28.2383 80.0644 67.9680
## 3 42.9838 15.2603 17.3741 39.1149 48.6007 45.2374 28.0462 80.1515 68.4400
## 4 43.8883 15.4459 17.7712 38.9241 49.5727 45.6212 28.3343 81.0227 69.6672
## 5 44.1739 15.7242 18.3669 38.7333 49.8643 45.4293 28.6705 81.1970 69.6672
## 6 44.6975 15.9097 18.5654 38.7333 50.3503 45.9570 29.1988 82.5909 67.6848
## 9943 9944 9945 9946 9955 9958
## 1 53.5385 16.3000 42.4068 11.5447 12.1500 60.8629
## 2 53.2615 16.3000 42.9798 11.5447 12.2500 58.0738
## 3 53.5385 16.1500 43.3619 11.5447 11.9500 52.2963
## 4 54.0923 16.3500 44.1259 11.5909 12.0000 52.5951
## 5 54.3692 16.3500 43.4574 11.4061 12.0500 52.2963
## 6 55.1077 16.3500 44.8423 11.4985 12.0500 52.7944#Q3: 將資料轉換為xts時間序列資料
library(pacman)
p_load(lubridate)
ymd_hms('2011-06-04 11:01:01')## [1] "2011-06-04 11:01:01 UTC"myDate <- ymd_hms('2011 june 4th,11:01:01')
myDate## [1] "2011-06-04 11:01:01 UTC"year(myDate)## [1] 2011month(myDate)## [1] 6yday(myDate)## [1] 155mday(myDate)## [1] 4wday(myDate, label = TRUE)## [1] Sat
## Levels: Sun < Mon < Tue < Wed < Thu < Fri < Satas.POSIXlt('2014-05-01', format = "%Y-%m-%d")## [1] "2014-05-01 UTC"library(xts)## Loading required package: zoo##
## Attaching package: 'zoo'## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric## Registered S3 method overwritten by 'xts':
## method from
## as.zoo.xts zoodates17 <- date(c("2019-01-02","2019-01-03","2019-01-04",
"2019-01-07","2019-01-08","2019-01-09"))
a1101 <- c(31.1099,30.7210,31.4124,
30.6778,30.3754,30.6346)
a1102 <- c(32.7650,32.5769,33.1410,
31.7778,31.8718,31.8248)
datadf <- data.frame(a1101, a1102)
xts(datadf, dates17)## a1101 a1102
## 2019-01-02 31.1099 32.7650
## 2019-01-03 30.7210 32.5769
## 2019-01-04 31.4124 33.1410
## 2019-01-07 30.6778 31.7778
## 2019-01-08 30.3754 31.8718
## 2019-01-09 30.6346 31.8248#Q4: 將Q3資料轉換為tibble的資料型態
p_load(tbl2xts)
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:xts':
##
## first, last## The following objects are masked from 'package:lubridate':
##
## intersect, setdiff, union## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionoptions(digits=3)
tibble(
s=c("2019-01-02","2019-01-03","2019-01-04",
"2019-01-07","2019-01-08","2019-01-09"),
x1101 = a1101,
x1102 = a1102)## # A tibble: 6 x 3
## s x1101 x1102
## <chr> <dbl> <dbl>
## 1 2019-01-02 31.1 32.8
## 2 2019-01-03 30.7 32.6
## 3 2019-01-04 31.4 33.1
## 4 2019-01-07 30.7 31.8
## 5 2019-01-08 30.4 31.9
## 6 2019-01-09 30.6 31.8