title: Python: Using Excel CSV file to read only certain columns and rows
body: <p>While I can read csv file instead of reading to whole file how can I print only certain rows and columns?</p>
  
  <p>Imagine as if this is Excel:</p>
  
  <pre><code>  A              B              C                  D                    E
  State  |Heart Disease Rate| Stroke Death Rate | HIV Diagnosis Rate |Teen Birth Rate
  
  Alabama     235.5             54.5                 16.7                 18.01
  
  Alaska      147.9             44.3                  3.2                  N/A    
  
  Arizona     152.5             32.7                 11.9                  N/A    
  
  Arkansas    221.8             57.4                 10.2                  N/A    
  
  California  177.9             42.2                  N/A                  N/A    
  
  Colorado    145.3             39                    8.4                 9.25    
  </code></pre>
  
  <p>Heres what I have:</p>
  
  <pre><code>import csv
  
  try:
      risk = open('riskfactors.csv', 'r', encoding="windows-1252").read() #find the file
  
  except:
      while risk != "riskfactors.csv":  # if the file cant be found if there is an error
      print("Could not open", risk, "file")
      risk = input("\nPlease try to open file again: ")
  else:
      with open("riskfactors.csv") as f:
          reader = csv.reader(f, delimiter=' ', quotechar='|')
  
          data = []
          for row in reader:# Number of rows including the death rates 
              for col in (2,4): # The columns I want read   B and D
                  data.append(row)
                  data.append(col)
          for item in data:
              print(item) #print the rows and columns
  </code></pre>
  
  <p>I need to only read column B and D with all statistics to read like this:</p>
  
  <pre><code>  A              B                D                    
   State  |Heart Disease Rate| HIV Diagnosis Rate |
  
   Alabama       235.5             16.7                
  
    Alaska       147.9             3.2                     
  
    Arizona      152.5             11.9                     
  
    Arkansas     221.8             10.2                    
  
   California    177.9             N/A                     
  
   Colorado      145.3             8.4                
  </code></pre>
  
  <h3>Edited</h3>
  
  <p>no errors</p>
  
  <p>Any ideas on how to tackle this? Everything I try isn't working. Any help or advice is much appreciated. </p>