Store integer and float in numpy array in matrix form

Question

The following code contains PostGIS query and get 'product', which includes integer and floats,

import numpy

k = 8
for i in cor_list:
    for l in cor_list:
        cur.execute(query, (i, l, False, False))
        element = cur.fetchall()
        product = sum([a[-1] for a in element[:-1]])
        print product
        ss = numpy.array(product, ndmin = 2)
kk = ss.reshape((k,k))

part of product looks like:

0
6460.51962839
16386.3142965
18349.9662043
13071.5492165
8349.95786602
3977.69337529
10471.7888158
6460.51962839
0
9925.79466809
11889.4465759

and I want to arrange these product in a numpy array which is 8 times 8, which could looks like,

but as I ran the code above, I got this error:

ValueError: total size of new array must be unchanged

How to store integer and float generated by for-loop in numpy array in matrix form?

product is integer or float, and as I ran print product.shape, error shows: AttributeError: 'int' object has no attribute 'shape'. — Heinz
– Heinz, Commented Oct 25, 2016 at 8:56
ss is just one of those product values. Nothing in your loops is collecting the product values. — hpaulj
– hpaulj, Commented Oct 25, 2016 at 8:58

Angus Williams · Accepted Answer · 2016-10-25 09:03:17Z

2

I think you can fix your code by doing something like this:

import numpy

product = []
k = 8
for i in cor_list:
    for l in cor_list:
        cur.execute(query, (i, l, False, False))
        element = cur.fetchall()
        product.append( sum([a[-1] for a in element[:-1]]) )
kk = numpy.array(product).reshape((k,k))

answered Oct 25, 2016 at 9:03

Angus Williams

2,34421 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Store integer and float in numpy array in matrix form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related