Creating a loop to parse a csv file and convert a list into a 96 well plate map

Question

I have a csv file I've gotten to look like this:

    Source_Well  Source_Concentration Source_Concentration_units  \
0           A01                   NaN                        NaN   
1           A01                   NaN                        NaN   
2           A03                 1.000                         mM   
3           A03                 1.000                         mM   
4           A05                 1.000                         mM   
..          ...                   ...                        ...   
539         D02                   NaN                        NaN   
540         O21                 0.008                         mM   
541         H02                   NaN                        NaN   
542         O02                   NaN                        NaN   
543         O02                   NaN                        NaN   

I want to take the source_well column and split the values like "A" "01" and "A" "03" I know I need to make a loop to do this but I'm not sure how to set it up. I then want to make the source well column to look like a 96 well plate, with A-H as the columns and 1-12 as the rows. I'm very new to python and I'm struggling how to do this

so far I've managed to figure out how to split the values with this:

import re re.split('(\d+)',stringdf)

But I don't know how to create a loop so it does this for every single value not just A01