I have some data that is currently a series of straight lines on a graph. I'd like to
- load the data from a CSV/Excel/JSON file (i can wrangle it to anything but CSV is easiest I think)
- convert the data in the matrix to screen appropriate (X, Y) coordinates
- 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
- 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