Hi,
I am new to scripting and would greatly appreciate any help with the following:
I am trying to write a script that will allow me to group and stack columns with variable name suffixes. My table consists of a few columns with names that dont change (i.e. source, frame) and many others (up to hundreds) that begin with x, y, area, perimeter, AR and have the suffix 1, 2, 3, etc . so normally it would look like this...
source, frame, x1, y1, ar1, area 1, angle1, perimeter1, x2, y2, ar, area2, angle2, perimeter2, ....and so on...
I would appreciate greatly any help with putting together a script that would group all the exes, all the ys, etc, regardless of the number. After this I would like to stack them with one column indicating the suffix and the other columns with the data for x, y, area, perimeter.
Hopefully I made myself clear.
I am also attaching a small table to make it easier to follow.
Thanks for any help,
Andres