Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #30744 > unrolled thread

sum function

Back to article view | Back to comp.lang.python

Contents

  sum function mike20007@gmail.com - 2012-10-04 13:52 -0700
    Re: sum function Ian Kelly <ian.g.kelly@gmail.com> - 2012-10-04 15:04 -0600
      Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 14:31 -0700
      Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 14:31 -0700
    Re: sum function Ian Kelly <ian.g.kelly@gmail.com> - 2012-10-04 15:05 -0600
      Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 14:29 -0700
        Re: sum function Dave Angel <d@davea.name> - 2012-10-04 17:39 -0400
          Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 17:40 -0700
            Re: sum function Ian Kelly <ian.g.kelly@gmail.com> - 2012-10-04 18:59 -0600
              Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 19:01 -0700
                Re: sum function Ramchandra Apte <maniandram01@gmail.com> - 2012-10-05 01:31 -0700
                Re: sum function Ramchandra Apte <maniandram01@gmail.com> - 2012-10-05 01:31 -0700
              Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 19:01 -0700
          Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 17:40 -0700
        Re: sum function Chris Angelico <rosuav@gmail.com> - 2012-10-05 07:34 +1000
      Re: sum function Mike <mike20007@gmail.com> - 2012-10-04 14:29 -0700
    Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 06:39 -0700
      Re: sum function Ramchandra Apte <maniandram01@gmail.com> - 2012-10-05 06:41 -0700
        Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 06:47 -0700
          Re: sum function Terry Reedy <tjreedy@udel.edu> - 2012-10-05 14:52 -0400
            Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 13:09 -0700
              Re: sum function Dave Angel <d@davea.name> - 2012-10-05 16:26 -0400
                Re: sum function Ramchandra Apte <maniandram01@gmail.com> - 2012-10-06 05:38 -0700
            Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 13:09 -0700
      Re: sum function Ian Kelly <ian.g.kelly@gmail.com> - 2012-10-05 13:29 -0600
    Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 13:03 -0700
      Re: sum function Ian Kelly <ian.g.kelly@gmail.com> - 2012-10-05 14:10 -0600
        Re: sum function Mike <mike20007@gmail.com> - 2012-10-05 14:19 -0700

Page 1 of 2  [1] 2  Next page →

#30744 — sum function

Hi All,

I am new to python and am getting the data from hbase. 
I am trying to do sum on the column as below


scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
total = 0.0
r = client.scannerGet(scanner)
while r:
  for k in (r[0].columns):
    total += float(r[0].columns[k].value)
  r = client.scannerGet(scanner)

print total

Do you know of better (faster) way to do sum?

Any thoughts please?

Thanks

[toc] | [next] | [standalone]

#30745

On Thu, Oct 4, 2012 at 2:52 PM,  <mike20007@gmail.com> wrote:
> scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
> total = 0.0
> r = client.scannerGet(scanner)
> while r:
>   for k in (r[0].columns):
>     total += float(r[0].columns[k].value)
>   r = client.scannerGet(scanner)
>
> print total
>
> Do you know of better (faster) way to do sum?

scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
next_r = itertools.partial(client.scannerGet, scanner)
total = sum(float(col.value) for r in iter(next_r, None) for col in
r.itervalues())

[toc] | [prev] | [next] | [standalone]

#30749

Thanks Ian for the quick reply.

I get the below error.

NameError: name 'itertools' is not defined

Thanks

[toc] | [prev] | [next] | [standalone]

#30750

Thanks Ian for the quick reply.

I get the below error.

NameError: name 'itertools' is not defined

Thanks

[toc] | [prev] | [next] | [standalone]

#30746

On Thu, Oct 4, 2012 at 3:04 PM, Ian Kelly <ian.g.kelly@gmail.com> wrote:
> scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
> next_r = itertools.partial(client.scannerGet, scanner)
> total = sum(float(col.value) for r in iter(next_r, None) for col in
> r.itervalues())

That should be "functools" above, not "itertools". :-P

[toc] | [prev] | [next] | [standalone]

#30747

I get below error

NameError: name 'functools' is not defined

Thanks

[toc] | [prev] | [next] | [standalone]

#30751

On 10/04/2012 05:29 PM, Mike wrote:
> I get below error
>
> NameError: name 'functools' is not defined
>

functools is a module in the standard library. You need to import it.

import functools



-- 

DaveA

[toc] | [prev] | [next] | [standalone]

#30761

