ABC DEF files

abc_def_csv_to_pandas.py

import os, pandas 
cwd = os.getcwd() # this is where to find the csv directories and files

dfs = {} # this is where we will put the pandas DataFrame for each color

for root, dirs, files in os.walk(cwd):
    for fn in files:
        if fn.endswith(".csv"): # skip non csv files silently
            color = fn.split('.',3)[1] # extract color name like 'ABC' or 'DEF'
            fqpn = os.path.sep.join((root,fn)) # construct a filename to read
            if color in dfs: # append existing color DataFrame if we find a new file
                dfs[color].append(pandas.read_csv(fqpn))
            else: # otherwise create a new color DataFrame from this csv
                dfs[color] = pandas.read_csv(fqpn)