Skip to content

Cannot able to read csv with date objects as columns #1861

@Swapnil-Kunjir

Description

@Swapnil-Kunjir

IHi i was trying to read csv in pandasai with columnheaders as datetime and i was not able to read it. I even tried converting datetime columns to pure text and it still fails
ValidationError: 1 validation error for SemanticLayerSchema
Value error, All columns in a table must be in the format '[column_name]' accepting only letters, numbers, and underscores. [type=value_error, input_value={'name': 'table_40d52ff5e...sion=None, alias=None)]}, input_type=dict]
For further information visit https://errors.pydantic.dev/2.12/v/value_error
Output is truncated. View as a scrollable element or open in a text editor. Adjust cell output settings...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions