-
-
Notifications
You must be signed in to change notification settings - Fork 320
Closed
Description
It is strange, when I ran a pandas dataframe.drop_duplicates script after a 'sql line', there was an error "Project.exe raised exception class EInvalidOP with message 'Invalid floating point operation'". But It can ran 'dataframe.drop_duplicates' line without 'sql' line secussfully. pandas ==1.0 /1.3 p4d==latest release
'''
from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://ruser:haosql@localhost:3306/shenweipipeline')
sql = ''' select * from ft5201; '''
df = pd.read_sql_query(sql, engine)
df.drop_duplicates(subset=['RecordDateTime'],keep='first',inplace=True)
'''
Metadata
Metadata
Assignees
Labels
No labels