title: How to store and retrieve data in python
body: <p>I have been looking for answers to my questions, but haven't found a definitive answer. I am new to python, mysql, and data science, so any advice is appreciated<br><br>
  What I want to be able to do is:<br></p>
  
  <ol>
  <li>use python to pull daily close data from quandl for n securities<br> </li>
  <li>store the data in a database<br> </li>
  <li>retrieve, clean, and normalize the data<br> </li>
  <li>run regressions on different pairs<br> </li>
  <li>write the results to a csv file<br></li>
  </ol>
  
  <p>The pseudocode below shows in a nutshell what I want to be able to do.<br><br>
  The questions I have are:<br>
  How do I store the quandl data in MySQL?<br>
  How do I retrieve that data from MySQL? Do I store it into lists and use statsmodels?<br></p>
  
  <pre><code>tickers = [AAPL, FB, GOOG, YHOO, XRAY, CSCO]
  qCodes = [x + 'WIKI/' for x in tickers]
  for i in range(0, len(qCodes)):
      ADD TO MYSQLDB-&gt;Quandl.get(qCodes[i], collapse='daily', start_date=start, end_date=end)
  
  for x in range(0, len(qCodes)-1):
      for y in range(x+1, len(qCodes)):
          //GET FROM MYSQLDB-&gt; x, y 
          //clean(x,y)
          //normalize(x,y)
          //write to csv file-&gt;(regression(x,y))
  </code></pre>