title: Need to calculate columns from CSV using pandas
body: <p><code>incidentcountlevel1</code> and <code>examcount</code> were two column names on CSV file. I want to calculate two columns based on these. I have written the script below but it's failing:</p>
  
  <pre><code>import pandas as pd
  import numpy as np
  import time, os, fnmatch, shutil
  df = pd.read_csv(r"/home/corp_sourcing/Metric_Fact_20180324_1227.csv",header='infer',skiprows=[1])
  df1 = pd.read_csv(r"/home/corp_sourcing/Metric_Fact_20180324_1227.csv",header='infer',skiprows=[1])
  df3 = pd.read_csv("/home/corp_sourcing/Metric_Fact_20180324_1227.csv",header='infer',converters={"incidentcountlevel1":int})
  inc_count_lvl_1 = df3.loc[:, ['incidentcountlevel1']]
  exam_count=df3.loc[:, ['examcount']]
  
  for exam_count in exam_count: #need to iterate this col to calculate for each row
  
  if exam_count &lt; 1:
          print "IPTE Cannot be calculated"
  
  else:
          if inc_count_lvl_1 &gt; 5:
          ipte1= (inc_count_lvl_1/exam_count)*1000
      else:
  
          dof = 2*(inc_count_lvl_1+ 1)
          chi_square=chi2.ppf(0.5,dof)
          ipte1=(chi_square/(2*exam_count))×1000 
  </code></pre>