You can read in tabular data really easily from a csv file, but let me just generate a random 100 x 100 matrix of floats (eg a numpy array).
# Import several useful plotting and numerical utilitiles
%pylab inline
# Generate 100x100 matrix using numpy (np)
data = np.random.randn(100,100)
print 'Shape of data is', data.shape
Populating the interactive namespace from numpy and matplotlib Shape of data is (100, 100)
Read the numpy matrix into a pandas.DataFrame
. We can add some row and column labels as well. In fact, let me just generate random labels (http://stackoverflow.com/questions/2257441/random-string-generation-with-upper-case-letters-and-digits-in-python).
import string
import random
def id_generator(size=6, chars=string.ascii_uppercase + string.digits):
return ''.join(random.choice(chars) for _ in range(size))
row_labels = [id_generator() for i in range(100)]
col_labels = [id_generator() for i in range(100)]
import pandas as pd
import string
df = pd.DataFrame(data, index=row_labels, columns=col_labels)
df
319HFQ | PZZMY7 | 807LSJ | KAT9KF | YX2HRH | YQRRV3 | 47OF5T | UW600C | MCS2TA | WFCS5J | ... | H7QKIS | D0W5AK | F1DMC8 | 2HNMFQ | YZLOOD | 036XCY | I8HYO1 | NYWBX9 | 38ONCM | 52OURD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NGBPTC | 0.778690 | 1.221722 | 0.715656 | 0.295813 | -0.839316 | -0.752484 | 0.588373 | 0.492934 | 0.588318 | 0.576905 | ... | 1.580382 | 0.754390 | 1.561100 | 0.006340 | -1.118712 | 1.351762 | 0.938249 | 0.075120 | 0.628631 | 0.016442 |
O8LUEF | -0.665460 | 0.439953 | -1.016424 | -0.820557 | 1.499309 | -1.143884 | -0.360754 | -1.134139 | 1.517119 | 0.384673 | ... | -0.195662 | 0.048840 | 0.213249 | 0.736781 | -2.184372 | 0.287336 | 0.259579 | -1.037473 | 0.615275 | -0.350450 |
5MBV0U | 0.145017 | 1.288917 | 1.921816 | 1.041838 | 0.635955 | -1.952380 | -2.413781 | -0.335551 | 0.501630 | -0.724326 | ... | 0.166984 | 1.314349 | 1.817277 | 0.753664 | 0.633940 | 0.198318 | -1.504531 | 0.843891 | 1.187936 | -0.117335 |
RTH362 | -0.001339 | -0.821757 | 0.302018 | 0.820761 | 1.322099 | 1.743116 | -1.797543 | -2.313272 | -0.281417 | -1.285721 | ... | -0.636922 | 0.175850 | 1.352796 | 0.061398 | 0.080131 | -0.628542 | -0.972533 | 0.260542 | 2.302908 | 1.113247 |
EFX0T1 | -0.764992 | 0.007955 | 1.333324 | -0.773931 | -1.529598 | -1.330428 | -0.223951 | 0.412147 | 1.113441 | -0.994744 | ... | -0.159716 | 0.240484 | -1.888641 | -0.829505 | 0.010769 | -0.677631 | -0.804589 | 0.064942 | 1.228502 | -0.913923 |
HEO1SY | 0.944998 | 0.918065 | -1.461024 | 1.058947 | 0.291686 | 1.749922 | -0.528326 | 1.148555 | -0.160195 | -0.573229 | ... | 0.377187 | 0.011215 | 0.731989 | 0.395910 | -0.376684 | -0.804077 | 0.170862 | 1.717925 | -1.835462 | 1.337839 |
3H8LFZ | -0.653986 | 0.432272 | 1.253496 | -1.698193 | 2.021788 | -3.496822 | -0.885878 | 0.323578 | 1.346455 | 0.259785 | ... | -1.063980 | 1.338739 | -0.849712 | -0.274973 | -0.610784 | -0.400837 | 1.429141 | -0.932177 | -1.973970 | -0.045206 |
N2Z6KS | 1.366887 | 0.809889 | -0.242704 | -0.188209 | 0.838676 | -0.493529 | 0.356837 | 0.493774 | 2.013345 | 0.155585 | ... | -0.698383 | 1.490902 | 0.445262 | 0.908813 | 0.680400 | 0.399042 | 0.569845 | -0.036595 | -0.239732 | -0.084841 |
UXMFVU | -0.447540 | 1.033916 | 1.163613 | 0.592706 | 0.089911 | 0.054017 | 1.322572 | -0.257122 | -0.100353 | -0.665717 | ... | 1.830203 | -2.123511 | -0.051915 | 2.133290 | 0.500580 | 0.570909 | -0.397985 | -0.500087 | 0.000725 | -1.191560 |
7KLX59 | -2.198889 | 0.781494 | -0.277551 | 0.043071 | 3.154460 | -0.180552 | -0.022574 | 0.455107 | -0.684722 | 0.292378 | ... | 0.887100 | 0.522153 | -0.281897 | 0.488889 | 0.813552 | -1.146371 | -0.747084 | -0.330693 | 0.317176 | -0.528860 |
CWXNWL | 0.306647 | -0.192182 | 0.765183 | -0.627827 | 1.474926 | 2.023975 | -0.249666 | 1.417011 | -0.116159 | 0.123722 | ... | -1.583092 | -0.532773 | 0.024076 | -0.738585 | -0.744864 | -0.617724 | 0.720857 | 0.564913 | 0.201011 | 1.283976 |
GO1W4T | -0.014548 | -1.078925 | 0.666450 | 0.488301 | 0.650169 | 1.057226 | 0.569971 | -0.110949 | 0.861067 | 1.274121 | ... | -0.212744 | 0.381204 | 0.651206 | 0.979356 | 2.024770 | 0.925248 | -0.380326 | -0.816976 | -0.561596 | 0.152891 |
RWDF0Y | 1.616390 | -1.186700 | -0.971436 | -0.290868 | -1.247698 | -1.264792 | 1.713419 | -1.817610 | -1.053562 | -1.214642 | ... | -0.897328 | -0.834710 | -0.683174 | -1.396112 | 1.133545 | -0.103149 | 0.431047 | -1.524295 | 1.761266 | -1.215532 |
VTMVJD | -0.320490 | -1.579689 | -1.428385 | 0.887385 | -1.313938 | -0.319383 | -0.429900 | 0.638465 | -1.983995 | 1.121168 | ... | 0.469585 | 1.755180 | 0.964617 | -1.086632 | -0.522464 | -0.786758 | -0.266076 | 2.183973 | 0.290032 | -1.868924 |
04J97O | 2.126514 | 0.028733 | -3.954128 | -1.168714 | 1.318967 | -0.047984 | 0.044110 | 0.225779 | 0.182075 | -0.175735 | ... | 1.635187 | -1.987034 | 0.736389 | -0.161665 | -0.367314 | -0.016252 | 0.803037 | -1.580418 | 1.186494 | -0.082381 |
59OTJ1 | -0.636972 | -1.984645 | -0.261619 | -1.782171 | 0.810816 | -0.527223 | -0.629189 | 0.926677 | 0.120621 | 1.374511 | ... | -0.677948 | 1.003529 | 0.170996 | -0.525659 | 0.475505 | -1.752991 | -0.690364 | -1.309543 | 0.950304 | -0.364679 |
506043 | 1.209984 | -1.729002 | -0.027402 | -0.249261 | -0.351807 | -0.323941 | -0.010198 | 0.593584 | 0.773256 | 0.843626 | ... | 0.780541 | -0.166512 | -0.881518 | 0.195680 | 0.092342 | -1.714647 | -0.616778 | 2.396309 | -1.996719 | -1.049794 |
057WR7 | -0.240231 | 0.614830 | -1.072167 | 0.530631 | -1.462494 | -1.303212 | -1.317025 | -0.916840 | 1.664395 | -0.476972 | ... | 0.391531 | 0.265437 | -0.140911 | 0.800525 | 1.147863 | -1.804572 | 0.203062 | 0.598856 | -1.634254 | -0.912255 |
L7QOB3 | 0.053271 | -1.093740 | 1.913374 | 1.848342 | 1.156427 | 0.629393 | 0.778395 | -0.236316 | -1.509501 | 0.213054 | ... | 1.259521 | -1.135191 | -1.688820 | 0.499802 | -0.269501 | -1.851031 | 1.170181 | -1.147493 | 1.529320 | 0.609831 |
V1BX9S | 0.659220 | 1.089930 | -1.109633 | -1.069460 | -0.156611 | -1.048771 | -0.496480 | -0.219938 | 2.057062 | 1.275169 | ... | 0.716812 | -2.231505 | 0.626729 | 1.282724 | 0.509377 | -0.265724 | 1.055092 | 0.514475 | 0.725272 | -0.051615 |
PZAW26 | 2.000379 | -0.498371 | -1.067533 | 0.479374 | 0.373651 | 0.361159 | 1.502729 | 0.444940 | 0.910022 | 0.688291 | ... | 1.816300 | 0.297162 | -0.534597 | -1.730250 | -1.137232 | -0.306192 | -0.201672 | -0.455747 | -0.156739 | -0.337653 |
VQUM9C | 0.054850 | -0.544908 | -0.656085 | -1.560528 | -1.522710 | 2.010669 | 0.947840 | -1.013192 | 0.234109 | -0.016719 | ... | -1.468794 | 0.354792 | -0.110455 | -1.060060 | 0.750911 | -1.270710 | 0.178716 | 1.149633 | 0.075579 | -1.422196 |
4TMMB6 | 0.548778 | 1.196902 | -1.558206 | -0.244922 | -0.660382 | -0.332905 | -0.857808 | -0.707176 | -0.917023 | 2.495432 | ... | -0.116084 | 0.453864 | -0.102270 | 0.039457 | -0.019113 | -0.213375 | 0.169564 | 0.132910 | 0.582278 | -0.249404 |
UD96JU | 0.096042 | 1.088942 | -0.435235 | -0.372586 | 0.117325 | 1.334264 | -1.072413 | 0.896994 | 0.002065 | 0.594672 | ... | -1.307295 | -0.268929 | -0.090147 | 0.159457 | -0.180262 | 1.502539 | -0.736129 | 1.475539 | -0.092298 | 0.910134 |
BOYMWR | -1.704903 | 1.484920 | 0.176865 | -0.594083 | -0.062577 | 0.745673 | -0.284795 | 0.118671 | -1.871699 | -0.029807 | ... | -0.914432 | -0.975881 | 1.230979 | 1.141278 | -0.273638 | -0.505785 | 0.271579 | -0.802465 | 0.202140 | 0.322480 |
1ZVMZP | 0.480748 | 2.513977 | 0.060993 | -2.662401 | -0.905468 | -0.934229 | -0.902420 | 0.210026 | -1.170233 | -0.218713 | ... | 1.243434 | -0.999992 | 1.405547 | -0.177745 | 0.329654 | -0.070239 | -0.840855 | -0.975620 | -0.609421 | 0.560709 |
BJC7CX | -1.153850 | -0.355706 | -0.525939 | -0.649099 | -0.721888 | -0.172888 | -0.372456 | 0.697233 | 0.827004 | -1.457622 | ... | -1.279347 | 0.797619 | -0.173961 | 0.737115 | -0.501604 | 1.674313 | -0.136826 | -1.296252 | -0.714817 | -0.351712 |
FVI4E4 | -0.139617 | 0.354288 | 0.564137 | -0.213402 | -0.554368 | 0.393860 | -0.144862 | -0.226043 | 1.042892 | 1.844925 | ... | 1.296367 | 2.004977 | 1.688052 | -1.477467 | -0.932912 | -0.928107 | 1.369133 | -0.725488 | -0.690945 | -2.481391 |
S9HTJV | 0.030092 | -0.362218 | -0.125603 | 0.755532 | 1.777172 | -0.519745 | 0.843875 | 0.398035 | 0.129263 | -0.017216 | ... | -0.640484 | 0.045647 | -0.052521 | -0.653234 | 0.106523 | -2.249239 | -0.690784 | -0.003275 | 0.749345 | -1.016725 |
5LVUQ7 | -0.576946 | 0.848249 | -1.040275 | 0.277970 | -0.244152 | -0.146600 | 0.050308 | 0.382049 | -0.488441 | -1.960180 | ... | 1.221074 | 0.414462 | -0.620482 | 0.925134 | 0.078544 | 0.845698 | 1.515813 | 0.689777 | -0.548271 | -1.781792 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
AIDONM | -1.050972 | 1.063689 | -0.538303 | 0.184602 | -0.198743 | -0.637295 | -1.038436 | 0.887492 | 2.395034 | 1.317884 | ... | 0.291297 | 1.078150 | 0.221735 | -1.287952 | 0.380941 | 1.299416 | 0.679817 | -0.201304 | 0.177027 | 1.010602 |
03MBWH | -1.163961 | -0.249222 | -0.784236 | -0.753768 | 0.515031 | -2.279390 | 1.072001 | 0.445251 | 0.959801 | -1.210720 | ... | -1.601103 | -0.043304 | 0.192722 | -0.876681 | -0.855802 | -0.661314 | -0.058914 | 0.119224 | 0.790722 | -0.078961 |
TOO5H1 | 0.099616 | 0.196090 | -0.794584 | -0.311331 | 1.074653 | -0.420625 | -0.605608 | 0.058944 | -1.357449 | -0.435971 | ... | 0.668204 | 0.346204 | -0.530054 | -1.727012 | -1.435023 | 1.605296 | 0.157533 | 0.303684 | -0.163150 | 1.375123 |
OYHVBX | -0.058429 | -0.649010 | 0.308342 | -0.564005 | 0.481566 | -2.482760 | 0.331903 | 0.680419 | 0.462881 | 0.516017 | ... | -0.751171 | -1.325414 | -0.237759 | 0.197342 | 0.115461 | -0.688797 | -0.121620 | -0.646406 | 0.046530 | -0.421538 |
V786PE | 1.175605 | -0.549779 | -0.152603 | 0.251049 | -0.439920 | 2.548060 | 1.517471 | -0.535800 | 1.193743 | -0.207529 | ... | -0.528714 | -0.570824 | 1.052736 | -1.934977 | 1.028915 | 0.196582 | -0.490245 | -1.617262 | 0.124872 | -0.101264 |
9RJQGW | 0.531730 | -0.949845 | -0.767607 | 0.713325 | 0.280676 | -0.155360 | 1.230055 | -0.071942 | -0.191062 | 1.805901 | ... | 1.554971 | 2.628866 | -1.375391 | -0.622019 | 0.971014 | -0.252702 | -0.630498 | 0.333760 | 0.919390 | 0.776618 |
3H1TF0 | -0.776475 | 0.015233 | 0.578381 | 0.309502 | 1.112238 | -1.133612 | -1.111345 | 0.295694 | 0.028571 | -0.072242 | ... | -0.562143 | -1.643505 | 0.407434 | 0.630195 | -0.529822 | 0.457045 | 0.554114 | 0.312236 | -0.610395 | -0.552145 |
JA1UVZ | 0.209478 | 0.616087 | 0.686761 | -1.507617 | -2.065342 | 0.644114 | -0.651913 | 0.210145 | -0.330996 | -0.276153 | ... | -1.014989 | 0.996623 | 0.053820 | -0.079041 | 0.476510 | 1.534363 | -0.883318 | -1.393355 | 0.107786 | 0.705707 |
IDSJNW | -0.121665 | -0.097962 | 0.807366 | 0.081383 | 0.644892 | 0.129373 | -0.757435 | -0.617414 | 1.276655 | 0.014567 | ... | 0.261372 | -0.021954 | -0.425738 | -1.077601 | -1.899470 | -0.051163 | 0.392335 | -1.510507 | 0.455301 | -0.169193 |
1SWX37 | 0.348530 | 1.049723 | 2.050838 | -0.163068 | 0.164497 | 0.905279 | 1.317616 | 0.490198 | 0.014271 | 1.745718 | ... | -1.833282 | -0.633634 | 0.938900 | -1.910806 | 0.268567 | -1.322201 | 0.770084 | 0.663527 | -0.121856 | 0.453828 |
XGMLQ8 | 0.699616 | -1.127668 | 0.396083 | -0.410279 | 0.517863 | -0.404662 | -1.344384 | -1.006028 | -0.058066 | 1.437227 | ... | 0.157280 | -0.994925 | 0.261407 | -0.341600 | -0.516439 | 1.695874 | -0.823078 | -0.555683 | 1.061061 | -0.803733 |
NMHGEE | -0.035213 | -0.417224 | -1.110075 | 0.471715 | 0.407583 | 0.255497 | 0.798749 | -0.971510 | 2.023323 | -1.176814 | ... | 2.245504 | 0.183047 | -0.851939 | -0.681572 | -0.381570 | -0.843561 | -0.487115 | -0.436357 | -0.160772 | 1.179809 |
ZE106Y | 0.388100 | 1.390867 | -0.625338 | 0.402109 | -0.615150 | -1.977710 | 0.096375 | 1.071499 | -0.640294 | 2.024948 | ... | -1.006659 | -1.851288 | -1.098039 | 0.335473 | 0.102949 | -0.173334 | 0.921692 | -0.946240 | 3.109802 | -1.613241 |
VU82W6 | 0.409184 | -0.597348 | -0.213950 | -1.578699 | 0.103515 | 0.386031 | 0.659690 | -1.035826 | -1.085160 | 0.912212 | ... | 1.396672 | 0.114622 | 0.584745 | 0.644695 | 0.515576 | 1.615773 | 0.530226 | -0.437022 | 0.265871 | -1.066229 |
PMIPXS | 1.048264 | -0.494404 | -1.562079 | 1.527681 | 1.287315 | 1.349877 | -0.157688 | -2.035788 | -0.557085 | -0.650246 | ... | -0.707062 | 1.082953 | -0.805189 | -0.347345 | 0.401073 | -0.699905 | 1.072408 | -0.960552 | -1.347891 | -0.729361 |
P8VE2M | -0.063655 | -0.648947 | 0.100656 | -0.222788 | 0.830899 | 0.379632 | 0.844519 | 0.942225 | -0.724774 | -1.186951 | ... | 1.177335 | 0.085742 | -0.880402 | -0.350645 | 0.185474 | -1.102351 | -1.449395 | 1.027139 | -0.579098 | -0.685742 |
FLLTHV | 0.700133 | 0.112048 | 0.040160 | 1.326763 | -1.083289 | 1.091013 | 1.273249 | 0.389621 | -0.308689 | 0.456083 | ... | 0.374150 | -0.943599 | -1.046250 | -0.716854 | -0.493997 | 1.925767 | -0.477072 | 0.845359 | -0.913847 | -0.605428 |
PUP2PQ | -0.678356 | -0.604432 | 1.721884 | -1.476664 | 0.138909 | -0.574471 | 1.129233 | -0.783076 | 2.323541 | 0.133040 | ... | 1.103544 | -1.201177 | -0.934520 | -0.363235 | 0.018136 | -1.226667 | 0.227545 | 0.211815 | -0.576056 | -2.256664 |
79DADD | 0.585458 | 1.430785 | -0.261384 | 0.237669 | 1.069034 | 1.115546 | -0.860222 | 0.934165 | 0.025137 | -2.358762 | ... | 0.373404 | 0.268576 | -0.787550 | -1.423307 | -0.826137 | 1.041633 | -0.221068 | -0.351164 | -0.561635 | 0.463503 |
8RC2IN | 0.644638 | 0.673291 | -0.408126 | 0.038960 | 0.108233 | -1.243956 | -0.677524 | 0.111171 | -0.352005 | 0.703641 | ... | -0.622083 | 2.126165 | 2.147805 | -0.671258 | 1.485356 | -0.286856 | 0.587079 | -0.252669 | -0.806095 | 0.115271 |
S596NM | 0.540961 | -0.223872 | 0.920438 | -0.018683 | 1.639389 | -0.120099 | 0.037902 | 1.102441 | -0.729953 | 0.361369 | ... | -0.109954 | -2.957260 | 0.622968 | -0.748892 | 0.029827 | 0.710654 | -0.262730 | 0.788460 | -0.771907 | -0.103100 |
3AX8MX | 0.079903 | -1.745836 | 0.161180 | -0.353359 | -0.937015 | 1.238429 | -0.497964 | 0.456501 | 0.046670 | -1.185108 | ... | -0.648525 | -2.075260 | -0.094427 | -0.127151 | 0.019272 | -0.600279 | 0.253308 | -0.190194 | 0.986948 | 0.461355 |
8YQ39T | 0.587273 | 0.080756 | -0.148554 | 1.118669 | -0.794594 | -0.001390 | 0.322896 | -0.037530 | -0.524104 | 0.167078 | ... | 0.197054 | -0.574352 | -0.214549 | 0.116520 | 0.371358 | 0.199762 | 1.753991 | 0.437527 | 0.332154 | 0.405922 |
UV8STX | -0.410131 | 0.645255 | -1.471356 | 0.003066 | -1.214533 | -0.249028 | -1.465662 | 0.852600 | 0.488305 | -0.012950 | ... | -0.500059 | -0.502727 | -1.587979 | -1.155992 | -1.608153 | -0.534764 | 0.007642 | 0.322106 | 0.297463 | 0.458898 |
J5OECV | 0.792933 | -0.960345 | 0.886241 | -2.085233 | 2.572415 | -0.328843 | 0.235018 | 0.919405 | 0.037407 | 0.278279 | ... | 1.143734 | 0.660959 | 1.334985 | -0.792520 | -0.990362 | -0.233102 | -0.749404 | 1.063977 | -2.315072 | 0.608956 |
JR95JC | 1.257929 | 0.093900 | -0.517913 | -0.596776 | -0.912053 | 0.114996 | -0.682782 | -0.922375 | -2.031803 | -0.155626 | ... | 0.111003 | -1.239903 | 0.145238 | -0.898801 | -0.697615 | 0.624183 | 1.478917 | -0.513417 | -0.083578 | -2.151011 |
Z3YZSE | -0.653105 | -1.039436 | -0.859396 | -1.694682 | -0.967473 | -1.257349 | -1.032920 | 0.111500 | -0.303369 | -0.024516 | ... | -0.000513 | -0.702601 | 1.177323 | 0.346724 | 1.433051 | 0.420690 | -1.222000 | -1.351158 | 0.086021 | 1.146971 |
EMUV5T | 0.779227 | -0.659934 | -0.896985 | -1.485401 | 0.531201 | -0.663957 | 0.064009 | 1.582108 | -0.421666 | 1.565358 | ... | -0.989920 | 0.497674 | 0.546680 | -0.361420 | -0.545086 | 0.260726 | 2.796664 | 0.025373 | 0.403482 | -0.350186 |
UR7JV9 | 1.069282 | -0.576223 | -0.734336 | -0.389060 | -0.325951 | -0.611100 | 0.022610 | 1.446888 | -1.076910 | 1.486644 | ... | 0.098600 | -0.929039 | 0.745916 | 0.757466 | -0.182448 | -0.435039 | 0.529863 | 0.760059 | -0.790890 | 0.796067 |
PAU2S6 | -1.882540 | 0.295109 | 0.086687 | -0.058689 | 0.453606 | -0.280420 | 1.461157 | -1.056406 | -1.105908 | -0.248352 | ... | -1.420816 | -0.618970 | 1.319199 | -1.262987 | -1.862227 | -0.725490 | -1.180435 | 0.676924 | 0.353834 | 0.445535 |
100 rows × 100 columns
We can slice and plot really easily. For example. plotting the first five columns:
df.iloc[::, 0:5].plot()
plt.ylabel('value');
Correlation/covariance and most other statistical functions are builtin
correlations = df.corr()
correlations
319HFQ | PZZMY7 | 807LSJ | KAT9KF | YX2HRH | YQRRV3 | 47OF5T | UW600C | MCS2TA | WFCS5J | ... | H7QKIS | D0W5AK | F1DMC8 | 2HNMFQ | YZLOOD | 036XCY | I8HYO1 | NYWBX9 | 38ONCM | 52OURD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
319HFQ | 1.000000 | 0.007140 | -0.213929 | -0.005143 | 0.113928 | 0.081875 | 0.074137 | -0.058777 | 0.043949 | -0.008847 | ... | 0.072356 | -0.136417 | 0.201655 | -0.195233 | 0.138774 | 0.017919 | 0.187885 | -0.010005 | -0.038841 | 0.043182 |
PZZMY7 | 0.007140 | 1.000000 | -0.018448 | -0.039470 | -0.101038 | -0.100659 | -0.160968 | 0.107909 | 0.080956 | 0.047954 | ... | 0.037599 | -0.082140 | 0.198644 | 0.153121 | -0.001213 | 0.218880 | -0.032214 | -0.038692 | 0.029213 | 0.112070 |
807LSJ | -0.213929 | -0.018448 | 1.000000 | 0.072635 | 0.095617 | -0.053480 | 0.001212 | -0.120085 | 0.012960 | -0.049312 | ... | -0.057978 | -0.035274 | -0.063702 | 0.141662 | 0.012000 | 0.020266 | -0.023459 | 0.109984 | -0.014740 | 0.051319 |
KAT9KF | -0.005143 | -0.039470 | 0.072635 | 1.000000 | 0.041314 | 0.173914 | 0.073332 | -0.168336 | 0.031269 | -0.095888 | ... | 0.064893 | 0.013298 | -0.093173 | 0.020214 | 0.018604 | -0.069153 | 0.019912 | 0.176726 | 0.111016 | -0.023197 |
YX2HRH | 0.113928 | -0.101038 | 0.095617 | 0.041314 | 1.000000 | -0.030489 | 0.031955 | 0.022200 | 0.065837 | -0.062196 | ... | -0.014020 | -0.004580 | 0.045299 | -0.001465 | -0.088427 | 0.042292 | -0.006268 | -0.136978 | -0.082791 | 0.089159 |
YQRRV3 | 0.081875 | -0.100659 | -0.053480 | 0.173914 | -0.030489 | 1.000000 | 0.149174 | -0.043730 | -0.224550 | -0.051636 | ... | 0.045543 | -0.111387 | -0.004978 | -0.209402 | 0.138757 | 0.091575 | -0.097798 | 0.131509 | -0.076417 | 0.097504 |
47OF5T | 0.074137 | -0.160968 | 0.001212 | 0.073332 | 0.031955 | 0.149174 | 1.000000 | -0.006719 | 0.055051 | -0.054117 | ... | 0.046496 | -0.055670 | -0.041901 | -0.163152 | 0.127931 | -0.029840 | 0.079345 | -0.095447 | 0.088280 | -0.210871 |
UW600C | -0.058777 | 0.107909 | -0.120085 | -0.168336 | 0.022200 | -0.043730 | -0.006719 | 1.000000 | -0.034447 | 0.160844 | ... | -0.150006 | -0.096910 | 0.000894 | -0.147773 | 0.080903 | 0.161829 | 0.033941 | 0.161408 | -0.142940 | 0.141235 |
MCS2TA | 0.043949 | 0.080956 | 0.012960 | 0.031269 | 0.065837 | -0.224550 | 0.055051 | -0.034447 | 1.000000 | -0.072161 | ... | 0.014487 | 0.019837 | -0.032611 | 0.013939 | -0.015451 | 0.074209 | 0.052577 | -0.035563 | 0.089478 | 0.044552 |
WFCS5J | -0.008847 | 0.047954 | -0.049312 | -0.095888 | -0.062196 | -0.051636 | -0.054117 | 0.160844 | -0.072161 | 1.000000 | ... | 0.081403 | 0.181426 | 0.118716 | 0.034379 | 0.085478 | -0.054885 | -0.097632 | 0.150435 | 0.083764 | -0.010358 |
ITKDYF | 0.026194 | -0.105259 | -0.042227 | -0.074034 | 0.148083 | 0.041933 | 0.016405 | 0.045082 | -0.161104 | -0.034623 | ... | -0.004834 | -0.232654 | -0.061411 | -0.002820 | -0.039363 | 0.079384 | 0.113005 | 0.006136 | -0.082216 | 0.103198 |
K23W0C | -0.093718 | -0.080886 | 0.061553 | 0.086799 | -0.013555 | -0.015857 | -0.008584 | 0.114188 | -0.018484 | -0.118218 | ... | -0.089331 | 0.036785 | -0.212622 | -0.029278 | -0.000968 | 0.064196 | -0.131667 | -0.003211 | -0.014206 | 0.144246 |
IPEQOJ | -0.076676 | -0.244437 | 0.075963 | -0.168068 | 0.078704 | -0.016815 | -0.023533 | -0.071065 | 0.019000 | -0.148650 | ... | 0.159429 | -0.144813 | -0.013204 | -0.019081 | 0.001790 | -0.041838 | -0.293812 | -0.024490 | -0.001484 | 0.049787 |
I16JN2 | 0.059431 | 0.109269 | -0.023845 | 0.011723 | -0.017583 | -0.050680 | -0.152575 | 0.089733 | 0.100866 | 0.106064 | ... | -0.044412 | -0.077350 | -0.014351 | 0.215837 | 0.033010 | 0.140401 | -0.089534 | 0.029339 | 0.067671 | 0.029738 |
2FVOVY | -0.039170 | 0.098170 | -0.087765 | 0.083873 | -0.155663 | 0.033068 | -0.077897 | -0.059236 | 0.160577 | -0.124213 | ... | 0.023642 | -0.057868 | 0.118940 | -0.030404 | 0.053724 | -0.064940 | -0.166850 | 0.116062 | -0.092077 | 0.009106 |
RVOESG | 0.227369 | 0.017560 | -0.151415 | -0.003364 | -0.134015 | 0.060412 | 0.041392 | 0.034815 | 0.150123 | -0.047575 | ... | 0.164046 | -0.101573 | 0.102281 | 0.083103 | 0.203684 | 0.044545 | 0.003126 | 0.026780 | 0.061906 | 0.092121 |
UF44C1 | 0.174383 | -0.107409 | -0.065850 | -0.139600 | -0.035484 | 0.009610 | 0.018426 | -0.028791 | -0.001508 | 0.030721 | ... | 0.188744 | 0.039629 | -0.182632 | 0.062833 | -0.010797 | -0.038308 | -0.000119 | 0.045929 | 0.008082 | -0.196223 |
PGA19D | 0.193837 | -0.003282 | -0.017488 | 0.059443 | 0.070972 | -0.101700 | -0.071103 | -0.153089 | 0.061322 | -0.015510 | ... | 0.025861 | -0.048693 | -0.137421 | 0.014489 | 0.016284 | -0.189485 | 0.078134 | -0.097223 | -0.035152 | -0.012949 |
JDVC5V | 0.113560 | -0.043280 | -0.029630 | 0.168976 | -0.220571 | -0.047286 | 0.062547 | -0.015243 | 0.063206 | -0.112609 | ... | -0.103999 | -0.083857 | 0.084353 | -0.090232 | 0.005081 | -0.087311 | 0.110606 | 0.015349 | 0.135133 | 0.088063 |
DLK84Z | 0.042705 | -0.051406 | -0.260070 | 0.130468 | 0.032679 | -0.063830 | -0.192126 | -0.043673 | 0.024177 | 0.025604 | ... | 0.032282 | 0.026272 | 0.002256 | 0.027891 | 0.173233 | 0.041182 | -0.154549 | -0.001246 | -0.100156 | 0.131698 |
Y0XQVS | -0.066325 | 0.026217 | 0.061642 | -0.123228 | -0.096771 | -0.038031 | 0.131688 | -0.143370 | -0.058581 | 0.026561 | ... | 0.189597 | -0.021942 | 0.234974 | 0.044663 | -0.067522 | -0.053283 | -0.030684 | -0.018734 | -0.111798 | -0.023336 |
EXW8Z5 | -0.059575 | 0.017001 | -0.007593 | -0.138766 | -0.091991 | 0.288963 | 0.092817 | 0.139564 | -0.025316 | -0.020227 | ... | -0.060599 | 0.045253 | -0.102054 | -0.221498 | 0.157376 | 0.004267 | -0.014119 | -0.191489 | -0.019425 | 0.010490 |
YQNYU2 | -0.118696 | 0.000634 | -0.006821 | 0.017378 | -0.125794 | -0.189958 | -0.075994 | -0.003029 | -0.051968 | -0.006153 | ... | -0.240948 | 0.068768 | -0.017474 | 0.022610 | 0.023267 | 0.050804 | -0.017076 | -0.046297 | 0.103872 | -0.009835 |
ISCM2J | 0.078247 | 0.045650 | -0.082359 | -0.030152 | 0.105079 | -0.116387 | 0.108377 | 0.039316 | 0.029162 | 0.112234 | ... | 0.013093 | -0.102246 | 0.165209 | 0.019511 | 0.072228 | -0.158185 | 0.130529 | -0.005660 | -0.034829 | 0.079522 |
UCBZBF | 0.130963 | 0.060181 | 0.115199 | 0.099336 | 0.162116 | 0.068197 | -0.171178 | -0.180729 | 0.129752 | 0.029650 | ... | 0.122032 | 0.123955 | 0.092309 | 0.219081 | -0.091310 | 0.019493 | -0.029473 | -0.025237 | -0.043579 | 0.079528 |
UATVRR | 0.049774 | -0.059787 | 0.073570 | 0.093958 | -0.138686 | 0.114907 | 0.042503 | -0.072086 | -0.199548 | 0.016499 | ... | -0.159451 | 0.061144 | 0.062537 | -0.106653 | 0.132448 | -0.064011 | -0.050183 | -0.070771 | 0.185609 | -0.082748 |
6957TY | 0.111341 | 0.014419 | -0.104692 | 0.009446 | -0.025077 | 0.087602 | -0.117114 | 0.061419 | 0.042050 | 0.127125 | ... | -0.012597 | -0.134220 | 0.218107 | 0.041930 | 0.162632 | 0.032049 | -0.028650 | -0.009370 | -0.086125 | 0.097789 |
H6JK7N | -0.017882 | -0.010903 | 0.055709 | -0.127937 | 0.095167 | 0.030073 | 0.023787 | -0.054757 | 0.140609 | 0.084974 | ... | 0.155643 | 0.068325 | -0.058166 | 0.209403 | -0.046772 | 0.036621 | 0.096155 | -0.038168 | -0.012315 | 0.081464 |
330BMJ | 0.007107 | -0.087716 | -0.058207 | 0.047380 | -0.029743 | 0.102565 | -0.158479 | -0.033691 | -0.144276 | -0.031831 | ... | 0.073488 | -0.081000 | -0.076235 | 0.064844 | -0.003260 | -0.015024 | 0.078486 | -0.021106 | -0.063537 | 0.001113 |
ESQ075 | -0.078978 | 0.049876 | 0.014557 | -0.120492 | 0.013057 | -0.023523 | 0.015361 | 0.017215 | -0.038590 | -0.046602 | ... | 0.040348 | -0.003077 | -0.084516 | -0.030625 | 0.047197 | -0.075745 | -0.107054 | -0.067800 | -0.036559 | -0.159747 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
P6RHYE | -0.015594 | -0.079265 | 0.039967 | -0.081803 | 0.031064 | 0.108944 | -0.012870 | 0.019235 | 0.026492 | -0.087275 | ... | -0.013126 | -0.025538 | -0.008685 | -0.015274 | -0.058383 | 0.068800 | 0.073037 | -0.026156 | -0.175359 | -0.053478 |
56AB42 | -0.112677 | 0.179052 | 0.016724 | 0.192387 | -0.002018 | 0.056441 | -0.070573 | -0.039749 | -0.053089 | -0.005103 | ... | 0.046756 | -0.043886 | -0.121862 | 0.275379 | -0.144679 | 0.095463 | 0.102077 | -0.001985 | 0.085544 | -0.120180 |
O9X09A | -0.059738 | -0.075375 | 0.053959 | 0.132054 | -0.080188 | -0.049783 | -0.131841 | -0.062237 | -0.012540 | -0.082035 | ... | -0.038890 | 0.007893 | -0.052944 | 0.166312 | -0.185403 | -0.159251 | 0.100047 | 0.110050 | 0.050798 | -0.029342 |
4GT5TO | -0.022626 | 0.128556 | 0.040496 | 0.114665 | -0.000403 | -0.046686 | 0.010378 | 0.060446 | -0.132979 | -0.037352 | ... | -0.069689 | -0.045534 | 0.067885 | 0.000955 | -0.022087 | 0.178404 | 0.000623 | 0.190482 | -0.190278 | 0.031173 |
XREJWU | 0.096806 | 0.089167 | -0.081842 | 0.005391 | -0.005366 | -0.086337 | -0.008731 | 0.019142 | 0.241388 | 0.022575 | ... | -0.013416 | -0.087217 | -0.025173 | -0.066110 | -0.211074 | 0.020182 | 0.160487 | -0.003259 | 0.126846 | -0.084220 |
N2H26D | 0.165886 | -0.138662 | -0.003324 | -0.140471 | -0.045750 | -0.025775 | -0.007580 | 0.088208 | 0.005386 | -0.078514 | ... | 0.092092 | 0.028489 | 0.002960 | 0.018769 | -0.035380 | 0.076948 | 0.170013 | 0.135174 | -0.255188 | -0.112149 |
VJZC2C | 0.293807 | 0.079028 | -0.110681 | -0.000373 | 0.031476 | -0.063734 | 0.160271 | 0.067942 | 0.071357 | 0.171816 | ... | 0.065333 | -0.035103 | 0.036239 | 0.147409 | 0.194107 | -0.056885 | -0.039534 | 0.048260 | -0.112668 | 0.031931 |
OY9W6N | -0.008877 | -0.001371 | -0.100800 | 0.074783 | -0.004014 | 0.061870 | 0.123631 | -0.023247 | 0.046474 | -0.072906 | ... | 0.009351 | 0.084252 | -0.202579 | -0.162574 | -0.220139 | 0.130522 | -0.062369 | -0.063759 | 0.114983 | -0.006631 |
0VSKAB | 0.054264 | -0.106843 | 0.029538 | 0.076949 | 0.076842 | -0.046781 | 0.052230 | -0.018516 | -0.005203 | 0.051738 | ... | 0.094860 | -0.190884 | -0.095440 | -0.031167 | -0.065040 | -0.055781 | 0.200611 | -0.098685 | -0.004697 | -0.025696 |
W7IEG3 | -0.117560 | 0.161196 | -0.108812 | 0.135007 | -0.055454 | -0.067473 | 0.107935 | 0.126018 | 0.022616 | -0.005151 | ... | 0.044805 | -0.022020 | 0.137196 | 0.116161 | 0.046906 | -0.184834 | 0.066891 | -0.021835 | 0.068633 | -0.048358 |
ZGV7RO | 0.049230 | 0.134409 | 0.052505 | -0.101394 | 0.223856 | -0.036113 | -0.025055 | -0.000544 | -0.040791 | 0.097266 | ... | -0.062164 | 0.119553 | 0.025797 | 0.161077 | -0.076322 | 0.074277 | 0.116211 | 0.042054 | -0.171242 | 0.017233 |
AITBKL | -0.122629 | -0.001526 | -0.069801 | -0.028750 | 0.095965 | 0.036599 | -0.029236 | -0.047541 | -0.003589 | 0.017027 | ... | 0.115293 | 0.026872 | -0.084482 | 0.252763 | -0.111743 | 0.077428 | 0.073224 | -0.068699 | -0.207540 | 0.076047 |
NKGSIZ | -0.097293 | -0.000378 | 0.048682 | 0.022250 | -0.202675 | 0.028460 | -0.096068 | -0.003174 | -0.105217 | -0.014594 | ... | 0.010943 | -0.026502 | -0.125799 | -0.021532 | -0.136799 | -0.062039 | 0.032881 | 0.107384 | 0.085544 | -0.083605 |
MJSV85 | 0.050902 | 0.093256 | -0.155774 | 0.078373 | -0.054267 | 0.018772 | 0.018023 | 0.002714 | 0.146912 | 0.044238 | ... | -0.049454 | 0.081615 | 0.021794 | -0.122698 | -0.074740 | -0.119201 | 0.129012 | -0.118767 | 0.064535 | 0.044809 |
KO9J5T | -0.033722 | -0.000561 | 0.071853 | 0.034396 | 0.121747 | -0.013664 | -0.133038 | 0.072615 | 0.065028 | -0.159769 | ... | -0.081222 | 0.014632 | 0.011482 | -0.090030 | 0.071944 | 0.026110 | -0.122917 | 0.093639 | 0.048857 | -0.059141 |
RLCCGC | -0.041178 | -0.104867 | 0.211733 | 0.122818 | -0.038433 | -0.063337 | -0.035688 | -0.078340 | -0.014154 | -0.006970 | ... | -0.078947 | -0.016266 | -0.061610 | 0.085913 | 0.053769 | 0.099599 | 0.076839 | -0.220200 | 0.112472 | -0.161200 |
5DUIH8 | 0.045551 | 0.033992 | 0.005146 | 0.069636 | -0.024387 | 0.119905 | -0.049495 | -0.118248 | 0.013269 | 0.008702 | ... | 0.078961 | 0.043761 | -0.003857 | -0.016952 | 0.065594 | -0.029922 | 0.102262 | 0.095469 | 0.020048 | 0.032094 |
8G6PLF | -0.149504 | -0.026678 | 0.033632 | -0.064720 | 0.082215 | -0.078751 | 0.072619 | 0.098373 | -0.013720 | -0.014395 | ... | 0.090758 | -0.079861 | -0.062378 | -0.015020 | -0.125453 | 0.043740 | -0.019046 | -0.190688 | -0.001721 | -0.084816 |
A6VGEC | -0.025418 | 0.153582 | 0.098096 | -0.068060 | -0.168270 | -0.108180 | -0.170801 | -0.024095 | -0.176773 | 0.027008 | ... | -0.016353 | 0.010926 | -0.008177 | 0.090234 | -0.146082 | -0.053165 | -0.077828 | -0.060941 | 0.203215 | 0.005512 |
6FEKPU | 0.011016 | -0.011012 | -0.014958 | -0.221360 | -0.115630 | 0.129884 | 0.065156 | 0.067850 | -0.014829 | 0.033402 | ... | -0.029008 | 0.016895 | 0.034388 | 0.015650 | 0.133752 | -0.045900 | 0.073205 | 0.076714 | -0.144819 | 0.021404 |
H7QKIS | 0.072356 | 0.037599 | -0.057978 | 0.064893 | -0.014020 | 0.045543 | 0.046496 | -0.150006 | 0.014487 | 0.081403 | ... | 1.000000 | 0.053435 | -0.106573 | 0.163033 | -0.033740 | -0.012037 | -0.119384 | 0.034395 | -0.067098 | -0.128799 |
D0W5AK | -0.136417 | -0.082140 | -0.035274 | 0.013298 | -0.004580 | -0.111387 | -0.055670 | -0.096910 | 0.019837 | 0.181426 | ... | 0.053435 | 1.000000 | -0.018232 | -0.100966 | 0.018382 | -0.072131 | -0.098042 | 0.036912 | -0.090763 | -0.032947 |
F1DMC8 | 0.201655 | 0.198644 | -0.063702 | -0.093173 | 0.045299 | -0.004978 | -0.041901 | 0.000894 | -0.032611 | 0.118716 | ... | -0.106573 | -0.018232 | 1.000000 | 0.059346 | 0.066110 | 0.157075 | 0.033966 | 0.078616 | 0.027675 | 0.116599 |
2HNMFQ | -0.195233 | 0.153121 | 0.141662 | 0.020214 | -0.001465 | -0.209402 | -0.163152 | -0.147773 | 0.013939 | 0.034379 | ... | 0.163033 | -0.100966 | 0.059346 | 1.000000 | 0.010418 | 0.111289 | 0.053477 | 0.038144 | 0.000990 | 0.059003 |
YZLOOD | 0.138774 | -0.001213 | 0.012000 | 0.018604 | -0.088427 | 0.138757 | 0.127931 | 0.080903 | -0.015451 | 0.085478 | ... | -0.033740 | 0.018382 | 0.066110 | 0.010418 | 1.000000 | 0.037689 | -0.093066 | -0.002560 | -0.050792 | 0.020773 |
036XCY | 0.017919 | 0.218880 | 0.020266 | -0.069153 | 0.042292 | 0.091575 | -0.029840 | 0.161829 | 0.074209 | -0.054885 | ... | -0.012037 | -0.072131 | 0.157075 | 0.111289 | 0.037689 | 1.000000 | 0.063860 | -0.047185 | -0.036828 | 0.148369 |
I8HYO1 | 0.187885 | -0.032214 | -0.023459 | 0.019912 | -0.006268 | -0.097798 | 0.079345 | 0.033941 | 0.052577 | -0.097632 | ... | -0.119384 | -0.098042 | 0.033966 | 0.053477 | -0.093066 | 0.063860 | 1.000000 | -0.043563 | 0.010203 | -0.102427 |
NYWBX9 | -0.010005 | -0.038692 | 0.109984 | 0.176726 | -0.136978 | 0.131509 | -0.095447 | 0.161408 | -0.035563 | 0.150435 | ... | 0.034395 | 0.036912 | 0.078616 | 0.038144 | -0.002560 | -0.047185 | -0.043563 | 1.000000 | -0.161375 | 0.077179 |
38ONCM | -0.038841 | 0.029213 | -0.014740 | 0.111016 | -0.082791 | -0.076417 | 0.088280 | -0.142940 | 0.089478 | 0.083764 | ... | -0.067098 | -0.090763 | 0.027675 | 0.000990 | -0.050792 | -0.036828 | 0.010203 | -0.161375 | 1.000000 | -0.128832 |
52OURD | 0.043182 | 0.112070 | 0.051319 | -0.023197 | 0.089159 | 0.097504 | -0.210871 | 0.141235 | 0.044552 | -0.010358 | ... | -0.128799 | -0.032947 | 0.116599 | 0.059003 | 0.020773 | 0.148369 | -0.102427 | 0.077179 | -0.128832 | 1.000000 |
100 rows × 100 columns
We can use imshow
, which is a plotting function for a 2d matrix (actually it's for images), to view the 2d map of this matrix.
imshow(correlations, cmap='hot')
plt.title('Correlations in random data')
plt.colorbar();
# Copy paste to change notebook style to something more contemporary
from IPython.core.display import HTML
import urllib2
HTML(urllib2.urlopen('http://bit.ly/1Bf5Hft').read())