Python 如何舍入Pandas 数据框中一列集合中的值

置信区间计算返回一组括号内的两个数字，我将其放入数据帧中.从这一点上，我需要向下舍入这些值，并将输出放入excel文件中.

在下面的示例代码中，如何将Col1中的值舍入为2位小数.

import pandas as pd
import xlwings

# example data frame
inp = [{'Id': 0, 'Col1': (1.245987, 3.12345), 'Col2': 9},
       {'Id': 1, 'Col1': (1.3386, 3.19826), 'Col2': 9},
       {'Id': 2, 'Col1': (1.4673, 3.23462), 'Col2': 10},
       {'Id': 3, 'Col1': (1.562624, 3.32546), 'Col2': 10}, 
       {'Id': 4, 'Col1': (1.2573, 3.436537), 'Col2': 11},
       {'Id': 5, 'Col1': (1.273883, 3.58924), 'Col2': 12}
       ]
df = pd.DataFrame(inp)


# round down col1 values
### df["Col1"] = df["Col1"].round(2)    # doesn't work

df["Col1"] = df["Col1"].astype(str)       # without this, values not exported by xlwings

book = xlwings.Book(r'C:\Users\Dyer01\Documents\Mappe1.xlsx')
sheet = book.sheets["Tabelle1"]
sheet.range("c3").options(header=False, index=False).value = df

我需要的是:

   Id      Col1        Col2
0   0  (1.25, 3.12)     9
1   1  (1.34, 3.20)     9
2   2  (1.47, 3.23)    10
3   3  (1.56, 3.33)    10
4   4  (1.26, 3.44)    11
5   5  (1.27, 3.60)    12