Scala: read path from dataframe column and merge result

[#1]

I have a dataframe with an id field and a path, looks like this:

I need to read the files (csv) and match them with the id. I expect it should work out:

while I can't even figure out how to read files from the path specified in the dataframe, all my knowledge leads to getting a list of paths from the dataframe and reading each one