Spotify: Winner Tracks Audio Features🎹

Audio features and info about all the songs we've loved (2018 - 2022).

@kaggle.sejungjenn_spotify_best_songs_of_2022

Table List

1 table(75.01 KB)

Df Complete

@kaggle.sejungjenn_spotify_best_songs_of_2022.df_complete

75.01 KB
500 rows
19 columns

track_uri Track Uri	track Track	artist Artist	artist_popularity Artist Popularity	followers Followers	artist_genre Artist Genre	track_popularity Track Popularity	album Album	year Year	danceability Danceability	valence Valence	energy Energy	tempo Tempo	loudness Loudness	speechiness Speechiness	instrumentalness Instrumentalness	liveness Liveness	acousticness Acousticness	key Key
6DCZcSspjsKoFjzjrWoCdn	God's Plan	Drake	97	70260570	['canadian hip hop', 'canadian pop', 'hip hop', 'rap', 'toronto rap']	83	Scorpion	2018	0.754	0.357	0.449	77.169	-9.211	0.109	0.0000829	0.552	0.0332	7
0e7ipj03S05BNilyu5bRzt	rockstar (feat. 21 Savage)	Post Malone	89	39233698	['dfw rap', 'melodic rap', 'rap']	83	beerbongs & bentleys	2018	0.585	0.129	0.52	159.801	-6.136	0.0712	0.0000701	0.131	0.124	5
09mEdoA6zrmBPgTEN5qXmN	Call Out My Name	The Weeknd	96	55208147	['canadian contemporary r&b', 'canadian pop', 'pop']	88	My Dear Melancholy,	2018	0.461	0.175	0.593	134.17	-4.954	0.0356		0.307	0.17	1
0u2P5u6lvoDfwTYjAADbn4	lovely (with Khalid)	Billie Eilish	89	73989789	['art pop', 'electropop', 'pop']	88	lovely (with Khalid)	2018	0.351	0.12	0.296	115.284	-10.109	0.0333		0.095	0.934	4
7ef4DlsgrMEH11cDZd32M6	One Kiss (with Dua Lipa)	Calvin Harris	85	23066688	['dance pop', 'edm', 'electro house', 'house', 'pop', 'progressive house', 'uk dance']	87	One Kiss (with Dua Lipa)	2018	0.791	0.592	0.862	123.994	-3.24	0.11	0.0000219	0.0814	0.037	9
285pBltuF7vW8TeWk8hdRR	Lucid Dreams	Juice WRLD	91	27045858	['chicago rap', 'melodic rap']	84	Goodbye & Good Riddance	2018	0.511	0.218	0.566	83.903	-7.23	0.2		0.34	0.349	6
09IStsImFySgyp0pIQdqAc	The Middle	Zedd	76	5866220	['complextro', 'dance pop', 'edm', 'electro house', 'electropop', 'german techno', 'pop', 'pop dance', 'pop rap', 'tropical house']	79	The Middle	2018	0.753	0.437	0.657	107.01	-3.061	0.0449		0.112	0.171	7
08bNPGLD8AhKpnnERrAc6G	FRIENDS	Marshmello	83	34652549	['brostep', 'dance pop', 'edm', 'pop', 'pop dance', 'progressive electro house']	78	FRIENDS	2018	0.626	0.534	0.88	95.079	-2.384	0.0504		0.128	0.205	9
58q2HKrzhC3ozto2nDdN4z	I Like It	Cardi B	82	20869665	['dance pop', 'pop', 'rap']	77	Invasion of Privacy	2018	0.816	0.65	0.726	136.048	-3.998	0.129		0.372	0.099	5
6IPwKM3fUUzlElbvKw2sKl	we fell in love in october	girl in red	77	5643207	['bedroom pop', 'indie pop', 'norwegian indie', 'pop']	85	we fell in love in october / October Passed Me By	2018	0.566	0.237	0.366	129.96	-12.808	0.028	0.181	0.155	0.113	7


CREATE TABLE df_complete (
  "track_uri" VARCHAR,
  "track" VARCHAR,
  "artist" VARCHAR,
  "artist_popularity" BIGINT,
  "followers" BIGINT,
  "artist_genre" VARCHAR,
  "track_popularity" BIGINT,
  "album" VARCHAR,
  "year" BIGINT,
  "danceability" DOUBLE,
  "valence" DOUBLE,
  "energy" DOUBLE,
  "tempo" DOUBLE,
  "loudness" DOUBLE,
  "speechiness" DOUBLE,
  "instrumentalness" DOUBLE,
  "liveness" DOUBLE,
  "acousticness" DOUBLE,
  "key" BIGINT
);