title: Display 2 decimal places, and use comma as separator in pandas?
body: <p>Is there any way to replace the dot in a float with a comma and keep a precision of 2 decimal places?</p>
  <p>Example 1 : 105 ---&gt; 105,00</p>
  <p>Example 2 : 99.2 ---&gt; 99,20</p>
  <p>I used a lambda function <code>df['abc']= df['abc'].apply(lambda x: f&quot;{x:.2f}&quot;.replace('.', ','))</code>. But then I have an invalid format in Excel.</p>
  <p><a href="https://i.stack.imgur.com/2z6td.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2z6td.png" alt="enter image description here" /></a></p>
  <p>I'm updating a specific sheet on excel, so I'm using : <code> wb = load_workbook(filename) ws = wb[&quot;FULL&quot;] for row in dataframe_to_rows(df, index=False, header=True): ws.append(row)</code></p>