Create multiple Tables from Python

Hi,

Using Python I'm connecting to Google Cloud Storage, I want to be able to loop through the various files in a bucket, create pandas dataframes for each one and then use the contents in Power Query.

I can get it all working in Pycharm with the below...

for file in blobs:
    file_path = "gs://{}/{}".format(file.bucket.name, file.name)
    with fs.open(file_path) as f:
        df = pd.DataFrame
        df.name = file.name
        df = pd.read_csv(f)
        print(df.name)
        print(df)

it loops through and prints the contents and name of each of the 3 files in the bucket, but in Power Query I only pull through the last iteration with the name df. 

I've tried various angles using dictionaries and lists but can't figure out how to end up with three separate tables.  I've seen examples concatenating various files but I want to keep these all separate.  I want to be able to loop through the files in the bucket because there will eventually be hundreds, so don't want to hard code each one.

Any ideas?  Is it possible?

Cheers

Mark