title: Pandas DataFrame - Replace NULL String with Blank and NULL Numeric with 0
body: <p>I am working on a large dataset with many columns of different types. There are a mix of numeric values and strings with some NULL values. I need to change the NULL Value to Blank or 0 depending on the type.</p>
  
  <pre><code>1   John   2    Doe   3   Mike   4    Orange   5   Stuff
  9   NULL   NULL NULL  8   NULL   NULL Lemon    12  NULL
  </code></pre>
  
  <p>I want it to look like this,</p>
  
  <pre><code>1   John   2    Doe   3   Mike   4    Orange   5   Stuff
  9          0          8          0    Lemon    12  
  </code></pre>
  
  <p>I can do this for each individual, but since I am going to be pulling several extremely large datasets with hundreds of columns, I'd like to do this some other way.</p>
  
  <p>Edit:
  Types from Smaller Dataset,</p>
  
  <pre><code>Field1              object
  Field2              object
  Field3              object
  Field4              object
  Field5              object
  Field6              object
  Field7              object
  Field8              object
  Field9              object
  Field10              float64
  Field11              float64
  Field12              float64
  Field13              float64
  Field14              float64
  Field15              object
  Field16              float64
  Field17              object
  Field18              object
  Field19              float64
  Field20              float64
  Field21              int64
  </code></pre>