On Thursday, October 4, 2012 5:40:26 PM UTC-4, Dave Angel wrote:
> On 10/04/2012 05:29 PM, Mike wrote:
> 
> > I get below error
> 
> >
> 
> > NameError: name 'functools' is not defined
> 
> >
> 
> 
> 
> functools is a module in the standard library. You need to import it.
> 
> 
> 
> import functools
> 
> 
> 
> 
> 
> 
> 
> -- 
> 
> 
> 
> DaveA

I imported functools. Now I get the below error please.


Traceback (most recent call last):
  File "test.py", line 16, in <module>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues()) 
  File "test.py", line 16, in <genexpr>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues()) 
AttributeError: 'list' object has no attribute 'itervalues'

Thanks

[toc] | [prev] | [next] | [standalone]

#30765

On Thu, Oct 4, 2012 at 6:40 PM, Mike <mike20007@gmail.com> wrote:
> Traceback (most recent call last):
>   File "test.py", line 16, in <module>
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues())
>   File "test.py", line 16, in <genexpr>
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues())
> AttributeError: 'list' object has no attribute 'itervalues'

"r.itervalues()" should have been "r[0].columns.itervalues()", I
think.  It's hard to test code against an API that you don't have. :-)

[toc] | [prev] | [next] | [standalone]

#30773

I agree with you, Ian. Thanks for all the help.  Now I get the below error.

  File "test.py", line 17, in <module>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
  File "test.py", line 17, in <genexpr>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())

Thanks

[toc] | [prev] | [next] | [standalone]

#30792

On Friday, 5 October 2012 07:31:24 UTC+5:30, Mike  wrote:
> I agree with you, Ian. Thanks for all the help.  Now I get the below error.
> 
> 
> 
>   File "test.py", line 17, in <module>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
>   File "test.py", line 17, in <genexpr>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
> 
> 
> Thanks

You have missed the last line of the traceback (error)

[toc] | [prev] | [next] | [standalone]

#30793

On Friday, 5 October 2012 07:31:24 UTC+5:30, Mike  wrote:
> I agree with you, Ian. Thanks for all the help.  Now I get the below error.
> 
> 
> 
>   File "test.py", line 17, in <module>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
>   File "test.py", line 17, in <genexpr>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
> 
> 
> Thanks

You have missed the last line of the traceback (error)

[toc] | [prev] | [next] | [standalone]

#30774

I agree with you, Ian. Thanks for all the help.  Now I get the below error.

  File "test.py", line 17, in <module>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
  File "test.py", line 17, in <genexpr>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())

Thanks

[toc] | [prev] | [next] | [standalone]

#30762

On Thursday, October 4, 2012 5:40:26 PM UTC-4, Dave Angel wrote:
> On 10/04/2012 05:29 PM, Mike wrote:
> 
> > I get below error
> 
> >
> 
> > NameError: name 'functools' is not defined
> 
> >
> 
> 
> 
> functools is a module in the standard library. You need to import it.
> 
> 
> 
> import functools
> 
> 
> 
> 
> 
> 
> 
> -- 
> 
> 
> 
> DaveA

I imported functools. Now I get the below error please.


Traceback (most recent call last):
  File "test.py", line 16, in <module>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues()) 
  File "test.py", line 16, in <genexpr>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r.itervalues()) 
AttributeError: 'list' object has no attribute 'itervalues'

Thanks

[toc] | [prev] | [next] | [standalone]

#30752

On Fri, Oct 5, 2012 at 7:29 AM, Mike <mike20007@gmail.com> wrote:
> I get below error
>
> NameError: name 'functools' is not defined
>
> Thanks

functools is a module:

import functools

ChrisA

[toc] | [prev] | [next] | [standalone]

#30748

I get below error

NameError: name 'functools' is not defined

Thanks

[toc] | [prev] | [next] | [standalone]

#30814

On Thursday, October 4, 2012 4:52:50 PM UTC-4, Mike wrote:
> Hi All,
> 
> 
> 
> I am new to python and am getting the data from hbase. 
> 
> I am trying to do sum on the column as below
> 
> 
> 
> 
> 
> scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
> 
> total = 0.0
> 
> r = client.scannerGet(scanner)
> 
> while r:
> 
>   for k in (r[0].columns):
> 
>     total += float(r[0].columns[k].value)
> 
>   r = client.scannerGet(scanner)
> 
> 
> 
> print total
> 
> 
> 
> Do you know of better (faster) way to do sum?
> 
> 
> 
> Any thoughts please?
> 
> 
> 
> Thanks

Sorry about that. Here you go

Traceback (most recent call last):
  File "test.py", line 17, in <module>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
  File "test.py", line 17, in <genexpr>
    total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
