title: Turn a List into a Data frame PYTHON - SQL
body: <p>I am currently pulling some data from SQL Server via python,</p>
  
  <p>Using the below:</p>
  
  <pre><code>import pyodbc
  data = []
  con = pyodbc.connect('Trusted_Connection=yes', driver = '{SQL Server}',server = 'bhxsql2014-dev', database = 'BMAnalytics')
  
  cursor = con.cursor()
  
  cursor.execute(" select * from dbo.EUActiveStores ")
  for columns in cursor.fetchall():
      data.append(columns[0:])
  
  print(data)
  </code></pre>
  
  <p>It returns data in the following format (Top 2 rows as sample):</p>
  
  <pre><code>[(1.0, 'Bradford', 'Main', 1.0, 'UK', 850.3489216, 79.0, 'Sharon Watson', 'Malcolm Bateman', 0.0, '199446', 199602.0, 'ST1', 1201.0, '12', 53.794851, -1.755584, 'COMP', 'Main', 'MALL', None), (4.0, 'EASTBOURNE', 'Main', 1.0, 'UK', 646.9788276755199, 60.10629999999999, 'Jocelyn Hill', 'Andrea Varley', 0.0, '199642', 199750.0, 'ST1', 1304.0, '13', 50.7696, 0.2859, 'COMP', 'Main', 'MALL', None),
  </code></pre>
  
  <p>Seems each Row is contained within parenthesis, and separated by a comma.</p>
  
  <p>I have no idea how to turn this into a data frame, any advice ?</p>