In a small project my friends and I are collecting songs and song metadata such as lyrics, song writer, composer, year, etc... information to a wide collection of Libyan folksmusic. The obtained files are mostly recordings in weddings and other occasions. So the copywrites are legit.
We decided to match the song file name (say .mp3 or .wav) with a corresponding cell in an excel sheet and add the information, including the lyrics (all in Arabic) in that row. Example:
file:'LibyanSong.mp3' located in a given file, in Excel, the rows are something like:
| File name | Singer | Composer | Lyrics | Year |
|---|---|---|---|---|
| 'LibyanSong' | 'Shadi Jabal' | 'Ali Shaalia' | 'Lorem Ipsum...' | 1953 |
I would like to know if there is a way to add these information to the music files by looping, matching and then adding the information, so that it saves us the cumbersome job of doing that manually (files are around 1200 and counting)
P.S. I have a mediocre background in python and can operate MATLAB well.