thank you for reading my question. I would like to animate a text object in a blender file replacing the body text every 10 frames, iterating row by row through data drawn from a large csv file. There are 2 million rows. The csv data is structured in the following way:
nonce,cost,target,result
1,400,3.12,4
2,400,3.12,3.24
3,400,3.12,1.08
4,400,6.24,3.36
5,400,9.36,33.67
By way of an example (using the first 3 rows of my data) I have made this looping animated gif which illustrates in a basic form what I'm trying to achieve. Text that is green/red colour will be replaced every 10 frames with text from the next row in my csv file.
From my readings here Python seems to be the best way to achieve my animated end goal. There are many excellent answers relating to the use of Python and importing csv data to set the x,y,z location of a mesh or drive a rotation of objects or vertices. Some answers deal with a small amount of changing text data. I cant find an example of how to approach this with text data from such a large data file.
It's entirely possible the solution is obtainable from merging a few answers here, but my python knowledge is not at a level that allows me to make the connections between the expert knowledge given in previous answers.
I'm embarrassed to admit the amount of time I have spent trying to achieve, what seems to be a relatively simple animation. My failure to find a solution has knocked my confidence a little, any guidance is very much appreciated, thank you. I can supply the blend file from my gif animation and a sample of the csv text data if that helps. Thank you very much for your time.