title: How to open and iterate through a list of CSV files - Python
body: <p>I have a list of pathnames to CSV files. I need to open each CSV file, take the data without the header and then merge it all together into a new CSV file.</p>
  
  <p>I have this code which gets me the list of CSV file pathnames:</p>
  
  <pre><code>file_list = []
  for folder_name, sub_folders, file_names in os.walk(wd):
      for file_name in file_names:
          file_extention = folder_name + '\\' + file_name
          if file_name.endswith('csv'):
              file_list.append(file_extention)
  </code></pre>
  
  <p>An example of my list is:</p>
  
  <pre><code>['C:\\Users\\Documents\\GPS_data\\West_coast\\Westland\\GPS_data1.csv',
   'C:\\Users\\Documents\\GPS_data\\West_coast\\Westland\\GPS_data2.csv',
   'C:\\Users\\Documents\\GPS_data\\West_coast\\Westland\\GPS_data3.csv']
  </code></pre>
  
  <p>I am struggling to figure out what to do, any help would be greatly appreciated. Thanks.</p>