title: Multiplying columns with NULL values
body: <p>I am trying to write a python code where I multiply a column value across the other columns. However, some values are NULL in my one C column. I am having a hard time how to program that if a value is NULL switch it to 1.</p>
  
  <pre><code>A     B     C         Result should be:    X    Y
  5     3     2                              10   6
  10    6                                    10   6
  15    9                                    15   9
  20    12    8                              160  96  
  </code></pre>
  
  <p>This is the python code I have tried:</p>
  
  <pre><code>if df[C] is NONE:
      df[X] = df[A]*1
  else:
      df[X] = df[A]*df[C]
  </code></pre>
  
  <p>And so on with <code>df[B]</code> as well. But, it still gives me blanks in the excel rather than the "10 &amp; 6" and "15 &amp; 9" I need.</p>
  
  <p>Results I get with my code:</p>
  
  <pre><code>X     Y
  10    6
  
  
  160   96
  </code></pre>