title: Python import table data from Mac .numbers file
body: <p>I'm new to Python and I'm trying to crunch some numbers. Sample attached: <a href="https://i.stack.imgur.com/XLv3G.png" rel="noreferrer">Open High Low Close Sample Data</a></p>
  
  <p>I have tested a few variations of importing data but failed. Really appreciate some advise. Thanks!</p>
  
  <pre><code>path = 'Data/Price.numbers'
  with open(path) as file:    
  file.readline()
  for line in file:
      values = map(float, line.split())
      test.append(values)
  </code></pre>
  
  <p>Key Objectives:</p>
  
  <p>1) Efficiently store the table data in a format that I can easily manipulate and apply calculations > I'm thinking of a Dict{} > Any comments?</p>
  
  <p>2) Optimised for quick calculations as I need to crunch data for multiple securities > I estimate about 1,000,000 to 2,000,000 datapoint.</p>
  
  <p>Again, appreciate any advise to do this better.</p>