Top songs in beauty-related TikToks Summer 2022 |> Table Contest

Conferences & Events tables
,
1

Top songs in beauty-related TikToks Summer 2022

Authors: Paavo Huoviala [Q Agentur für Forschung GmbH], Paul Simmering [Q Agentur für Forschung GmbH], Swen Sieben [Q Agentur für Forschung GmbH]

Q-Website
Q-Twitter
Q-Facebook
Q-Instagram

Abstract: An interactive table that shows the most used songs in cosmetics-related TikTok videos in Summer 2022. You can listen to the songs right in the table.

Full Description:

About

What's hot on #BeautyTok? The table lets you explore the most popular songs that users have featured in the cosmetics-related videos from Summer 2022. Each song conveys a different mood: dreamy, whimsical to energetic. Each is a community-vetted earworm. Listen to the hits, discover trends and compare metrics in this interactive table.

Technology

The table was built and styled in R with the packages reactable and reactablefmtr, sparkline and custom JavaScript, HTML, CSS. It features a custom audio player, custom cell arrangements with album covers, and the use of spark lines. The icons are from Font Awesome.

Data

The dataset comprises 1,000 popular songs on TikTok and is formatted as an RDS file.

The columns are:

  • music_id: chr, unique ID of the song
  • song_title: chr, name of the song
  • artist: chr, name of the artist
  • play_url: chr, url to the audio file hosted by TikTok
  • n_tiktoks: int, number of times the song was used in TikToks
  • weekly_tiktoks: list, contains a numeric vector for each row that has the number of uses by week from 2022-06-01 to 2022-08-31
  • weeks: list, contains a yearweek vector (via tsibble::yearweek()) indicating the timing of the weekly_tiktoks column

The dataset is an excerpt from a large database of TikTok videos, TikTok songs, and their relationships. The data was collected from TikTok by Cosmention, a social media monitoring tool specialized for the cosmetics industry. Only videos that were classified as cosmetics related. The classification was done via a spaCy model.

Table Type: interactive-HTML
Submission Type: Single Table Example
Table: Top songs in cosmetics-related TikToks Summer 2022
Code: GitHub - qagentur/table-contest-2022: An interactive table that shows the most used songs in cosmetics-related TikTok videos in Summer 2022. You can listen to the songs right in the table.
Cloud project:
Languages: Built with R: true. Built with Python: false.
Industries: Market Research.
Other packages: reactable, reactablefmtr, dplyr, stringr, sparkline, scales

2 Likes