title: How to merge dataframes with others that have empty column values in python?
body: <p>Have tried to merge DF1 and DF2 but cannot success. Please help. I used the code
  DF_new = DF1.merge(DF2[[&quot;C&quot;, &quot;Z&quot;]], on=&quot;C&quot;, how=&quot;left&quot;)</p>
  <p><a href="https://i.stack.imgur.com/yckAI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yckAI.png" alt="enter image description here" /></a></p>