<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>name</th>
      <th>album</th>
      <th>release_date</th>
      <th>track_number</th>
      <th>id</th>
      <th>uri</th>
      <th>acousticness</th>
      <th>danceability</th>
      <th>energy</th>
      <th>instrumentalness</th>
      <th>liveness</th>
      <th>loudness</th>
      <th>speechiness</th>
      <th>tempo</th>
      <th>valence</th>
      <th>popularity</th>
      <th>duration_ms</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>0</td>
      <td>Fortnight (feat. Post Malone)</td>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>2024-04-19</td>
      <td>1</td>
      <td>6dODwocEuGzHAavXqTbwHv</td>
      <td>spotify:track:6dODwocEuGzHAavXqTbwHv</td>
      <td>0.5020</td>
      <td>0.504</td>
      <td>0.386</td>
      <td>0.000015</td>
      <td>0.0961</td>
      <td>-10.976</td>
      <td>0.0308</td>
      <td>192.004</td>
      <td>0.281</td>
      <td>92</td>
      <td>228965</td>
    </tr>
    <tr>
      <th>1</th>
      <td>1</td>
      <td>The Tortured Poets Department</td>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>2024-04-19</td>
      <td>2</td>
      <td>4PdLaGZubp4lghChqp8erB</td>
      <td>spotify:track:4PdLaGZubp4lghChqp8erB</td>
      <td>0.0483</td>
      <td>0.604</td>
      <td>0.428</td>
      <td>0.000000</td>
      <td>0.1260</td>
      <td>-8.441</td>
      <td>0.0255</td>
      <td>110.259</td>
      <td>0.292</td>
      <td>90</td>
      <td>293048</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2</td>
      <td>My Boy Only Breaks His Favorite Toys</td>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>2024-04-19</td>
      <td>3</td>
      <td>7uGYWMwRy24dm7RUDDhUlD</td>
      <td>spotify:track:7uGYWMwRy24dm7RUDDhUlD</td>
      <td>0.1370</td>
      <td>0.596</td>
      <td>0.563</td>
      <td>0.000000</td>
      <td>0.3020</td>
      <td>-7.362</td>
      <td>0.0269</td>
      <td>97.073</td>
      <td>0.481</td>
      <td>90</td>
      <td>203801</td>
    </tr>
    <tr>
      <th>3</th>
      <td>3</td>
      <td>Down Bad</td>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>2024-04-19</td>
      <td>4</td>
      <td>1kbEbBdEgQdQeLXCJh28pJ</td>
      <td>spotify:track:1kbEbBdEgQdQeLXCJh28pJ</td>
      <td>0.5600</td>
      <td>0.541</td>
      <td>0.366</td>
      <td>0.000001</td>
      <td>0.0946</td>
      <td>-10.412</td>
      <td>0.0748</td>
      <td>159.707</td>
      <td>0.168</td>
      <td>91</td>
      <td>261228</td>
    </tr>
    <tr>
      <th>4</th>
      <td>4</td>
      <td>So Long, London</td>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>2024-04-19</td>
      <td>5</td>
      <td>7wAkQFShJ27V8362MqevQr</td>
      <td>spotify:track:7wAkQFShJ27V8362MqevQr</td>
      <td>0.7300</td>
      <td>0.423</td>
      <td>0.533</td>
      <td>0.002640</td>
      <td>0.0816</td>
      <td>-11.388</td>
      <td>0.3220</td>
      <td>160.218</td>
      <td>0.248</td>
      <td>90</td>
      <td>262974</td>
    </tr>
  </tbody>
</table>
</div>

   Unnamed: 0                                  name  \
0           0         Fortnight (feat. Post Malone)   
1           1         The Tortured Poets Department   
2           2  My Boy Only Breaks His Favorite Toys   
3           3                              Down Bad   
4           4                       So Long, London   

                                          album release_date  track_number  \
0  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   2024-04-19             1   
1  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   2024-04-19             2   
2  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   2024-04-19             3   
3  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   2024-04-19             4   
4  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   2024-04-19             5   

                       id                                   uri  acousticness  \
0  6dODwocEuGzHAavXqTbwHv  spotify:track:6dODwocEuGzHAavXqTbwHv        0.5020   
1  4PdLaGZubp4lghChqp8erB  spotify:track:4PdLaGZubp4lghChqp8erB        0.0483   
2  7uGYWMwRy24dm7RUDDhUlD  spotify:track:7uGYWMwRy24dm7RUDDhUlD        0.1370   
3  1kbEbBdEgQdQeLXCJh28pJ  spotify:track:1kbEbBdEgQdQeLXCJh28pJ        0.5600   
4  7wAkQFShJ27V8362MqevQr  spotify:track:7wAkQFShJ27V8362MqevQr        0.7300   

   danceability  energy  instrumentalness  liveness  loudness  speechiness  \
0         0.504   0.386          0.000015    0.0961   -10.976       0.0308   
1         0.604   0.428          0.000000    0.1260    -8.441       0.0255   
2         0.596   0.563          0.000000    0.3020    -7.362       0.0269   
3         0.541   0.366          0.000001    0.0946   -10.412       0.0748   
4         0.423   0.533          0.002640    0.0816   -11.388       0.3220   

     tempo  valence  popularity  duration_ms  
0  192.004    0.281          92       228965  
1  110.259    0.292          90       293048  
2   97.073    0.481          90       203801  
3  159.707    0.168          91       261228  
4  160.218    0.248          90       262974  

<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>album</th>
      <th>popularity</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>20</th>
      <td>THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY</td>
      <td>87.935484</td>
    </tr>
    <tr>
      <th>19</th>
      <td>THE TORTURED POETS DEPARTMENT</td>
      <td>84.187500</td>
    </tr>
    <tr>
      <th>8</th>
      <td>Lover</td>
      <td>78.277778</td>
    </tr>
    <tr>
      <th>27</th>
      <td>reputation</td>
      <td>77.866667</td>
    </tr>
    <tr>
      <th>9</th>
      <td>Midnights</td>
      <td>76.846154</td>
    </tr>
  </tbody>
</table>
</div>

                                           album  popularity
20  THE TORTURED POETS DEPARTMENT: THE ANTHOLOGY   87.935484
19                 THE TORTURED POETS DEPARTMENT   84.187500
8                                          Lover   78.277778
27                                    reputation   77.866667
9                                      Midnights   76.846154

<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>album</th>
      <th>popularity</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>28</th>
      <td>reputation Stadium Tour Surprise Song Playlist</td>
      <td>33.913043</td>
    </tr>
    <tr>
      <th>7</th>
      <td>Live From Clear Channel Stripped 2008</td>
      <td>34.000000</td>
    </tr>
    <tr>
      <th>6</th>
      <td>Fearless Platinum Edition</td>
      <td>40.526316</td>
    </tr>
    <tr>
      <th>13</th>
      <td>Red (Deluxe Edition)</td>
      <td>42.090909</td>
    </tr>
    <tr>
      <th>18</th>
      <td>Speak Now World Tour Live</td>
      <td>43.437500</td>
    </tr>
  </tbody>
</table>
</div>

                                             album  popularity
28  reputation Stadium Tour Surprise Song Playlist   33.913043
7            Live From Clear Channel Stripped 2008   34.000000
6                        Fearless Platinum Edition   40.526316
13                            Red (Deluxe Edition)   42.090909
18                       Speak Now World Tour Live   43.437500

Notebook

Show me Taylor Swift's top 5 and worst 5 albums

Summary of Taylor Swift's Album Popularity