I have some data that is currently a series of straight lines on a graph. I'd like to

  1. load the data from a CSV/Excel/JSON file (i can wrangle it to anything but CSV is easiest I think)
  2. convert the data in the matrix to screen appropriate (X, Y) coordinates
  3. create a loop that can time sequence through rows of the data file and interpolate the values for each column value across each iteration of the loop
  4. create a smooth curve from resulting set of (X, Y) coordinates

In QC this would be pretty easy work for me but I'm a Vuo newb, could anybody get me started on any of asks 1-4?

I'm kinda in a hurry and would normally go straight to QC with Kineme data tools and 2D drawing plugins but the Kineme Spline line patch creates weird kinky loops on the line near the end points (for no apparent reason) so I determined it was unusable when I tried it a while back. I could do manually in After Effects but the idea makes me scream when I could make it in QC/VUO/ORIGAMI.

I'm just animating the Duck Curve graph if people know what that is. A time sequence of modeled data for daily demand curves across a series of years. So one coloured line becomes the next through interpolation in the illustration below. And smoothing as a bonus would be nice to have (and interesting to see the performance hit too :-) )

Link to CSV File of Data (4KB)

If someone can get me a demo of something doing this with some data I can make all the grid lines, labels bells and whistles. Just knocked this up in AE: (can't get this tiny video to either upload to vuo.org as a .mov file or use a YouTube link… it uploads and then on the last question and button gives error screen) https://youtu.be/HJPQ89_tbJ8

Here is a animation of the data generated in Python but i want to do something prettier. It actually is grabbing minimum (green line), maximum (red line) and calculating average demand (black line) for each year, would require 3 sets of data and some way to fill the regions (not sure how I'd shade the complex regions b/w red and green lines in Vuo yet). https://youtu.be/7wqpBhxSnU4

Comments

So I can load the table and

useful design's picture
Submitted by

So I can load the table and append all the header text from the first row into a single text item and that's about it so far.

How do I rotate a text layer?! I used a 2D Transform node and although it will translate (X, Y) it will not scale or rotate the text.

No idea what I'm doing wrong, how hard does rotating a single "Hello World" by 45º have to be?

In this vuo file the filepath to the data will have to be updated to wherever you put it. Just drag the CSV file into the composition and a new Fetch Table node is created with the correct URL.

Here is the CSV file again, zipped this time to get it on the VUO server minimum_swis_load_21.2V2c.csv_.zip