pandas-ai
pandas-ai copied to clipboard
type object 'datetime.datetime' has no attribute 'datetime'
System Info
pandasai version 2.0.42
🐛 Describe the bug
When I input question related to date time, it will generate code using datetime library, but it often encounters this error. I guess sometimes it will confuse between import datetime and from datetime import datetime?
AttributeError: type object 'datetime.datetime' has no attribute 'datetime'
[INFO] Code generated:
import datetime
# Assuming dfs[0] is your DataFrame
filtered_df = dfs[0][(dfs[0]['priority'].isin(['P0 - Critical', 'P1 - High'])) & (dfs[0]['created'] >= datetime.datetime.now() - datetime.timedelta(days=30)) & (dfs[0]['created'] < datetime.datetime.now() - datetime.timedelta(days=7))]
result_df = filtered_df[['epic_id', 'priority', 'summary', 'created']]
result = {'type': 'dataframe', 'value': result_df}
[INFO] Executing Step 2: CodeCleaning [INFO] Code running:
filtered_df = dfs[0][dfs[0]['priority'].isin(['P0 - Critical', 'P1 - High']) & (dfs[0]['created'] >= datetime.datetime.now() - datetime.timedelta(days=30)) & (dfs[0]['created'] < datetime.datetime.now() - datetime.timedelta(days=7))]
result_df = filtered_df[['epic_id', 'priority', 'summary', 'created']]
result = {'type': 'dataframe', 'value': result_df}