rough work and querying


In [1]:
import pymongo
from pymongo import MongoClient
mongo_url = 'mongodb://localhost:27017/'
db = 'CamSim'
coll_in = 'CamHarvest'
coll_out = 'CamAuthors'
client = MongoClient(mongo_url)
ch = client[db][coll_in]
ca = client[db][coll_out]

In [65]:
ca.find_one()
ca.create_index([('name',pymongo.TEXT)],default_language='english')
ch.create_index([('title',pymongo.TEXT)],default_language='english')


Out[65]:
u'title_text'

In [69]:
nam = 'dynamic'
cursor = client[db].command('text','CamAuthors',search=nam)
cursor = client[db].command('text','CamHarvest',search=nam)

In [2]:
'''for rec in cursor['results']:
    print(rec['obj']['title'])
'''


Out[2]:
"for rec in cursor['results']:\n    print(rec['obj']['title'])\n"

In [3]:
'''curs = ca.find()
for rec in curs:
    print(rec['name'])
'''


Out[3]:
"curs = ca.find()\nfor rec in curs:\n    print(rec['name'])\n"

In [32]:
cursor = ca.find({'sims':{'$exists':1}},no_cursor_timeout=True)
i = 0
for rec in cursor:
    print(rec['name'] + ' ' +str(i))
    i+=1


lc smeeton 0
lk chan 1
ap ivanov 2
h-f chow 3
t rovis 4
g filippini 5
e esposito 6
y chebaro 7
ka thomas 8
r mezzenga 9
e ertekin 10
aj liu 11
ic mangialavori 12
tv o'halloran 13
n shivananju 14
ap johnson 15
va makarov 16
f kawasaki 17
gt heller 18
i landrieu 19
aj mcconnell 20
e bouvier 21
a nekrutenko 22
s gérard 23
a oliynyk 24
kh sutherland-casha 25
r gajić 26
lh thamdrup 27
ra stockman 28
sj fernstad 29
aj kooistra 30
n cohrs 31
sb lou 32
em llamas 33
d montes-grajales 34
yk motamedi 35
m peymani 36
mh nasr-esfahani 37
c combadière 38
r barton 39
c huynen 40
n willet 41
q lu 42
hg hiscock 43
xd liu 44
nm wilf 45
f kundel 46
pms cunha 47
z rong 48
v andré 49
j negele 50
ac brańka 51
s ball 52
lc andreani 53
jl sussman 54
ce atkinson 55
p deoliveira 56
jg kircz 57
y kong 58
c rovira 59
p bernadó 60
h clausen 61
a lostao 62
p nogueira 63
j freitas 64
g lacroix 65
a moreira 66
jp rossi 67
p braeuninger-weimer 68
z cournia 69
tw allen 70
i andricioaei 71
b antonny 72
d baum 73
g brannigan 74
jt deckman 75
l delemotte 76
c del val 77
r friedman 78
p gkeka 79
hc hege 80
j hénin 81
ma kasimova 82
a kolocouris 83
mj lemieux 84
n lindow 85
m roy 86
j selent 87
m tarek 88
f tofoleanu 89
s vanni 90
s urban 91
jc smith 92
an bondar 93
ys yu 94
c kim 95
da shapiro 96
m farmand 97
t tyliszczak 98
al kilcoyne 99
r celestre 100
s marchesini 101
j joseph 102
p denes 103
t warwick 104
h padmore 105
s castillón 106
i sovago 107
r pini 108
j castro-lõpez 109
i compañõn 110
m salvadõ 111
rc walsh 112
tds young 113
t cao 114
c chen 115
h jia 116
x zhou 117
c calero 118
j martí 119
a sinha 120
pr preiser 121
r chandramohanadas 122
ia boutle 123
ob riabova 124
dm walther 125
p kasturi 126
m zheng 127
g vecchi 128
m mann 129
re hardisty 130
hm walker 131
a colette 132
e-r janeček 133
ns gandhi 134
ljc jeuken 135
m charnley 136
a renzetti 137
a di crescenzo 138
j sapi 139
c villani 140
j medley-hallam 141
fr manby 142
pp upadhyay 143
me briggs 144
ag slater 145
jj velasco-velez 146
v pfeifer 147
r arrigo 148
p biswas 149
j ma 150
wn zhao 151
sd kloss 152
e meneguz 153
pj butterworth 154
wd blaylock 155
se dutton 156
n nikolovski 157
dm lienhard 158
c teichert 159
l brégonzio-rozier 160
js bett 161
ms ritorto 162
r ewan 163
eg jaffray 164
a knebel 165
t kurz 166
m trost 167
mh tatham 168
rt hay 169
wa vigor 170
t nielsen 171
ma parniak 172
a szumska 173
wa vitale 174
hr maier 175
u schlink 176
y luo 177
b brennan 178
m ouyang 179
aj johnston 180
mc chen 181
j zhu 182
s kanemura 183
p jenö 184
t teşileanu 185
s leibler 186
r labes 187
f palazzesi 188
mi walker 189
naw bell 190
jk harada 191
pj nowack 192
gs rauber 193
s de vito 194
p delli veneri 195
m salvato 196
m yagi-utsumi 197
hk fung 198
mco figueiredo 199
a matsuoka 200
t isogawa 201
y morioka 202
ma shehata 203
el hogg 204
bcm martindale 205
ge folkers 206
m kaplan 207
ea van der cruijsen 208
j dworzak 209
m beltrandi 210
s bolisetty 211
t korcsmaros 212
k roberts 213
a fernández-tejada 214
bg de la torre 215
j heer 216
o kennedy 217
g henkelman 218
as duwez 219
a šarić 220
jb wagner 221
t ouchi 222
r kostecki 223
bc hong 224
s illingworth 225
dm dias 226
h wienk 227
s patil 228
m huntley 229
ar langley 230
dkh ho 231
p thiruvenkatanathan 232
jc kim 233
cj moore 234
je ladbury 235
y furukawa 236
n begum 237
a luque 238
c hussal 239
g stephenson 240
e abad 241
a samal 242
av uversky 243
l baker 244
a martínez 245
b list 246
s judge 247
l towers 248
b falcone 249
a klöckner 250
m karesoja 251
l guan 252
g dietler 253
p imhof 254
s selvaraj 255
pm cal 256
j seitsonen 257
z-k tan 258
rr teixeira 259
a salomone 260
v ivaništšev 261
l oriol 262
d gharbharan 263
lt law 264
d capsoni 265

In [92]:
cursor = ca.find({'sims':{'$exists':1}},no_cursor_timeout=True)
#be = np.arange(-1,1.01,0.01)
#hist_ac = np.zeros(200)
be = np.arange(-1,1.1,0.1)
hist_ac = np.zeros(20)
ind = 0
for rec in cursor:
    name = rec['name']
    sims = rec['sims'][:]
    for s in rec['sims']:
        if s.keys()[0]==name:
            sims.remove(s)
    float_sims = [si.values()[0] for si in sims]
    hist,be = np.histogram(float_sims, bins=be)
    hist_ac+=hist
    ind+=1
    print(str(ind) + ' completed')
bc = []
for i in range(len(be)-1):
        bc.append((be[i]+be[i+1])/2)
plt.plot(bc,hist_ac)
plt.show()


1 completed
2 completed
3 completed
4 completed
5 completed
6 completed
7 completed
8 completed
9 completed
10 completed
11 completed
12 completed
13 completed
14 completed
15 completed
16 completed
17 completed
18 completed
19 completed
20 completed
21 completed
22 completed
23 completed
24 completed
25 completed
26 completed
27 completed
28 completed
29 completed
30 completed
31 completed
32 completed
33 completed
34 completed
35 completed
36 completed
37 completed
38 completed
39 completed
40 completed
41 completed
42 completed
43 completed
44 completed
45 completed
46 completed
47 completed
48 completed
49 completed
50 completed
51 completed
52 completed
53 completed
54 completed
55 completed
56 completed
57 completed
58 completed
59 completed
60 completed
61 completed
62 completed
63 completed
64 completed
65 completed
66 completed
67 completed
68 completed
69 completed
70 completed
71 completed
72 completed
73 completed
74 completed
75 completed
76 completed
77 completed
78 completed
79 completed
80 completed
81 completed
82 completed
83 completed
84 completed
85 completed
86 completed
87 completed
88 completed
89 completed
90 completed
91 completed
92 completed
93 completed
94 completed
95 completed
96 completed
97 completed
98 completed
99 completed
100 completed
101 completed
102 completed
103 completed
104 completed
105 completed
106 completed
107 completed
108 completed
109 completed
110 completed
111 completed
112 completed
113 completed
114 completed
115 completed
116 completed
117 completed
118 completed
119 completed
120 completed
121 completed
122 completed
123 completed
124 completed
125 completed
126 completed
127 completed
128 completed
129 completed
130 completed
131 completed
132 completed
133 completed
134 completed
135 completed
136 completed
137 completed
138 completed
139 completed
140 completed
141 completed
142 completed
143 completed
144 completed
145 completed
146 completed
147 completed
148 completed
149 completed
150 completed
151 completed
152 completed
153 completed
154 completed
155 completed
156 completed
157 completed
158 completed
159 completed
160 completed
161 completed
162 completed
163 completed
164 completed
165 completed
166 completed
167 completed
168 completed
169 completed
170 completed
171 completed
172 completed
173 completed
174 completed
175 completed
176 completed
177 completed
178 completed
179 completed
180 completed
181 completed
182 completed
183 completed
184 completed
185 completed
186 completed
187 completed
188 completed
189 completed
190 completed
191 completed
192 completed
193 completed
194 completed
195 completed
196 completed
197 completed
198 completed
199 completed
200 completed
201 completed
202 completed
203 completed
204 completed
205 completed
206 completed
207 completed
208 completed
209 completed
210 completed
211 completed
212 completed
213 completed
214 completed
215 completed
216 completed
217 completed
218 completed
219 completed
220 completed
221 completed
222 completed
223 completed
224 completed
225 completed
226 completed
227 completed
228 completed
229 completed
230 completed
231 completed
232 completed
233 completed
234 completed
235 completed
236 completed
237 completed
238 completed
239 completed
240 completed
241 completed
242 completed
243 completed
244 completed
245 completed
246 completed
247 completed
248 completed
249 completed
250 completed
251 completed
252 completed
253 completed
254 completed
255 completed
256 completed
257 completed
258 completed
259 completed
260 completed
261 completed
262 completed
263 completed
264 completed
265 completed
266 completed
267 completed
268 completed
269 completed
270 completed
271 completed
272 completed
273 completed
274 completed
275 completed
276 completed
277 completed
278 completed
279 completed
280 completed
281 completed
282 completed
283 completed
284 completed
285 completed
286 completed
287 completed
288 completed
289 completed
290 completed
291 completed
292 completed
293 completed
294 completed
295 completed
296 completed
297 completed
298 completed
299 completed
300 completed
301 completed
302 completed
303 completed
304 completed
305 completed
306 completed
307 completed
308 completed
309 completed
310 completed
311 completed
312 completed
313 completed
314 completed
315 completed
316 completed
317 completed
318 completed
319 completed
320 completed
321 completed
322 completed
323 completed
324 completed
325 completed
326 completed
327 completed
328 completed
329 completed
330 completed
331 completed
332 completed
333 completed
334 completed
335 completed
336 completed
337 completed
338 completed
339 completed
340 completed
341 completed
342 completed
343 completed
344 completed
345 completed
346 completed
347 completed
348 completed
349 completed
350 completed
351 completed
352 completed
353 completed
354 completed
355 completed
356 completed
357 completed
358 completed
359 completed
360 completed
361 completed
362 completed
363 completed
364 completed
365 completed
366 completed
367 completed
368 completed
369 completed
370 completed
371 completed
372 completed
373 completed
374 completed
375 completed
376 completed
377 completed
378 completed
379 completed
380 completed
381 completed
382 completed
383 completed
384 completed
385 completed
386 completed
387 completed
388 completed
389 completed
390 completed
391 completed
392 completed
393 completed
394 completed
395 completed
396 completed
397 completed
398 completed
399 completed
400 completed
401 completed
402 completed
403 completed
404 completed
405 completed
406 completed
407 completed
408 completed
409 completed
410 completed
411 completed
412 completed
413 completed
414 completed
415 completed
416 completed
417 completed
418 completed
419 completed
420 completed
421 completed
422 completed
423 completed
424 completed
425 completed
426 completed
427 completed
428 completed
429 completed
430 completed
431 completed
432 completed
433 completed
434 completed
435 completed
436 completed
437 completed
438 completed
439 completed
440 completed
441 completed
442 completed
443 completed
444 completed
445 completed
446 completed
447 completed
448 completed
449 completed
450 completed
451 completed
452 completed
453 completed
454 completed
455 completed
456 completed
457 completed
458 completed
459 completed
460 completed
461 completed
462 completed
463 completed
464 completed
465 completed
466 completed
467 completed
468 completed
469 completed
470 completed
471 completed
472 completed
473 completed
474 completed
475 completed
476 completed
477 completed
478 completed
479 completed
480 completed
481 completed
482 completed
483 completed
484 completed
485 completed
486 completed
487 completed
488 completed
489 completed
490 completed
491 completed
492 completed
493 completed
494 completed
495 completed
496 completed
497 completed
498 completed
499 completed
500 completed
501 completed
502 completed
503 completed
504 completed
505 completed
506 completed
507 completed
508 completed
509 completed
510 completed
511 completed
512 completed
513 completed
514 completed
515 completed
516 completed
517 completed
518 completed
519 completed
520 completed
521 completed
522 completed
523 completed
524 completed
525 completed
526 completed
527 completed
528 completed
529 completed
530 completed
531 completed
532 completed
533 completed
534 completed
535 completed
536 completed
537 completed
538 completed
539 completed
540 completed
541 completed
542 completed
543 completed
544 completed
545 completed
546 completed
547 completed
548 completed
549 completed
550 completed
551 completed
552 completed
553 completed
554 completed
555 completed
556 completed
557 completed
558 completed
559 completed
560 completed
561 completed
562 completed
563 completed
564 completed
565 completed
566 completed
567 completed
568 completed
569 completed
570 completed
571 completed
572 completed
573 completed
574 completed
575 completed
576 completed
577 completed
578 completed
579 completed
580 completed
581 completed
582 completed
583 completed
584 completed
585 completed
586 completed
587 completed
588 completed
589 completed
590 completed
591 completed
592 completed
593 completed
594 completed
595 completed
596 completed
597 completed
598 completed
599 completed
600 completed
601 completed
602 completed
603 completed
604 completed
605 completed
606 completed
607 completed
608 completed
609 completed
610 completed
611 completed
612 completed
613 completed
614 completed
615 completed
616 completed
617 completed
618 completed
619 completed
620 completed
621 completed
622 completed
623 completed
624 completed
625 completed
626 completed
627 completed
628 completed
629 completed
630 completed
631 completed
632 completed
633 completed
634 completed
635 completed
636 completed
637 completed
638 completed
639 completed
640 completed
641 completed
642 completed
643 completed
644 completed
645 completed
646 completed
647 completed
648 completed
649 completed
650 completed
651 completed
652 completed
653 completed
654 completed
655 completed
656 completed
657 completed
658 completed
659 completed
660 completed
661 completed
662 completed
663 completed
664 completed
665 completed
666 completed
667 completed
668 completed
669 completed
670 completed
671 completed
672 completed
673 completed
674 completed
675 completed
676 completed
677 completed
678 completed
679 completed
680 completed
681 completed
682 completed
683 completed
684 completed
685 completed
686 completed
687 completed
688 completed
689 completed
690 completed
691 completed
692 completed
693 completed
694 completed
695 completed
696 completed
697 completed
698 completed
699 completed
700 completed
701 completed
702 completed
703 completed
704 completed
705 completed
706 completed
707 completed
708 completed
709 completed
710 completed
711 completed
712 completed
713 completed
714 completed
715 completed
716 completed
717 completed
718 completed
719 completed
720 completed
721 completed
722 completed
723 completed
724 completed
725 completed
726 completed
727 completed
728 completed
729 completed
730 completed
731 completed
732 completed
733 completed
734 completed
735 completed
736 completed
737 completed
738 completed
739 completed
740 completed
741 completed
742 completed
743 completed
744 completed
745 completed
746 completed
747 completed
748 completed
749 completed
750 completed
751 completed
752 completed
753 completed
754 completed
755 completed
756 completed
757 completed
758 completed
759 completed
760 completed
761 completed
762 completed
763 completed
764 completed
765 completed
766 completed
767 completed
768 completed
769 completed
770 completed
771 completed
772 completed
773 completed
774 completed
775 completed
776 completed
777 completed
778 completed
779 completed
780 completed
781 completed
782 completed
783 completed
784 completed
785 completed
786 completed
787 completed
788 completed
789 completed
790 completed
791 completed
792 completed
793 completed
794 completed
795 completed
796 completed
797 completed
798 completed
799 completed
800 completed
801 completed
802 completed
803 completed
804 completed
805 completed
806 completed
807 completed
808 completed
809 completed
810 completed
811 completed
812 completed
813 completed
814 completed
815 completed
816 completed
817 completed
818 completed
819 completed
820 completed
821 completed
822 completed
823 completed
824 completed
825 completed
826 completed
827 completed
828 completed
829 completed
830 completed
831 completed
832 completed
833 completed
834 completed
835 completed
836 completed
837 completed
838 completed
839 completed
840 completed
841 completed
842 completed
843 completed
844 completed
845 completed
846 completed
847 completed
848 completed
849 completed
850 completed
851 completed
852 completed
853 completed
854 completed
855 completed
856 completed
857 completed
858 completed
859 completed
860 completed
861 completed
862 completed
863 completed
864 completed
865 completed
866 completed
867 completed
868 completed
869 completed
870 completed
871 completed
872 completed
873 completed
874 completed
875 completed
876 completed
877 completed
878 completed
879 completed
880 completed
881 completed
882 completed
883 completed
884 completed
885 completed
886 completed
887 completed
888 completed
889 completed
890 completed
891 completed
892 completed
893 completed
894 completed
895 completed
896 completed
897 completed
898 completed
899 completed
900 completed
901 completed
902 completed
903 completed
904 completed
905 completed
906 completed
907 completed
908 completed
909 completed
910 completed
911 completed
912 completed
913 completed
914 completed
915 completed
916 completed
917 completed
918 completed
919 completed
920 completed
921 completed
922 completed
923 completed
924 completed
925 completed
926 completed
927 completed
928 completed
929 completed
930 completed
931 completed
932 completed
933 completed
934 completed
935 completed
936 completed
937 completed
938 completed
939 completed
940 completed
941 completed
942 completed
943 completed
944 completed
945 completed
946 completed
947 completed
948 completed
949 completed
950 completed
951 completed
952 completed
953 completed
954 completed
955 completed
956 completed
957 completed
958 completed
959 completed
960 completed
961 completed
962 completed
963 completed
964 completed
965 completed
966 completed
967 completed
968 completed
969 completed
970 completed
971 completed
972 completed
973 completed
974 completed
975 completed
976 completed
977 completed
978 completed
979 completed

