NameError: name 're' is not defined

[abhigarg]

This error occurs when I am asking it to find sum of rows of certain column after filtering the rows by value of another column. In case of value being string, its applying the flag=re.IGNORECASE which is throwing the error re is not defined

This is the command returned by chatGPT:
df[df['Description/Narration'].str.contains('MONTHLY INTEREST', flags=re.IGNORECASE)]['Credit(Cr.)'].sum()

I asked this question:
df_table.llm.query("What is the total credit with MONTHLY INTEREST in Description?")

[ccurme]

Hi @abhigarg

Thanks for raising this issue. NameErrors like this can arise if code generated in .query references something outside the namespace of that method-- in this case the package re.

I've created #28 to capture this issue generally. A workaround for now is to add an instruction in the query to "import any packages you need." I was able to reproduce your issue and this workaround solved it for me. Streamlining this will require some development in yolopandas that is described in #28.