title: How to convert a log file to a pandas DF
body: <p>I have managed to read the following log file into python:</p>
  <pre><code>import os
  import glob
  import pandas as pd
  
  
  folder = r'C:\Users\x\x\x\x\\'
  
  for infile in glob.glob(os.path.join(folder, 'console*')):
      file = open(infile, 'r').read()
      print( file)
  </code></pre>
  <p><code>print(file)</code> gives me:</p>
  <pre><code>John, 1,7,8, text
  Matt, 3,7,10, text2
  Natasha, 4,60,3,text3
  </code></pre>
  <p>I am hoping to convert into a <code>pandas df</code>:</p>
  <pre><code>df = pd.DataFrame(file)
  </code></pre>
  <p>but getting a <code>ValueError: DataFrame constructor not properly called!</code></p>
  <p>Does anyone know how to construct the Dataframe of 3 rows by 5 columns and then add in my own columns headers? Thanks very much!</p>