學(xué)習(xí)SQL 記錄Spotify Wrapped世界神奇頻率
今天學(xué)習(xí)了一個(gè)很有趣的問(wèn)題,分享一下?
Spotify 利用音樂(lè)的各種屬性來(lái)對(duì)歌和人分類。然后每年會(huì)給你生產(chǎn)一個(gè)報(bào)告。
Spotify Wrapped?is a feature presenting Spotify users’ 100 most played songs from the past year. In 2021, Spotify Wrapped calculated an?“Audio Aura”?for each user, a “reading of [their] two most prominent moods as dictated by [their] top songs and artists of the year.” Suppose Spotify determines an audio aura by looking at the average energy, valence, and danceability of a person’s top 100 songs from the past year.

Speechiness?:說(shuō)話指數(shù)
Speechiness?detects the presence of spoken words in a track. The more exclusively speech-like the recording (e.g. talk show, audio book, poetry), the closer to 1.0 the attribute value. Values above 0.66 describe tracks that are probably made entirely of spoken words. (resource: github.io)
如果這個(gè)指數(shù)大于0.66 的話就說(shuō)明這個(gè)歌可能一直都是在說(shuō)話了。
Valence: Valence 愉快指數(shù),valence 高的歌聽(tīng)了讓人開(kāi)心低了,讓人難過(guò)。

神奇的發(fā)現(xiàn),Drake 的歌居然能量是0.599 這個(gè)神奇的數(shù)字。不愧是Drake。