python。OverflowError: Python int too large to convert to C int

Question

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

数据是如下这样。Sales Doc为文本格式或者数字。然后run下来就报错
Sales Doc Sales Doc Item
3000561929 10
3000564356 10
3000568582 60
3000570574 10
3000571113 10
3000575647 60
3000576468 10
3000576560 10
3000576715 10
3000576722 10
3000577644 20
3000578679 10

Answer 1

数据超过了对应类型的范围。

Pandas : OverflowError: Python int too large to convert to C long问题解决的一个方法_筑梦新时代的博客-CSDN博客 有的时候，我们在处理dataframe时，需要将这些dtype(just means data type)是object的数据转换为int，如果数据很大的话，就会出现如下的报错：In [1]: data['itemId'] = data['itemId'].astype(int)Out[1]: Traceback (most recent call last): File "<ip... https://blog.csdn.net/weixin_43187555/article/details/103995364?utm_source=app&app_version=4.17.0