fetch unique values of item from dynamoDB using python

Question

I am new to dynamoDB and unable to find material on how to fetch unique values of a particular item. I had a data in dynamoDB as show below:

Item_1      |  Item_2      |     Item_3
----------------------------------------
value_1_1   |  value_2_1   |    value_3_1
value_1_2   |  value_2_2   |    value_3_2
value_1_3   |  value_2_3   |    value_3_3
value_1_4   |  value_2_4   |    value_3_4

I want to get all the unique values of column Item_3

my approach is as follow:

import boto3
dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('women_kurta')
i=1
pricelist=[]
while i<50:
    data = table.get_item(Key={'id':i})#   data.save()
    pricelist+=[data['Item']['price']]
    print i
    i+=1
print list(set(pricelist))

but it is very slow and not efficient. Is there any other way to do it efficiently?

helloV · Accepted Answer · 2016-12-23 19:20:52Z

3

Untested code. So tweak it as necessary.

Instead of creating a new list every time, just append it. You will see many order of magnitude in speed.

pricelist.append(data['Item']['price'])

Use list comprehension for further speed improvement. This is just an idea. Try to understand and fix any syntax.

import boto3
dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('women_kurta')
pricelist = [table.get_item(Key={'id':i})['Item']['price'] for i in xrange(50)]
print list(set(pricelist))

answered Dec 23, 2016 at 19:20

helloV

52.9k7 gold badges146 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

fetch unique values of item from dynamoDB using python

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