Pandas format column as currency
<p>Given the following data frame:</p>
<pre><code>import pandas as pd
df = pd.DataFrame(
        {'A':['A','B','C','D'],
         'C':[12355.00,12555.67,640.00,7000]
        })
df

    A   C
0   A   12355.00
1   B   12555.67
2   C   640.00
3   D   7000.00
</code></pre>
<p>I'd like to convert the values to dollars in thousands of USD like this:</p>
<pre><code>    A   C
0   A   $12.3K
1   B   $12.5K
2   C    $0.6K
3   D    $7.0K
</code></pre>
<p>The second thing I need to do is somehow get these into a Seaborn heat map, which only accepts floats and integers. See <a href="https://stackoverflow.com/questions/35003011/seaborn-heatmap-currency-format">here</a> for more on the heat map aspect.</p>
<p>I'm assuming once the floats are converted to currency, they will be in object format but I'm hoping there's a way around that.</p>