title: Pandas Creating Normal Dist series
body: <p>I'm trying to convert an excel "normal distribution" formula into python.</p>
  
  <p>(1-NORM.DIST(a+col,b,c,TRUE))/(1-NORM.DIST(a,b,c,TRUE)))</p>
  
  <p>For example: Here's my given df</p>
  
  <pre><code>Id   a  b    c    
  ijk  4  3.5  12.53
  xyz  12 3    10.74
  </code></pre>
  
  <p>My goal: </p>
  
  <pre><code>Id   a  b    c      0    1    2    3
  ijk  4  3.5  12.53  1   .93  .87  .81
  xyz  12 3    10.74  1   .87  .76  .66
  </code></pre>
  
  <p>Here's the math behind it:</p>
  
  <p>column 0: always 1</p>
  
  <p>column 1: (1-NORM.DIST(a+1,b,c,TRUE))/(1-NORM.DIST(a,b,c,TRUE))</p>
  
  <p>column 2: (1-NORM.DIST(a+2,b,c,TRUE))/(1-NORM.DIST(a,b,c,TRUE))</p>
  
  <p>column 3: (1-NORM.DIST(a+3,b,c,TRUE))/(1-NORM.DIST(a,b,c,TRUE))</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>df1 = pd.DataFrame(df, columns=np.arange(0,4))
  result = pd.concat([df, df1], axis=1, join_axes=[df.index])
  result[0] = 1
  </code></pre>
  
  <p>I'm not sure what to do after this.</p>
  
  <p>This is how I use the normal distribution function:
  <a href="https://support.office.com/en-us/article/normdist-function-126db625-c53e-4591-9a22-c9ff422d6d58" rel="nofollow noreferrer">https://support.office.com/en-us/article/normdist-function-126db625-c53e-4591-9a22-c9ff422d6d58</a></p>
  
  <p>Many many thanks!</p>