title: How can I store columns from excel to python3.6?
body: <p>I'm slowly working my way in using spyder Python3.6, hope you can give me some solutions to this question:</p>
  
  <p>An Excel file [ c1.xlsx ] which contains 10 columns (from column a to e) and 20 rows(from row 2 to 21), now I want to create a sheet using python (columns namely A, B, C, E). I need all data from these 20 rows from column a, b, c and e.</p>
  
  <p>So I hope I will get this as <a href="https://i.stack.imgur.com/FLbgS.jpg" rel="nofollow noreferrer">result</a></p>
  
  <p>I alread have some codes:</p>
  
  <pre><code>    import pandas as pd
      import os
  
      dir = os.path.join('..' , 'Climate')
      fname = 'C1.xlsx'
      fpath = os.path.join(dir,fname)
      data = pd.read_excel(fpath,sheetname = 'sheet1',header=0)
  
      df_Ct = pd.columns = (['A', 'B', 'C', 'E']) 
  </code></pre>
  
  <p>how can I continue to read these values?</p>