Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: AllLASSO_MSE (2)
|      MSE |   lambda |
|---------:|---------:|
| 103.77   |     0    |
|  91.9821 |     0.01 |
|  83.2464 |     0.02 |
|  81.7971 |     0.03 |
|  80.9614 |     0.04 |
|  80.2844 |     0.05 |
|  78.7547 |     0.06 |
|  77.223  |     0.07 |
|  76.49   |     0.08 |
|  76.1943 |     0.09 |


Table: AllLASSO_MSE
|      MSE |   lambda |
|---------:|---------:|
| 103.77   |     0    |
|  91.9821 |     0.01 |
|  83.2464 |     0.02 |
|  81.7971 |     0.03 |
|  80.9614 |     0.04 |
|  80.2844 |     0.05 |
|  78.7547 |     0.06 |
|  77.223  |     0.07 |
|  76.49   |     0.08 |
|  76.1943 |     0.09 |


Table: avg_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    5.614 | 143.488 |
|    5.615 | 143.488 |
|    5.616 | 143.488 |
|    5.617 | 143.488 |
|    5.618 | 143.488 |
|    5.619 | 143.488 |
|    5.62  | 143.488 |
|    5.621 | 143.488 |
|    5.622 | 143.488 |
|    5.623 | 143.488 |


Table: Dataset_0
| AP_Rnk   | PS_Rnk   |   KP_Rank |   TournamentYear |   TeamID | TS_Team       |   Auto Bid | KP_Conference   |   TS_GP |   STA_W |   STA_L |   STA_Pct |   STA_Conf_W |   STA_Conf_L |   STA_Conf_Pct |   STA_Home_W |   STA_Home_L |   STA_Away_W |   STA_Away_L |   STA_Neutral_W |   STA_Neutral_L |   STA_Top25_W |   STA_Top25_L |   STA_Conf_PF |   STA_Conf_PA |   STA_Conf_PPG |   STA_Conf_PAPG |   STA_PF |   STA_PA |   STA_PPG |   STA_PAPG |   TS_FGM |   TS_FGA |   TS_FG% |   TS_3PM |   TS_3PA |   TS_3P% |   TS_FTM |   TS_FTA |   TS_FT% |   KP_Ajusted Efficiency Margin |   KP_Adjusted Offensive Efficiency |   KP_AOE Rk |   KP_Adjusted Defensive Efficiency |   KP_ADE Rk |   KP_Adjusted Tempo |   KP_AT Rk |   KP_Luck |   KP_Luck Rk |   KP_Strength of Schedule |   KP_SOS Rk |   KP_Non-Conference Strength of Schedule |   KP_NCSOS Rk |   KP_Average Opponents Offensive Efficiency |   KP_AOOE Rk |   KP_Average Opponents Defensive Efficiency |   KP_AODE Rk | Round       |   Round Number | Team            |   Seed | Opponent          |   OppSeed |   PF** |   PA | WL   |   Won Game |   OppTeamID | Opp_AP_Rnk   | Opp_PS_Rnk   |   Opp_KP_Rank |   Opp_TeamID | Opp_TS_Team     | Opp_KP_Conference   |   Opp_TS_GP |   Opp_STA_W |   Opp_STA_L |   Opp_STA_Pct |   Opp_STA_Conf_W |   Opp_STA_Conf_L |   Opp_STA_Conf_Pct |   Opp_STA_Home_W |   Opp_STA_Home_L |   Opp_STA_Away_W |   Opp_STA_Away_L |   Opp_STA_Neutral_W |   Opp_STA_Neutral_L |   Opp_STA_Top25_W |   Opp_STA_Top25_L |   Opp_STA_Conf_PF |   Opp_STA_Conf_PA |   Opp_STA_Conf_PPG |   Opp_STA_Conf_PAPG |   Opp_STA_PF |   Opp_STA_PA |   Opp_STA_PPG |   Opp_STA_PAPG |   Opp_TS_FGM |   Opp_TS_FGA |   Opp_TS_FG% |   Opp_TS_3PM |   Opp_TS_3PA |   Opp_TS_3P% |   Opp_TS_FTM |   Opp_TS_FTA |   Opp_TS_FT% |   Opp_KP_Ajusted Efficiency Margin |   Opp_KP_Adjusted Offensive Efficiency |   Opp_KP AOW Rk |   Opp_KP_Adjusted Defensive Efficiency |   Opp_KP_ADE Rk |   Opp_KP_Adjusted Tempo |   Opp_KP_AT Rk |   Opp_KP_Luck |   Opp_KP_Luck_Rk |   Opp_KP_Strength of Schedule |   Opp_KP_SOS Rk |   Opp_KP_Non-Conference Strength of Schedule |   Opp_KP_NCSOS Rk |   Opp_KP_Average Opponents Offensive Efficiency |   Opp_KP_AOOE Rk |   Opp_KP_Average Opponents Defensive Efficiency |   Opp_KP_AODE Rk | PFBins   |   PFBinOrder | PPGBins   |   PPGBinOrder |
|:---------|:---------|----------:|-----------------:|---------:|:--------------|-----------:|:----------------|--------:|--------:|--------:|----------:|-------------:|-------------:|---------------:|-------------:|-------------:|-------------:|-------------:|----------------:|----------------:|--------------:|--------------:|--------------:|--------------:|---------------:|----------------:|---------:|---------:|----------:|-----------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|-------------------------------:|-----------------------------------:|------------:|-----------------------------------:|------------:|--------------------:|-----------:|----------:|-------------:|--------------------------:|------------:|-----------------------------------------:|--------------:|--------------------------------------------:|-------------:|--------------------------------------------:|-------------:|:------------|---------------:|:----------------|-------:|:------------------|----------:|-------:|-----:|:-----|-----------:|------------:|:-------------|:-------------|--------------:|-------------:|:----------------|:--------------------|------------:|------------:|------------:|--------------:|-----------------:|-----------------:|-------------------:|-----------------:|-----------------:|-----------------:|-----------------:|--------------------:|--------------------:|------------------:|------------------:|------------------:|------------------:|-------------------:|--------------------:|-------------:|-------------:|--------------:|---------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-----------------------------------:|---------------------------------------:|----------------:|---------------------------------------:|----------------:|------------------------:|---------------:|--------------:|-----------------:|------------------------------:|----------------:|---------------------------------------------:|------------------:|------------------------------------------------:|-----------------:|------------------------------------------------:|-----------------:|:---------|-------------:|:----------|--------------:|
|          |          |        69 |             2019 |      302 | Temple        |          0 | Amer            |      32 |      23 |       9 |     0.719 |           13 |            5 |          0.722 |           13 |            2 |            8 |            5 |               2 |               3 |             2 |             2 |          1365 |          1308 |        75.8    |         72.7    |     2465 |     2358 |   74.697  |    71.4545 |      845 |     1927 |    0.439 |      240 |      726 |    0.331 |      465 |      636 |    0.731 |                           9.72 |                              109.2 |          80 |                               99.5 |          85 |                68.9 |        110 |     0.064 |           35 |                      4.55 |          74 |                                    -1.07 |           188 |                                       106.3 |           77 |                                       101.8 |           68 | First Four  |              0 | Temple          |     11 | Belmont           |        11 |     70 |   81 | L    |          0 |          13 |              |              |            49 |           13 | Belmont         | OVC                 |          31 |          26 |           5 |         0.839 |               16 |                2 |              0.889 |               13 |                1 |               12 |                3 |                   2 |                   2 |                 0 |                 0 |              1605 |              1312 |            89.2    |             72.9    |         2868 |         2439 |       86.9091 |        73.9091 |          987 |         1976 |        0.499 |          325 |          871 |        0.373 |          411 |          557 |        0.738 |                              14.09 |                                  115.6 |              18 |                                  101.5 |             117 |                    71.3 |             34 |         0.025 |              113 |                         -1.98 |             194 |                                         3.78 |                63 |                                           103.6 |              183 |                                           105.6 |              198 | 66-70    |            5 | 71-75     |             6 |
|          |          |        88 |             2019 |       59 | St. John's    |          0 | BE              |      33 |      21 |      12 |     0.636 |            8 |           10 |          0.444 |           13 |            4 |            4 |            7 |               4 |               2 |             3 |             2 |          1350 |          1378 |        75      |         76.6    |     2623 |     2542 |   77.1471 |    74.7647 |      922 |     2031 |    0.454 |      281 |      778 |    0.361 |      433 |      597 |    0.725 |                           7.61 |                              108.6 |          92 |                              101   |         106 |                70.8 |         46 |     0.06  |           44 |                      5    |          68 |                                    -6.49 |           330 |                                       106.9 |           70 |                                       101.9 |           71 | First Four  |              0 | St. John's (NY) |     11 | Arizona St.       |        11 |     65 |   74 | L    |          0 |         235 |              |              |            57 |          235 | Arizona State   | P12                 |          32 |          22 |          10 |         0.688 |               12 |                6 |              0.667 |               13 |                3 |                6 |                5 |                   4 |                   3 |                 2 |                 2 |              1376 |              1322 |            76.4    |             73.4    |         2638 |         2494 |       77.5882 |        73.3529 |          851 |         1903 |        0.447 |          232 |          680 |        0.341 |          556 |          829 |        0.671 |                              11.55 |                                  109.7 |              73 |                                   98.2 |              64 |                    70.8 |             47 |         0.051 |               59 |                          5.56 |              65 |                                         1.55 |               112 |                                           107.3 |               64 |                                           101.7 |               66 | 61-65    |            4 | 76-80     |             7 |
|          |          |        49 |             2019 |       13 | Belmont       |          0 | OVC             |      31 |      26 |       5 |     0.839 |           16 |            2 |          0.889 |           13 |            1 |           12 |            3 |               2 |               2 |             0 |             0 |          1605 |          1312 |        89.2    |         72.9    |     2868 |     2439 |   86.9091 |    73.9091 |      987 |     1976 |    0.499 |      325 |      871 |    0.373 |      411 |      557 |    0.738 |                          14.09 |                              115.6 |          18 |                              101.5 |         117 |                71.3 |         34 |     0.025 |          113 |                     -1.98 |         194 |                                     3.78 |            63 |                                       103.6 |          183 |                                       105.6 |          198 | First Four  |              0 | Belmont         |     11 | Temple            |        11 |     81 |   70 | W    |          1 |         302 |              |              |            69 |          302 | Temple          | Amer                |          32 |          23 |           9 |         0.719 |               13 |                5 |              0.722 |               13 |                2 |                8 |                5 |                   2 |                   3 |                 2 |                 2 |              1365 |              1308 |            75.8    |             72.7    |         2465 |         2358 |       74.697  |        71.4545 |          845 |         1927 |        0.439 |          240 |          726 |        0.331 |          465 |          636 |        0.731 |                               9.72 |                                  109.2 |              80 |                                   99.5 |              85 |                    68.9 |            110 |         0.064 |               35 |                          4.55 |              74 |                                        -1.07 |               188 |                                           106.3 |               77 |                                           101.8 |               68 | 81-85    |            8 | 86-90     |             9 |
|          |          |        57 |             2019 |      235 | Arizona State |          0 | P12             |      32 |      22 |      10 |     0.688 |           12 |            6 |          0.667 |           13 |            3 |            6 |            5 |               4 |               3 |             2 |             2 |          1376 |          1322 |        76.4    |         73.4    |     2638 |     2494 |   77.5882 |    73.3529 |      851 |     1903 |    0.447 |      232 |      680 |    0.341 |      556 |      829 |    0.671 |                          11.55 |                              109.7 |          73 |                               98.2 |          64 |                70.8 |         47 |     0.051 |           59 |                      5.56 |          65 |                                     1.55 |           112 |                                       107.3 |           64 |                                       101.7 |           66 | First Four  |              0 | Arizona St.     |     11 | St. John's (NY)   |        11 |     74 |   65 | W    |          1 |          59 |              |              |            88 |           59 | St. John's      | BE                  |          33 |          21 |          12 |         0.636 |                8 |               10 |              0.444 |               13 |                4 |                4 |                7 |                   4 |                   2 |                 3 |                 2 |              1350 |              1378 |            75      |             76.6    |         2623 |         2542 |       77.1471 |        74.7647 |          922 |         2031 |        0.454 |          281 |          778 |        0.361 |          433 |          597 |        0.725 |                               7.61 |                                  108.6 |              92 |                                  101   |             106 |                    70.8 |             46 |         0.06  |               44 |                          5    |              68 |                                        -6.49 |               330 |                                           106.9 |               70 |                                           101.9 |               71 | 71-75    |            6 | 76-80     |             7 |
|          |          |        41 |             2018 |      155 | Syracuse      |          0 | ACC             |      33 |      20 |      13 |     0.606 |            8 |           10 |          0.444 |           14 |            5 |            4 |            6 |               5 |               3 |             2 |             8 |          1161 |          1173 |        64.5    |         65.1667 |     2466 |     2360 |   66.6486 |    63.7838 |      751 |     1796 |    0.418 |      193 |      600 |    0.322 |      534 |      721 |    0.741 |                          14.82 |                              107   |         135 |                               92.2 |           5 |                62.9 |        345 |     0.021 |          119 |                      9.81 |          27 |                                    -0.2  |           163 |                                       111.3 |            9 |                                       101.5 |           58 | First Four  |              0 | Syracuse        |     11 | Arizona St.       |        11 |     60 |   56 | W    |          1 |         235 |              |              |            49 |          235 | Arizona State   | P12                 |          31 |          20 |          11 |         0.645 |                8 |               10 |              0.444 |               13 |                4 |                4 |                6 |                   3 |                   2 |                 2 |                 2 |              1403 |              1378 |            77.9444 |             76.5556 |         2645 |         2395 |       82.6562 |        74.8438 |          867 |         1868 |        0.464 |          277 |          761 |        0.364 |          578 |          783 |        0.738 |                              14.13 |                                  116.7 |              18 |                                  102.6 |             123 |                    71.3 |             43 |        -0.083 |              340 |                          5.48 |              71 |                                         0.94 |               138 |                                           107.4 |               77 |                                           101.9 |               64 | 56-60    |            3 | 66-70     |             5 |
| 11       | 20       |         5 |             2018 |      203 | Purdue        |          0 | B10             |      34 |      28 |       6 |     0.824 |           15 |            3 |          0.833 |           16 |            1 |            8 |            2 |               6 |               4 |             3 |             4 |          1379 |          1193 |        76.6111 |         66.2778 |     2974 |     2431 |   80.3784 |    65.7027 |      958 |     1928 |    0.497 |      326 |      776 |    0.42  |      517 |      696 |    0.743 |                          26.27 |                              122.7 |           2 |                               96.4 |          31 |                67.2 |        223 |     0.006 |          163 |                      9.02 |          41 |                                     0.69 |           144 |                                       109.1 |           51 |                                       100.1 |           14 | First Round |              1 | Purdue          |      2 | Cal St. Fullerton |        15 |     74 |   48 | W    |          1 |         255 |              |              |           162 |          255 | CSU Fullerton   | BW                  |          31 |          20 |          11 |         0.645 |               10 |                6 |              0.625 |               10 |                4 |                7 |                7 |                   3 |                   1 |                 0 |                 3 |              1189 |              1138 |            74.3125 |             71.125  |         2318 |         2245 |       72.4375 |        70.1562 |          786 |         1671 |        0.47  |          163 |          482 |        0.338 |          535 |          729 |        0.734 |                               0.62 |                                  103.7 |             192 |                                  103.1 |             133 |                    69.6 |             98 |         0.097 |               14 |                         -1.2  |             167 |                                         2.76 |                83 |                                           103.8 |              204 |                                           105   |              139 | 71-75    |            6 | 81-85     |             8 |
|          | 21       |        56 |             2018 |      238 | UCLA          |          0 | P12             |      32 |      21 |      11 |     0.656 |           11 |            7 |          0.611 |           14 |            2 |            3 |            7 |               4 |               3 |             2 |             2 |          1472 |          1374 |        81.7778 |         76.3333 |     2679 |     2507 |   81.1818 |    75.9697 |      906 |     1964 |    0.461 |      300 |      783 |    0.383 |      509 |      705 |    0.722 |                          13.52 |                              115   |          31 |                              101.4 |         103 |                70.3 |         70 |    -0.027 |          257 |                      6.42 |          63 |                                     2.93 |            81 |                                       108.1 |           72 |                                       101.7 |           60 | First Four  |              0 | UCLA            |     11 | St. Bonaventure   |        11 |     58 |   65 | L    |          0 |         261 |              |              |            68 |          261 | St. Bonaventure | A10                 |          32 |          25 |           7 |         0.781 |               14 |                4 |              0.778 |               13 |                1 |                9 |                4 |                   4 |                   3 |                 1 |                 1 |              1434 |              1330 |            79.6667 |             73.8889 |         2620 |         2407 |       77.0588 |        70.7941 |          844 |         1851 |        0.456 |          248 |          623 |        0.398 |          557 |          739 |        0.754 |                              11.21 |                                  110.8 |              74 |                                   99.5 |              74 |                    69.4 |            104 |         0.078 |               21 |                          2.8  |              94 |                                         1.17 |               127 |                                           107   |               86 |                                           104.2 |              111 | 56-60    |            3 | 81-85     |             8 |
|          |          |        49 |             2018 |      235 | Arizona State |          0 | P12             |      31 |      20 |      11 |     0.645 |            8 |           10 |          0.444 |           13 |            4 |            4 |            6 |               3 |               2 |             2 |             2 |          1403 |          1378 |        77.9444 |         76.5556 |     2645 |     2395 |   82.6562 |    74.8438 |      867 |     1868 |    0.464 |      277 |      761 |    0.364 |      578 |      783 |    0.738 |                          14.13 |                              116.7 |          18 |                              102.6 |         123 |                71.3 |         43 |    -0.083 |          340 |                      5.48 |          71 |                                     0.94 |           138 |                                       107.4 |           77 |                                       101.9 |           64 | First Four  |              0 | Arizona St.     |     11 | Syracuse          |        11 |     56 |   60 | L    |          0 |         155 |              |              |            41 |          155 | Syracuse        | ACC                 |          33 |          20 |          13 |         0.606 |                8 |               10 |              0.444 |               14 |                5 |                4 |                6 |                   5 |                   3 |                 2 |                 8 |              1161 |              1173 |            64.5    |             65.1667 |         2466 |         2360 |       66.6486 |        63.7838 |          751 |         1796 |        0.418 |          193 |          600 |        0.322 |          534 |          721 |        0.741 |                              14.82 |                                  107   |             135 |                                   92.2 |               5 |                    62.9 |            345 |         0.021 |              119 |                          9.81 |              27 |                                        -0.2  |               163 |                                           111.3 |                9 |                                           101.5 |               58 | 56-60    |            3 | 81-85     |             8 |
| 11       |          |        12 |             2019 |      130 | Houston       |          0 | Amer            |      34 |      31 |       3 |     0.912 |           16 |            2 |          0.889 |           19 |            1 |           10 |            1 |               4 |               2 |             3 |             2 |          1401 |          1155 |        77.8    |         64.2    |     2787 |     2258 |   75.3243 |    61.027  |      883 |     1968 |    0.449 |      305 |      838 |    0.364 |      443 |      629 |    0.704 |                          24.13 |                              115.3 |          19 |                               91.2 |          11 |                66.1 |        260 |     0.039 |           86 |                      4.45 |          76 |                                    -4.16 |           283 |                                       105.7 |           92 |                                       101.3 |           62 | First Round |              1 | Houston         |      3 | Georgia St.       |        14 |     84 |   55 | W    |          1 |          24 |              |              |           124 |           24 | Georgia State   | SB                  |          33 |          24 |           9 |         0.727 |               13 |                5 |              0.722 |               13 |                1 |                7 |                7 |                   4 |                   2 |                 0 |                 2 |              1395 |              1330 |            77.5    |             73.9    |         2598 |         2491 |       76.4118 |        73.2647 |          865 |         1858 |        0.466 |          316 |          814 |        0.388 |          424 |          643 |        0.659 |                               4.85 |                                  107.7 |             111 |                                  102.8 |             143 |                    70   |             69 |         0.143 |                2 |                          1.09 |             115 |                                         3.5  |                70 |                                           105.2 |              121 |                                           104.1 |              137 | 81-85    |            8 | 76-80     |             7 |
|          |          |        34 |             2019 |      296 | UCF           |          0 | Amer            |      31 |      23 |       8 |     0.742 |           13 |            5 |          0.722 |           15 |            2 |            5 |            5 |               4 |               2 |             2 |             2 |          1265 |          1158 |        70.3    |         64.3    |     2385 |     2128 |   72.2727 |    64.4848 |      765 |     1652 |    0.463 |      211 |      596 |    0.354 |      495 |      767 |    0.645 |                          16.51 |                              112.1 |          44 |                               95.6 |          33 |                65   |        309 |     0.011 |          152 |                      4.99 |          69 |                                    -3.71 |           264 |                                       105.9 |           90 |                                       100.9 |           57 | First Round |              1 | UCF             |      9 | VCU               |         8 |     73 |   58 | W    |          1 |         187 |              |              |            42 |          187 | VCU             | A10                 |          32 |          25 |           7 |         0.781 |               16 |                2 |              0.889 |               16 |                1 |                8 |                4 |                   1 |                   3 |                 0 |                 1 |              1312 |              1069 |            72.9    |             59.4    |         2344 |         2044 |       71.0303 |        61.9394 |          801 |         1811 |        0.442 |          229 |          745 |        0.307 |          455 |          652 |        0.698 |                              14.89 |                                  104.3 |             177 |                                   89.5 |               7 |                    68.4 |            136 |         0.007 |              164 |                          1.37 |             105 |                                         3.6  |                67 |                                           105.2 |              120 |                                           103.8 |              123 | 71-75    |            6 | 71-75     |             6 |


Table: fullpredictions
| Team           |   Actual_PF |   Predicted_PF | Opponent      |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:--------------|----------------:|--------------:|
| Vermont        |          69 |        66.0766 | Florida St.   |              76 |       76.4077 |
| Houston        |          58 |        63.8065 | Kentucky      |              62 |       67.3693 |
| Houston        |          84 |        84.0909 | Georgia St.   |              55 |       59.904  |
| Houston        |          74 |        71.9993 | Ohio St.      |              59 |       62.0067 |
| Temple         |          70 |        70.7751 | Belmont       |              81 |       76.3283 |
| Cincinnati     |          72 |        73.0752 | Iowa          |              79 |       74.8322 |
| UCF            |          73 |        74.8163 | VCU           |              58 |       53.6476 |
| UCF            |          76 |        73.2536 | Duke          |              77 |       78.5931 |
| Saint Louis    |          52 |        48.3583 | Virginia Tech |              66 |       61.0165 |
| North Carolina |          88 |        93.7346 | Iona          |              73 |       74.8053 |


Table: full_lamb_df
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 200.072 |
|      0.1 | 125.182 |
|      0.2 | 119.451 |
|      0.3 | 116.38  |
|      0.4 | 114.264 |
|      0.5 | 112.656 |
|      0.6 | 111.366 |
|      0.7 | 110.295 |
|      0.8 | 109.383 |
|      0.9 | 108.594 |


Table: greaterthan1_lassoMSE
|      MSE |   lambda |
|---------:|---------:|
|  75.8953 |        1 |
|  78.794  |        2 |
|  85.0601 |        3 |
|  93.3058 |        4 |
| 104.526  |        5 |
| 108.298  |        6 |
| 108.298  |        7 |
| 108.298  |        8 |
| 108.298  |        9 |
| 108.298  |       10 |


Table: l1246_predictions
| Team           |   Actual_PF |   Predicted_PF | Opponent         |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:-----------------|----------------:|--------------:|
| Houston        |          58 |        68.4226 | Kentucky         |              62 |       68.4782 |
| Houston        |          74 |        69.2742 | Ohio St.         |              59 |       62.3518 |
| Temple         |          70 |        72.849  | Belmont          |              81 |       74.6985 |
| UCF            |          76 |        65.7684 | Duke             |              77 |       75.8533 |
| North Carolina |          81 |        76.328  | Washington       |              59 |       70.4985 |
| Duke           |          85 |        83.0539 | North Dakota St. |              62 |       64.8414 |
| Florida St.    |          58 |        71.9657 | Gonzaga          |              72 |       76.2184 |
| Syracuse       |          69 |        65.9307 | Baylor           |              78 |       68.1201 |
| Virginia       |          80 |        71.4962 | Purdue           |              75 |       65.0421 |
| Liberty        |          80 |        69.2031 | Mississippi St.  |              76 |       67.9902 |


Table: l1_predictions
| Team           |   Actual_PF |   Predicted_PF | Opponent         |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:-----------------|----------------:|--------------:|
| Houston        |          58 |        68.6797 | Kentucky         |              62 |       68.8487 |
| Houston        |          74 |        68.4479 | Ohio St.         |              59 |       62.3409 |
| Temple         |          70 |        74.0101 | Belmont          |              81 |       75.3134 |
| UCF            |          76 |        65.3737 | Duke             |              77 |       76.7843 |
| North Carolina |          81 |        77.8026 | Washington       |              59 |       71.4038 |
| Duke           |          85 |        84.0968 | North Dakota St. |              62 |       64.0677 |
| Florida St.    |          58 |        72.6632 | Gonzaga          |              72 |       76.5852 |
| Syracuse       |          69 |        65.6615 | Baylor           |              78 |       67.9394 |
| Virginia       |          80 |        72.062  | Purdue           |              75 |       65.0492 |
| Liberty        |          80 |        68.4998 | Mississippi St.  |              76 |       68.4159 |


Table: lessthan1_lassoMSE
|     MSE |   lambda |
|--------:|---------:|
| 76.0496 |      0.1 |
| 80.6463 |      0.2 |
| 83.5531 |      0.3 |
| 82.9082 |      0.4 |
| 81.4012 |      0.5 |
| 79.9647 |      0.6 |
| 78.2998 |      0.7 |
| 77.3189 |      0.8 |
| 76.4396 |      0.9 |
| 75.8953 |      1   |


Table: NEW full_coefficients
|        0_x | 0_y        | FullCoeff_Bins   |   Order_FullCoeff_Bins |
|-----------:|:-----------|:-----------------|-----------------------:|
|  -3.55304  | AP_Rnk     | (-5,0)           |                      7 |
|   0.664423 | PS_Rnk     | (0,5)            |                      8 |
|   3.52229  | KP_Rank    | (0,5)            |                      8 |
|  -2.27707  | Auto Bid   | (-5,0)           |                      7 |
|  -4.28262  | TS_GP      | (-5,0)           |                      7 |
|  27.9974   | STA_W      | (11,50)          |                     10 |
|  64.7062   | STA_L      | (51-100)         |                     11 |
|  -4.15734  | STA_Pct    | (-5,0)           |                      7 |
|   2.66841  | STA_Conf_W | (0,5)            |                      8 |
| -25.9236   | STA_Conf_L | (-50,-11)        |                      5 |


Table: NEW traintest_coefficients
|       0_x | 0_y        | TTCoeff_Bins   |   Order_TTCoeff_Bins |
|----------:|:-----------|:---------------|---------------------:|
|  -5.52823 | AP_Rnk     | (-10,-6)       |                    6 |
|   0.31869 | PS_Rnk     | (0,5)          |                    8 |
|   6.42023 | KP_Rank    | (6,10)         |                    9 |
|  -2.61186 | Auto Bid   | (-5,0)         |                    7 |
|  -9.04458 | TS_GP      | (-10,-6)       |                    6 |
|  56.0024  | STA_W      | (51-100)       |                   11 |
|  47.7097  | STA_L      | (11,50)        |                   10 |
| -28.4557  | STA_Pct    | (-50,-11)      |                    5 |
|  -4.00614 | STA_Conf_W | (-5,0)         |                    7 |
| -35.7111  | STA_Conf_L | (-50,-11)      |                    5 |


Table: r1_predictions
| Team           |   Actual_PF |   Predicted_PF | Opponent         |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:-----------------|----------------:|--------------:|
| Houston        |          58 |        68.3412 | Kentucky         |              62 |       70.6786 |
| Houston        |          74 |        66.4159 | Ohio St.         |              59 |       61.9593 |
| Temple         |          70 |        77.4314 | Belmont          |              81 |       76.9443 |
| UCF            |          76 |        67.3634 | Duke             |              77 |       77.9325 |
| North Carolina |          81 |        81.1773 | Washington       |              59 |       76.1629 |
| Duke           |          85 |        87.5457 | North Dakota St. |              62 |       65.0522 |
| Florida St.    |          58 |        76.575  | Gonzaga          |              72 |       78.3355 |
| Syracuse       |          69 |        66.4742 | Baylor           |              78 |       66.6402 |
| Virginia       |          80 |        70.8437 | Purdue           |              75 |       66.6303 |
| Liberty        |          80 |        65.2283 | Mississippi St.  |              76 |       70.2471 |


Table: r7582_predictions
| Team           |   Actual_PF |   Predicted_PF | Opponent         |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:-----------------|----------------:|--------------:|
| Houston        |          58 |        68.3412 | Kentucky         |              62 |       70.6786 |
| Houston        |          74 |        66.4159 | Ohio St.         |              59 |       61.9593 |
| Temple         |          70 |        77.4314 | Belmont          |              81 |       76.9443 |
| UCF            |          76 |        67.3634 | Duke             |              77 |       77.9325 |
| North Carolina |          81 |        81.1773 | Washington       |              59 |       76.1629 |
| Duke           |          85 |        87.5457 | North Dakota St. |              62 |       65.0522 |
| Florida St.    |          58 |        76.575  | Gonzaga          |              72 |       78.3355 |
| Syracuse       |          69 |        66.4742 | Baylor           |              78 |       66.6402 |
| Virginia       |          80 |        70.8437 | Purdue           |              75 |       66.6303 |
| Liberty        |          80 |        65.2283 | Mississippi St.  |              76 |       70.2471 |


Table: ridgeMSEs
|     MSE |   Lambda |
|--------:|---------:|
| 496.638 |    0     |
| 465.004 |    0.001 |
| 436.075 |    0.002 |
| 409.804 |    0.003 |
| 386.272 |    0.004 |
| 365.287 |    0.005 |
| 346.577 |    0.006 |
| 329.865 |    0.007 |
| 314.896 |    0.008 |
| 301.446 |    0.009 |


Table: Split1_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    4.724 | 165.862 |
|    4.725 | 165.862 |
|    4.726 | 165.862 |
|    4.727 | 165.862 |
|    4.728 | 165.862 |
|    4.729 | 165.862 |
|    4.73  | 165.862 |
|    4.731 | 165.862 |
|    4.732 | 165.862 |
|    4.733 | 165.862 |


Table: Split1_MSEs
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 174.162 |
|      0.1 | 132.592 |
|      0.2 | 126.438 |
|      0.3 | 122.744 |
|      0.4 | 120.211 |
|      0.5 | 118.331 |
|      0.6 | 116.863 |
|      0.7 | 115.673 |
|      0.8 | 114.681 |
|      0.9 | 113.837 |


Table: Split2_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    5.235 | 121.644 |
|    5.236 | 121.644 |
|    5.237 | 121.644 |
|    5.238 | 121.644 |
|    5.239 | 121.644 |
|    5.24  | 121.644 |
|    5.241 | 121.644 |
|    5.242 | 121.644 |
|    5.243 | 121.644 |
|    5.244 | 121.644 |


Table: Split2_MSEs
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 93.4802 |
|      0.1 | 67.064  |
|      0.2 | 64.3042 |
|      0.3 | 63.1307 |
|      0.4 | 62.4888 |
|      0.5 | 62.085  |
|      0.6 | 61.8086 |
|      0.7 | 61.609  |
|      0.8 | 61.4602 |
|      0.9 | 61.3473 |


Table: Split3_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    5.391 | 155.685 |
|    5.392 | 155.685 |
|    5.393 | 155.685 |
|    5.394 | 155.685 |
|    5.395 | 155.685 |
|    5.396 | 155.685 |
|    5.397 | 155.685 |
|    5.398 | 155.685 |
|    5.399 | 155.685 |
|    5.4   | 155.685 |


Table: Split3_MSEs
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 129.21  |
|      0.1 | 121.053 |
|      0.2 | 120.641 |
|      0.3 | 119.41  |
|      0.4 | 118.129 |
|      0.5 | 116.949 |
|      0.6 | 115.894 |
|      0.7 | 114.955 |
|      0.8 | 114.12  |
|      0.9 | 113.373 |


Table: Split4_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    5.614 | 136.403 |
|    5.615 | 136.403 |
|    5.616 | 136.403 |
|    5.617 | 136.403 |
|    5.618 | 136.403 |
|    5.619 | 136.403 |
|    5.62  | 136.403 |
|    5.621 | 136.403 |
|    5.622 | 136.403 |
|    5.623 | 136.403 |


Table: Split4_MSEs
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 504.574 |
|      0.1 | 209.465 |
|      0.2 | 192.296 |
|      0.3 | 184.501 |
|      0.4 | 179.449 |
|      0.5 | 175.695 |
|      0.6 | 172.702 |
|      0.7 | 170.213 |
|      0.8 | 168.084 |
|      0.9 | 166.226 |


Table: Split5_LASSO_MSE
|   Lambda |     MSE |
|---------:|--------:|
|    5.176 | 137.847 |
|    5.177 | 137.847 |
|    5.178 | 137.847 |
|    5.179 | 137.847 |
|    5.18  | 137.847 |
|    5.181 | 137.847 |
|    5.182 | 137.847 |
|    5.183 | 137.847 |
|    5.184 | 137.847 |
|    5.185 | 137.847 |


Table: Split5_MSEs
|   Lambda |     MSE |
|---------:|--------:|
|      0   | 98.9322 |
|      0.1 | 95.7381 |
|      0.2 | 93.577  |
|      0.3 | 92.1114 |
|      0.4 | 91.0428 |
|      0.5 | 90.2201 |
|      0.6 | 89.5626 |
|      0.7 | 89.0228 |
|      0.8 | 88.5706 |
|      0.9 | 88.1856 |


Table: traintest_predictions
|       0 |   PF** |   y-yhat |   y-yhat_sq |
|--------:|-------:|---------:|------------:|
| 56.9502 |     69 | 12.0498  |   145.198   |
| 78.9345 |     70 | -8.93455 |    79.8262  |
| 75.1942 |     80 |  4.80579 |    23.0956  |
| 70.0597 |     75 |  4.94031 |    24.4067  |
| 62.2759 |     67 |  4.72414 |    22.3175  |
| 80.4557 |     76 | -4.45568 |    19.8531  |
| 54.8962 |     66 | 11.1038  |   123.294   |
| 63.8239 |     85 | 21.1761  |   448.429   |
| 78.1111 |     80 |  1.88891 |     3.56797 |
| 57.6871 |     59 |  1.31286 |     1.72361 |


Table: tt_predictions
| Team           |   Actual_PF |   Predicted_PF | Opponent         |   Opp Actual PF |   Opp Pred PF |
|:---------------|------------:|---------------:|:-----------------|----------------:|--------------:|
| Houston        |          58 |        68.4961 | Kentucky         |              62 |       72.8322 |
| Houston        |          74 |        58.0774 | Ohio St.         |              59 |       59.35   |
| Temple         |          70 |        69.5411 | Belmont          |              81 |       77.2891 |
| UCF            |          76 |        69.9419 | Duke             |              77 |       83.0825 |
| North Carolina |          81 |        83.1709 | Washington       |              59 |       65.7408 |
| Duke           |          85 |        88.005  | North Dakota St. |              62 |       57.0891 |
| Florida St.    |          58 |        69.392  | Gonzaga          |              72 |       79.9785 |
| Syracuse       |          69 |        72.8192 | Baylor           |              78 |       70.0728 |
| Virginia       |          80 |        75.9624 | Purdue           |              75 |       70.2282 |
| Liberty        |          80 |        75.5519 | Mississippi St.  |              76 |       62.2465 |


Table: T_Tpredictions
|   Actual PF |   Predicted PF |
|------------:|---------------:|
|          69 |        60.3443 |
|          70 |        70.559  |
|          80 |        78.1376 |
|          75 |        72.3505 |
|          67 |        54.3773 |
|          76 |        83.2835 |
|          66 |        62.0968 |
|          85 |        78.8557 |
|          80 |        83.968  |
|          59 |        50.7236 |

 


tables: name: AllLASSO_MSE (2)
data: AllLASSO_MSE (2).csv
name: AllLASSO_MSE
data: AllLASSO_MSE.csv
name: avg_LASSO_MSE
data: avg_LASSO_MSE.csv
name: Dataset_0
data: Dataset_0.csv
name: fullpredictions
data: fullpredictions.csv
name: full_lamb_df
data: full_lamb_df.csv
name: greaterthan1_lassoMSE
data: greaterthan1_lassoMSE.csv
name: l1246_predictions
data: l1246_predictions.csv
name: l1_predictions
data: l1_predictions.csv
name: lessthan1_lassoMSE
data: lessthan1_lassoMSE.csv
name: NEW full_coefficients
data: NEW full_coefficients.csv
name: NEW traintest_coefficients
data: NEW traintest_coefficients.csv
name: r1_predictions
data: r1_predictions.csv
name: r7582_predictions
data: r7582_predictions.csv
name: ridgeMSEs
data: ridgeMSEs.csv
name: Split1_LASSO_MSE
data: Split1_LASSO_MSE.csv
name: Split1_MSEs
data: Split1_MSEs.csv
name: Split2_LASSO_MSE
data: Split2_LASSO_MSE.csv
name: Split2_MSEs
data: Split2_MSEs.csv
name: Split3_LASSO_MSE
data: Split3_LASSO_MSE.csv
name: Split3_MSEs
data: Split3_MSEs.csv
name: Split4_LASSO_MSE
data: Split4_LASSO_MSE.csv
name: Split4_MSEs
data: Split4_MSEs.csv
name: Split5_LASSO_MSE
data: Split5_LASSO_MSE.csv
name: Split5_MSEs
data: Split5_MSEs.csv
name: traintest_predictions
data: traintest_predictions.csv
name: tt_predictions
data: tt_predictions.csv
name: T_Tpredictions
data: T_Tpredictions.csv
label: Split2_MSEs
Lambda
Split1_MSEs
Lambda
Split3_MSEs
Lambda
Split2_MSEs
Lambda
Split4_MSEs
Lambda
Split3_MSEs
Lambda
Split5_MSEs
Lambda
Split4_MSEs
Lambda
AllLASSO_MSE (2)
lambda
avg_LASSO_MSE
Lambda
AllLASSO_MSE
lambda
avg_LASSO_MSE
Lambda
Split2_LASSO_MSE
Lambda
Split1_LASSO_MSE
Lambda
Split3_LASSO_MSE
Lambda
Split2_LASSO_MSE
Lambda
Split4_LASSO_MSE
Lambda
Split3_LASSO_MSE
Lambda
Split5_LASSO_MSE
Lambda
Split4_LASSO_MSE
Lambda
output: {
    "joins": [
        {
            "from_table": "Split2_MSEs",
            "from_column": "Lambda",
            "to_table": "Split1_MSEs",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split3_MSEs",
            "from_column": "Lambda",
            "to_table": "Split2_MSEs",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split4_MSEs",
            "from_column": "Lambda",
            "to_table": "Split3_MSEs",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split5_MSEs",
            "from_column": "Lambda",
            "to_table": "Split4_MSEs",
            "to_column": "Lambda"
        },
        {
            "from_table": "AllLASSO_MSE (2)",
            "from_column": "lambda",
            "to_table": "avg_LASSO_MSE",
            "to_column": "Lambda"
        },
        {
            "from_table": "AllLASSO_MSE",
            "from_column": "lambda",
            "to_table": "avg_LASSO_MSE",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split2_LASSO_MSE",
            "from_column": "Lambda",
            "to_table": "Split1_LASSO_MSE",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split3_LASSO_MSE",
            "from_column": "Lambda",
            "to_table": "Split2_LASSO_MSE",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split4_LASSO_MSE",
            "from_column": "Lambda",
            "to_table": "Split3_LASSO_MSE",
            "to_column": "Lambda"
        },
        {
            "from_table": "Split5_LASSO_MSE",
            "from_column": "Lambda",
            "to_table": "Split4_LASSO_MSE",
            "to_column": "Lambda"
        }
    ]
}