[FIXED] Pandas format column as currency

Issue

Given the following data frame:

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

I'd like to convert the values to dollars in thousands of USD like this:

    A   C
0   A   $12.3K
1   B   $12.5K
2   C    $0.6K
3   D    $7.0K

The second thing I need to do is somehow get these into a Seaborn heat map, which only accepts floats and integers. See here for more on the heat map aspect.

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.

Thanks in advance!

Solution

    def format(x):
        return "${:.1f}K".format(x/1000)


    df = pd.DataFrame(
        {'A':['A','B','C','D'],
         'C':[12355.00,12555.67,640.00,7000]
        })

    df['C'] = df['C'].apply(format)

    print(df)

Answered By - chenhong