How to Round Pandas Sum Results to Two Decimals – A Quick Fix

1. Introduction

Hello, I'm PiPi. A fan asked a Pandas data‑processing question about rounding the sum of a loan‑balance column to two decimal places.

2. Problem Statement

The DataFrame column 贷款余额 is of type float64, and the user tried to keep two decimal places after summing, but the result was not rounded.

3. Solution

Removing the second line does not help. The following code reads the Excel file, groups by borrower, sums the loan balance, and divides by 100 000. The result can then be formatted to two decimals as needed.

import pandas as pd
df = pd.read_excel('test_data.xlsx')
df1 = (df.groupby('借款人')['贷款余额'].sum())/100000
print(df1)

The fan’s issue was resolved successfully.

4. Conclusion

This post demonstrated how to handle a Pandas rounding problem and provided a concise code example for aggregating and formatting loan‑balance data.