title: Why do I get '0' instead of values while comparing '' or blank cell in Python?
body: <p>I have data as in the first picture.
  <a href="https://i.stack.imgur.com/bmnVq.png" rel="nofollow noreferrer">Data</a>
  I have written code as:</p>
  <pre><code>test_data = pd.read_excel('all_test_doc.xlsx')
  conditions = [ test_data['Area Code'] == 'A56',test_data['Area Code'] == 'A90',test_data['Area 
  Code'] == 'A20',test_data['Area Code'] == '']
  values = [ 'Mount Bundy', 'Downhill', &quot;Paterson&quot;, 'No data']
  test_data['Area Name'] = np.select(conditions, values)
  test_data.to_excel(&quot;test_output.xlsx&quot;)
  </code></pre>
  <p>I want to obtain a result as:
  <a href="https://i.stack.imgur.com/hMZlo.png" rel="nofollow noreferrer">desired output</a></p>
  <p>But landed in the following result:
  <a href="https://i.stack.imgur.com/g9ize.png" rel="nofollow noreferrer">Result with 0 in Blank</a></p>
  <p>How do I get result as in pc 2?</p>