Changing filenames based on information contained in a csv

Hi - I've spent a time looking and can't find, so was hoping some kind soul would point me in the right direction....
I have a few hundred folders containing albums. The tracks are labeled 1_1.wav, 1_2.wav etc
Each folder containers a csv file that has the track names. So basically, can I get Hazel to peak in the folder, get the info from the csv file and change the name of the 1_1.wav to 1. Track Name.wav?
Thanks in advance if anyone can help!!
The long version:
400 folders
each folder has a unique name
each has between 1 and 50 tracks in it. Plus cover art.
each has a data.csv file (all called data.csv)
So what I need is for each track to be renamed - the csv file has a header row and 40 columns.
2 of those columns are:
Track Number Track Title
So I need the tracks changed from 1_1.wav to 1. Track title etc
The art changed to Album Title.jpg which is also in the csv
The folder then changed to Album Title
I have a few hundred folders containing albums. The tracks are labeled 1_1.wav, 1_2.wav etc
Each folder containers a csv file that has the track names. So basically, can I get Hazel to peak in the folder, get the info from the csv file and change the name of the 1_1.wav to 1. Track Name.wav?
Thanks in advance if anyone can help!!
The long version:
400 folders
each folder has a unique name
each has between 1 and 50 tracks in it. Plus cover art.
each has a data.csv file (all called data.csv)
So what I need is for each track to be renamed - the csv file has a header row and 40 columns.
2 of those columns are:
Track Number Track Title
So I need the tracks changed from 1_1.wav to 1. Track title etc
The art changed to Album Title.jpg which is also in the csv
The folder then changed to Album Title