In [59]:
import numpy as np
import matplotlib.pyplot as plt
bins = 200
hist,be = np.histogram(float_sims, bins=bins)
print(hist)
plt.plot(bc,hist)
plt.show()


[  4   0   0   0   0   0   0   0   0   0   0   2   3   0   2   0   0   1
   0   0   0   1   3   0   3   0   1   1   0   0  12   0   0  63   0   1
   0   2   0   0   0   0   0   1  17   0   0   4   6   4   9   7  29  22
  28  23  34  59  39  49  63  63 100  93  83  78 102  84  72 100  79  63
  93  74  45  71 522  85  86  71 105 101  93  98  94  78  77 100  96  60
 100  72  73  88  75 139  91  92 108  83  77 101  87  97  87 139 110 107
  98 162 106  97 111 117 126 105 138 122 126 231 157 134 194 169 164 175
 142 142 119 139 165 161 181 156 168 205 157 157 167 153 164 154 200 193
 210 270 198 210 215 220 197 165 190 174 178 321 215 233 259 434 195 285
 229 232 302 275 239 240 246 282 256 261 291 296 341 298 270 267 274 274
 234 266 212 246 189 166 124 127 122  94  63  51  27  14  15   7   5   1
   2   4]

In [58]:
bc = []
for i in range(len(be)-1):
        bc.append((be[i]+be[i+1])/2)

In [89]:
bc = []
for i in range(len(be)-1):
        bc.append((be[i]+be[i+1])/2)
plt.plot(bc,hist_ac)
plt.show()

In [90]:
hist_ac


Out[90]:
array([  0.00000000e+00,   0.00000000e+00,   0.00000000e+00,
         0.00000000e+00,   2.00000000e+00,   2.00000000e+00,
         8.00000000e+00,   2.00000000e+01,   2.30000000e+01,
         4.00000000e+01,   4.40000000e+01,   7.40000000e+01,
         1.15000000e+02,   1.15000000e+02,   2.02000000e+02,
         2.11000000e+02,   3.03000000e+02,   3.75000000e+02,
         4.06000000e+02,   5.01000000e+02,   9.55000000e+02,
         7.72000000e+02,   1.07900000e+03,   1.49600000e+03,
         1.49000000e+03,   2.09000000e+03,   2.42400000e+03,
         3.74500000e+03,   4.30100000e+03,   5.19900000e+03,
         5.78600000e+03,   7.84700000e+03,   9.20700000e+03,
         1.09750000e+04,   1.15800000e+04,   1.40270000e+04,
         1.60310000e+04,   1.78510000e+04,   2.05030000e+04,
         2.24030000e+04,   2.38810000e+04,   2.80760000e+04,
         3.06100000e+04,   3.16830000e+04,   3.32470000e+04,
         3.54650000e+04,   3.69270000e+04,   3.60900000e+04,
         3.69160000e+04,   3.92520000e+04,   4.06440000e+04,
         4.09700000e+04,   4.20300000e+04,   4.47540000e+04,
         4.50200000e+04,   4.57400000e+04,   4.63050000e+04,
         4.83510000e+04,   4.89270000e+04,   4.93230000e+04,
         5.15830000e+04,   5.15660000e+04,   5.64750000e+04,
         5.28090000e+04,   5.51650000e+04,   5.75620000e+04,
         6.08190000e+04,   5.75390000e+04,   6.22030000e+04,
         5.87710000e+04,   6.25720000e+04,   6.42370000e+04,
         6.30010000e+04,   6.99250000e+04,   6.55500000e+04,
         7.05670000e+04,   6.76280000e+04,   6.99720000e+04,
         7.17520000e+04,   7.46450000e+04,   7.71470000e+04,
         7.26860000e+04,   8.01400000e+04,   8.40170000e+04,
         9.02200000e+04,   8.20140000e+04,   8.10290000e+04,
         8.20620000e+04,   9.03880000e+04,   8.16390000e+04,
         8.58950000e+04,   7.98530000e+04,   8.86300000e+04,
         8.71840000e+04,   8.83770000e+04,   9.20710000e+04,
         8.88260000e+04,   8.74430000e+04,   9.00380000e+04,
         9.77430000e+04,   9.60420000e+04,   9.46750000e+04,
         9.26630000e+04,   9.84670000e+04,   9.92980000e+04,
         9.91450000e+04,   1.01297000e+05,   1.00390000e+05,
         9.96340000e+04,   9.85920000e+04,   1.04676000e+05,
         1.01076000e+05,   9.98130000e+04,   1.00646000e+05,
         1.05021000e+05,   1.06148000e+05,   1.07011000e+05,
         1.01672000e+05,   1.06052000e+05,   1.11228000e+05,
         1.10152000e+05,   1.16759000e+05,   1.13659000e+05,
         1.10595000e+05,   1.17773000e+05,   1.16542000e+05,
         1.17367000e+05,   1.19706000e+05,   1.18726000e+05,
         1.27547000e+05,   1.24525000e+05,   1.27783000e+05,
         1.27164000e+05,   1.29067000e+05,   1.30606000e+05,
         1.34356000e+05,   1.27868000e+05,   1.33751000e+05,
         1.30818000e+05,   1.29190000e+05,   1.34615000e+05,
         1.35682000e+05,   1.37817000e+05,   1.37868000e+05,
         1.40049000e+05,   1.35609000e+05,   1.41496000e+05,
         1.40195000e+05,   1.40963000e+05,   1.47890000e+05,
         1.45144000e+05,   1.45046000e+05,   1.41335000e+05,
         1.49306000e+05,   1.45800000e+05,   1.50357000e+05,
         1.48214000e+05,   1.48282000e+05,   1.46862000e+05,
         1.47772000e+05,   1.50258000e+05,   1.52567000e+05,
         1.49298000e+05,   1.45587000e+05,   1.52834000e+05,
         1.57252000e+05,   1.47753000e+05,   1.48100000e+05,
         1.46865000e+05,   1.47667000e+05,   1.51644000e+05,
         1.47683000e+05,   1.42934000e+05,   1.44297000e+05,
         1.49313000e+05,   1.42347000e+05,   1.40920000e+05,
         1.42415000e+05,   1.36767000e+05,   1.42052000e+05,
         1.36464000e+05,   1.29370000e+05,   1.31893000e+05,
         1.21650000e+05,   1.18360000e+05,   1.09731000e+05,
         1.08481000e+05,   1.01120000e+05,   9.62350000e+04,
         8.67030000e+04,   7.97880000e+04,   6.66930000e+04,
         5.80460000e+04,   4.67410000e+04,   3.57320000e+04,
         2.68750000e+04,   1.59710000e+04,   6.92000000e+03,
         2.58900000e+03,   3.70400000e+03])

In [ ]: