While being at it.
Not clear about the Date(time) in Explorer anyway. I wrote it as utc_datetime in the SQLite with Ecto. Than in the DB the date is a text (why). Explorer does read it as text and does not infer it from the format (which is okay, because the db should have the correct type in the first place.
The strings has the format of
2023-08-29T15:38:00 I convert the Series of strings to a list of DateTime with
dt = S.to_list(df["date"]) |> Enum.map(&elem(DateTime.from_iso8601(&1 <>"+00:00"),1))
a) Why couldn’t I not write with
DateTime.from_iso8601(&1, :basic, "ETC/UTC")
b) Why cann’t I convert the list to a Series? Error:
unsupported datatype: ~U[2023-08-29 15:38:00Z]
c) Why cannot I write it into the DataFrame with put? Sane error as in b)
Minimum example for a)
test_dates = S.from_list(["2023-08-29T15:38:00", "2023-08-29T14:17:28", "2023-08-29T12:53:17",]) dt0 = Enum.at(S.to_list(test_dates), 0) DateTime.from_iso8601(dt0, :basic, "ETC/UTC")
Throws the error:
FunctionClauseError) no function clause matching in Calendar.ISO.parse_utc_datetime/2 The following arguments were given to Calendar.ISO.parse_utc_datetime/2: # 1 "2023-08-29T15:38:00" # 2 "ETC/UTC" Attempted function clauses (showing 1 out of 1): def parse_utc_datetime(string, format) when is_binary(string) and format === :basic or format === :extended
Which is strange because I added the format as :basic …
Edit: In the end I only want to be able to filter the DataFrame by a minimum date and/or a maximum date.