Skip to main content
Toolathlon-Verified · Website task ID 319 · Canonical task music-analysis View the task source at d57361c0

​
Required Tools

MCP Servers
excel
google_sheet
terminal
Local Tools
python_execute
claim_done
handle_overlong_tool_outputs
manage_context
history

​
Instruction

A music streaming platform wants to accurately identify the 1940s pop singles with the most sustained popularity during their classic oldies promotion campaign, in order to replicate marketing strategies and plan themed programs. You should use the original sheet data Billboard Pop Chart by Year on my google drive to complete the following analysis:
  1. Calculate the total number of consecutive weeks each song stayed on the chart (defined as the longest streak of non-empty/non-black weekly rankings).
  2. Strictly follow the format of the music_analysis_result_example.xlsx in the workspace, create one sheet for each year and fill them. The final resulted file should be named as music_analysis_result.xlsx with multiple sheets. The final leaderboard in each sheet should contain all songds and be sorted in descending order firstly by the “Longest Consecutive Top 3 Weeks”, secondly by “Song” (In lexicographical order), then by “Artist” (In lexicographical order).

​
Initial State

​
Local Workspace

workspace/ └── music_analysis_result_example.xlsx

​
Runtime Setup

This task initializes application or service state during preprocessing. Review the pinned setup source.

​
Legacy Trajectories

These replays were produced on the original Toolathlon release. They are retained for historical inspection and are not Toolathlon-Verified results.