IndexError: list index out of range

[toc] | [prev] | [next] | [standalone]

#30815

On Friday, 5 October 2012 19:09:15 UTC+5:30, Mike  wrote:
> On Thursday, October 4, 2012 4:52:50 PM UTC-4, Mike wrote:
> 
> > Hi All,
> 
> > 
> 
> > 
> 
> > 
> 
> > I am new to python and am getting the data from hbase. 
> 
> > 
> 
> > I am trying to do sum on the column as below
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
> 
> > 
> 
> > total = 0.0
> 
> > 
> 
> > r = client.scannerGet(scanner)
> 
> > 
> 
> > while r:
> 
> > 
> 
> >   for k in (r[0].columns):
> 
> > 
> 
> >     total += float(r[0].columns[k].value)
> 
> > 
> 
> >   r = client.scannerGet(scanner)
> 
> > 
> 
> > 
> 
> > 
> 
> > print total
> 
> > 
> 
> > 
> 
> > 
> 
> > Do you know of better (faster) way to do sum?
> 
> > 
> 
> > 
> 
> > 
> 
> > Any thoughts please?
> 
> > 
> 
> > 
> 
> > 
> 
> > Thanks
> 
> 
> 
> Sorry about that. Here you go
> 
> 
> 
> Traceback (most recent call last):
> 
>   File "test.py", line 17, in <module>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
>   File "test.py", line 17, in <genexpr>
> 
>     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
> IndexError: list index out of range

the variable "r" is an empty list

[toc] | [prev] | [next] | [standalone]

#30816

On Friday, October 5, 2012 9:41:44 AM UTC-4, Ramchandra Apte wrote:
> On Friday, 5 October 2012 19:09:15 UTC+5:30, Mike  wrote:
> 
> > On Thursday, October 4, 2012 4:52:50 PM UTC-4, Mike wrote:
> 
> > 
> 
> > > Hi All,
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > I am new to python and am getting the data from hbase. 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > I am trying to do sum on the column as below
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"])
> 
> > 
> 
> > > 
> 
> > 
> 
> > > total = 0.0
> 
> > 
> 
> > > 
> 
> > 
> 
> > > r = client.scannerGet(scanner)
> 
> > 
> 
> > > 
> 
> > 
> 
> > > while r:
> 
> > 
> 
> > > 
> 
> > 
> 
> > >   for k in (r[0].columns):
> 
> > 
> 
> > > 
> 
> > 
> 
> > >     total += float(r[0].columns[k].value)
> 
> > 
> 
> > > 
> 
> > 
> 
> > >   r = client.scannerGet(scanner)
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > print total
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > Do you know of better (faster) way to do sum?
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > Any thoughts please?
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > 
> 
> > 
> 
> > > Thanks
> 
> > 
> 
> > 
> 
> > 
> 
> > Sorry about that. Here you go
> 
> > 
> 
> > 
> 
> > 
> 
> > Traceback (most recent call last):
> 
> > 
> 
> >   File "test.py", line 17, in <module>
> 
> > 
> 
> >     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
> > 
> 
> >   File "test.py", line 17, in <genexpr>
> 
> > 
> 
> >     total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())
> 
> > 
> 
> > IndexError: list index out of range
> 
> 
> 
> the variable "r" is an empty list

Here is the actual code.

scanner = client.scannerOpenWithStop("tab", "10", "1000", ["cf:col1"]) 
next_r = functools.partial(client.scannerGet, scanner)
total = sum(float(col.value) for r in iter(next_r, None) for col in r[0].columns.itervalues())


Scanner does have rows.

Are we missing something please?

Thanks

[toc] | [prev] | [next] | [standalone]

#30829

On 10/5/2012 9:47 AM, Mike wrote:
> On Friday, October 5, 2012 9:41:44 AM UTC-4, Ramchandra Apte wrote:
>> On Friday, 5 October 2012 19:09:15 UTC+5:30, Mike  wrote:
>>
>>> On Thursday, October 4, 2012 4:52:50 PM UTC-4, Mike wrote:
>>
>>>
>>
>>>> Hi All,
>>
>>>
>>
>>>>
>>
>>>
>>
>>>>
>>
>>>
>>
>>>>
>>
>>>
>>
>>>> I am new to python and am getting the data from hbase.

If you want as many people as possible to read your posts, stop using a 
mail-agent and site that spits in the face of readers by doubling blank 
lines each iteration. Alternatives have been discussed previously.

-- 
Terry Jan Reedy

[toc] | [prev] | [next] | [standalone]

Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.python

csiph-web