In [1]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
In [2]:
import matplotlib as mpl
In [6]:
file = 'synapsinR_7thA.tif.Pivots.txt.2011Features.txt'
df = pd.read_csv(file,header=None)
In [7]:
print df
0 1 2 3 4 5 \
0 58955.555759 413312 2.824995 13.081793 73070 0.000000
1 53244.926918 376941 2.868083 13.535824 158571 4.898979
2 105100.272782 613838 2.535085 11.279717 157436 0.000000
3 116031.268008 1359253 3.521347 16.723392 565753 4.242641
4 49139.277268 327389 2.655015 12.533369 104003 5.000000
5 73818.642406 538707 2.945184 12.659126 233644 4.123106
6 131805.109207 862612 2.645872 11.194206 233644 2.236068
7 71243.551610 478505 2.810289 13.000997 99847 0.000000
8 74110.635311 602545 2.916275 13.450006 150924 5.000000
9 88475.322871 712187 2.900866 12.643470 89913 4.123106
10 147724.649772 1140541 2.840580 12.597952 179683 0.000000
11 202243.413848 1451092 2.752548 11.874494 303870 3.316625
12 89597.997917 752120 2.896704 14.305817 239683 4.582576
13 102988.941062 741730 2.717930 11.050614 180054 3.000000
14 101476.224771 633131 2.560986 11.320254 158241 0.000000
15 51329.809808 371616 2.981564 13.751641 111612 4.123106
16 98703.102461 673758 2.675115 11.433530 134404 0.000000
17 131425.071938 779825 2.574683 10.490107 197298 0.000000
18 91968.262646 735814 2.790176 12.308859 144519 4.242641
19 48778.299222 285502 2.592184 11.578045 72351 0.000000
20 108507.435621 725283 2.687107 11.567510 134404 2.828427
21 78976.836889 707372 2.886904 13.867931 248686 4.000000
22 76496.037853 613130 2.930566 13.219087 117571 3.741657
23 76872.428962 664090 3.069924 13.909634 165402 4.582576
24 74996.200685 654584 2.957169 14.166031 125515 4.582576
25 80899.683962 557015 2.799305 12.459133 108510 0.000000
26 80343.950457 645456 2.919955 13.354841 128015 3.316625
27 90093.758190 632558 2.822057 12.117365 257531 4.242641
28 98492.059368 553578 2.586866 10.331429 151323 0.000000
29 87569.721328 536870 2.555420 9.994043 107255 3.000000
... ... ... ... ... ... ...
1119269 145367.535821 1001355 2.718190 11.430200 316753 2.449490
1119270 102850.054971 955489 2.905586 13.388285 263033 3.316625
1119271 78625.409939 751302 3.197531 14.839387 263033 4.358899
1119272 48902.008783 240372 2.454783 9.744255 79274 0.000000
1119273 61665.386985 312164 2.470138 10.733925 98838 0.000000
1119274 108836.521490 494538 2.320194 9.179970 181221 0.000000
1119275 140063.910442 724864 2.387087 9.835502 221431 0.000000
1119276 125842.848383 978190 2.826881 13.190541 267559 3.316625
1119277 332305.452352 2291068 2.727980 11.250570 581059 4.358899
1119278 80425.138865 743095 3.170520 14.895659 293200 4.690416
1119279 65503.376031 337745 2.388366 9.873621 102433 0.000000
1119280 102306.493222 633962 2.693216 11.227029 238815 3.000000
1119281 74010.232901 352324 2.368120 10.340641 121251 0.000000
1119282 149376.185550 669358 2.089360 8.838109 246657 0.000000
1119283 71582.220045 379589 2.617428 10.398534 244754 4.582576
1119284 151259.990158 1068865 2.735406 11.930542 214488 4.358899
1119285 110364.701196 932598 3.061320 14.072325 352854 3.605551
1119286 68830.445993 774476 3.498388 16.057445 620537 5.000000
1119287 92575.224100 731080 2.905599 12.637673 282341 3.741657
1119288 64458.053148 397010 2.557820 10.971222 88761 0.000000
1119289 54254.070265 318864 2.605874 11.670825 76738 0.000000
1119290 61652.911372 467526 2.753412 12.258071 88761 3.000000
1119291 44658.169898 291583 2.813864 12.743171 113719 5.000000
1119292 56805.160832 341003 2.641464 11.312939 82184 0.000000
1119293 48612.958108 208156 2.228815 9.036540 83683 0.000000
1119294 77306.292169 433397 2.632513 11.144108 117994 0.000000
1119295 94235.036486 465741 2.335189 9.739447 151243 0.000000
1119296 41836.975677 211140 2.440840 11.226726 66214 0.000000
1119297 90510.751835 609819 2.744253 12.300365 192841 4.690416
1119298 64649.068280 273571 2.233624 8.660775 109724 0.000000
6 7 8 9 ... 134 \
0 17444.257510 147712 2.986790 13.643780 ... 3.515727
1 48019.317413 380041 2.855622 13.473275 ... 3.129556
2 123167.131667 812735 2.746647 11.536395 ... 3.142004
3 51153.043301 597050 3.218511 15.540583 ... 2.970779
4 63131.265577 675670 3.126650 14.688160 ... 3.346902
5 14553.605809 194713 3.390101 16.407682 ... 3.360688
6 20537.028115 225543 3.048281 14.196951 ... 3.450060
7 97919.341501 875271 3.039999 13.730034 ... 3.205527
8 80950.605180 595907 2.681220 11.543154 ... 2.917087
9 46449.799113 394430 2.871249 12.769685 ... 2.766779
10 53210.503507 558576 3.124350 13.593690 ... 3.164374
11 85586.084896 646615 2.928037 12.372856 ... 3.101972
12 35113.671352 461121 3.240502 14.936908 ... 2.851235
13 53629.928483 494518 2.913386 12.686685 ... 3.106453
14 51949.794500 515875 3.017851 13.543944 ... 3.347980
15 55982.824439 431355 2.918811 12.640795 ... 2.883770
16 49062.390684 434523 2.863044 13.007489 ... 3.262040
17 57906.413006 533554 3.046595 13.216823 ... 2.810319
18 42791.431423 497340 3.041568 14.281130 ... 3.082853
19 40020.683644 450333 3.051014 14.097292 ... 3.282044
20 42071.155823 455678 3.050366 14.353296 ... 3.317697
21 43423.385103 377575 2.972086 13.295340 ... 3.601508
22 47037.072803 489935 3.098810 13.338110 ... 3.237316
23 38508.591835 422039 3.142797 14.184101 ... 3.383676
24 21315.470989 268520 3.286279 15.655657 ... 3.054326
25 34845.073128 276542 2.842631 11.896996 ... 2.944017
26 47002.604985 408732 2.970038 12.823315 ... 3.212756
27 34565.868268 320560 3.057873 13.433532 ... 2.693228
28 61004.594570 530570 2.963249 12.486824 ... 3.460744
29 9272.418327 113514 3.452224 15.687008 ... 3.469954
... ... ... ... ... ... ...
1119269 84204.972397 803103 2.905387 11.740733 ... 2.802699
1119270 80521.911640 794879 2.838107 12.995700 ... 3.133783
1119271 120584.482879 758650 2.633987 11.378464 ... 3.320726
1119272 49037.127696 466705 3.029456 13.828577 ... 2.859033
1119273 53490.998045 453874 2.865674 12.951923 ... 3.258807
1119274 35914.863888 318688 3.075449 13.737012 ... 3.130422
1119275 59741.336918 433592 2.760944 11.942681 ... 3.074245
1119276 89463.867998 706075 2.695335 11.469783 ... 3.337599
1119277 248471.444909 1922240 2.686658 11.198821 ... 3.635637
1119278 45464.488705 366577 2.906287 12.603663 ... 3.189560
1119279 36856.486268 257217 2.699755 10.899668 ... 3.661239
1119280 42297.034750 271612 2.622095 11.171841 ... 2.646272
1119281 48908.350019 348287 2.730592 11.822224 ... 3.691352
1119282 94887.549497 482845 2.389317 9.703031 ... 2.949656
1119283 33819.892124 254283 2.786611 11.695064 ... 3.373465
1119284 71810.131562 692997 2.998821 13.527278 ... 3.264257
1119285 17834.434230 224998 3.170400 16.198402 ... 3.253237
1119286 32169.032475 210003 2.663907 11.038095 ... 3.460003
1119287 49554.094586 416867 2.843957 11.932314 ... 2.781727
1119288 28393.768309 324617 3.155842 15.096169 ... 3.523653
1119289 9653.778364 152245 3.635961 17.540845 ... 3.044667
1119290 46913.010319 391506 2.884377 13.172225 ... 3.287252
1119291 24837.386598 322568 3.337261 15.487686 ... 3.176383
1119292 45027.163065 357718 2.830413 12.483216 ... 3.134294
1119293 31172.038615 231094 2.757328 11.314971 ... 3.571104
1119294 86888.877040 493411 2.491720 10.348379 ... 2.790947
1119295 37108.244838 340694 2.926963 13.538730 ... 3.425632
1119296 39525.063694 334341 2.932582 13.518408 ... 3.005101
1119297 55695.049602 446078 2.871085 12.722006 ... 3.445427
1119298 20064.001275 180493 3.017735 12.957090 ... 3.516911
135 136 137 138 139 140 \
0 16.240112 56558 4.242641 3731.396581 22081 2.571220
1 15.183658 87120 4.898979 5471.083376 51805 3.189269
2 14.679860 100223 5.000000 6670.802720 74837 3.241470
3 13.737126 38530 4.898979 2920.910775 38062 3.407064
4 15.551689 94118 4.898979 19101.674731 182788 3.077416
5 16.423711 203625 4.582576 2222.653465 30348 3.428142
6 16.941656 95390 4.898979 4998.883109 57951 3.174761
7 16.277976 70832 4.582576 3893.570292 44096 3.165806
8 12.150650 73097 2.236068 8876.332157 86554 3.014603
9 11.628599 192618 2.449490 6214.501612 64208 3.058741
10 14.623247 43066 4.123106 5744.847534 57620 3.049747
11 13.509239 76261 3.000000 2022.831317 24485 3.433500
12 12.996248 257827 4.242641 4742.910539 47031 2.991866
13 14.104973 90275 3.162278 3421.651821 31989 2.989040
14 15.416251 127173 4.472136 4054.191756 38659 2.997374
15 11.988354 113440 3.741657 3131.122695 33555 3.172286
16 15.180198 124820 5.000000 7685.198889 126054 3.730540
17 12.603593 181670 3.162278 3540.881008 31992 2.956964
18 13.257926 124713 2.449490 3575.747988 38643 3.141732
19 15.318359 95935 3.316625 2699.416438 29592 3.170659
20 14.840925 202338 4.898979 1967.610170 20439 3.129957
21 16.991119 111960 4.582576 3260.402911 35195 3.139277
22 15.318460 93615 4.123106 2193.768272 21861 3.102115
23 15.496678 54138 3.605551 3283.765595 29678 2.968505
24 15.194713 131640 4.472136 4869.115994 40925 2.877955
25 13.727855 67432 4.358899 3232.919358 29354 3.009353
26 15.088394 133877 4.472136 2833.217405 29317 3.034592
27 11.896492 141206 1.414214 4584.136883 45224 3.025066
28 15.511148 129267 4.582576 3284.666279 34048 3.072210
29 16.663397 40342 4.582576 3284.634203 31209 3.001511
... ... ... ... ... ... ...
1119269 12.121469 40984 3.162278 2348.995180 28309 3.139459
1119270 14.284396 26316 4.242641 1350.894765 19256 3.465585
1119271 15.915882 23655 4.690416 872.706925 12232 3.520116
1119272 13.377133 28173 3.605551 3900.461581 37194 3.033407
1119273 14.788089 132856 4.582576 2076.071024 25288 3.209995
1119274 14.828640 17997 4.582576 4302.524902 37434 2.850297
1119275 13.444670 82674 2.828427 2069.273448 20175 3.081918
1119276 17.003898 37198 4.358899 2617.855715 23070 3.017262
1119277 16.821042 19494 4.472136 4767.485090 36129 2.820578
1119278 14.975314 38524 5.000000 2797.939219 28401 3.037122
1119279 17.919904 58445 4.898979 2711.317489 34558 3.259104
1119280 10.871967 37388 2.236068 2505.589516 33750 3.282471
1119281 16.719048 55128 4.898979 2141.203727 20135 3.083876
1119282 12.383991 85904 3.316625 840.219872 12546 3.611135
1119283 15.258995 113800 3.741657 2330.945482 25090 3.157775
1119284 15.920688 57043 4.242641 5074.235937 48549 2.916957
1119285 15.217110 21363 5.000000 3836.600220 51594 3.432218
1119286 17.489697 67974 4.898979 983.444285 12948 3.348903
1119287 12.878548 58836 5.000000 1344.767285 14679 3.184765
1119288 16.208637 67133 4.898979 2773.925919 30969 3.142244
1119289 12.397905 53561 3.316625 2306.240059 22576 2.998135
1119290 14.191039 30189 3.000000 4136.314170 39275 2.994288
1119291 16.217949 40227 5.000000 3211.560301 31792 3.123790
1119292 15.324202 36671 3.605551 3976.159425 37896 2.993969
1119293 16.317411 55128 4.123106 3086.559210 33990 3.076715
1119294 11.207252 74211 3.316625 4947.345752 42377 2.878379
1119295 16.530696 37569 4.898979 2971.593301 30813 3.061423
1119296 11.859891 72848 3.000000 1114.943587 13922 3.334238
1119297 15.730148 74211 4.582576 2967.243624 28595 2.951736
1119298 16.863407 53591 4.582576 2206.890649 27164 3.193115
141 142 143
0 12.183551 4821 0.000000
1 14.896226 107648 4.582576
2 15.002672 37849 5.000000
3 16.490043 9142 3.464102
4 13.980316 107785 5.000000
5 16.264334 8826 4.123106
6 13.919656 8826 2.236068
7 15.110464 6850 4.472136
8 13.258035 11378 3.316625
9 13.664232 5977 3.162278
10 13.426050 6698 3.741657
11 15.119257 15184 4.358899
12 13.484808 9675 3.316625
13 13.282847 6344 4.898979
14 13.475025 6781 4.123106
15 14.546178 5590 4.582576
16 18.698225 215016 4.898979
17 13.200206 3205 2.000000
18 14.552493 5808 5.000000
19 14.563598 3873 4.582576
20 14.356035 7575 4.472136
21 14.789260 6114 4.472136
22 14.100453 3736 4.123106
23 13.185794 5275 3.162278
24 12.452389 7527 2.449490
25 13.785276 3019 3.162278
26 13.855613 4101 5.000000
27 13.743786 4258 5.000000
28 14.547551 7501 4.582576
29 13.585184 3491 4.472136
... ... ... ...
1119269 14.652443 3976 4.472136
1119270 16.128116 4792 5.000000
1119271 16.856769 3696 5.000000
1119272 14.539764 4981 4.000000
1119273 15.405133 3809 4.242641
1119274 13.068467 9373 3.162278
1119275 14.193606 2817 3.000000
1119276 14.418856 4569 5.000000
1119277 13.368153 5852 2.000000
1119278 13.602338 4195 3.605551
1119279 15.574918 7441 4.898979
1119280 15.351793 7327 3.605551
1119281 14.560119 4684 5.000000
1119282 16.556273 13765 5.000000
1119283 14.855680 3973 4.690416
1119284 13.103957 9128 4.000000
1119285 15.360643 25589 3.741657
1119286 15.899830 3322 5.000000
1119287 14.779549 3725 5.000000
1119288 14.531951 5674 5.000000
1119289 13.536100 3668 2.000000
1119290 13.281299 5563 2.828427
1119291 14.665891 5610 4.123106
1119292 13.334336 6682 4.123106
1119293 13.865284 4474 3.605551
1119294 13.508908 6271 3.000000
1119295 13.808782 5098 4.472136
1119296 15.509050 3450 5.000000
1119297 13.491554 5326 4.123106
1119298 15.032028 4772 5.000000
[1119299 rows x 144 columns]
In [8]:
df.shape
Out[8]:
(1119299, 144)
In [11]:
144/3
Out[11]:
48
In [30]:
df.plot(kind='scatter',x=0,y=6)
Out[30]:
<matplotlib.axes._subplots.AxesSubplot at 0x10fb79a50>
In [29]:
Out[29]:
6.0
In [ ]:
In [ ]:
Content source: Upward-Spiral-Science/the-vat
Similar notebooks: