stdout

<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>Unnamed: 0</th>
      <th>Values in ppm</th>
      <th>Sc</th>
      <th>V</th>
      <th>Cr</th>
      <th>Co</th>
      <th>Ni</th>
      <th>Cu</th>
      <th>Zn</th>
      <th>Rb</th>
      <th>...</th>
      <th>Ho</th>
      <th>Er</th>
      <th>Tm</th>
      <th>Yb</th>
      <th>Lu</th>
      <th>Hf</th>
      <th>Ta</th>
      <th>Pb</th>
      <th>Th</th>
      <th>U</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>NaN</td>
      <td>Method DL (fusions)</td>
      <td>0.187785</td>
      <td>0.139596</td>
      <td>1.591991</td>
      <td>0.104345</td>
      <td>0.614483</td>
      <td>0.325633</td>
      <td>2.989530</td>
      <td>0.066512</td>
      <td>...</td>
      <td>0.002696</td>
      <td>0.003459</td>
      <td>0.001024</td>
      <td>0.007580</td>
      <td>0.005523</td>
      <td>0.012565</td>
      <td>0.002697</td>
      <td>0.078602</td>
      <td>0.002853</td>
      <td>0.004637</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Certified BCR glass</td>
      <td>NaN</td>
      <td>33.000000</td>
      <td>425.000000</td>
      <td>17.000000</td>
      <td>38.000000</td>
      <td>13.000000</td>
      <td>21.000000</td>
      <td>125.000000</td>
      <td>47.000000</td>
      <td>...</td>
      <td>1.270000</td>
      <td>3.700000</td>
      <td>0.510000</td>
      <td>3.390000</td>
      <td>0.503000</td>
      <td>4.840000</td>
      <td>0.780000</td>
      <td>11.000000</td>
      <td>5.900000</td>
      <td>1.690000</td>
    </tr>
    <tr>
      <th>2</th>
      <td>NaN</td>
      <td>BCR-2G</td>
      <td>32.280946</td>
      <td>394.935430</td>
      <td>15.269346</td>
      <td>37.832051</td>
      <td>12.516213</td>
      <td>18.185483</td>
      <td>159.024303</td>
      <td>46.914446</td>
      <td>...</td>
      <td>1.282083</td>
      <td>3.331760</td>
      <td>0.503488</td>
      <td>3.163349</td>
      <td>0.491683</td>
      <td>4.518269</td>
      <td>0.781933</td>
      <td>10.445390</td>
      <td>5.439970</td>
      <td>1.655374</td>
    </tr>
    <tr>
      <th>3</th>
      <td>NaN</td>
      <td>BCR-2G</td>
      <td>32.645280</td>
      <td>402.977959</td>
      <td>15.101562</td>
      <td>37.630262</td>
      <td>13.275790</td>
      <td>17.983849</td>
      <td>160.377711</td>
      <td>46.126096</td>
      <td>...</td>
      <td>1.285771</td>
      <td>3.393320</td>
      <td>0.519103</td>
      <td>3.240367</td>
      <td>0.495125</td>
      <td>4.608376</td>
      <td>0.792624</td>
      <td>10.323739</td>
      <td>5.619844</td>
      <td>1.705767</td>
    </tr>
    <tr>
      <th>4</th>
      <td>NaN</td>
      <td>BCR-2G</td>
      <td>31.919941</td>
      <td>377.860142</td>
      <td>15.101693</td>
      <td>36.467416</td>
      <td>11.316142</td>
      <td>17.416010</td>
      <td>152.940573</td>
      <td>46.931636</td>
      <td>...</td>
      <td>1.208983</td>
      <td>3.335452</td>
      <td>0.471531</td>
      <td>3.204906</td>
      <td>0.466471</td>
      <td>4.470008</td>
      <td>0.751932</td>
      <td>10.837426</td>
      <td>5.539408</td>
      <td>1.617836</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 36 columns</p>
</div>

            Unnamed: 0        Values in ppm         Sc           V         Cr  \
0                  NaN  Method DL (fusions)   0.187785    0.139596   1.591991   
1  Certified BCR glass                  NaN  33.000000  425.000000  17.000000   
2                  NaN               BCR-2G  32.280946  394.935430  15.269346   
3                  NaN               BCR-2G  32.645280  402.977959  15.101562   
4                  NaN               BCR-2G  31.919941  377.860142  15.101693   

          Co         Ni         Cu          Zn         Rb  ...        Ho  \
0   0.104345   0.614483   0.325633    2.989530   0.066512  ...  0.002696   
1  38.000000  13.000000  21.000000  125.000000  47.000000  ...  1.270000   
2  37.832051  12.516213  18.185483  159.024303  46.914446  ...  1.282083   
3  37.630262  13.275790  17.983849  160.377711  46.126096  ...  1.285771   
4  36.467416  11.316142  17.416010  152.940573  46.931636  ...  1.208983   

         Er        Tm        Yb        Lu        Hf        Ta         Pb  \
0  0.003459  0.001024  0.007580  0.005523  0.012565  0.002697   0.078602   
1  3.700000  0.510000  3.390000  0.503000  4.840000  0.780000  11.000000   
2  3.331760  0.503488  3.163349  0.491683  4.518269  0.781933  10.445390   
3  3.393320  0.519103  3.240367  0.495125  4.608376  0.792624  10.323739   
4  3.335452  0.471531  3.204906  0.466471  4.470008  0.751932  10.837426   

         Th         U  
0  0.002853  0.004637  
1  5.900000  1.690000  
2  5.439970  1.655374  
3  5.619844  1.705767  
4  5.539408  1.617836  

[5 rows x 36 columns]

<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>Values in ppm</th>
      <th>Sc</th>
      <th>V</th>
      <th>Cr</th>
      <th>Co</th>
      <th>Ni</th>
      <th>Cu</th>
      <th>Zn</th>
      <th>Rb</th>
      <th>Sr</th>
      <th>...</th>
      <th>Ho</th>
      <th>Er</th>
      <th>Tm</th>
      <th>Yb</th>
      <th>Lu</th>
      <th>Hf</th>
      <th>Ta</th>
      <th>Pb</th>
      <th>Th</th>
      <th>U</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>ENF - 1</td>
      <td>2.860693</td>
      <td>14.514355</td>
      <td>390.100204</td>
      <td>2.601951</td>
      <td>111.387552</td>
      <td>14.945676</td>
      <td>146.440541</td>
      <td>127.027523</td>
      <td>54.672984</td>
      <td>...</td>
      <td>3.862648</td>
      <td>10.109876</td>
      <td>1.541921</td>
      <td>9.049524</td>
      <td>1.377034</td>
      <td>19.886453</td>
      <td>6.494302</td>
      <td>78.136504</td>
      <td>15.372999</td>
      <td>2.338168</td>
    </tr>
    <tr>
      <th>1</th>
      <td>ENF - 2</td>
      <td>3.030932</td>
      <td>14.289565</td>
      <td>384.880008</td>
      <td>2.480874</td>
      <td>109.898787</td>
      <td>14.965225</td>
      <td>141.638596</td>
      <td>125.369953</td>
      <td>53.840328</td>
      <td>...</td>
      <td>3.894680</td>
      <td>9.902998</td>
      <td>1.519457</td>
      <td>8.671702</td>
      <td>1.404728</td>
      <td>19.968322</td>
      <td>6.464128</td>
      <td>77.461388</td>
      <td>15.288197</td>
      <td>2.456838</td>
    </tr>
    <tr>
      <th>2</th>
      <td>ENV - 1</td>
      <td>2.522075</td>
      <td>15.620488</td>
      <td>1065.676988</td>
      <td>6.817489</td>
      <td>273.621817</td>
      <td>39.863641</td>
      <td>321.697645</td>
      <td>258.185809</td>
      <td>1.980601</td>
      <td>...</td>
      <td>3.837634</td>
      <td>11.562508</td>
      <td>1.718484</td>
      <td>10.775372</td>
      <td>1.370192</td>
      <td>15.061332</td>
      <td>12.466809</td>
      <td>26.185163</td>
      <td>20.358023</td>
      <td>7.480647</td>
    </tr>
    <tr>
      <th>3</th>
      <td>ENV - 2</td>
      <td>1.985153</td>
      <td>15.422299</td>
      <td>1062.842696</td>
      <td>6.687500</td>
      <td>287.615600</td>
      <td>39.240511</td>
      <td>321.000880</td>
      <td>267.203813</td>
      <td>2.045667</td>
      <td>...</td>
      <td>3.889471</td>
      <td>10.970075</td>
      <td>1.712672</td>
      <td>11.725417</td>
      <td>1.464126</td>
      <td>15.496956</td>
      <td>13.175835</td>
      <td>28.295873</td>
      <td>21.866190</td>
      <td>8.468296</td>
    </tr>
    <tr>
      <th>4</th>
      <td>ENO - 1</td>
      <td>3.636945</td>
      <td>25.126412</td>
      <td>608.528258</td>
      <td>7.504753</td>
      <td>210.560542</td>
      <td>30.080481</td>
      <td>141.719185</td>
      <td>139.411610</td>
      <td>45.906241</td>
      <td>...</td>
      <td>3.159288</td>
      <td>8.244338</td>
      <td>1.245540</td>
      <td>7.179192</td>
      <td>1.017333</td>
      <td>11.264385</td>
      <td>4.892983</td>
      <td>22.672716</td>
      <td>15.654104</td>
      <td>4.280952</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 35 columns</p>
</div>

  Values in ppm        Sc          V           Cr        Co          Ni  \
0       ENF - 1  2.860693  14.514355   390.100204  2.601951  111.387552   
1       ENF - 2  3.030932  14.289565   384.880008  2.480874  109.898787   
2       ENV - 1  2.522075  15.620488  1065.676988  6.817489  273.621817   
3       ENV - 2  1.985153  15.422299  1062.842696  6.687500  287.615600   
4       ENO - 1  3.636945  25.126412   608.528258  7.504753  210.560542   

          Cu          Zn          Rb         Sr  ...        Ho         Er  \
0  14.945676  146.440541  127.027523  54.672984  ...  3.862648  10.109876   
1  14.965225  141.638596  125.369953  53.840328  ...  3.894680   9.902998   
2  39.863641  321.697645  258.185809   1.980601  ...  3.837634  11.562508   
3  39.240511  321.000880  267.203813   2.045667  ...  3.889471  10.970075   
4  30.080481  141.719185  139.411610  45.906241  ...  3.159288   8.244338   

         Tm         Yb        Lu         Hf         Ta         Pb         Th  \
0  1.541921   9.049524  1.377034  19.886453   6.494302  78.136504  15.372999   
1  1.519457   8.671702  1.404728  19.968322   6.464128  77.461388  15.288197   
2  1.718484  10.775372  1.370192  15.061332  12.466809  26.185163  20.358023   
3  1.712672  11.725417  1.464126  15.496956  13.175835  28.295873  21.866190   
4  1.245540   7.179192  1.017333  11.264385   4.892983  22.672716  15.654104   

          U  
0  2.338168  
1  2.456838  
2  7.480647  
3  8.468296  
4  4.280952  

[5 rows x 35 columns]

Analyzing Element Concentrations in Multiple Data Sheets

Comparison of elements concentration

Compare element concentrations across samples in Sheet2