pandas-ai icon indicating copy to clipboard operation
pandas-ai copied to clipboard

type object 'datetime.datetime' has no attribute 'datetime'

Open ssling0817 opened this issue 8 months ago • 1 comments

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}

ssling0817 avatar Jun 26 '24 20:06 ssling0817