当我运行代码时,出现了下面的“python int too large to convert to sqlite integer”错误。我是psql的初学者。
代码:import pandas as pd import numpy as np import pandasql as psql from pandasql import sqldf
T900_file = r'K:\myfile.xlsx'
df1 = pd.read_excel(T900_file)
T1000 = psql.sqldf("""Select Date
,UP_Cust_Num
,UP_Cust_Name
,sum(Utilized_FVO) as FVO
,avg(UP_Generation) as UP_Gen
from df1
Group by Date, UP_Cust_Num, UP_Cust_Name""")
错误必须与聚合有关。如何解决错误?任何帮助都将不胜感激。
暂无答案!
目前还没有任何答案,快来回答吧!