Looping to read data in database

[scidam]

besides static reading process like I have above?

Do you mean hard coded file names to be processed?
If I understood you correctly, you want to find all *.csv files in a specific folder/subfolders and load them one-by-one (and do something with data). The following code snippet could help you to do this:

import os
for root, dirs, files in os.walk("C:/Data"):
    for name in files:
        if name.endswith('csv'):
            data = pd.read_csv(os.path.join(root, name))
            # do something with data...