title: Read Json with NaN into Python and Pandas
body: <p>I understand that NaN is not allowed in JSON files. I usually use </p>
  
  <pre><code>import pandas as pd 
  pd.read_json('file.json') 
  </code></pre>
  
  <p>to read in JSON into python. Looking through the documentation, I do not see an option to handle that value.</p>
  
  <p>I have a JSON file, data.json, that looks like </p>
  
  <pre><code>[{"city": "Los Angeles","job":"chef","age":30},
   {"city": "New York","job":"driver","age":35},
   {"city": "San Jose","job":"pilot","age":NaN}]
  </code></pre>
  
  <p>How can I read this into python/pandas and handle the NaN values?</p>
  
  <p>EDIT:</p>
  
  <p>Amazing answer below!! Thanks fixxxer!! Just so it's documented, reading it in from a separate file </p>
  
  <pre><code>import pandas as pd
  import json
  
  text=open('data.json','r')
  x=text.read()
  
  y=json.loads(x)
  data=pd.DataFrame(y)
  data.head()
  </code></pre>