title: looping through a list of dataframes, writing each element of that list to a new .csv file on disk
body: <p>I have a list of dataframes and am attempting to export each using the pandas.df.to_csv method to a folder on disk. However, only the last item in the list of dataframes is being written to disk as a .csv</p>
  <p>Please see code below:</p>
  <pre><code>import pandas as pd
  import os
  import datetime
  from pathlib import Path
  
  CSV_Folder = Path('C:\PA_Boundaries\Tests')
  Output = r'C:/PA_Boundaries/test_output'
  
  today = datetime.date.today()
  date = today.strftime('%Y%m%d')
  
  try:
      dfs = []
      for file in os.listdir(CSV_Folder):
          df = pd.read_csv(CSV_Folder / file)
          dfs.append(df)
      
      new_dfs = []
      for df in dfs:
          new_df = pd.DataFrame()
          new_df['Original Addr string'] = df['StreetConc']
          new_df['Addr #'] = df['AddNum']
          new_df['Prefix'] = df['StPreDir']
          new_df['Street Name'] = df['StName']
          new_df['StreetType'] = df['StType']
          new_df['Suffix'] = df['StDir']
          new_df['Multi-Unit'] = ''
          new_df['City'] = df['City']
          new_df['Zip Code'] = df['PostCode']
          new_df['4'] = df['PostalExt']
          new_df['County'] = df['CountyID']
          new_df['Addr Type'] = ''
          new_df['Precint Part Name'] = ''
          new_df['Lat'] = df['X']
          new_df['Long'] = df['Y']
      
      
          replaced_address_names = []
          for index, row in new_df.iterrows():
              new_row = row['Original Addr string'].replace(',', ' ')
              replaced_address_names.append(new_row)
          
          
          new_df['Original Addr string'] = replaced_address_names
          
          county_id = df.iloc[0, 37]
      
          new_dfs.append(new_df)
          
      for i in range(len(new_dfs)):
          new_dfs[i].to_csv(f'{Output}\ADDR_{county_id}_{date}.csv', index=False)
  
  except FileNotFoundError:
      print(f'{file} not found in {CSV_Folder}')
  
  except PermissionError:
      print('Check syntax of paths')
  
  else:
      print('Process Complete')
  </code></pre>
  <p><code>new_dfs</code> contains the correct number of dataframes. However, when looping through the new list of dataframes and calling .to_csv on each item in the list, only the last item in the list is written to the disk.</p>