title: Replace cell value to NAN based on background color
body: <p>i want to replace the cell value to None or NAN if background color is red (or any specific color) of an excel.</p>
  <p>i tried this code but i'm not getting the expected result</p>
  <pre><code>import pandas as pd
  df = pd.read_excel(path)
  df.style.applymap(lambda x: ' ' if 'background-color: red' else x==x)
  df.to_excel(r&quot;C:\Users\Hp\Desktop\sada\new.xlsx&quot;)
  print(df)
  </code></pre>
  <p>input data:</p>
  <p><a href="https://i.stack.imgur.com/ERkAN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ERkAN.jpg" alt="enter image description here" /></a></p>
  <p>Expected output should be:</p>
  <p><a href="https://i.stack.imgur.com/Cim1n.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Cim1n.jpg" alt="enter image description here" /></a></p>