I have a lot of csv files in a folder. For the example say file1.csv to file9.csv. What I want is to import each of these files in separarate dataframes. Importing it in 1 dataframe is no option since all the files have different columns. The code below loops through all the csv files in this filepath and is supposed to import them in different dataframes. However only I don't see 9 dataframes but only 1 called df. Why isn't this working. I thought df.name would do the trick of creating the separate dataframes but it doesn't. Does anyone know what I should change to have this work.

```
import pandas as pd
import os
import glob

filepath = r'C:/Source data'

all_files = glob.glob(filepath + "/*.csv")

for filename in all_files:
    name_df = os.path.basename(filename)
    name_df = name_df.replace('.csv','')
    df = pd.read_csv(filename)
    df.name = name_df

```