Show HN: Visprex – Open-source, in-browser data visualisation tool for CSV files

Re:Show HN: Visprex – Open-source, in-browser data visualisa... by teddyh on Saturday November 09, 2024 @05:35PM (#42097336)

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?

[ Parent | on HN ]

Re:Show HN: Visprex – Open-source, in-browser data visualisa... by kengoa on Saturday November 09, 2024 @05:57PM (#42097449)

Thanks 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....

[ Parent | on HN ]

Re:Show HN: Visprex – Open-source, in-browser data visualisa... by nerdponx on Saturday November 09, 2024 @06:33PM (#42097574)

You 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.

[ Parent | on HN ]

Re:Show HN: Visprex – Open-source, in-browser data visualisa... by nyclounge on Saturday November 09, 2024 @07:19PM (#42097754)

Maybe use dayjs to handle all kinds of wired string dates.

[ Parent | on HN ]

Re:Show HN: Visprex – Open-source, in-browser data visualisa... by kengoa on Sunday November 10, 2024 @10:26AM (#42100685)

dayjs seems like exactly I was looking for, thanks for the suggestion! I might have tried to write a parser myself otherwise.

[ Parent | on HN ]