In [1]:
import booq
In [2]:
# let's define some parameters for our mock catalogs
# to be real fake, we have to fake evrything... :(
# let's start with the size of the supposed images
# from where the sources are coming from...
sx = 5000
sy = 5000
# number of sources to be relative to the size of the image
num_sources = int( 0.1 * (sx*sy)/(sx+sy) )
# and, say there is an error radius
error_radius = 20
In [3]:
from booq.data import mock
from booq import coordinates
# Generate catalog A
A_image_catalog = mock.D2.generate_catalog(num_sources, error_radius, (sy,sx))
A = A_image_catalog.rename(columns={'ID':'id'})
A.loc[:,'ra'] = coordinates.pixel_to_sky(A_image_catalog.x, 0, 1.0/sx)
A.loc[:,'dec'] = coordinates.pixel_to_sky(A_image_catalog.y, 0, 1.0/sy)
# Generate catalog B
B_image_catalog = mock.D2.generate_catalog_around(A_image_catalog, 0.75, (sy,sx))
B = B_image_catalog.rename(columns={'ID':'id'})
B.loc[:,'ra'] = coordinates.pixel_to_sky(B_image_catalog.x, 0, 1.0/sx)
B.loc[:,'dec'] = coordinates.pixel_to_sky(B_image_catalog.y, 0, 1.0/sy)
In [4]:
from booq.pipelines import xmatch_nn
# X-match the catalogs
matched_catalog_serial = xmatch_nn.xmatch(A, B)
/home/chbrandt/fido/repos/booq/booq/pipelines/xmatch_nn.py:121: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
B_matched['A_idx'] = df_matched_idx.index
In [5]:
from booq.pipelines import xmatch_nn
# X-match the catalogs
matched_catalog_parallel = xmatch_nn.xmatch(A, B, parallel_run=True)
Running in parallel
Running in parallel
In [6]:
matched_catalog_parallel.equals(matched_catalog_serial)
Out[6]:
True
In [7]:
from booq.table.atable import aTable
aTable.from_pandas(matched_catalog_parallel).show_in_notebook()
Out[7]:
<Table length=250>
A_id A_r A_x A_y A_ra A_dec B_id B_r B_x B_y B_ra B_dec AB_dist
1.0 20.0 2249.0 146.0 0.4498 0.0292 1.0 20.0 2232.0 120.0 0.4464 0.024 22.3664026523
2.0 20.0 4509.0 2379.0 0.9018 0.4758 2.0 20.0 4503.0 2404.0 0.9006 0.4808 18.5111074623
3.0 20.0 1326.0 3287.0 0.2652 0.6574 3.0 20.0 1333.0 3324.0 0.2666 0.6648 27.1125029884
4.0 20.0 1449.0 100.0 0.2898 0.02 4.0 20.0 1442.0 82.0 0.2884 0.0164 13.9055096069
5.0 20.0 1401.0 4706.0 0.2802 0.9412 5.0 20.0 1401.0 4689.0 0.2802 0.9378 12.24
6.0 20.0 257.0 2603.0 0.0514 0.5206 6.0 20.0 265.0 2581.0 0.053 0.5162 16.8546873023
7.0 20.0 4474.0 0.0 0.8948 0.0 nan nan nan nan nan nan nan
8.0 20.0 3148.0 4217.0 0.6296 0.8434 8.0 20.0 3149.0 4219.0 0.6298 0.8438 1.60993404434
9.0 20.0 2338.0 763.0 0.4676 0.1526 9.0 20.0 2356.0 781.0 0.4712 0.1562 18.3281744926
10.0 20.0 2293.0 3523.0 0.4586 0.7046 10.0 20.0 2284.0 3508.0 0.4568 0.7016 12.5946050783
11.0 20.0 3953.0 5.0 0.7906 0.001 11.0 20.0 3994.0 5.0 0.7988 0.001 29.5199999955
12.0 20.0 634.0 1047.0 0.1268 0.2094 12.0 20.0 590.0 1028.0 0.118 0.2056 34.5072693283
13.0 20.0 2198.0 274.0 0.4396 0.0548 13.0 20.0 2176.0 289.0 0.4352 0.0578 19.1714724965
14.0 20.0 3282.0 2297.0 0.6564 0.4594 14.0 20.0 3283.0 2311.0 0.6566 0.4622 10.1056799113
15.0 20.0 1925.0 2397.0 0.385 0.4794 nan nan nan nan nan nan nan
16.0 20.0 4978.0 984.0 0.9956 0.1968 nan nan nan nan nan nan nan
17.0 20.0 178.0 2086.0 0.0356 0.4172 nan nan nan nan nan nan nan
18.0 20.0 2539.0 3910.0 0.5078 0.782 18.0 20.0 2555.0 3916.0 0.511 0.7832 12.3023592118
19.0 20.0 3947.0 874.0 0.7894 0.1748 19.0 20.0 3943.0 862.0 0.7886 0.1724 9.10735548084
20.0 20.0 3888.0 1381.0 0.7776 0.2762 nan nan nan nan nan nan nan
21.0 20.0 442.0 3185.0 0.0884 0.637 21.0 20.0 426.0 3232.0 0.0852 0.6464 35.7468789388
22.0 20.0 4457.0 4512.0 0.8914 0.9024 22.0 20.0 4469.0 4515.0 0.8938 0.903 8.9048678711
23.0 20.0 1746.0 2969.0 0.3492 0.5938 23.0 20.0 1736.0 2989.0 0.3472 0.5978 16.0995153529
24.0 20.0 839.0 817.0 0.1678 0.1634 24.0 20.0 826.0 810.0 0.1652 0.162 10.6306393762
25.0 20.0 2319.0 3263.0 0.4638 0.6526 25.0 20.0 2333.0 3281.0 0.4666 0.6562 16.4181224893
26.0 20.0 2973.0 2842.0 0.5946 0.5684 26.0 20.0 2960.0 2811.0 0.592 0.5622 24.202964113
27.0 20.0 3901.0 1775.0 0.7802 0.355 nan nan nan nan nan nan nan
28.0 20.0 998.0 951.0 0.1996 0.1902 nan nan nan nan nan nan nan
29.0 20.0 604.0 2863.0 0.1208 0.5726 139.0 20.0 605.0 2865.0 0.121 0.573 1.60995285343
30.0 20.0 1129.0 2939.0 0.2258 0.5878 30.0 20.0 1124.0 2968.0 0.2248 0.5936 21.1880396104
31.0 20.0 3627.0 2174.0 0.7254 0.4348 31.0 20.0 3628.0 2202.0 0.7256 0.4404 20.1728522961
32.0 20.0 3649.0 2379.0 0.7298 0.4758 32.0 20.0 3616.0 2378.0 0.7232 0.4756 23.7700880557
33.0 20.0 2384.0 3368.0 0.4768 0.6736 33.0 20.0 2389.0 3380.0 0.4778 0.676 9.35990397448
34.0 20.0 3790.0 1885.0 0.758 0.377 34.0 20.0 3769.0 1865.0 0.7538 0.373 20.8797654903
35.0 20.0 1661.0 3058.0 0.3322 0.6116 35.0 20.0 1693.0 3068.0 0.3386 0.6136 24.1375416796
36.0 20.0 3480.0 4970.0 0.696 0.994 nan nan nan nan nan nan nan
37.0 20.0 4662.0 1695.0 0.9324 0.339 37.0 20.0 4656.0 1688.0 0.9312 0.3376 6.638023003
38.0 20.0 2037.0 4343.0 0.4074 0.8686 38.0 20.0 2026.0 4297.0 0.4052 0.8594 34.0535833244
39.0 20.0 517.0 200.0 0.1034 0.04 nan nan nan nan nan nan nan
40.0 20.0 4554.0 779.0 0.9108 0.1558 40.0 20.0 4566.0 759.0 0.9132 0.1518 16.7931254411
41.0 20.0 1598.0 1580.0 0.3196 0.316 nan nan nan nan nan nan nan
42.0 20.0 4177.0 4874.0 0.8354 0.9748 42.0 20.0 4178.0 4874.0 0.8356 0.9748 0.719895797581
43.0 20.0 3527.0 1038.0 0.7054 0.2076 nan nan nan nan nan nan nan
44.0 20.0 1494.0 43.0 0.2988 0.0086 44.0 20.0 1486.0 53.0 0.2972 0.0106 9.22049885121
45.0 20.0 2680.0 4229.0 0.536 0.8458 45.0 20.0 2694.0 4237.0 0.5388 0.8474 11.6086957921
46.0 20.0 2793.0 4080.0 0.5586 0.816 46.0 20.0 2798.0 4107.0 0.5596 0.8214 19.7704565969
47.0 20.0 662.0 2435.0 0.1324 0.487 47.0 20.0 684.0 2451.0 0.1368 0.4902 19.5856517429
48.0 20.0 3215.0 1398.0 0.643 0.2796 nan nan nan nan nan nan nan
49.0 20.0 2829.0 1040.0 0.5658 0.208 150.0 20.0 2993.0 1082.0 0.5986 0.2164 121.889920532
50.0 20.0 4475.0 403.0 0.895 0.0806 50.0 20.0 4479.0 398.0 0.8958 0.0796 4.6102476928
51.0 20.0 3028.0 2240.0 0.6056 0.448 nan nan nan nan nan nan nan
52.0 20.0 4056.0 3290.0 0.8112 0.658 52.0 20.0 4053.0 3312.0 0.8106 0.6624 15.9865750105
53.0 20.0 1645.0 3270.0 0.329 0.654 53.0 20.0 1654.0 3276.0 0.3308 0.6552 7.7876388768
54.0 20.0 3417.0 685.0 0.6834 0.137 54.0 20.0 3397.0 700.0 0.6794 0.14 17.9999663416
55.0 20.0 2063.0 3011.0 0.4126 0.6022 55.0 20.0 2035.0 2993.0 0.407 0.5986 23.965445385
56.0 20.0 831.0 1404.0 0.1662 0.2808 56.0 20.0 815.0 1359.0 0.163 0.2718 34.3870224586
57.0 20.0 3203.0 1794.0 0.6406 0.3588 57.0 20.0 3177.0 1823.0 0.6354 0.3646 28.0428036074
58.0 20.0 4685.0 3503.0 0.937 0.7006 nan nan nan nan nan nan nan
59.0 20.0 1347.0 169.0 0.2694 0.0338 59.0 20.0 1328.0 160.0 0.2656 0.032 15.1371311113
60.0 20.0 1602.0 993.0 0.3204 0.1986 nan nan nan nan nan nan nan
61.0 20.0 4421.0 3306.0 0.8842 0.6612 61.0 20.0 4404.0 3303.0 0.8808 0.6606 12.4283251941
62.0 20.0 1618.0 3085.0 0.3236 0.617 62.0 20.0 1588.0 3091.0 0.3176 0.6182 22.0265338264
63.0 20.0 2493.0 4205.0 0.4986 0.841 63.0 20.0 2488.0 4203.0 0.4976 0.8406 3.87695876877
64.0 20.0 3188.0 1730.0 0.6376 0.346 64.0 20.0 3175.0 1743.0 0.635 0.3486 13.2369173549
65.0 20.0 4553.0 2880.0 0.9106 0.576 nan nan nan nan nan nan nan
66.0 20.0 3567.0 3537.0 0.7134 0.7074 66.0 20.0 3573.0 3536.0 0.7146 0.7072 4.37926433831
67.0 20.0 1689.0 2357.0 0.3378 0.4714 223.0 20.0 1636.0 2335.0 0.3272 0.467 41.3157784393
68.0 20.0 1203.0 1280.0 0.2406 0.256 68.0 20.0 1181.0 1290.0 0.2362 0.258 17.3994411367
69.0 20.0 4278.0 1333.0 0.8556 0.2666 7.0 20.0 4285.0 1328.0 0.857 0.2656 6.19362996133
70.0 20.0 3886.0 4662.0 0.7772 0.9324 nan nan nan nan nan nan nan
71.0 20.0 4699.0 2716.0 0.9398 0.5432 nan nan nan nan nan nan nan
72.0 20.0 4253.0 603.0 0.8506 0.1206 nan nan nan nan nan nan nan
73.0 20.0 2700.0 3837.0 0.54 0.7674 nan nan nan nan nan nan nan
74.0 20.0 54.0 1827.0 0.0108 0.3654 74.0 20.0 35.0 1800.0 0.007 0.36 23.7707488447
75.0 20.0 4098.0 4117.0 0.8196 0.8234 75.0 20.0 4098.0 4114.0 0.8196 0.8228 2.16
76.0 20.0 3302.0 42.0 0.6604 0.0084 76.0 20.0 3291.0 73.0 0.6582 0.0146 23.6835131983
77.0 20.0 1215.0 293.0 0.243 0.0586 77.0 20.0 1206.0 286.0 0.2412 0.0572 8.20926044886
78.0 20.0 1451.0 538.0 0.2902 0.1076 78.0 20.0 1462.0 545.0 0.2924 0.109 9.38763952689
79.0 20.0 3572.0 4746.0 0.7144 0.9492 79.0 20.0 3609.0 4755.0 0.7218 0.951 27.4132243791
80.0 20.0 2989.0 3163.0 0.5978 0.6326 80.0 20.0 2987.0 3164.0 0.5974 0.6328 1.60989041647
81.0 20.0 3928.0 59.0 0.7856 0.0118 81.0 20.0 3938.0 53.0 0.7876 0.0106 8.39657061051
82.0 20.0 1091.0 2845.0 0.2182 0.569 82.0 20.0 1104.0 2837.0 0.2208 0.5674 10.9899310377
83.0 20.0 866.0 722.0 0.1732 0.1444 83.0 20.0 883.0 719.0 0.1766 0.1438 12.4290889592
84.0 20.0 3181.0 3994.0 0.6362 0.7988 84.0 20.0 3170.0 4011.0 0.634 0.8022 14.5784689406
85.0 20.0 2878.0 2008.0 0.5756 0.4016 85.0 20.0 2916.0 1999.0 0.5832 0.3998 28.1162477645
86.0 20.0 4725.0 2735.0 0.945 0.547 86.0 20.0 4727.0 2719.0 0.9454 0.5438 11.6096430657
87.0 20.0 4511.0 2983.0 0.9022 0.5966 87.0 20.0 4536.0 2996.0 0.9072 0.5992 20.2872945197
88.0 20.0 4287.0 598.0 0.8574 0.1196 72.0 20.0 4278.0 587.0 0.8556 0.1174 10.2331139142
89.0 20.0 3353.0 256.0 0.6706 0.0512 89.0 20.0 3333.0 249.0 0.6666 0.0498 15.2565211927
90.0 20.0 654.0 200.0 0.1308 0.04 90.0 20.0 663.0 159.0 0.1326 0.0318 30.2228520071
91.0 20.0 996.0 604.0 0.1992 0.1208 91.0 20.0 1000.0 621.0 0.2 0.1242 12.5742579138
92.0 20.0 4477.0 3271.0 0.8954 0.6542 nan nan nan nan nan nan nan
93.0 20.0 823.0 3807.0 0.1646 0.7614 93.0 20.0 807.0 3840.0 0.1614 0.768 26.4050063731
94.0 20.0 2439.0 934.0 0.4878 0.1868 94.0 20.0 2456.0 914.0 0.4912 0.1828 18.8991016028
95.0 20.0 3817.0 1814.0 0.7634 0.3628 nan nan nan nan nan nan nan
96.0 20.0 732.0 3050.0 0.1464 0.61 96.0 20.0 690.0 3059.0 0.138 0.6118 30.9248127837
97.0 20.0 117.0 4380.0 0.0234 0.876 97.0 20.0 114.0 4366.0 0.0228 0.8732 10.3087784414
98.0 20.0 4878.0 4158.0 0.9756 0.8316 nan nan nan nan nan nan nan
99.0 20.0 3861.0 4366.0 0.7722 0.8732 99.0 20.0 3840.0 4357.0 0.768 0.8714 16.4484593365
100.0 20.0 3576.0 785.0 0.7152 0.157 nan nan nan nan nan nan nan
101.0 20.0 414.0 2254.0 0.0828 0.4508 101.0 20.0 405.0 2245.0 0.081 0.449 9.16396262661
102.0 20.0 3287.0 2682.0 0.6574 0.5364 102.0 20.0 3309.0 2683.0 0.6618 0.5366 15.8556614987
103.0 20.0 324.0 2208.0 0.0648 0.4416 nan nan nan nan nan nan nan
104.0 20.0 2755.0 3516.0 0.551 0.7032 104.0 20.0 2777.0 3497.0 0.5554 0.6994 20.9286982812
105.0 20.0 208.0 3112.0 0.0416 0.6224 nan nan nan nan nan nan nan
106.0 20.0 3668.0 4830.0 0.7336 0.966 106.0 20.0 3661.0 4818.0 0.7322 0.9636 10.002199661
107.0 20.0 2981.0 2208.0 0.5962 0.4416 107.0 20.0 2978.0 2206.0 0.5956 0.4412 2.59594358624
108.0 20.0 1372.0 1635.0 0.2744 0.327 39.0 20.0 1299.0 1510.0 0.2598 0.302 104.223175551
109.0 20.0 2319.0 430.0 0.4638 0.086 109.0 20.0 2314.0 386.0 0.4628 0.0772 31.8838889361
110.0 20.0 4621.0 705.0 0.9242 0.141 110.0 20.0 4605.0 673.0 0.921 0.1346 25.759488198
111.0 20.0 4822.0 643.0 0.9644 0.1286 nan nan nan nan nan nan nan
112.0 20.0 3650.0 4201.0 0.73 0.8402 nan nan nan nan nan nan nan
113.0 20.0 325.0 3662.0 0.065 0.7324 113.0 20.0 343.0 3675.0 0.0686 0.735 15.9857329853
114.0 20.0 1017.0 3710.0 0.2034 0.742 114.0 20.0 1003.0 3733.0 0.2006 0.7466 19.3861511021
115.0 20.0 2556.0 4301.0 0.5112 0.8602 115.0 20.0 2524.0 4278.0 0.5048 0.8556 28.3717499634
116.0 20.0 1501.0 1758.0 0.3002 0.3516 116.0 20.0 1517.0 1787.0 0.3034 0.3574 23.8470065127
117.0 20.0 2206.0 510.0 0.4412 0.102 nan nan nan nan nan nan nan
118.0 20.0 4957.0 257.0 0.9914 0.0514 118.0 20.0 4986.0 265.0 0.9972 0.053 21.6599085432
119.0 20.0 2138.0 294.0 0.4276 0.0588 119.0 20.0 2154.0 276.0 0.4308 0.0552 17.3398924049
120.0 20.0 65.0 586.0 0.013 0.1172 nan nan nan nan nan nan nan
121.0 20.0 1388.0 4010.0 0.2776 0.802 121.0 20.0 1404.0 4004.0 0.2808 0.8008 12.3023102903
122.0 20.0 2559.0 775.0 0.5118 0.155 122.0 20.0 2567.0 812.0 0.5134 0.1624 27.255585582
123.0 20.0 2799.0 1644.0 0.5598 0.3288 123.0 20.0 2810.0 1656.0 0.562 0.3312 11.7206620633
124.0 20.0 4673.0 523.0 0.9346 0.1046 124.0 20.0 4684.0 512.0 0.9368 0.1024 11.2005622764
125.0 20.0 3618.0 1359.0 0.7236 0.2718 125.0 20.0 3626.0 1374.0 0.7252 0.2748 12.2399691632
126.0 20.0 1771.0 1875.0 0.3542 0.375 nan nan nan nan nan nan nan
127.0 20.0 2161.0 4675.0 0.4322 0.935 127.0 20.0 2166.0 4691.0 0.4332 0.9382 12.0692558669
128.0 20.0 1107.0 2490.0 0.2214 0.498 128.0 20.0 1115.0 2484.0 0.223 0.4968 7.19982636259
129.0 20.0 3793.0 875.0 0.7586 0.175 129.0 20.0 3819.0 868.0 0.7638 0.1736 19.3865096623
130.0 20.0 2761.0 2907.0 0.5522 0.5814 130.0 20.0 2768.0 2919.0 0.5536 0.5838 10.0024283907
131.0 20.0 1170.0 4629.0 0.234 0.9258 131.0 20.0 1175.0 4644.0 0.235 0.9288 11.3840504919
132.0 20.0 3245.0 587.0 0.649 0.1174 132.0 20.0 3217.0 581.0 0.6434 0.1162 20.6176213715
133.0 20.0 2243.0 4200.0 0.4486 0.84 133.0 20.0 2224.0 4204.0 0.4448 0.8408 13.9784312619
134.0 20.0 4213.0 250.0 0.8426 0.05 nan nan nan nan nan nan nan
135.0 20.0 4592.0 1811.0 0.9184 0.3622 135.0 20.0 4618.0 1819.0 0.9236 0.3638 19.5857584452
136.0 20.0 2381.0 4912.0 0.4762 0.9824 236.0 20.0 2467.0 4701.0 0.4934 0.9402 164.05088676
137.0 20.0 4640.0 940.0 0.928 0.188 137.0 20.0 4669.0 961.0 0.9338 0.1922 25.7795267703
138.0 20.0 796.0 1911.0 0.1592 0.3822 138.0 20.0 808.0 1908.0 0.1616 0.3816 8.90572195483
139.0 20.0 619.0 2846.0 0.1238 0.5692 29.0 20.0 597.0 2838.0 0.1194 0.5676 16.8540353574
140.0 20.0 2422.0 3455.0 0.4844 0.691 140.0 20.0 2407.0 3443.0 0.4814 0.6886 13.8301371829
141.0 20.0 4641.0 678.0 0.9282 0.1356 nan nan nan nan nan nan nan
142.0 20.0 2507.0 2832.0 0.5014 0.5664 142.0 20.0 2500.0 2815.0 0.5 0.563 13.2369457431
143.0 20.0 4179.0 350.0 0.8358 0.07 143.0 20.0 4169.0 356.0 0.8338 0.0712 8.39656604144
144.0 20.0 1145.0 4241.0 0.229 0.8482 144.0 20.0 1134.0 4234.0 0.2268 0.8468 9.38692052153
145.0 20.0 400.0 3822.0 0.08 0.7644 145.0 20.0 389.0 3815.0 0.0778 0.763 9.38705792094
146.0 20.0 3573.0 2845.0 0.7146 0.569 nan nan nan nan nan nan nan
147.0 20.0 3766.0 2850.0 0.7532 0.57 nan nan nan nan nan nan nan
148.0 20.0 3540.0 4796.0 0.708 0.9592 nan nan nan nan nan nan nan
149.0 20.0 2942.0 2069.0 0.5884 0.4138 149.0 20.0 2913.0 2054.0 0.5826 0.4108 23.5072717373
150.0 20.0 2016.0 951.0 0.4032 0.1902 212.0 20.0 2030.0 1141.0 0.406 0.2282 137.17086076
151.0 20.0 1294.0 1758.0 0.2588 0.3516 151.0 20.0 1327.0 1776.0 0.2654 0.3552 27.0643256472
152.0 20.0 1873.0 1920.0 0.3746 0.384 nan nan nan nan nan nan nan
153.0 20.0 611.0 4016.0 0.1222 0.8032 153.0 20.0 594.0 4020.0 0.1188 0.804 12.5730875586
154.0 20.0 3542.0 2192.0 0.7084 0.4384 154.0 20.0 3565.0 2222.0 0.713 0.4444 27.2172247732
155.0 20.0 2363.0 28.0 0.4726 0.0056 20.0 20.0 2266.0 7.0 0.4532 0.0014 71.457959526
156.0 20.0 4695.0 2311.0 0.939 0.4622 156.0 20.0 4673.0 2300.0 0.9346 0.46 17.7091995936
157.0 20.0 2036.0 1496.0 0.4072 0.2992 157.0 20.0 2012.0 1482.0 0.4024 0.2964 20.0049177302
158.0 20.0 4542.0 618.0 0.9084 0.1236 158.0 20.0 4541.0 629.0 0.9082 0.1258 7.95265977798
159.0 20.0 1780.0 4048.0 0.356 0.8096 159.0 20.0 1770.0 4072.0 0.354 0.8144 18.719721919
160.0 20.0 3563.0 2414.0 0.7126 0.4828 nan nan nan nan nan nan nan
161.0 20.0 3919.0 2400.0 0.7838 0.48 161.0 20.0 3889.0 2394.0 0.7778 0.4788 22.0270228941
162.0 20.0 489.0 4163.0 0.0978 0.8326 162.0 20.0 514.0 4134.0 0.1028 0.8268 27.5664009604
163.0 20.0 2551.0 3729.0 0.5102 0.7458 163.0 20.0 2540.0 3751.0 0.508 0.7502 17.7093565615
164.0 20.0 1114.0 3456.0 0.2228 0.6912 164.0 20.0 1103.0 3468.0 0.2206 0.6936 11.72036006
165.0 20.0 1125.0 2406.0 0.225 0.4812 nan nan nan nan nan nan nan
166.0 20.0 3948.0 112.0 0.7896 0.0224 nan nan nan nan nan nan nan
167.0 20.0 55.0 2358.0 0.011 0.4716 167.0 20.0 54.0 2365.0 0.0108 0.473 5.09116536516
168.0 20.0 2721.0 1215.0 0.5442 0.243 nan nan nan nan nan nan nan
169.0 20.0 1850.0 2189.0 0.37 0.4378 169.0 20.0 1875.0 2189.0 0.375 0.4378 17.9994745315
170.0 20.0 4533.0 2878.0 0.9066 0.5756 nan nan nan nan nan nan nan
171.0 20.0 2310.0 4506.0 0.462 0.9012 171.0 20.0 2288.0 4529.0 0.4576 0.9058 22.9145546349
172.0 20.0 1533.0 342.0 0.3066 0.0684 172.0 20.0 1552.0 313.0 0.3104 0.0626 24.9623026836
173.0 20.0 372.0 3947.0 0.0744 0.7894 173.0 20.0 403.0 3956.0 0.0806 0.7912 23.2395788194
174.0 20.0 4581.0 3040.0 0.9162 0.608 174.0 20.0 4582.0 3059.0 0.9164 0.6118 13.6989321212
175.0 20.0 2424.0 981.0 0.4848 0.1962 175.0 20.0 2412.0 954.0 0.4824 0.1908 21.2735128394
176.0 20.0 1940.0 2161.0 0.388 0.4322 176.0 20.0 1938.0 2161.0 0.3876 0.4322 1.43995903106
177.0 20.0 4047.0 4274.0 0.8094 0.8548 177.0 20.0 4034.0 4261.0 0.8068 0.8522 13.2363046449
178.0 20.0 4079.0 3003.0 0.8158 0.6006 178.0 20.0 4061.0 2986.0 0.8122 0.5972 17.8258477791
179.0 20.0 1457.0 1398.0 0.2914 0.2796 179.0 20.0 1464.0 1404.0 0.2928 0.2808 6.63802625001
180.0 20.0 2454.0 1301.0 0.4908 0.2602 180.0 20.0 2438.0 1325.0 0.4876 0.265 20.7679082293
181.0 20.0 2025.0 441.0 0.405 0.0882 nan nan nan nan nan nan nan
182.0 20.0 576.0 1848.0 0.1152 0.3696 182.0 20.0 591.0 1865.0 0.1182 0.373 16.3233789902
183.0 20.0 1098.0 639.0 0.2196 0.1278 183.0 20.0 1114.0 649.0 0.2228 0.1298 13.5849081463
184.0 20.0 666.0 851.0 0.1332 0.1702 184.0 20.0 677.0 837.0 0.1354 0.1674 12.8192143109
185.0 20.0 3921.0 3430.0 0.7842 0.686 nan nan nan nan nan nan nan
186.0 20.0 1980.0 2314.0 0.396 0.4628 nan nan nan nan nan nan nan
187.0 20.0 1117.0 1189.0 0.2234 0.2378 187.0 20.0 1094.0 1193.0 0.2188 0.2386 16.80842825
188.0 20.0 3632.0 453.0 0.7264 0.0906 188.0 20.0 3601.0 464.0 0.7202 0.0928 23.6834863111
189.0 20.0 1953.0 1961.0 0.3906 0.3922 189.0 20.0 1947.0 1968.0 0.3894 0.3936 6.63800590793
190.0 20.0 1106.0 4712.0 0.2212 0.9424 190.0 20.0 1087.0 4698.0 0.2174 0.9396 16.9911249196
191.0 20.0 3059.0 4372.0 0.6118 0.8744 191.0 20.0 3060.0 4366.0 0.612 0.8732 4.37957525772
192.0 20.0 2436.0 1004.0 0.4872 0.2008 192.0 20.0 2407.0 1021.0 0.4814 0.2042 24.2030277867
193.0 20.0 3405.0 1392.0 0.681 0.2784 193.0 20.0 3407.0 1379.0 0.6814 0.2758 9.47011887459
194.0 20.0 3233.0 1306.0 0.6466 0.2612 nan nan nan nan nan nan nan
195.0 20.0 2030.0 3562.0 0.406 0.7124 nan nan nan nan nan nan nan
196.0 20.0 3681.0 4778.0 0.7362 0.9556 196.0 20.0 3661.0 4794.0 0.7322 0.9588 18.4394287091
197.0 20.0 199.0 4064.0 0.0398 0.8128 197.0 20.0 198.0 4042.0 0.0396 0.8084 15.8563519211
198.0 20.0 789.0 3739.0 0.1578 0.7478 198.0 20.0 771.0 3754.0 0.1542 0.7508 16.8692879378
199.0 20.0 1003.0 4208.0 0.2006 0.8416 199.0 20.0 1000.0 4191.0 0.2 0.8382 12.4290867522
200.0 20.0 1479.0 897.0 0.2958 0.1794 200.0 20.0 1492.0 909.0 0.2984 0.1818 12.7380661619
201.0 20.0 2117.0 2961.0 0.4234 0.5922 201.0 20.0 2110.0 2978.0 0.422 0.5956 13.2369358556
202.0 20.0 110.0 3821.0 0.022 0.7642 202.0 20.0 125.0 3839.0 0.025 0.7678 16.8695214344
203.0 20.0 1565.0 3378.0 0.313 0.6756 203.0 20.0 1548.0 3375.0 0.3096 0.675 12.42828987
204.0 20.0 4849.0 3886.0 0.9698 0.7772 204.0 20.0 4855.0 3907.0 0.971 0.7814 15.7249275903
205.0 20.0 1176.0 3236.0 0.2352 0.6472 248.0 20.0 1189.0 3234.0 0.2378 0.6468 9.4695316085
206.0 20.0 3298.0 883.0 0.6596 0.1766 nan nan nan nan nan nan nan
207.0 20.0 2639.0 3126.0 0.5278 0.6252 239.0 20.0 2617.0 3206.0 0.5234 0.6412 59.7380528266
208.0 20.0 2508.0 2172.0 0.5016 0.4344 nan nan nan nan nan nan nan
209.0 20.0 2878.0 3540.0 0.5756 0.708 48.0 20.0 2864.0 3474.0 0.5728 0.6948 48.5771713211
210.0 20.0 3774.0 2042.0 0.7548 0.4084 100.0 20.0 3903.0 2055.0 0.7806 0.411 93.3480739603
211.0 20.0 378.0 3553.0 0.0756 0.7106 211.0 20.0 410.0 3585.0 0.082 0.717 32.5822162236
212.0 20.0 4398.0 4325.0 0.8796 0.865 nan nan nan nan nan nan nan
213.0 20.0 1454.0 509.0 0.2908 0.1018 nan nan nan nan nan nan nan
214.0 20.0 1330.0 4872.0 0.266 0.9744 214.0 20.0 1304.0 4893.0 0.2608 0.9786 24.0614010053
215.0 20.0 1950.0 964.0 0.39 0.1928 nan nan nan nan nan nan nan
216.0 20.0 1704.0 1355.0 0.3408 0.271 216.0 20.0 1687.0 1358.0 0.3374 0.2716 12.428991953
217.0 20.0 2108.0 4928.0 0.4216 0.9856 217.0 20.0 2081.0 4936.0 0.4162 0.9872 20.2726219794
218.0 20.0 791.0 391.0 0.1582 0.0782 218.0 20.0 777.0 395.0 0.1554 0.079 10.4833491206
219.0 20.0 1736.0 4797.0 0.3472 0.9594 219.0 20.0 1768.0 4808.0 0.3536 0.9616 24.3601895025
220.0 20.0 1476.0 2167.0 0.2952 0.4334 nan nan nan nan nan nan nan
221.0 20.0 1622.0 3329.0 0.3244 0.6658 221.0 20.0 1635.0 3330.0 0.327 0.666 9.38702118493
222.0 20.0 3997.0 3802.0 0.7994 0.7604 222.0 20.0 4014.0 3808.0 0.8028 0.7616 12.9789665295
223.0 20.0 1870.0 2413.0 0.374 0.4826 112.0 20.0 1859.0 2602.0 0.3718 0.5204 136.310263708
224.0 20.0 1132.0 3781.0 0.2264 0.7562 224.0 20.0 1142.0 3764.0 0.2284 0.7528 14.2003031992
225.0 20.0 442.0 3840.0 0.0884 0.768 225.0 20.0 432.0 3836.0 0.0864 0.7672 7.75403740823
226.0 20.0 4699.0 1698.0 0.9398 0.3396 nan nan nan nan nan nan nan
227.0 20.0 4931.0 2338.0 0.9862 0.4676 227.0 20.0 4957.0 2323.0 0.9914 0.4646 21.6114601348
228.0 20.0 4137.0 995.0 0.8274 0.199 228.0 20.0 4132.0 1033.0 0.8264 0.2066 27.5958228291
229.0 20.0 661.0 4381.0 0.1322 0.8762 229.0 20.0 703.0 4382.0 0.1406 0.8764 30.2450344718
230.0 20.0 2035.0 698.0 0.407 0.1396 nan nan nan nan nan nan nan
231.0 20.0 3022.0 3629.0 0.6044 0.7258 231.0 20.0 3062.0 3606.0 0.6124 0.7212 33.2195928656
232.0 20.0 380.0 2952.0 0.076 0.5904 232.0 20.0 375.0 2945.0 0.075 0.589 6.19356336863
233.0 20.0 3900.0 3634.0 0.78 0.7268 233.0 20.0 3888.0 3583.0 0.7776 0.7166 37.7226212836
234.0 20.0 717.0 184.0 0.1434 0.0368 nan nan nan nan nan nan nan
235.0 20.0 937.0 200.0 0.1874 0.04 235.0 20.0 917.0 207.0 0.1834 0.0414 15.2565230428
236.0 20.0 485.0 2092.0 0.097 0.4184 nan nan nan nan nan nan nan
237.0 20.0 3731.0 4081.0 0.7462 0.8162 237.0 20.0 3736.0 4059.0 0.7472 0.8118 16.2438598968
238.0 20.0 4751.0 1065.0 0.9502 0.213 238.0 20.0 4750.0 1060.0 0.95 0.212 3.67129307863
239.0 20.0 3153.0 2994.0 0.6306 0.5988 nan nan nan nan nan nan nan
240.0 20.0 3412.0 2583.0 0.6824 0.5166 240.0 20.0 3392.0 2592.0 0.6784 0.5184 15.7902971579
241.0 20.0 3407.0 4770.0 0.6814 0.954 nan nan nan nan nan nan nan
242.0 20.0 4708.0 1782.0 0.9416 0.3564 242.0 20.0 4733.0 1799.0 0.9466 0.3598 21.7670609804
243.0 20.0 268.0 3230.0 0.0536 0.646 243.0 20.0 264.0 3241.0 0.0528 0.6482 8.42732116699
244.0 20.0 578.0 139.0 0.1156 0.0278 244.0 20.0 557.0 135.0 0.1114 0.027 15.3918402965
245.0 20.0 3026.0 3256.0 0.6052 0.6512 245.0 20.0 3048.0 3294.0 0.6096 0.6588 31.6139591097
246.0 20.0 2969.0 1822.0 0.5938 0.3644 246.0 20.0 2965.0 1851.0 0.593 0.3702 21.0776767964
247.0 20.0 1533.0 4186.0 0.3066 0.8372 247.0 20.0 1528.0 4203.0 0.3056 0.8406 12.7583236316
248.0 20.0 1217.0 3259.0 0.2434 0.6518 nan nan nan nan nan nan nan
249.0 20.0 622.0 876.0 0.1244 0.1752 249.0 20.0 630.0 909.0 0.126 0.1818 24.4482080724
250.0 20.0 334.0 2979.0 0.0668 0.5958 250.0 20.0 332.0 2961.0 0.0664 0.5922 13.0397460534
In [ ]:
Content source: chbrandt/pynotes
Similar notebooks: