Skip to content

Instantly share code, notes, and snippets.

@LogIN-
Created August 1, 2018 00:59
Show Gist options
  • Save LogIN-/00d7628e0850f843ba84a678fac0a103 to your computer and use it in GitHub Desktop.
Save LogIN-/00d7628e0850f843ba84a678fac0a103 to your computer and use it in GitHub Desktop.
data
json_info
| feature_count|sql                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |features_hash                    | donors_count|data_source |
|-------------:|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------|------------:|:-----------|
|            25|B_cells','CD161_pos_CD45RA_pos_Tregs','CD161_pos_CD8_pos_T_cells','CD161_pos_NK_cells','CD27_pos_CD8_pos_T_cells','CD28_pos_CD8_pos_T_cells','CD85j_pos_CD8_pos_T_cells','CD94_pos_CD8_pos_T_cells','CD94_pos_NK_cells','central_memory_CD4_pos_T_cells','central_memory_CD8_pos_T_cells','effector_CD8_pos_T_cells','effector_memory_CD8_pos_T_cells','IgD_pos_CD27_neg_B_cells','L50_EOTAXIN','L50_HGF','L50_IL7','L50_LIF','L50_MCP3','L50_SCF','L50_TRAIL','monocytes','naive_B_cells','naive_CD4_pos_T_cells','naive_CD8_pos_T_cells |2573ea599d696ddd60071892bfebed12 |          105|predicted   |


results
| donor_id|outcome | B_cells| CD161_pos_CD45RA_pos_Tregs| CD161_pos_CD8_pos_T_cells| CD161_pos_NK_cells| CD27_pos_CD8_pos_T_cells| CD28_pos_CD8_pos_T_cells| CD85j_pos_CD8_pos_T_cells| CD94_pos_CD8_pos_T_cells| CD94_pos_NK_cells| central_memory_CD4_pos_T_cells| central_memory_CD8_pos_T_cells| effector_CD8_pos_T_cells| effector_memory_CD8_pos_T_cells| IgD_pos_CD27_neg_B_cells| L50_EOTAXIN| L50_HGF| L50_IL7| L50_LIF| L50_MCP3| L50_SCF| L50_TRAIL| monocytes| naive_B_cells| naive_CD4_pos_T_cells| naive_CD8_pos_T_cells|
|--------:|:-------|-------:|--------------------------:|-------------------------:|------------------:|------------------------:|------------------------:|-------------------------:|------------------------:|-----------------:|------------------------------:|------------------------------:|------------------------:|-------------------------------:|------------------------:|-----------:|-------:|-------:|-------:|--------:|-------:|---------:|---------:|-------------:|---------------------:|---------------------:|
|      166|low     |    36.3|                       1.68|                     10.80|               70.0|                     85.2|                     80.5|                      17.7|                     4.31|              86.9|                           24.5|                           1.96|                     14.7|                            23.4|                     66.5|       -0.14|   -0.06|   -0.11|   -0.10|    -1.38|   -0.18|      0.17|      17.1|          74.7|                  63.0|                  59.9|
|      167|low     |    55.8|                       0.84|                     14.50|               79.7|                     71.9|                     63.5|                      25.8|                    14.20|              92.7|                           16.2|                           3.27|                     26.9|                            31.8|                     61.5|        1.30|    1.45|    1.49|    1.36|     2.00|    1.58|      1.80|      12.0|          71.2|                  73.9|                  38.1|
|      169|high    |    61.2|                       0.43|                      4.63|               62.5|                     84.5|                     81.5|                      17.1|                     3.94|              91.9|                           35.9|                           2.77|                     13.4|                            10.4|                     55.2|        0.28|   -0.14|   -0.10|    0.11|    -0.17|    0.26|      0.21|      20.5|          76.4|                  51.6|                  73.4|
|      171|high    |    41.3|                       0.72|                     12.10|               48.3|                     89.7|                     80.0|                      13.8|                     5.86|              92.1|                           40.9|                           6.97|                     22.6|                            31.8|                     67.7|       -0.37|   -0.44|   -0.36|   -0.21|    -0.53|   -0.37|     -2.18|      21.4|          77.2|                  44.4|                  38.6|
|      177|high    |    40.9|                       0.56|                      4.76|               80.7|                     83.0|                     78.9|                      19.1|                     4.48|              89.4|                           32.0|                           6.31|                     11.7|                            23.2|                     52.5|       -0.76|   -1.12|   -0.88|   -0.92|     0.48|   -1.02|     -1.56|      21.2|          68.4|                  56.6|                  58.9|
|      178|high    |    54.1|                       0.73|                      8.48|               66.2|                     74.8|                     75.5|                      19.1|                    10.10|              91.2|                           37.9|                           7.59|                     21.0|                            34.5|                     69.4|        0.16|   -0.36|    0.07|    0.23|    -0.54|    0.16|      0.34|      13.4|          74.9|                  46.9|                  36.9|

data_training
|outcome | B_cells| CD161_pos_CD45RA_pos_Tregs| CD161_pos_CD8_pos_T_cells| CD161_pos_NK_cells| CD27_pos_CD8_pos_T_cells| CD28_pos_CD8_pos_T_cells| CD85j_pos_CD8_pos_T_cells| CD94_pos_CD8_pos_T_cells| CD94_pos_NK_cells| central_memory_CD4_pos_T_cells| central_memory_CD8_pos_T_cells| effector_CD8_pos_T_cells| effector_memory_CD8_pos_T_cells| IgD_pos_CD27_neg_B_cells| L50_EOTAXIN| L50_HGF| L50_IL7| L50_LIF| L50_MCP3| L50_SCF| L50_TRAIL| monocytes| naive_B_cells| naive_CD4_pos_T_cells| naive_CD8_pos_T_cells|
|:-------|-------:|--------------------------:|-------------------------:|------------------:|------------------------:|------------------------:|-------------------------:|------------------------:|-----------------:|------------------------------:|------------------------------:|------------------------:|-------------------------------:|------------------------:|-----------:|-------:|-------:|-------:|--------:|-------:|---------:|---------:|-------------:|---------------------:|---------------------:|
|low     |    36.3|                       1.68|                     10.80|               70.0|                     85.2|                     80.5|                      17.7|                     4.31|              86.9|                           24.5|                           1.96|                     14.7|                            23.4|                     66.5|       -0.14|   -0.06|   -0.11|   -0.10|    -1.38|   -0.18|      0.17|      17.1|          74.7|                  63.0|                  59.9|
|low     |    55.8|                       0.84|                     14.50|               79.7|                     71.9|                     63.5|                      25.8|                    14.20|              92.7|                           16.2|                           3.27|                     26.9|                            31.8|                     61.5|        1.30|    1.45|    1.49|    1.36|     2.00|    1.58|      1.80|      12.0|          71.2|                  73.9|                  38.1|
|high    |    61.2|                       0.43|                      4.63|               62.5|                     84.5|                     81.5|                      17.1|                     3.94|              91.9|                           35.9|                           2.77|                     13.4|                            10.4|                     55.2|        0.28|   -0.14|   -0.10|    0.11|    -0.17|    0.26|      0.21|      20.5|          76.4|                  51.6|                  73.4|
|high    |    40.9|                       0.56|                      4.76|               80.7|                     83.0|                     78.9|                      19.1|                     4.48|              89.4|                           32.0|                           6.31|                     11.7|                            23.2|                     52.5|       -0.76|   -1.12|   -0.88|   -0.92|     0.48|   -1.02|     -1.56|      21.2|          68.4|                  56.6|                  58.9|
|high    |    54.1|                       0.73|                      8.48|               66.2|                     74.8|                     75.5|                      19.1|                    10.10|              91.2|                           37.9|                           7.59|                     21.0|                            34.5|                     69.4|        0.16|   -0.36|    0.07|    0.23|    -0.54|    0.16|      0.34|      13.4|          74.9|                  46.9|                  36.9|
|high    |    54.8|                       0.64|                      7.60|               53.2|                     66.4|                     55.7|                      28.6|                    25.80|              95.7|                           32.0|                           6.02|                     18.8|                            39.3|                     69.1|        0.40|    0.19|    0.23|    0.17|     1.03|    0.01|      0.96|      15.9|          76.0|                  46.3|                  35.9|

data_testing
|outcome | B_cells| CD161_pos_CD45RA_pos_Tregs| CD161_pos_CD8_pos_T_cells| CD161_pos_NK_cells| CD27_pos_CD8_pos_T_cells| CD28_pos_CD8_pos_T_cells| CD85j_pos_CD8_pos_T_cells| CD94_pos_CD8_pos_T_cells| CD94_pos_NK_cells| central_memory_CD4_pos_T_cells| central_memory_CD8_pos_T_cells| effector_CD8_pos_T_cells| effector_memory_CD8_pos_T_cells| IgD_pos_CD27_neg_B_cells| L50_EOTAXIN| L50_HGF| L50_IL7| L50_LIF| L50_MCP3| L50_SCF| L50_TRAIL| monocytes| naive_B_cells| naive_CD4_pos_T_cells| naive_CD8_pos_T_cells|
|:-------|-------:|--------------------------:|-------------------------:|------------------:|------------------------:|------------------------:|-------------------------:|------------------------:|-----------------:|------------------------------:|------------------------------:|------------------------:|-------------------------------:|------------------------:|-----------:|-------:|-------:|-------:|--------:|-------:|---------:|---------:|-------------:|---------------------:|---------------------:|
|high    |    41.3|                       0.72|                     12.10|               48.3|                     89.7|                     80.0|                      13.8|                     5.86|              92.1|                           40.9|                           6.97|                     22.6|                            31.8|                     67.7|       -0.37|   -0.44|   -0.36|   -0.21|    -0.53|   -0.37|     -2.18|      21.4|          77.2|                  44.4|                  38.6|
|low     |    30.2|                       1.54|                      5.67|               54.3|                     93.1|                     82.4|                      11.0|                     7.71|              86.0|                           34.6|                           8.44|                     15.5|                            19.3|                     73.6|        1.25|    0.66|    1.12|    1.16|    -0.03|    1.26|      0.88|      19.6|          80.0|                  50.9|                  56.8|
|low     |    36.0|                       1.74|                     15.20|               77.9|                     90.6|                     84.6|                      10.7|                    12.50|              88.6|                           31.4|                           4.61|                     15.2|                            25.1|                     64.0|        0.79|    0.54|    0.98|    0.91|     0.59|    0.83|      0.34|      11.2|          68.4|                  56.4|                  55.1|
|high    |    42.2|                       0.89|                      7.72|               41.7|                     66.7|                     64.9|                      28.9|                    13.40|              74.0|                           32.8|                           4.39|                     28.5|                            20.9|                     56.4|        0.55|    0.31|    0.36|    0.47|    -0.26|    0.46|      0.32|      26.1|          60.0|                  48.6|                  46.1|
|low     |    53.8|                       0.59|                      7.61|               40.1|                     57.1|                     56.7|                      29.7|                     6.63|              83.9|                           40.7|                           6.71|                     20.3|                            40.4|                     69.0|        0.59|   -0.34|   -0.06|   -0.10|    -0.86|   -0.10|     -1.15|      18.4|          78.5|                  43.8|                  32.6|
|high    |    50.8|                       1.53|                     17.60|               59.9|                     81.1|                     80.9|                      10.7|                     5.15|              77.0|                           37.9|                           9.00|                     13.5|                            31.6|                     76.7|       -0.41|    0.39|   -0.17|   -0.21|    -0.12|   -0.33|      0.44|      20.3|          83.4|                  36.8|                  45.9|
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment