Python get decimal number from float64 in a dataframe

Question

How to extract the decimal number part from a float (float64) in a dataframe? (a very common scenario but I can 't find a solution in StackOverFlow)

Note: be careful with the 196.09, I need 09, not 9.

Sample DataFrame:

    dollars Count
0   56.46   2
1   196.09  3
2   78.12   2

Expected result is the 2 decimal digits:

    decimal
0   46
1   09
2   12

Answer 1

Use numpy.modf, multiple by 100 and cast to integers:

df['decimal'] = (np.modf(df['dollars'])[0] * 100).astype(int)

Or split by .:

df['decimal'] = df['dollars'].astype(str).str.split('.').str[1].astype(int)

print (df)
   dollars  Count  decimal
0    56.46      2       46
1   196.69      3       68
2    78.12      2       12

EDIT: If need 09 format need second solution - output is strings:

df['decimal'] = df['dollars'].astype(str).str.split('.').str[1]
print (df)
   dollars  Count decimal
0    56.46      2      46
1   196.09      3      09
2    78.12      2      12