Hello!! I’m trying to import a local csv file using uplink. I have no problems with text and number types. But I can’t figure how to import date columns. What I have is: A datatable named “datetable” with one column named “datetime” of type date. [image] A csv with one column and one row: […

You have to manually convert the datetime column in your csv to a datetime object before adding the row to the table. The table does not automatically convert strings to datetimes. def import_csv_data(file): with open(file,"r") as r: df = pd.read_csv(f) for d in df.to_dict(orien…

Import csv with dates

Anvil Q&A

ianb March 6, 2024, 7:08pm 3

I made this clonable example, if you look at the code in it, how to parse datetimes is there.
Or you can just use it to load your data.

Also welcome to anvil!