{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "**Table of Contents**\n", "\n", "
\n", "" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Load modules and collect data\n", "- use `sqlite3` (database small enough to be held in memory)" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import os\n", "from os.path import dirname, join\n", "\n", "import numpy as np\n", "import pandas.io.sql as psql\n", "import sqlite3 as sql\n", "\n", "\n", "from bokeh.sampledata.movies_data import movie_path\n", "__file__ = os.path.expanduser('~/git_local/bokeh_original/examples/app/movies/main.py')\n", "conn = sql.connect(movie_path)\n", "query = open(join(dirname(__file__), 'query.sql')).read()\n", "movies = psql.read_sql(query, conn)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "SELECT omdb.ID,\n", " imdbID,\n", " Title,\n", " Year,\n", " omdb.Rating as mpaaRating,\n", " Runtime,\n", " Genre,\n", " Released,\n", " Director,\n", " Writer,\n", " omdb.Cast,\n", " imdbRating,\n", " imdbVotes,\n", " Language,\n", " Country,\n", " Oscars,\n", " tomatoes.Rating as numericRating,\n", " Meter,\n", " Reviews,\n", " Fresh,\n", " Rotten,\n", " userMeter,\n", " userRating,\n", " userReviews,\n", " BoxOffice,\n", " Production\n", "FROM omdb, tomatoes\n", "WHERE omdb.ID = tomatoes.ID AND Reviews >= 10\n", "\n" ] } ], "source": [ "print query" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", " | ID | \n", "imdbID | \n", "Title | \n", "Year | \n", "mpaaRating | \n", "Runtime | \n", "Genre | \n", "Released | \n", "Director | \n", "Writer | \n", "Cast | \n", "imdbRating | \n", "imdbVotes | \n", "Language | \n", "Country | \n", "Oscars | \n", "numericRating | \n", "Meter | \n", "Reviews | \n", "Fresh | \n", "Rotten | \n", "userMeter | \n", "userRating | \n", "userReviews | \n", "BoxOffice | \n", "Production | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "4972 | \n", "tt0004972 | \n", "The Birth of a Nation | \n", "1915 | \n", "Not Rated | \n", "165.0 | \n", "Drama, History, Romance | \n", "1915-03-03 | \n", "D.W. Griffith | \n", "Thomas F. Dixon Jr. (adapted from his novel: \"... | \n", "Lillian Gish, Mae Marsh, Henry B. Walthall, Mi... | \n", "6.9 | \n", "13793.0 | \n", "None | \n", "USA | \n", "0 | \n", "8.0 | \n", "100 | \n", "38 | \n", "38 | \n", "0 | \n", "58.0 | \n", "3.3 | \n", "4034.0 | \n", "NaN | \n", "Gravitas | \n", "
1 | \n", "6206 | \n", "tt0006206 | \n", "Les vampires | \n", "1915 | \n", "Not Rated | \n", "399.0 | \n", "Action, Adventure, Crime | \n", "1915-11-13 | \n", "Louis Feuillade | \n", "Louis Feuillade | \n", "Musidora, Édouard Mathé, Marcel Lévesque, Jean... | \n", "6.6 | \n", "2502.0 | \n", "French | \n", "France | \n", "0 | \n", "8.8 | \n", "100 | \n", "13 | \n", "13 | \n", "0 | \n", "85.0 | \n", "3.8 | \n", "2075.0 | \n", "NaN | \n", "None | \n", "
2 | \n", "6864 | \n", "tt0006864 | \n", "Intolerance: Love's Struggle Throughout the Ages | \n", "1916 | \n", "Not Rated | \n", "197.0 | \n", "Drama, History | \n", "1916-09-05 | \n", "D.W. Griffith | \n", "D.W. Griffith (scenario), Anita Loos (titles) | \n", "Lillian Gish, Spottiswoode Aitken, Mary Alden,... | \n", "8.0 | \n", "8673.0 | \n", "None | \n", "USA | \n", "0 | \n", "8.0 | \n", "96 | \n", "28 | \n", "27 | \n", "1 | \n", "78.0 | \n", "3.8 | \n", "4604.0 | \n", "NaN | \n", "Cohen Media Group | \n", "
\n", " | ID | \n", "Year | \n", "Runtime | \n", "imdbRating | \n", "imdbVotes | \n", "Oscars | \n", "numericRating | \n", "Meter | \n", "Reviews | \n", "Fresh | \n", "Rotten | \n", "userMeter | \n", "userRating | \n", "userReviews | \n", "BoxOffice | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "1.2569e+04 | \n", "12569.0000 | \n", "12569.0000 | \n", "12549.0000 | \n", "1.2548e+04 | \n", "12569.0000 | \n", "12569.0000 | \n", "12569.0000 | \n", "12569.0000 | \n", "12569.0000 | \n", "12569.0000 | \n", "12478.0000 | \n", "12358.0000 | \n", "1.2557e+04 | \n", "4.1890e+03 | \n", "
mean | \n", "5.8837e+05 | \n", "1996.3287 | \n", "102.7464 | \n", "6.6102 | \n", "2.7486e+04 | \n", "0.1071 | \n", "6.0808 | \n", "62.6467 | \n", "52.4545 | \n", "32.4200 | \n", "20.0345 | \n", "64.2593 | \n", "3.4025 | \n", "1.8156e+05 | \n", "3.0246e+07 | \n", "
std | \n", "6.5278e+05 | \n", "17.6909 | \n", "23.5299 | \n", "1.0107 | \n", "6.5074e+04 | \n", "0.6050 | \n", "1.4497 | \n", "27.5983 | \n", "52.6809 | \n", "38.3948 | \n", "27.1021 | \n", "19.8652 | \n", "0.4614 | \n", "1.9692e+06 | \n", "5.7222e+07 | \n", "
min | \n", "4.9720e+03 | \n", "1902.0000 | \n", "0.0000 | \n", "1.1000 | \n", "5.0000e+00 | \n", "0.0000 | \n", "1.1000 | \n", "0.0000 | \n", "10.0000 | \n", "0.0000 | \n", "0.0000 | \n", "0.0000 | \n", "0.5000 | \n", "2.0000e+00 | \n", "3.8200e+02 | \n", "
25% | \n", "1.0386e+05 | \n", "1991.0000 | \n", "91.0000 | \n", "6.0000 | \n", "1.5518e+03 | \n", "0.0000 | \n", "5.1000 | \n", "41.0000 | \n", "16.0000 | \n", "9.0000 | \n", "4.0000 | \n", "50.0000 | \n", "3.1000 | \n", "1.4560e+03 | \n", "2.0000e+05 | \n", "
50% | \n", "3.0021e+05 | \n", "2002.0000 | \n", "100.0000 | \n", "6.7000 | \n", "5.6120e+03 | \n", "0.0000 | \n", "6.2000 | \n", "69.0000 | \n", "30.0000 | \n", "18.0000 | \n", "9.0000 | \n", "67.0000 | \n", "3.4000 | \n", "6.7600e+03 | \n", "5.1000e+06 | \n", "
75% | \n", "9.9717e+05 | \n", "2008.0000 | \n", "112.0000 | \n", "7.3000 | \n", "2.2700e+04 | \n", "0.0000 | \n", "7.2000 | \n", "86.0000 | \n", "68.0000 | \n", "40.0000 | \n", "23.0000 | \n", "81.0000 | \n", "3.7000 | \n", "4.1481e+04 | \n", "3.6000e+07 | \n", "
max | \n", "3.4041e+06 | \n", "2014.0000 | \n", "566.0000 | \n", "9.3000 | \n", "1.1875e+06 | \n", "11.0000 | \n", "10.0000 | \n", "100.0000 | \n", "304.0000 | \n", "292.0000 | \n", "192.0000 | \n", "99.0000 | \n", "5.0000 | \n", "3.5778e+07 | \n", "7.6050e+08 | \n", "
\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "10 | \n", "11 | \n", "12 | \n", "13 | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "21 | \n", "22 | \n", "23 | \n", "24 | \n", "25 | \n", "26 | \n", "27 | \n", "28 | \n", "29 | \n", "30 | \n", "31 | \n", "32 | \n", "33 | \n", "34 | \n", "35 | \n", "36 | \n", "37 | \n", "38 | \n", "39 | \n", "40 | \n", "41 | \n", "42 | \n", "43 | \n", "44 | \n", "45 | \n", "46 | \n", "47 | \n", "48 | \n", "49 | \n", "50 | \n", "51 | \n", "52 | \n", "53 | \n", "54 | \n", "55 | \n", "56 | \n", "57 | \n", "58 | \n", "59 | \n", "60 | \n", "61 | \n", "62 | \n", "63 | \n", "64 | \n", "65 | \n", "66 | \n", "67 | \n", "68 | \n", "69 | \n", "70 | \n", "71 | \n", "72 | \n", "73 | \n", "74 | \n", "75 | \n", "76 | \n", "77 | \n", "78 | \n", "79 | \n", "80 | \n", "81 | \n", "82 | \n", "83 | \n", "84 | \n", "85 | \n", "86 | \n", "87 | \n", "88 | \n", "89 | \n", "90 | \n", "91 | \n", "92 | \n", "93 | \n", "94 | \n", "95 | \n", "96 | \n", "97 | \n", "98 | \n", "99 | \n", "100 | \n", "101 | \n", "102 | \n", "103 | \n", "104 | \n", "105 | \n", "106 | \n", "107 | \n", "108 | \n", "109 | \n", "110 | \n", "111 | \n", "112 | \n", "113 | \n", "114 | \n", "115 | \n", "116 | \n", "117 | \n", "118 | \n", "119 | \n", "120 | \n", "121 | \n", "122 | \n", "123 | \n", "124 | \n", "125 | \n", "126 | \n", "127 | \n", "128 | \n", "129 | \n", "130 | \n", "131 | \n", "132 | \n", "133 | \n", "134 | \n", "135 | \n", "136 | \n", "137 | \n", "138 | \n", "139 | \n", "140 | \n", "141 | \n", "142 | \n", "143 | \n", "144 | \n", "145 | \n", "146 | \n", "147 | \n", "148 | \n", "149 | \n", "150 | \n", "151 | \n", "152 | \n", "153 | \n", "154 | \n", "155 | \n", "156 | \n", "157 | \n", "158 | \n", "159 | \n", "160 | \n", "161 | \n", "162 | \n", "163 | \n", "164 | \n", "165 | \n", "166 | \n", "167 | \n", "168 | \n", "169 | \n", "170 | \n", "171 | \n", "172 | \n", "173 | \n", "174 | \n", "175 | \n", "176 | \n", "177 | \n", "178 | \n", "179 | \n", "180 | \n", "181 | \n", "182 | \n", "183 | \n", "184 | \n", "185 | \n", "186 | \n", "187 | \n", "188 | \n", "189 | \n", "190 | \n", "191 | \n", "192 | \n", "193 | \n", "194 | \n", "195 | \n", "196 | \n", "197 | \n", "198 | \n", "199 | \n", "200 | \n", "201 | \n", "202 | \n", "203 | \n", "204 | \n", "205 | \n", "206 | \n", "207 | \n", "208 | \n", "209 | \n", "210 | \n", "211 | \n", "212 | \n", "213 | \n", "214 | \n", "215 | \n", "216 | \n", "217 | \n", "218 | \n", "219 | \n", "220 | \n", "221 | \n", "222 | \n", "223 | \n", "224 | \n", "225 | \n", "226 | \n", "227 | \n", "228 | \n", "229 | \n", "230 | \n", "231 | \n", "232 | \n", "233 | \n", "234 | \n", "235 | \n", "236 | \n", "237 | \n", "238 | \n", "239 | \n", "240 | \n", "241 | \n", "242 | \n", "243 | \n", "244 | \n", "245 | \n", "246 | \n", "247 | \n", "248 | \n", "249 | \n", "... | \n", "12319 | \n", "12320 | \n", "12321 | \n", "12322 | \n", "12323 | \n", "12324 | \n", "12325 | \n", "12326 | \n", "12327 | \n", "12328 | \n", "12329 | \n", "12330 | \n", "12331 | \n", "12332 | \n", "12333 | \n", "12334 | \n", "12335 | \n", "12336 | \n", "12337 | \n", "12338 | \n", "12339 | \n", "12340 | \n", "12341 | \n", "12342 | \n", "12343 | \n", "12344 | \n", "12345 | \n", "12346 | \n", "12347 | \n", "12348 | \n", "12349 | \n", "12350 | \n", "12351 | \n", "12352 | \n", "12353 | \n", "12354 | \n", "12355 | \n", "12356 | \n", "12357 | \n", "12358 | \n", "12359 | \n", "12360 | \n", "12361 | \n", "12362 | \n", "12363 | \n", "12364 | \n", "12365 | \n", "12366 | \n", "12367 | \n", "12368 | \n", "12369 | \n", "12370 | \n", "12371 | \n", "12372 | \n", "12373 | \n", "12374 | \n", "12375 | \n", "12376 | \n", "12377 | \n", "12378 | \n", "12379 | \n", "12380 | \n", "12381 | \n", "12382 | \n", "12383 | \n", "12384 | \n", "12385 | \n", "12386 | \n", "12387 | \n", "12388 | \n", "12389 | \n", "12390 | \n", "12391 | \n", "12392 | \n", "12393 | \n", "12394 | \n", "12395 | \n", "12396 | \n", "12397 | \n", "12398 | \n", "12399 | \n", "12400 | \n", "12401 | \n", "12402 | \n", "12403 | \n", "12404 | \n", "12405 | \n", "12406 | \n", "12407 | \n", "12408 | \n", "12409 | \n", "12410 | \n", "12411 | \n", "12412 | \n", "12413 | \n", "12414 | \n", "12415 | \n", "12416 | \n", "12417 | \n", "12418 | \n", "12419 | \n", "12420 | \n", "12421 | \n", "12422 | \n", "12423 | \n", "12424 | \n", "12425 | \n", "12426 | \n", "12427 | \n", "12428 | \n", "12429 | \n", "12430 | \n", "12431 | \n", "12432 | \n", "12433 | \n", "12434 | \n", "12435 | \n", "12436 | \n", "12437 | \n", "12438 | \n", "12439 | \n", "12440 | \n", "12441 | \n", "12442 | \n", "12443 | \n", "12444 | \n", "12445 | \n", "12446 | \n", "12447 | \n", "12448 | \n", "12449 | \n", "12450 | \n", "12451 | \n", "12452 | \n", "12453 | \n", "12454 | \n", "12455 | \n", "12456 | \n", "12457 | \n", "12458 | \n", "12459 | \n", "12460 | \n", "12461 | \n", "12462 | \n", "12463 | \n", "12464 | \n", "12465 | \n", "12466 | \n", "12467 | \n", "12468 | \n", "12469 | \n", "12470 | \n", "12471 | \n", "12472 | \n", "12473 | \n", "12474 | \n", "12475 | \n", "12476 | \n", "12477 | \n", "12478 | \n", "12479 | \n", "12480 | \n", "12481 | \n", "12482 | \n", "12483 | \n", "12484 | \n", "12485 | \n", "12486 | \n", "12487 | \n", "12488 | \n", "12489 | \n", "12490 | \n", "12491 | \n", "12492 | \n", "12493 | \n", "12494 | \n", "12495 | \n", "12496 | \n", "12497 | \n", "12498 | \n", "12499 | \n", "12500 | \n", "12501 | \n", "12502 | \n", "12503 | \n", "12504 | \n", "12505 | \n", "12506 | \n", "12507 | \n", "12508 | \n", "12509 | \n", "12510 | \n", "12511 | \n", "12512 | \n", "12513 | \n", "12514 | \n", "12515 | \n", "12516 | \n", "12517 | \n", "12518 | \n", "12519 | \n", "12520 | \n", "12521 | \n", "12522 | \n", "12523 | \n", "12524 | \n", "12525 | \n", "12526 | \n", "12527 | \n", "12528 | \n", "12529 | \n", "12530 | \n", "12531 | \n", "12532 | \n", "12533 | \n", "12534 | \n", "12535 | \n", "12536 | \n", "12537 | \n", "12538 | \n", "12539 | \n", "12540 | \n", "12541 | \n", "12542 | \n", "12543 | \n", "12544 | \n", "12545 | \n", "12546 | \n", "12547 | \n", "12548 | \n", "12549 | \n", "12550 | \n", "12551 | \n", "12552 | \n", "12553 | \n", "12554 | \n", "12555 | \n", "12556 | \n", "12557 | \n", "12558 | \n", "12559 | \n", "12560 | \n", "12561 | \n", "12562 | \n", "12563 | \n", "12564 | \n", "12565 | \n", "12566 | \n", "12567 | \n", "12568 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
color | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "orange | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "orange | \n", "orange | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "... | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "orange | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "grey | \n", "
alpha | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.9 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "... | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.9 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "0.25 | \n", "
2 rows × 12569 columns
\n", "