title: How to import data from excel into python array?
body: <p>I have a very basic neural network. For the array data, what code do I need to do to point the array to data in an excel file? </p>
  
  <p>Here is the code with the data hard coded. </p>
  
  <p>How do I tell the array to look at another file on the computer? </p>
  
  <pre><code>import numpy as np
  
  # X = (hours studying, hours sleeping), y = score on test
  xAll = np.array(([2, 9], [1, 5], [3, 6], [5, 10], [8,8], [1,4]), 
  dtype=float) # input data
  y = np.array(([92], [60], [89], [91], [99]), dtype=float) # output
  
  # scale units
  xAll = xAll/np.amax(xAll, axis=0) # scaling input data
  y = y/100 # scaling output data (max test score is 100)
  
  # split data
  X = np.split(xAll, [5])[0] # training data has to match all input data E 
  X testing data
  xPredicted = np.split(xAll, [5])[1] # testing data
  
  class Neural_Network(object):
    def __init__(self):
    #parameters
      self.inputSize = 2
      self.outputSize = 1
      self.hiddenSize = 3
  </code></pre>