Ytukyg

I made a similar post here. Now I am trying to generalize what was done there for an entire matrix of numbers.

Specifically I want to do this:

dates = 

dates.append(NDD_month[0])

for i in range(1,len(cpi)):

    dates.append((dates[i-1] + 12 - number_of_payments[:i]) % 12)

print(dates)

where the number_of_payments is a matrix of type <class 'list'>.

Here is an example:

print(number_of_payments[:1])

is

[array([[0, 1, 0, 1, 1, 1, 0, 5, 1, 0, 2, 1]])]

After performing what I want then

print(dates[:1])

Should be

[array([[8, 8, 7, 7, 6, 5, 4, 4, 11, 10, 10, 8]])]

or something like that.

EDIT:

Here is an example of what my data looks like:

print(number_of_payments[:3])

This gives me this:

[

    array(

    [

        [0, 1, 0, 1, 1, 1, 0, 5, 1, 0, 2, 1]

    ]),

    array(

    [

        [0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0],

        [1, 3, 1, 0, 0, 1, 1, 1, 1, 0, 1, 0]

    ]),

    array(

    [

        [0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0],

        [0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

        [1, 0, 2, 0, 2, 1, 1, 0, 2, 1, 0, 0]

    ])

]



print(NDD_month[:3])

Gives me

[8, 7, 11]

Now for the answer I want I want to do something like this that I did in my earlier post where I had

dates = 

dates.append(NDD_month[0])

for i in range(1, len(first_payments)):

    dates.append((dates[i-1] + 12 - first_payments[i-1]) % 12)

print(dates)

This gave me the correct output of

[8 8 7 7 6 5 4 4 11 10 10 8]

But now since I have the number_of_payments being a matrix I need to apply the same logic to this larger data structure. Let me know if that is clear.
Edit 2:

Okay this is hard to explain so I am going to go step by step example, I have this data or matrix (number_of_payments) whatever it is in python:

    [[0, 1, 0, 1, 1, 1, 0, 5, 1, 0, 2, 1],

     [0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0],

     [1, 3, 1, 0, 0, 1, 1, 1, 1, 0, 1, 0]]

I have another list or vector called NDD_month, the first three elements are

[8, 7, 11]

Now for sake of simplicity lets say I just have the first row of number_of_payments i.e.

[0, 1, 0, 1, 1, 1, 0, 5, 1, 0, 2, 1]

Further for simplicity lets say I have just the first element of NDD_month so

8

Then to get the answer I seek I would do this that Aurora Wang provided a nice answer too which was this

first_payments = number_of_payments[:1]

first_payments = first_payments[0][0]

dates = 

dates.append(NDD_month[0])

for i in range(1, len(first_payments)):

    dates.append((dates[i-1] + 12 - first_payments[i-1]) % 12)

print(dates)

This gives me [8, 8, 7, 7, 6, 5, 4, 4, 11, 10, 10, 8].

Now I need to do the same thing but for each row in the matrix and each element in the NDD_month vector. I hope that makes it much more clear.

I was thinking this may work but again I am new to python and this does not work:

dates = 

for i in range(1,len(NDD_month)):

    dates.append(NDD_month[i-1])

    for j in range(1, len(NDD_month)):

        dates.append((dates[j-1] + 12 - number_of_payments[i-1][j-1]) % 12)

print(dates)

If I understood you right, you want to do something like this:

number_of_payments = [

    [0, 1, 0, 1, 1, 1, 0, 5, 1, 0, 2, 1],

    [0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0],

    [1, 3, 1, 0, 0, 1, 1, 1, 1, 0, 1, 0]

]

NDD_month = [8, 7, 11]

dates = 

for i in range(len(number_of_payments)):

    dates.append([NDD_month[i]])

    for j in range(1, len(number_of_payments[i])):

        dates[i].append((dates[i][j-1] + 12 - number_of_payments[i][j-1]) % 12)

print(dates)