4 ms·
I loaded a CSV with one date/time column and one numerical column. I then selected “Scatter Plot”, but got the message “Not enough numerical columns found. Loa
by teddyh 2y ago
I loaded a CSV with one date/time column and one numerical column. I then selected “Scatter Plot”, but got the message “Not enough numerical columns found. Load a CSV file with at least 2 numerical columns in the Datasets tab.” I would have thought that a date/time column would count?
- kengoa 2y agoThanks for trying it out! This is unfortunately not possible as of now and is one of th high-priority tasks to parse timestamps and datetimes, which is now incorrectly parsed as a string (Categorical). I'm using Papa Parse to load CSV data and I will likely need to add a custom parser on top of it. Some of those plans are mentioned in my blog post reflecting on building this app: https://kengoa.github.io/software/2024/11/03/small-software.html https://kengoa.github.io/software/2024/11/03/small-software....
- nerdponx 2y agoYou might also want to support a Unix timestamp as input, i.e. an integer or decimal number of (mili|micro|nano-)seconds since the Unix epoch. No need to worry about messy date parsing there.
- nyclounge 2y agoMaybe use dayjs to handle all kinds of wired string dates.
- kengoa 2y agodayjs seems like exactly I was looking for, thanks for the suggestion! I might have tried to write a parser myself otherwise.