Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to Read Second Hand Songs File? #13

Open
s2t2 opened this issue Feb 5, 2025 · 0 comments
Open

How to Read Second Hand Songs File? #13

s2t2 opened this issue Feb 5, 2025 · 0 comments

Comments

@s2t2
Copy link

s2t2 commented Feb 5, 2025

Hi, I see the Second Hand Songs data files have an interesting structure. Do you have any recommendations for how to read this structure into a pandas dataframe? Perhaps a function that would produce a pandas dataframe of the intended data?

Thanks.

Structure:

# TESTING SET
# SECONDHANDSONGS DATASET
#      http://labrosa.ee.columbia.edu/millionsong/secondhand
# A collaboration with the Million Song Dataset team
# list of clique created on Fri Mar 25 12:07:37 2011
# contact: Thierry Bertin-Mahieux <[email protected]>
# FORMAT for each line:
#   #                      - comment, to ignore
#   %a,b,c, title          - beginning of a clique (group of cover songs)
#                            the numbers a,b,c are "work" on secondhandsongs.com
#                            title is chosen at random from songs in the clique
#   TID<SEP>AID<SEP>perf   - MSD track id, artist id and SHS performance for one track
#                            in the current clique
# Please get involved with www.secondhandsongs.com, and enjoy this dataset!
%115402,74782, Putty (In Your Hands)
TRJVDMI128F4281B99<SEP>AR46LG01187B98DB5D<SEP>74784
TRNJXCO128F92E1930<SEP>ARQD13K1187B98E441<SEP>138584
%24350, I.G.Y. (Album Version)
TRIBOIS128F9340B19<SEP>ARUVZYG1187B9B2809<SEP>24350
TRGXZDU128F9301E53<SEP>AR4LE591187FB3FCFB<SEP>24363
%79178, When The Catfish Is In Bloom
TRQSIOY128F92FACA7<SEP>ARU75JD1187FB38B79<SEP>79178
TRXEFPP128F92F9D97<SEP>ARZDN5A1187B99338B<SEP>79186
%11012, Sheer Heart Attack
TRXIXMS128F4287B96<SEP>ARL4TII1187B9B46E1<SEP>11012
TRABVTG128F934AB80<SEP>AR9BVRM1187FB51139<SEP>97131
TRRZZZZ128F422F784<SEP>ARNFBNR1187B9A25C2<SEP>-1
%5262, Calling Dr. Love
TRNBZMV128F42B261C<SEP>ARGCVZG1187B9B916F<SEP>26300
TRZFOYF128F148D281<SEP>ARMI8BW1187FB57B2E<SEP>5262
%10974, Standing At The Crossroads
TRNTRUC128F4234EB5<SEP>AR49MOS1187B991A8B<SEP>139493
TRFACVP128F931DF8E<SEP>ARXKMZJ11F4C83DF37<SEP>101217
TRGJNCX128F1456B59<SEP>ARCOBLE1187B9A2446<SEP>32310
TRLGBDK128F9314B44<SEP>ARZENOX1187B98A645<SEP>141237
TRETOLL128F4266338<SEP>ARKJHKX1187FB5AEE5<SEP>17039
TROKQBW128F92FACDF<SEP>AR5U94U1187FB5CDCF<SEP>16206
TRKGFVN128F4250F29<SEP>ARH1XAK1187B98F188<SEP>38920
TRVJQRV128F4214321<SEP>ARZHSES1187FB58AAC<SEP>10975
TRTGOUT128F92F9590<SEP>ARQ8BBK1187FB49C9A<SEP>90772
%42790, The Hustle Is On
TRTRMDB128F4267363<SEP>ARGRDHI1187B9B93F0<SEP>99698
TRGYGGS12903CF2C06<SEP>AR8Q4RZ1187FB46BDC<SEP>42790
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant