How do I multiply items within a CSV

asked 2013-06-14 21:29:29 +0100

NickC
1 ●1

updated 2013-06-14 22:13:24 +0100

Hi, I am trying to import a CSV file then find the product of all of the numbers within the file. The code I have used so far is:

import csv
    mylist = list(csv.reader(open(DATA+'mydata.csv','rb'),dialect='excel'))
    from numpy import prod
    prod(mylist)

However, this doesn't work, I receive the following error "TypeError: cannot perform reduce with flexible type".

I think this is because of the format of how the mylist is created. This list data comes out in this format:

[['1'],['2'],['3']]

How do I coerce it into the format (1,2,3)?

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2013-06-15 07:14:37 +0100

tmonteil
27423 ●31 ●204 ●517 http://wiki.sagemath.o...

updated 2013-06-15 07:23:41 +0100

Here your list is a list of lists (you can see this by the nested brackets), each one contains a single string representing your integer (you can see this by the quotes). You can transform it to a list of integers as follows:

sage: mylist = [['1'],['2'],['3']]
sage: mylist
[['1'], ['2'], ['3']]
sage: [ZZ(i[0])  for i in mylist]
[1, 2, 3]
sage: prod([ZZ(i[0])  for i in mylist])
6

By the way, yo do not have to import the prod() function from numpy, Sage already have its own.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2013-06-14 21:29:29 +0100

Seen: 318 times

Last updated: Jun 15 '13

How do I multiply items within a CSV edit

1 Answer