用str后出现小数点，这是什么原因啊

Question

```python
import pandas as pd
import openpyxl
from pandas import DataFrame
from openpyxl import load_workbook
Expore= pd.read_excel('sales_FINAL.xlsx',sheet_name='Sheet1')
column1= Expore['Sales Doc'].map(str)+Expore['Sales Doc Item'].map(str)
column2= Expore['Updated By']
Expore=pd.DataFrame({"SO+LINE":column1,"Updated By":column2})
Expore.drop_duplicates(subset='SO+LINE',inplace=True,keep='first')
Expore.to_excel('Exp.xlsx',sheet_name='Exp-updated',index=None,header=True

原始数据类似：Sales Doc Sales Doc Item Created By
3000561929 10 PIPARALLEL
3000564356 10 PIPARALLEL
3000568582 60 PIPARALLEL
3000570574 10 PIPARALLEL
3000571113 10 PIPARALLEL
我合并后变成了
300056192910.0
300056435610.0
300056858260.0
300057057410.0
300057111310.0

为什么会有.0呢，这个怎么去掉呀。

Answer 1

第10行改成：column2 = Expore['Created By']。为避免读取的浮点数据，可以在读取后对该列进行数据类型强制转换。比如Expore['Sales Doc Item']=Expore['Sales Doc Item'].astype(int),然后再map成字符串并拼接。