title: Value in dataframe column wont change from string to float
body: <p>So I've got a column in a dataframe that is filled with float values and occasional string values. I've tried following some answers on stack but it just doesnt work.</p>
  
  <pre><code>print(data['Snowfall'][48609]) #prints #VALUE!
  print(type(data['Snowfall'][48609])) #prints &lt;class 'str'&gt;
  data['Snowfall'].str.contains("#VALUE!").replace(float(0.0),inplace=True)
  print(type(data['Snowfall'][48609])) # prints &lt;class 'str'&gt;
  </code></pre>
  
  <p>what am i doing wrong</p>