{ "cells": [ { "cell_type": "code", "id": "initial_id", "metadata": { "collapsed": true, "ExecuteTime": { "end_time": "2024-04-30T17:02:20.755555100Z", "start_time": "2024-04-30T17:02:19.059300700Z" } }, "source": [ "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "%matplotlib inline\n", "from data import load_data, categorize_metadata" ], "outputs": [], "execution_count": 1 }, { "metadata": { "ExecuteTime": { "end_time": "2024-04-30T17:02:21.016157300Z", "start_time": "2024-04-30T17:02:20.755555100Z" } }, "cell_type": "code", "source": [ "metadata, experiments = load_data(\"train\", \"\")\n", "metadata" ], "id": "125d760bf8c9de8d", "outputs": [ { "data": { "text/plain": " strain replica phase objective substrate laser_power[%] grating \\\n0 CHA0 3.0 liquid 50 alu 100 1800 \n1 CHA0 NaN solid 50 alu 100 1800 \n2 F113 2.0 solid 50 alu 100 1800 \n3 A390 3.0 liquid 50 alu 100 1800 \n4 A390 2.0 solid 50 alu 100 1800 \n.. ... ... ... ... ... ... ... \n523 F113 3.0 liquid 50 alu 100 1800 \n524 CHA0 1.0 liquid 50 alu 100 1800 \n525 F113 2.0 solid 50 alu 100 1800 \n526 CHA0 3.0 liquid 50 alu 100 1800 \n527 F113 2.0 solid 50 alu 100 1800 \n\n exposition[sec] confocalhigh accumulations \n0 20 True 2 \n1 20 True 2 \n2 20 True 2 \n3 20 True 2 \n4 20 True 2 \n.. ... ... ... \n523 20 True 2 \n524 20 True 2 \n525 20 True 2 \n526 20 True 2 \n527 20 True 2 \n\n[528 rows x 10 columns]", "text/html": "
| \n | strain | \nreplica | \nphase | \nobjective | \nsubstrate | \nlaser_power[%] | \ngrating | \nexposition[sec] | \nconfocalhigh | \naccumulations | \n
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \nCHA0 | \n3.0 | \nliquid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 1 | \nCHA0 | \nNaN | \nsolid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 2 | \nF113 | \n2.0 | \nsolid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 3 | \nA390 | \n3.0 | \nliquid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 4 | \nA390 | \n2.0 | \nsolid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| ... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
| 523 | \nF113 | \n3.0 | \nliquid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 524 | \nCHA0 | \n1.0 | \nliquid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 525 | \nF113 | \n2.0 | \nsolid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 526 | \nCHA0 | \n3.0 | \nliquid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
| 527 | \nF113 | \n2.0 | \nsolid | \n50 | \nalu | \n100 | \n1800 | \n20 | \nTrue | \n2 | \n
528 rows × 10 columns
\n| \n | objective | \nlaser_power[%] | \ngrating | \nexposition[sec] | \naccumulations | \nphase_liquid | \nphase_solid | \nsubstrate_alu | \nconfocalhigh_True | \n
|---|---|---|---|---|---|---|---|---|---|
| 0 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n
| 1 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n
| 2 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n
| 3 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n
| 4 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n
| ... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
| 523 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n
| 524 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n
| 525 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n
| 526 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n
| 527 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n
528 rows × 9 columns
\n| \n | 181 | \n182 | \n183 | \n184 | \n185 | \n186 | \n187 | \n188 | \n189 | \n190 | \n... | \n1917 | \n1918 | \n1919 | \n1920 | \n1921 | \n1922 | \n1923 | \n1924 | \n1925 | \n1926 | \n
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n2030.861866 | \n2043.768053 | \n2055.920044 | \n2064.173827 | \n2064.413277 | \n2037.293374 | \n2015.221563 | \n2005.448102 | \n1996.382385 | \n1988.599936 | \n... | \n2885.421944 | \n2927.555782 | \n2874.978419 | \n2807.984727 | \n2822.958246 | \n2844.638489 | \n2864.405921 | \n2829.313862 | \n2822.088791 | \n2838.136140 | \n
| 1 | \n7852.938583 | \n7789.226133 | \n7729.871034 | \n7684.749948 | \n7635.234416 | \n7575.407729 | \n7531.087425 | \n7513.945003 | \n7492.789443 | \n7466.307342 | \n... | \n11493.612790 | \n11719.259088 | \n11670.631211 | \n11579.719393 | \n11576.039468 | \n11605.911636 | \n11624.620016 | \n11498.723551 | \n11534.855892 | \n11661.783201 | \n
| 2 | \n4362.354997 | \n4433.595406 | \n4451.034918 | \n4352.237791 | \n4266.765683 | \n4203.135641 | \n4177.874050 | \n4200.404837 | \n4199.451920 | \n4175.915090 | \n... | \n5140.455999 | \n5071.298680 | \n5147.605334 | \n5196.152590 | \n5132.106504 | \n5099.248095 | \n5071.851922 | \n5029.698197 | \n5049.829455 | \n5095.167409 | \n
| 3 | \n3676.144213 | \n3680.582217 | \n3679.503966 | \n3649.913908 | \n3622.135514 | \n3600.541786 | \n3596.431925 | \n3634.916913 | \n3649.184314 | \n3619.540757 | \n... | \n5361.827220 | \n5296.784607 | \n5312.611270 | \n5343.476227 | \n5316.028557 | \n5315.315095 | \n5325.196162 | \n5292.517723 | \n5337.812719 | \n5448.225282 | \n
| 4 | \n9873.391244 | \n9896.587508 | \n9884.553562 | \n9796.404872 | \n9705.894800 | \n9611.514004 | \n9593.564386 | \n9670.818710 | \n9651.071648 | \n9538.039870 | \n... | \n17184.220925 | \n17169.826221 | \n17194.941818 | \n17200.982284 | \n17151.063092 | \n17082.008985 | \n17024.961405 | \n17032.450041 | \n17168.732873 | \n17305.712763 | \n
| ... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
| 523 | \n2084.041170 | \n2021.638070 | \n1978.476575 | \n2034.768953 | \n2063.089691 | \n1995.920765 | \n1958.470371 | \n1993.421365 | \n2005.578679 | \n1976.406840 | \n... | \n3254.670796 | \n3261.366502 | \n3272.676517 | \n3278.115278 | \n3251.436367 | \n3210.008681 | \n3172.244319 | \n3249.871217 | \n3260.952953 | \n3216.461160 | \n
| 524 | \n7243.554940 | \n7232.422883 | \n7210.338436 | \n7152.476179 | \n7118.142932 | \n7139.018310 | \n7138.782155 | \n7101.544029 | \n7035.620040 | \n6931.622011 | \n... | \n9995.081816 | \n9932.822669 | \n10030.510762 | \n10121.979900 | \n10067.985582 | \n9990.683366 | \n9914.801509 | \n9903.585600 | \n9918.220675 | \n9950.592656 | \n
| 525 | \n6290.164064 | \n6285.578797 | \n6260.533539 | \n6191.284547 | \n6167.541016 | \n6218.388989 | \n6221.357782 | \n6164.687474 | \n6142.045859 | \n6152.129107 | \n... | \n10824.400770 | \n10802.906442 | \n10733.806089 | \n10672.337683 | \n10644.521395 | \n10620.716495 | \n10611.719473 | \n10651.781342 | \n10684.854706 | \n10702.353518 | \n
| 526 | \n5327.836545 | \n5401.122331 | \n5456.359102 | \n5418.306128 | \n5383.273787 | \n5358.553291 | \n5334.995174 | \n5314.268889 | \n5303.749689 | \n5311.737819 | \n... | \n9694.848556 | \n9704.488708 | \n9743.374621 | \n9762.006943 | \n9649.631146 | \n9593.338048 | \n9579.071631 | \n9666.939860 | \n9703.644841 | \n9697.622114 | \n
| 527 | \n8195.034277 | \n8192.678071 | \n8162.267898 | \n8071.247233 | \n8010.268057 | \n7998.532200 | \n7976.096146 | \n7940.331751 | \n7887.197385 | \n7817.358591 | \n... | \n8722.159925 | \n8719.149837 | \n8676.622386 | \n8661.970062 | \n8722.639885 | \n8673.858473 | \n8616.453751 | \n8648.938599 | \n8698.230708 | \n8733.806260 | \n
528 rows × 1746 columns
\n| \n | objective | \nlaser_power[%] | \ngrating | \nexposition[sec] | \naccumulations | \nphase_liquid | \nphase_solid | \nsubstrate_alu | \nconfocalhigh_True | \n181 | \n... | \n1917 | \n1918 | \n1919 | \n1920 | \n1921 | \n1922 | \n1923 | \n1924 | \n1925 | \n1926 | \n
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n-0.299485 | \n... | \n-0.099779 | \n-0.133344 | \n-0.233556 | \n-0.353051 | \n-0.412390 | \n-0.375944 | \n-0.337513 | \n-0.373616 | \n-0.401737 | \n-0.387572 | \n
| 1 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n-0.071990 | \n... | \n-0.361364 | \n-0.286732 | \n-0.254597 | \n-0.273810 | \n-0.311510 | \n-0.330628 | \n-0.354670 | \n-0.391580 | \n-0.375889 | \n-0.265337 | \n
| 2 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n-0.129200 | \n... | \n-0.229192 | \n-0.202971 | \n-0.191374 | \n-0.181775 | \n-0.191283 | \n-0.314714 | \n-0.439199 | \n-0.495830 | \n-0.485446 | \n-0.387097 | \n
| 3 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n-0.281426 | \n... | \n-0.269852 | \n-0.275944 | \n-0.305332 | \n-0.323362 | \n-0.301384 | \n-0.333912 | \n-0.379791 | \n-0.376634 | \n-0.287635 | \n-0.072417 | \n
| 4 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n-0.232889 | \n... | \n-0.309343 | \n-0.328670 | \n-0.326767 | \n-0.332768 | \n-0.361922 | \n-0.411394 | \n-0.440068 | \n-0.432535 | \n-0.373218 | \n-0.245863 | \n
| ... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
| 523 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n-0.090060 | \n... | \n-0.167459 | \n-0.165322 | \n-0.132145 | \n-0.140044 | \n-0.275117 | \n-0.372081 | \n-0.371779 | \n-0.283918 | \n-0.235794 | \n-0.310222 | \n
| 524 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n0.218434 | \n... | \n-0.396873 | \n-0.336000 | \n-0.216534 | \n-0.114254 | \n-0.136184 | \n-0.355353 | \n-0.594436 | \n-0.707970 | \n-0.702249 | \n-0.540342 | \n
| 525 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n-0.124807 | \n... | \n-0.164972 | \n-0.194494 | \n-0.275090 | \n-0.364688 | \n-0.440014 | \n-0.472264 | \n-0.467227 | \n-0.439868 | \n-0.401022 | \n-0.361123 | \n
| 526 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n1 | \n0 | \n1 | \n1 | \n-0.500839 | \n... | \n-0.204567 | \n-0.197048 | \n-0.175478 | \n-0.219285 | \n-0.366606 | \n-0.494809 | \n-0.517148 | \n-0.394632 | \n-0.281323 | \n-0.263670 | \n
| 527 | \n50 | \n100 | \n1800 | \n20 | \n2 | \n0 | \n1 | \n1 | \n1 | \n-0.067152 | \n... | \n-0.357148 | \n-0.380659 | \n-0.389910 | \n-0.394442 | \n-0.414922 | \n-0.433362 | \n-0.447434 | \n-0.459646 | \n-0.428600 | \n-0.327952 | \n
528 rows × 1755 columns
\n