pandasql:python int太大,无法转换为sqlite整数

dly7yett  于 2021-07-13  发布在  Java
关注(0)|答案(0)|浏览(293)

当我运行代码时,出现了下面的“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""")

错误必须与聚合有关。如何解决错误?任何帮助都将不胜感激。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题