title: After creating a list of csv files, how do I merge them?
body: <p>I've created a list of csv files and cleaned them. I've been stuck on merging these lists of csv files together. Each csv file, after cleaning, have the same column labels. They also have an extra column labels. I need to merge the columns with the same name.</p>
  <p>Here is an example of my code:</p>
  <pre><code>os.listdir(os.getcwd()) 
  filelist = glob.glob('*.csv') 
  
  for file in filelist:
      df = pd.read_csv(file)
      #cleaning code section
      print(df.head())
  pd.concat(filelist)
  </code></pre>
  <p>I've tried to use pd.concat(filelist) because I though it can do that with lists but I get this</p>
  <p>TypeError: cannot concatenate object of type '&lt;class 'str'&gt;'; only Series and DataFrame objs are valid</p>
  <p>If that's the case, can I make my list into a DataFrame object or can I use something like merge or join?</p>
  <p>Please send help!</p>