Import CSV, write variables to contact extra slots

UDEC
1

Hi all,

I am looking to create a plot that compares contact data from two different save states for different modelling scenarios in UDEC v7.

From each of the two save states I have exported a text file with contact data. For simplicity say it is a text file with about 15,000 rows, where the first column is contact index, second column is “variable 1” and third column is “variable 2”.

I used Excel to create a third text file that compares these two save states. So now I have a text file, call it “compare.csv” with 15,000 rows, where the first column is contact index, second column is “difference 1” and third column is “difference 2”.

I am trying to create FISH function in UDEC v7 where I can do the following

  • import “compare.csv”
  • write the values for “difference 1” and “difference 2” to the corresponding contact index in the model

Doing this so I can create a plot where contacts are coloured by the difference between save state 1 and save state 2.

Been struggling through the manual and trying to get help from various AI chatbots but no success so far. Could anyone point me in the right direction?

Thanks very much

2

for any who are interested, I think I sorted it out. see below:

fish def _compare
io.out(‘Plotting contact data…’)
local filename = ‘_compare.csv’
local filepointer = file.open(filename,‘read’,‘text’)

    line = file.read(filepointer)
    rows = list.size(line)
    
    input_array = array.create(rows-1,3)
    
    loop i (2,rows)
        value = string.split(line(i),',')
            idx = value(1)
            d_cr = value(2)
            d_tr = value(3)
                input_array(i-1,1) = int(idx)
                input_array(i-1,2) = float(d_cr)
                input_array(i-1,3) = float(d_tr)
    endloop

ic = block.contact.head
loop while ic # 0
rownum = 1
    loop rownum (1,rows-1)
        if int(input_array(rownum,1)) = ic then
            block.contact.extra(ic,1) = float(input_array(rownum,2))
            block.contact.extra(ic,2) = float(input_array(rownum,3))
        endif
    endloop

ic = block.contact.next(ic)
endloop

end
@_compare

2 Likes