Hi all !
New to the forum and rather new to Python scripting, but not new to programming in general. I am looking for advice on the data structure to incorporate the below. Looking at the attached picture, I have a structure that looks like an array in Excel VBA. The rows and columns need to be dynamic. Each column will always have 10 fixed entries to start with (shown in yellow), followed by a variable part containing each time a number and a string.
I coded this in Excel VBA as a proof of concept but it's painfully slow. The question: how do I set it up in Python objects ? Is this feasible in a list ? or an array ? A dictionary ? Or nested objects ? There are 1 to 100 columns at most, and 1 to 4000 rows per column, at most.
The source of the data is a text file. Each line will have some information stored in the object. After that, I need to loop over the object to output to a new text file.
Thanks a lot !
![[Image: 01.png]](https://www.wimgielis.com/pics/01.png)
New to the forum and rather new to Python scripting, but not new to programming in general. I am looking for advice on the data structure to incorporate the below. Looking at the attached picture, I have a structure that looks like an array in Excel VBA. The rows and columns need to be dynamic. Each column will always have 10 fixed entries to start with (shown in yellow), followed by a variable part containing each time a number and a string.
I coded this in Excel VBA as a proof of concept but it's painfully slow. The question: how do I set it up in Python objects ? Is this feasible in a list ? or an array ? A dictionary ? Or nested objects ? There are 1 to 100 columns at most, and 1 to 4000 rows per column, at most.
The source of the data is a text file. Each line will have some information stored in the object. After that, I need to loop over the object to output to a new text file.
Thanks a lot !