I have successfully pulled in 31 '\*.csv' files and created 31 dataframes with JupyterLab. I was able to adjust the headers in one data frame as needed, but I dread having to apply individually. As my database grows it will be entirely too tedious to adjust each header.

```
filenames = glob.glob('*.csv')
dataframes = [pd.read_csv(f) for f in filenames]
tlt = 'tlt.csv'
qqq = 'qqq.csv'
gld = 'gld.csv'
slv = 'slv.csv'

```

etc,etc

Code:

```
df_gold = pd.read_csv(gold, skiprows=[0], header=None)
header = df_gold.iloc[0]
df_gold = df_gold[1:]
df_gold.rename(columns = header)
df_gold.rename(columns={0:'Date', 1:'Open', 2:'High',3:'Low',4:'Close',5:'Volume'}, inplace=True)
print(df_gold.columns)

```

Output:

```
Index(['Date', 'Open', 'High', 'Low', 'Close', 'Volume'], dtype='object')

```

My issue is that I would like to use a loop to apply the change in the headers to all dataframes used by this program.

TYIA