# Set decimal precision of a pandas dataframe column with a datatype of Decimal

We Are Going To Discuss About Set decimal precision of a pandas dataframe column with a datatype of Decimal. So lets Start this Python Article.

## Set decimal precision of a pandas dataframe column with a datatype of Decimal

1. How to solve Set decimal precision of a pandas dataframe column with a datatype of Decimal

This can be modified by changing the print options for floats, however it will modify how every float datatype is printed
`pd.set_option('display.float_format', '{:.10f}'.format)`
Keep in mind that this is only the way it's printed. The value is stored in the dataframe, with every decimal.
On the other hand, you can restrict decimals by:
`df.Value = df.Value.round(4)`
But this will round depending the fifth decimal. Last option would be to use `np.ceil` or `np.floor` but since this wont support decimals, an approach with multiplication and division is requierd:
`precision = 4 df['Value_ceil'] = np.ceil(df.Value * 10**precision) / (10**precision) df['Value_floor'] = np.floor(df.Value * 10**precision) / (10**precision)`

2. Set decimal precision of a pandas dataframe column with a datatype of Decimal

This can be modified by changing the print options for floats, however it will modify how every float datatype is printed
`pd.set_option('display.float_format', '{:.10f}'.format)`
Keep in mind that this is only the way it's printed. The value is stored in the dataframe, with every decimal.
On the other hand, you can restrict decimals by:
`df.Value = df.Value.round(4)`
But this will round depending the fifth decimal. Last option would be to use `np.ceil` or `np.floor` but since this wont support decimals, an approach with multiplication and division is requierd:
`precision = 4 df['Value_ceil'] = np.ceil(df.Value * 10**precision) / (10**precision) df['Value_floor'] = np.floor(df.Value * 10**precision) / (10**precision)`

## Solution 1

This can be modified by changing the print options for floats, however it will modify how every float datatype is printed

``````pd.set_option('display.float_format', '{:.10f}'.format)
``````

Keep in mind that this is only the way it’s printed. The value is stored in the dataframe, with every decimal.

On the other hand, you can restrict decimals by:

``````df.Value = df.Value.round(4)
``````

But this will round depending the fifth decimal. Last option would be to use `np.ceil` or `np.floor` but since this wont support decimals, an approach with multiplication and division is requierd:

``````precision = 4
df['Value_ceil'] = np.ceil(df.Value * 10**precision) / (10**precision)
df['Value_floor'] = np.floor(df.Value * 10**precision) / (10**precision)``````

Original Author jcaliz Of This Content

## Solution 2

Fixed the issue, seems to be related to how Decimal converts from float to decimal. Setting the Values column to be of data type string then converting to Decimal got me the result I desired.

``````def get_df(table_filepath):
df['Value'] = df['Value'].apply(str)
df['Value'] = df['Value'].apply(Decimal)
``````
Key Value
A 1.2089
B 5.6718
B 7.3084

Original Author jcaliz Of This Content

## Conclusion

So This is all About This Tutorial. Hope This Tutorial Helped You. Thank You.