convert a django queryset into an array

Question

i would like convert a django queryset into an array like,

firstnames=Users.objects.values('firstnames')

to get a result that looks like

firstnames = ["Nancy", "Andrew", "Janet", "Margaret", "Steven", "Michael", "Robert", "Laura", "Anne"];

Any insights please? Regards Josh

Sahir Saiyed · Accepted Answer · 2020-07-30 23:54:51Z

38

Use QuerySet.values_list and specify flat=True:

firstnames = Users.objects.values_list('firstnames', flat=True)
firstnames = list(firstnames)

edited Jul 30, 2020 at 23:54

Sahir Saiyed

5308 silver badges17 bronze badges

answered Feb 21, 2014 at 23:53

falsetru

371k69 gold badges770 silver badges660 bronze badges

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

6 Comments

Joshua Over a year ago

Hi falsetru,I get an error Manager object has no attribute value_list

falsetru Over a year ago

@user3262370, It is values_list, not value_list.

almost a beginner Over a year ago

I tried this with decimal values, the returned list contains strings: Decimal('50.00'), Decimal('100.00')?? How do I just get the values?

falsetru Over a year ago

@almostabeginner, They are not strings. The representation of decimal objects looks like so. Try int(Decimal('50.00')) or float(Decimal('50.00')) according to your need.

G.Lebret Over a year ago

With values_list you get a Queryset... containing a list : <QuerySet [... , ...]> So you must be aware that you can't really use your result as a list (for example add your 'list' to another list).

|

Umair Khan · Accepted Answer · 2014-02-21 23:53:06Z

1

def get_array(Table, column):
    rows = Table.objects.values(column)
    return [row[column] for row in rows]

print get_array(Users, 'firstnames')

answered Feb 21, 2014 at 23:53

Umair Khan

1994 bronze badges

2 Comments

vivekv Over a year ago

Use value_list() instead and select only the columns you need

vee_ess Over a year ago

In some abstractions, it may not make sense to limit columns. For simple use cases what you say is a good general rule.

Collectives™ on Stack Overflow

convert a django queryset into an array

2 Answers 2

6 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related