Ignoring blanks for continous lines

Support questions for Flow CSV Viewer and Editor.
Post Reply
Ezy
Posts: 1
Joined: Sun Apr 30, 2023 12:25 am

Ignoring blanks for continous lines

Post by Ezy »

Hey! I have a csv with timestamp in first column, and a lot of other entries in the other.
When I use timestamp on X-axis I only get dots where there are active entries. Is there a way for flow to assume emtpy entries to get continous lines?
Attachments
Uten navn.png
Uten navn.png (94.68 KiB) Viewed 9662 times
Waveworks
Posts: 169
Joined: Thu Sep 05, 2019 1:05 pm

Re: Ignoring blanks for continous lines

Post by Waveworks »

Hello Ezy!

First of all, terribly sorry for the delayed response. For some reason I didn't get an email notification.

I assume that what you would like is to connect the dots with diagonal lines, i.e. interpolate between them? Unfortunately this is currently not supported in Flow. What you could do is to write a formula that fills in the gaps with the last known value whenever there is no value as follows:

x_continuous = x if not isnan(x) else x_continuous[t-1]

Here, x is the variable name for the column. For column headers containing non-alphanumeric characters, the variable names are printed in the message view when you open the file. I can see that you have quite many variables (and also quite long variable names), so I'm afraid it might be a bit cumbersome.

Best regards,
Gustaf
Post Reply