| \n", " | Unnamed: 0 | \n", "track_id | \n", "artists | \n", "album_name | \n", "track_name | \n", "popularity | \n", "duration_ms | \n", "explicit | \n", "danceability | \n", "energy | \n", "... | \n", "loudness | \n", "mode | \n", "speechiness | \n", "acousticness | \n", "instrumentalness | \n", "liveness | \n", "valence | \n", "tempo | \n", "time_signature | \n", "track_genre | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "5SuOikwiRyPMVoIQDJUgSV | \n", "Gen Hoshino | \n", "Comedy | \n", "Comedy | \n", "73 | \n", "230666 | \n", "False | \n", "0.676 | \n", "0.4610 | \n", "... | \n", "-6.746 | \n", "0 | \n", "0.1430 | \n", "0.0322 | \n", "0.000001 | \n", "0.3580 | \n", "0.715 | \n", "87.917 | \n", "4 | \n", "acoustic | \n", "
| 1 | \n", "1 | \n", "4qPNDBW1i3p13qLCt0Ki3A | \n", "Ben Woodward | \n", "Ghost (Acoustic) | \n", "Ghost - Acoustic | \n", "55 | \n", "149610 | \n", "False | \n", "0.420 | \n", "0.1660 | \n", "... | \n", "-17.235 | \n", "1 | \n", "0.0763 | \n", "0.9240 | \n", "0.000006 | \n", "0.1010 | \n", "0.267 | \n", "77.489 | \n", "4 | \n", "acoustic | \n", "
| 2 | \n", "2 | \n", "1iJBSr7s7jYXzM8EGcbK5b | \n", "Ingrid Michaelson;ZAYN | \n", "To Begin Again | \n", "To Begin Again | \n", "57 | \n", "210826 | \n", "False | \n", "0.438 | \n", "0.3590 | \n", "... | \n", "-9.734 | \n", "1 | \n", "0.0557 | \n", "0.2100 | \n", "0.000000 | \n", "0.1170 | \n", "0.120 | \n", "76.332 | \n", "4 | \n", "acoustic | \n", "
| 3 | \n", "3 | \n", "6lfxq3CG4xtTiEg7opyCyx | \n", "Kina Grannis | \n", "Crazy Rich Asians (Original Motion Picture Sou... | \n", "Can't Help Falling In Love | \n", "71 | \n", "201933 | \n", "False | \n", "0.266 | \n", "0.0596 | \n", "... | \n", "-18.515 | \n", "1 | \n", "0.0363 | \n", "0.9050 | \n", "0.000071 | \n", "0.1320 | \n", "0.143 | \n", "181.740 | \n", "3 | \n", "acoustic | \n", "
| 4 | \n", "4 | \n", "5vjLSffimiIP26QG5WcN2K | \n", "Chord Overstreet | \n", "Hold On | \n", "Hold On | \n", "82 | \n", "198853 | \n", "False | \n", "0.618 | \n", "0.4430 | \n", "... | \n", "-9.681 | \n", "1 | \n", "0.0526 | \n", "0.4690 | \n", "0.000000 | \n", "0.0829 | \n", "0.167 | \n", "119.949 | \n", "4 | \n", "acoustic | \n", "
5 rows × 21 columns
\n", "| \n", " | 0 | \n", "
|---|---|
| Unnamed: 0 | \n", "0 | \n", "
| track_id | \n", "0 | \n", "
| artists | \n", "1 | \n", "
| album_name | \n", "1 | \n", "
| track_name | \n", "1 | \n", "
| popularity | \n", "0 | \n", "
| duration_ms | \n", "0 | \n", "
| explicit | \n", "0 | \n", "
| danceability | \n", "0 | \n", "
| energy | \n", "0 | \n", "
| key | \n", "0 | \n", "
| loudness | \n", "0 | \n", "
| mode | \n", "0 | \n", "
| speechiness | \n", "0 | \n", "
| acousticness | \n", "0 | \n", "
| instrumentalness | \n", "0 | \n", "
| liveness | \n", "0 | \n", "
| valence | \n", "0 | \n", "
| tempo | \n", "0 | \n", "
| time_signature | \n", "0 | \n", "
| track_genre | \n", "0 | \n", "
| \n", " | 0 | \n", "
|---|---|
| Unnamed: 0 | \n", "0 | \n", "
| track_id | \n", "0 | \n", "
| artists | \n", "0 | \n", "
| album_name | \n", "0 | \n", "
| track_name | \n", "0 | \n", "
| popularity | \n", "0 | \n", "
| duration_ms | \n", "0 | \n", "
| explicit | \n", "0 | \n", "
| danceability | \n", "0 | \n", "
| energy | \n", "0 | \n", "
| key | \n", "0 | \n", "
| loudness | \n", "0 | \n", "
| mode | \n", "0 | \n", "
| speechiness | \n", "0 | \n", "
| acousticness | \n", "0 | \n", "
| instrumentalness | \n", "0 | \n", "
| liveness | \n", "0 | \n", "
| valence | \n", "0 | \n", "
| tempo | \n", "0 | \n", "
| time_signature | \n", "0 | \n", "
| track_genre | \n", "0 | \n", "
| \n", " | 0 | \n", "
|---|---|
| popularity | \n", "0 | \n", "
| duration_ms | \n", "946 | \n", "
| loudness | \n", "2475 | \n", "
| tempo | \n", "201 | \n", "
| danceability | \n", "157 | \n", "
| energy | \n", "0 | \n", "
| acousticness | \n", "0 | \n", "
| instrumentalness | \n", "0 | \n", "
| liveness | \n", "3634 | \n", "
| valence | \n", "0 | \n", "
| \n", " | Unnamed: 0 | \n", "popularity | \n", "duration_ms | \n", "danceability | \n", "energy | \n", "key | \n", "loudness | \n", "mode | \n", "speechiness | \n", "acousticness | \n", "instrumentalness | \n", "liveness | \n", "valence | \n", "tempo | \n", "time_signature | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "113999.000000 | \n", "113999.000000 | \n", "1.139990e+05 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "113999.000000 | \n", "
| mean | \n", "56999.421925 | \n", "33.238827 | \n", "2.280312e+05 | \n", "0.566801 | \n", "0.641383 | \n", "5.309126 | \n", "-8.258950 | \n", "0.637558 | \n", "0.084652 | \n", "0.314907 | \n", "0.156051 | \n", "0.213554 | \n", "0.474066 | \n", "122.147695 | \n", "3.904034 | \n", "
| std | \n", "32909.243463 | \n", "22.304959 | \n", "1.072961e+05 | \n", "0.173543 | \n", "0.251530 | \n", "3.559999 | \n", "5.029357 | \n", "0.480708 | \n", "0.105733 | \n", "0.332522 | \n", "0.309556 | \n", "0.190378 | \n", "0.259261 | \n", "29.978290 | \n", "0.432623 | \n", "
| min | \n", "0.000000 | \n", "0.000000 | \n", "8.586000e+03 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "-49.531000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| 25% | \n", "28499.500000 | \n", "17.000000 | \n", "1.740660e+05 | \n", "0.456000 | \n", "0.472000 | \n", "2.000000 | \n", "-10.013000 | \n", "0.000000 | \n", "0.035900 | \n", "0.016900 | \n", "0.000000 | \n", "0.098000 | \n", "0.260000 | \n", "99.218500 | \n", "4.000000 | \n", "
| 50% | \n", "56999.000000 | \n", "35.000000 | \n", "2.129060e+05 | \n", "0.580000 | \n", "0.685000 | \n", "5.000000 | \n", "-7.004000 | \n", "1.000000 | \n", "0.048900 | \n", "0.169000 | \n", "0.000042 | \n", "0.132000 | \n", "0.464000 | \n", "122.017000 | \n", "4.000000 | \n", "
| 75% | \n", "85499.500000 | \n", "50.000000 | \n", "2.615060e+05 | \n", "0.695000 | \n", "0.854000 | \n", "8.000000 | \n", "-5.003000 | \n", "1.000000 | \n", "0.084500 | \n", "0.597500 | \n", "0.049000 | \n", "0.273000 | \n", "0.683000 | \n", "140.071000 | \n", "4.000000 | \n", "
| max | \n", "113999.000000 | \n", "100.000000 | \n", "5.237295e+06 | \n", "0.985000 | \n", "1.000000 | \n", "11.000000 | \n", "4.532000 | \n", "1.000000 | \n", "0.965000 | \n", "0.996000 | \n", "1.000000 | \n", "1.000000 | \n", "0.995000 | \n", "243.372000 | \n", "5.000000 | \n", "
| \n", " | popularity | \n", "
|---|---|
| popularity | \n", "1.000000 | \n", "
| loudness | \n", "0.050420 | \n", "
| explicit | \n", "0.044078 | \n", "
| danceability | \n", "0.035444 | \n", "
| Unnamed: 0 | \n", "0.032146 | \n", "
| time_signature | \n", "0.031076 | \n", "
| tempo | \n", "0.013212 | \n", "
| energy | \n", "0.001053 | \n", "
| key | \n", "-0.003847 | \n", "
| liveness | \n", "-0.005397 | \n", "
| duration_ms | \n", "-0.007129 | \n", "
| mode | \n", "-0.013948 | \n", "
| acousticness | \n", "-0.025458 | \n", "
| valence | \n", "-0.040522 | \n", "
| speechiness | \n", "-0.044930 | \n", "
| instrumentalness | \n", "-0.095147 | \n", "
| \n", " | cluster_id | \n", "
|---|---|
| 0 | \n", "4 | \n", "
| 1 | \n", "1 | \n", "
| 2 | \n", "1 | \n", "
| 3 | \n", "1 | \n", "
| 4 | \n", "3 | \n", "
| \n", " | cluster_id | \n", "cluster_distance | \n", "
|---|---|---|
| 0 | \n", "4 | \n", "2.591315 | \n", "
| 1 | \n", "1 | \n", "2.132972 | \n", "
| 2 | \n", "1 | \n", "3.089415 | \n", "
| 3 | \n", "1 | \n", "3.432708 | \n", "
| 4 | \n", "3 | \n", "2.381846 | \n", "
| \n", " | danceability | \n", "energy | \n", "valence | \n", "acousticness | \n", "popularity | \n", "
|---|---|---|---|---|---|
| cluster_id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
| 0 | \n", "0.52 | \n", "0.75 | \n", "0.48 | \n", "0.34 | \n", "33.94 | \n", "
| 1 | \n", "0.45 | \n", "0.25 | \n", "0.29 | \n", "0.81 | \n", "30.69 | \n", "
| 2 | \n", "0.56 | \n", "0.76 | \n", "0.32 | \n", "0.09 | \n", "28.15 | \n", "
| 3 | \n", "0.60 | \n", "0.72 | \n", "0.56 | \n", "0.22 | \n", "34.14 | \n", "
| 4 | \n", "0.62 | \n", "0.73 | \n", "0.53 | \n", "0.19 | \n", "35.66 | \n", "
| \n", " | Model | \n", "MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "
|---|---|---|---|---|---|
| 0 | \n", "Linear Regression (Enhanced) | \n", "14.049905 | \n", "362.253681 | \n", "19.032963 | \n", "0.269782 | \n", "
| 1 | \n", "Random Forest | \n", "15.966834 | \n", "398.036527 | \n", "19.950853 | \n", "0.197652 | \n", "
| 2 | \n", "Gradient Boosting | \n", "17.017961 | \n", "422.224097 | \n", "20.548092 | \n", "0.148895 | \n", "