{ "cells": [ { "cell_type": "code", "execution_count": 123, "id": "dd2df12d-5a47-49b1-8b76-4da744779b2d", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "from matplotlib import pyplot as plt\n", "import seaborn as sns\n", "from scipy import stats\n", "from statsmodels.stats.multicomp import pairwise_tukeyhsd\n", "plt.rcParams['pdf.fonttype'] = 42" ] }, { "cell_type": "code", "execution_count": 124, "id": "a00f1ac4-e747-45c9-bdb6-856d72bb8856", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | cellID | \n", "CFP | \n", "FRET | \n", "RFP | \n", "iRFP | \n", "Time from treatment (min) | \n", "FRET/CFP | \n", "Norm Gem | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1288.896067 | \n", "1731.963483 | \n", "279.123596 | \n", "1034.929775 | \n", "-6 | \n", "1.343757 | \n", "0.269703 | \n", "
1 | \n", "1 | \n", "1324.434018 | \n", "1784.439883 | \n", "272.249267 | \n", "1061.322581 | \n", "-4 | \n", "1.347323 | \n", "0.256519 | \n", "
2 | \n", "1 | \n", "1326.686782 | \n", "1789.250000 | \n", "282.959770 | \n", "1053.422414 | \n", "-2 | \n", "1.348660 | \n", "0.268610 | \n", "
3 | \n", "1 | \n", "1378.579545 | \n", "1810.096591 | \n", "276.696023 | \n", "1043.289773 | \n", "0 | \n", "1.313016 | \n", "0.265215 | \n", "
4 | \n", "1 | \n", "1785.913043 | \n", "2343.695652 | \n", "276.007905 | \n", "1359.268775 | \n", "2 | \n", "1.312323 | \n", "0.203056 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
763 | \n", "50 | \n", "559.379310 | \n", "769.303448 | \n", "228.122414 | \n", "376.839655 | \n", "16 | \n", "1.375280 | \n", "0.605357 | \n", "
764 | \n", "50 | \n", "569.223265 | \n", "798.311445 | \n", "229.731707 | \n", "383.574109 | \n", "18 | \n", "1.402458 | \n", "0.598924 | \n", "
765 | \n", "50 | \n", "591.429769 | \n", "831.450734 | \n", "226.580713 | \n", "389.293501 | \n", "20 | \n", "1.405832 | \n", "0.582031 | \n", "
766 | \n", "50 | \n", "544.656075 | \n", "767.637383 | \n", "224.285981 | \n", "378.373832 | \n", "22 | \n", "1.409398 | \n", "0.592763 | \n", "
767 | \n", "50 | \n", "540.757455 | \n", "768.514911 | \n", "225.288270 | \n", "378.449304 | \n", "24 | \n", "1.421182 | \n", "0.595293 | \n", "
768 rows × 8 columns
\n", "cellID | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "10 | \n", "... | \n", "41 | \n", "42 | \n", "43 | \n", "44 | \n", "45 | \n", "46 | \n", "47 | \n", "48 | \n", "49 | \n", "50 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Time from treatment (min) | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
-6 | \n", "1.004161 | \n", "1.005238 | \n", "0.999777 | \n", "0.995904 | \n", "0.999855 | \n", "0.998776 | \n", "0.995692 | \n", "1.001374 | \n", "0.999517 | \n", "1.002865 | \n", "... | \n", "0.999013 | \n", "1.001404 | \n", "0.995638 | \n", "0.993432 | \n", "1.003995 | \n", "0.997344 | \n", "0.996963 | \n", "0.996420 | \n", "0.992714 | \n", "0.999372 | \n", "
-4 | \n", "1.006825 | \n", "0.999599 | \n", "1.005049 | \n", "1.007011 | \n", "1.003895 | \n", "1.001265 | \n", "1.007700 | \n", "1.002078 | \n", "1.001469 | \n", "0.999801 | \n", "... | \n", "1.006947 | \n", "0.996563 | \n", "0.996855 | \n", "1.002074 | \n", "1.001210 | \n", "1.006680 | \n", "1.006454 | \n", "0.998917 | \n", "1.000200 | \n", "1.006672 | \n", "
-2 | \n", "1.007825 | \n", "1.004524 | \n", "0.998007 | \n", "1.002882 | \n", "0.997131 | \n", "1.002070 | \n", "1.001496 | \n", "0.998835 | \n", "1.004784 | \n", "1.001909 | \n", "... | \n", "1.004270 | \n", "1.000551 | \n", "1.008300 | \n", "1.015616 | \n", "1.003720 | \n", "1.003079 | \n", "0.999263 | \n", "0.999702 | \n", "1.009271 | \n", "1.002744 | \n", "
0 | \n", "0.981189 | \n", "0.990639 | \n", "0.997166 | \n", "0.994203 | \n", "0.999119 | \n", "0.997889 | \n", "0.995112 | \n", "0.997712 | \n", "0.994230 | \n", "0.995425 | \n", "... | \n", "0.989770 | \n", "1.001482 | \n", "0.999206 | \n", "0.988878 | \n", "0.991074 | \n", "0.992897 | \n", "0.997320 | \n", "1.004961 | \n", "0.997815 | \n", "0.991211 | \n", "
2 | \n", "0.980671 | \n", "0.982141 | \n", "1.008687 | \n", "0.996938 | \n", "0.985637 | \n", "1.012691 | \n", "0.997467 | \n", "0.997148 | \n", "0.994707 | \n", "0.996461 | \n", "... | \n", "1.091304 | \n", "1.014759 | \n", "1.003548 | \n", "0.996220 | \n", "0.982279 | \n", "0.991573 | \n", "1.025181 | \n", "1.002403 | \n", "0.985368 | \n", "0.992815 | \n", "
4 | \n", "0.983897 | \n", "0.992389 | \n", "1.019468 | \n", "1.013986 | \n", "1.001342 | \n", "1.018053 | \n", "0.997449 | \n", "1.014280 | \n", "1.004989 | \n", "1.004763 | \n", "... | \n", "1.105295 | \n", "1.025134 | \n", "1.004748 | \n", "0.990439 | \n", "0.999939 | \n", "0.990691 | \n", "1.020903 | \n", "1.008867 | \n", "0.993728 | \n", "0.999852 | \n", "
6 | \n", "0.998391 | \n", "1.002947 | \n", "1.029810 | \n", "1.018009 | \n", "1.001878 | \n", "1.026839 | \n", "1.006327 | \n", "1.016787 | \n", "1.019574 | \n", "1.022511 | \n", "... | \n", "1.111975 | \n", "1.030505 | \n", "1.008474 | \n", "1.001999 | \n", "1.003936 | \n", "1.006662 | \n", "1.017075 | \n", "1.015527 | \n", "1.004356 | \n", "1.020374 | \n", "
8 | \n", "1.021235 | \n", "1.014932 | \n", "1.023797 | \n", "1.032594 | \n", "1.019282 | \n", "1.030100 | \n", "1.005099 | \n", "1.025330 | \n", "1.029820 | \n", "1.030059 | \n", "... | \n", "1.111558 | \n", "1.039890 | \n", "1.012789 | \n", "1.009933 | \n", "1.017424 | \n", "1.012880 | \n", "1.020428 | \n", "1.011511 | \n", "1.020914 | \n", "1.019601 | \n", "
10 | \n", "1.043669 | \n", "1.024128 | \n", "1.033658 | \n", "1.042951 | \n", "1.025904 | \n", "1.034244 | \n", "1.013755 | \n", "1.032453 | \n", "1.050292 | \n", "1.029460 | \n", "... | \n", "1.108832 | \n", "1.051537 | \n", "1.022099 | \n", "1.008891 | \n", "1.033266 | \n", "1.019069 | \n", "1.013664 | \n", "1.004760 | \n", "1.038733 | \n", "1.036708 | \n", "
12 | \n", "1.054670 | \n", "1.051974 | \n", "1.040086 | \n", "1.045484 | \n", "1.028539 | \n", "1.036301 | \n", "1.013197 | \n", "1.041208 | \n", "1.059944 | \n", "1.036418 | \n", "... | \n", "1.127348 | \n", "1.050976 | \n", "1.009506 | \n", "1.018338 | \n", "1.040620 | \n", "1.041888 | \n", "1.007754 | \n", "1.005596 | \n", "1.044537 | \n", "1.050909 | \n", "
14 | \n", "1.067428 | \n", "1.070827 | \n", "1.044400 | \n", "1.061938 | \n", "1.034578 | \n", "1.045107 | \n", "1.034246 | \n", "1.044788 | \n", "1.073837 | \n", "1.037855 | \n", "... | \n", "1.148102 | \n", "1.064984 | \n", "1.024778 | \n", "1.039822 | \n", "1.065347 | \n", "1.058068 | \n", "1.019127 | \n", "1.005392 | \n", "1.055099 | \n", "1.058778 | \n", "
16 | \n", "1.084135 | \n", "1.078920 | \n", "1.048805 | \n", "1.055556 | \n", "1.033849 | \n", "1.052752 | \n", "1.040772 | \n", "1.057363 | \n", "1.080007 | \n", "1.045373 | \n", "... | \n", "1.132326 | \n", "1.064931 | \n", "1.034606 | \n", "1.025850 | \n", "1.079914 | \n", "1.060693 | \n", "1.016395 | \n", "1.008996 | \n", "1.061683 | \n", "1.065179 | \n", "
18 | \n", "1.092683 | \n", "1.111753 | \n", "1.058022 | \n", "1.070639 | \n", "1.054467 | \n", "1.064376 | \n", "1.048024 | \n", "1.061365 | \n", "1.078122 | \n", "1.038575 | \n", "... | \n", "1.132021 | \n", "1.070508 | \n", "1.050973 | \n", "1.037846 | \n", "1.091303 | \n", "1.081960 | \n", "1.029412 | \n", "1.021854 | \n", "1.066182 | \n", "1.086228 | \n", "
20 | \n", "1.105839 | \n", "1.092913 | \n", "1.058573 | \n", "1.065727 | \n", "1.045210 | \n", "1.055261 | \n", "1.049130 | \n", "1.069134 | \n", "1.094585 | \n", "1.049899 | \n", "... | \n", "1.159289 | \n", "1.063232 | \n", "1.047907 | \n", "1.045923 | \n", "1.094727 | \n", "1.084294 | \n", "1.015205 | \n", "1.014459 | \n", "1.066844 | \n", "1.088841 | \n", "
22 | \n", "1.108403 | \n", "1.093627 | \n", "1.051430 | \n", "1.064724 | \n", "1.044230 | \n", "1.060840 | \n", "1.042369 | \n", "1.060934 | \n", "1.091216 | \n", "1.055450 | \n", "... | \n", "1.152534 | \n", "1.066442 | \n", "1.050825 | \n", "1.038197 | \n", "1.096294 | \n", "1.088910 | \n", "1.016143 | \n", "1.013066 | \n", "1.065993 | \n", "1.091604 | \n", "
24 | \n", "1.137899 | \n", "1.115172 | \n", "1.064346 | \n", "1.071273 | \n", "1.049891 | \n", "1.069871 | \n", "1.049209 | \n", "1.079081 | \n", "1.093022 | \n", "1.050310 | \n", "... | \n", "1.165273 | \n", "1.079653 | \n", "1.063344 | \n", "1.043836 | \n", "1.120602 | \n", "1.108116 | \n", "1.024733 | \n", "1.013807 | \n", "1.082931 | \n", "1.100730 | \n", "
16 rows × 48 columns
\n", "group1 | group2 | meandiff | p-adj | lower | upper | reject | \n", "
---|---|---|---|---|---|---|
0.0 | 1.0 | 0.0005 | 0.9972 | -0.006 | 0.007 | False | \n", "
0.0 | 10.0 | 0.0066 | 0.0249 | 0.0006 | 0.0126 | True | \n", "
0.0 | 100.0 | 0.0323 | 0.0 | 0.0267 | 0.038 | True | \n", "
1.0 | 10.0 | 0.0061 | 0.0838 | -0.0005 | 0.0127 | False | \n", "
1.0 | 100.0 | 0.0318 | 0.0 | 0.0255 | 0.0382 | True | \n", "
10.0 | 100.0 | 0.0258 | 0.0 | 0.02 | 0.0315 | True | \n", "