title: How do I convert numbers stored as text in excel file to numbers using python pandas
body: <p>In short my code is about importing a csv file then making changes to it data and then producing my result in excel file. when I am finding the average to of a column using the code below my answers come out as numbers stored as text. because of that I cannot use the newly created column to do further calculations.</p>
  <pre><code>mean_day= df.groupby('day')['day'].mean().apply(lambda x: '{:.10f}'.format(x))
  df['mean_day'] = mean_day
  </code></pre>
  <p>Is there is something wrong with this statement above that is causing the issue because my other calculations dont give me this issue. If additional detail is required please let me know. Also the code above is basically finding average of one column based on the value of another column</p>
  <p><a href="https://i.stack.imgur.com/mE5gV.png" rel="nofollow noreferrer">the green marker on the top means the number is stored as text</a></p>