<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Entering Program</th>
      <th>Current Program</th>
      <th>Program Status</th>
      <th>BIO201 Term</th>
      <th>BIO201 Grade</th>
      <th>BIO201A Grade</th>
      <th>BIO202 Term</th>
      <th>BIO202 Grade</th>
      <th>BIO202A Grade</th>
      <th>BIO203 Term</th>
      <th>BIO203 Grade</th>
      <th>BIO203A Grade</th>
      <th>BST322 Term</th>
      <th>BST322 Grade</th>
      <th>TEAS Score</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Non-Degree UGRD</td>
      <td>Non-Degree UGRD</td>
      <td>Cancelled</td>
      <td>2007.0</td>
      <td>A</td>
      <td>A</td>
      <td>2011.0</td>
      <td>A</td>
      <td>A</td>
      <td>2001.0</td>
      <td>A</td>
      <td>A</td>
      <td>1807.0</td>
      <td>A-</td>
      <td>96.0</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Non-Degree UGRD</td>
      <td>Nursing BS (PB)</td>
      <td>Completed Program</td>
      <td>1911.0</td>
      <td>A</td>
      <td>A</td>
      <td>2001.0</td>
      <td>A</td>
      <td>A</td>
      <td>1909.0</td>
      <td>A</td>
      <td>A</td>
      <td>1908.0</td>
      <td>A-</td>
      <td>96.0</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Human Biology AS</td>
      <td>Non-Degree UGRD</td>
      <td>Active in Program</td>
      <td>1905.0</td>
      <td>B-</td>
      <td>C</td>
      <td>1907.0</td>
      <td>B+</td>
      <td>A-</td>
      <td>1909.0</td>
      <td>A-</td>
      <td>B-</td>
      <td>1904.0</td>
      <td>A</td>
      <td>95.3</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Non-Degree UGRD</td>
      <td>Nursing BS (PB)</td>
      <td>Completed Program</td>
      <td>2002.0</td>
      <td>A</td>
      <td>A</td>
      <td>2004.0</td>
      <td>A</td>
      <td>A</td>
      <td>2006.0</td>
      <td>A</td>
      <td>A</td>
      <td>1911.0</td>
      <td>A</td>
      <td>95.3</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Public Health BS</td>
      <td>Nursing BS</td>
      <td>Completed Program</td>
      <td>2008.0</td>
      <td>A</td>
      <td>A</td>
      <td>2010.0</td>
      <td>A</td>
      <td>A</td>
      <td>2001.0</td>
      <td>A-</td>
      <td>A</td>
      <td>1908.0</td>
      <td>A</td>
      <td>95.3</td>
    </tr>
  </tbody>
</table>
</div>

   Entering Program  Current Program     Program Status  BIO201 Term  \
0   Non-Degree UGRD  Non-Degree UGRD          Cancelled       2007.0   
1   Non-Degree UGRD  Nursing BS (PB)  Completed Program       1911.0   
2  Human Biology AS  Non-Degree UGRD  Active in Program       1905.0   
3   Non-Degree UGRD  Nursing BS (PB)  Completed Program       2002.0   
4  Public Health BS       Nursing BS  Completed Program       2008.0   

  BIO201 Grade BIO201A Grade  BIO202 Term BIO202 Grade BIO202A Grade  \
0            A             A       2011.0            A             A   
1            A             A       2001.0            A             A   
2           B-             C       1907.0           B+            A-   
3            A             A       2004.0            A             A   
4            A             A       2010.0            A             A   

   BIO203 Term BIO203 Grade BIO203A Grade  BST322 Term BST322 Grade  \
0       2001.0            A             A       1807.0           A-   
1       1909.0            A             A       1908.0           A-   
2       1909.0           A-            B-       1904.0            A   
3       2006.0            A             A       1911.0            A   
4       2001.0           A-             A       1908.0            A   

   TEAS Score  
0        96.0  
1        96.0  
2        95.3  
3        95.3  
4        95.3  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>BIO201 Grade</th>
      <th>BIO201A Grade</th>
      <th>BIO202 Grade</th>
      <th>BIO202A Grade</th>
      <th>BIO203 Grade</th>
      <th>BIO203A Grade</th>
      <th>BST322 Grade</th>
      <th>TEAS Score</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>BIO201 Grade</th>
      <td>1.000000</td>
      <td>0.493771</td>
      <td>0.451072</td>
      <td>0.320011</td>
      <td>0.096505</td>
      <td>0.241727</td>
      <td>0.098536</td>
      <td>0.262960</td>
    </tr>
    <tr>
      <th>BIO201A Grade</th>
      <td>0.493771</td>
      <td>1.000000</td>
      <td>0.179034</td>
      <td>0.224407</td>
      <td>0.041235</td>
      <td>0.233379</td>
      <td>0.229784</td>
      <td>-0.013531</td>
    </tr>
    <tr>
      <th>BIO202 Grade</th>
      <td>0.451072</td>
      <td>0.179034</td>
      <td>1.000000</td>
      <td>0.617610</td>
      <td>0.321986</td>
      <td>0.353393</td>
      <td>0.226358</td>
      <td>0.378407</td>
    </tr>
    <tr>
      <th>BIO202A Grade</th>
      <td>0.320011</td>
      <td>0.224407</td>
      <td>0.617610</td>
      <td>1.000000</td>
      <td>0.137909</td>
      <td>0.078454</td>
      <td>0.111416</td>
      <td>0.157483</td>
    </tr>
    <tr>
      <th>BIO203 Grade</th>
      <td>0.096505</td>
      <td>0.041235</td>
      <td>0.321986</td>
      <td>0.137909</td>
      <td>1.000000</td>
      <td>0.735167</td>
      <td>0.092316</td>
      <td>0.234223</td>
    </tr>
    <tr>
      <th>BIO203A Grade</th>
      <td>0.241727</td>
      <td>0.233379</td>
      <td>0.353393</td>
      <td>0.078454</td>
      <td>0.735167</td>
      <td>1.000000</td>
      <td>0.065384</td>
      <td>0.127664</td>
    </tr>
    <tr>
      <th>BST322 Grade</th>
      <td>0.098536</td>
      <td>0.229784</td>
      <td>0.226358</td>
      <td>0.111416</td>
      <td>0.092316</td>
      <td>0.065384</td>
      <td>1.000000</td>
      <td>0.176865</td>
    </tr>
    <tr>
      <th>TEAS Score</th>
      <td>0.262960</td>
      <td>-0.013531</td>
      <td>0.378407</td>
      <td>0.157483</td>
      <td>0.234223</td>
      <td>0.127664</td>
      <td>0.176865</td>
      <td>1.000000</td>
    </tr>
  </tbody>
</table>
</div>

               BIO201 Grade  BIO201A Grade  BIO202 Grade  BIO202A Grade  \
BIO201 Grade       1.000000       0.493771      0.451072       0.320011   
BIO201A Grade      0.493771       1.000000      0.179034       0.224407   
BIO202 Grade       0.451072       0.179034      1.000000       0.617610   
BIO202A Grade      0.320011       0.224407      0.617610       1.000000   
BIO203 Grade       0.096505       0.041235      0.321986       0.137909   
BIO203A Grade      0.241727       0.233379      0.353393       0.078454   
BST322 Grade       0.098536       0.229784      0.226358       0.111416   
TEAS Score         0.262960      -0.013531      0.378407       0.157483   

               BIO203 Grade  BIO203A Grade  BST322 Grade  TEAS Score  
BIO201 Grade       0.096505       0.241727      0.098536    0.262960  
BIO201A Grade      0.041235       0.233379      0.229784   -0.013531  
BIO202 Grade       0.321986       0.353393      0.226358    0.378407  
BIO202A Grade      0.137909       0.078454      0.111416    0.157483  
BIO203 Grade       1.000000       0.735167      0.092316    0.234223  
BIO203A Grade      0.735167       1.000000      0.065384    0.127664  
BST322 Grade       0.092316       0.065384      1.000000    0.176865  
TEAS Score         0.234223       0.127664      0.176865    1.000000  

Vizly: AI-powered data analysis

Correlation Analysis of Course Grades and TEAS Scores for Human Biology AS Students

Please show me the correlations between the course grades and TEAS scores for students in the Human Biology AS program

Could you please bin courses and their 'A' equivalents? i.e. BIO201 and BIO201A in one bin. Plot these courses vs. the correlation with TEAS scores on a bar chart

	BIO201 Grade	BIO201A Grade	BIO202 Grade	BIO202A Grade	BIO203 Grade	BIO203A Grade	BST322 Grade	TEAS Score
BIO201 Grade	1.000000	0.493771	0.451072	0.320011	0.096505	0.241727	0.098536	0.262960
BIO201A Grade	0.493771	1.000000	0.179034	0.224407	0.041235	0.233379	0.229784	-0.013531
BIO202 Grade	0.451072	0.179034	1.000000	0.617610	0.321986	0.353393	0.226358	0.378407
BIO202A Grade	0.320011	0.224407	0.617610	1.000000	0.137909	0.078454	0.111416	0.157483
BIO203 Grade	0.096505	0.041235	0.321986	0.137909	1.000000	0.735167	0.092316	0.234223
BIO203A Grade	0.241727	0.233379	0.353393	0.078454	0.735167	1.000000	0.065384	0.127664
BST322 Grade	0.098536	0.229784	0.226358	0.111416	0.092316	0.065384	1.000000	0.176865
TEAS Score	0.262960	-0.013531	0.378407	0.157483	0.234223	0.127664	0.176865	1.000000