Batch rename in Terminal by appending prefix from .csv file

Edit (to improve question):

In the image above you can see the naming of a series of files.

Each file has a filename of:
01-NameOfProject_Data Set X-01.png
where X is sequential from 1 to 24
(please note! NOT 01, 02, ..., 24)

I have created two .csv files (to explore which works better upon your answer) as shown in the picture.

First step:
I need to add the country-code prefix to each corresponding file.
E.g.
EN_01-NameOfProject_Data Set 1-01.png

Second step:
I need to remove the part _Data Set X-01
The result would be
EN_01-NameOfProject.png

I am kindly asking for help in the above two steps so I can better understand the procedure.
I need to do this via macOS Terminal. I have install rename via Homebrew with
brew install rename

Original question:
I have a list of files that look like this:

01-NameOfProject_Data Set 1-01.png
01-NameOfProject_Data Set 2-01.png
01-NameOfProject_Data Set 3-01.png
...
01-NameOfProject_Data Set 24-01.png

I also have an Excel file (which I can save as .csv).
It has a single column and exactly as many rows as the amount of the aforementioned files.
Each cell has a language shortcode.
It looks like this:

EN
GR
IT
...
BU

The Excel file in the correct (corresponding) order as the files meaning that:
01-NameOfProject_Data Set 1-01.png is indeed in English (EN) and so on.

How would you batch rename the files so you'd end up with something like:

EN_01-NameOfProject_new-text.png
GR_01-NameOfProject_new-text.png
IT_01-NameOfProject_new-text.png
...
BU_01-NameOfProject_new-text.png

Like this, using Perl's rename:

brew install rename

Remove -n switch, aka dry-run when your attempts are satisfactory to rename for real.

#!/usr/bin/env bash

c=0 arr=( * )
while IFS=, read -r _ country; do
    rename -n "s/^(\d+).*/${country}_NameOfProject_new-text.png/" "${arr[c++]}"
done < /tmp/file.csv

Output

rename(01-NameOfProject_Data Set 1-01.png, EN_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 2-01.png, GR_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 24-01.png, IT_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 3-01.png, BU_NameOfProject_new-text.png)

If order is not natural, then use:

#!/usr/bin/env bash

readarray -td '' files < <(
    ls --zero -v -- *.png
)
c=0
while IFS=, read -r _ country; do
    rename -0 -n "s/^(\d+).*/${country}_NameOfProject_new-text.png/" "${files[c++]}"
done < /tmp/file.csv

Output

rename(01-NameOfProject_Data Set 1-01.png, EN_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 2-01.png, GR_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 3-01.png, IT_NameOfProject_new-text.png)
rename(01-NameOfProject_Data Set 24-01.png, BU_NameOfProject_new-text.png)