How can I access elements inside a list within a dictionary python?

Question

I have a function that's returning a json formatted dataset. Here's a sample:

[{u'category': [u'Transfer', u'Withdrawal', u'ATM'], u'category_id': u'21012002', u'_account': u'XARE85EJqKsjxLp6XR8ocg8VakrkXpTXmRdOo', u'name': u'ATM Withdrawal', u'amount': 200, u'meta': {u'location': {u'city': u'San Francisco', u'state': u'CA'}}, u'date': u'2014-07-21', u'score': {u'location': {u'city': 1, u'state': 1}, u'name': 1}, u'_id': u'0AZ0De04KqsreDgVwM1RSRYjyd8yXxSDQ8Zxn', u'type': {u'primary': u'special'}, u'pending': False}] 

for trans in foodie_data:
            print 'Name={},Amount={},Date={}, Categories ={}\n'.format(trans['name'],trans['amount'],trans['date'],trans['category'])

This script prints:

Name=ATM Withdrawal,Amount=200,Date=2014-07-21,Categories=[u'Transfer', u'Withdrawal', u'ATM']

I want it to return Categories as a string and not a list:

Name=ATM Withdrawal,Amount=200,Date=2014-07-21,Categories='Transfer, Withdrawal,ATM']

What's the most efficient way of doing so?

', '.join(trans['category'])?

Shashank
– Shashank

2015-04-26 18:55:12 +00:00
Commented Apr 26, 2015 at 18:55 — Shashank
– Shashank, Commented Apr 26, 2015 at 18:55

Abhijit · Accepted Answer · 2015-04-26 18:59:16Z

2

Two quick fix in your code should solve it

Join the list returned by trans['category'] separated by comma such that it is a string rather than a string representation of list.

Quote the format specifier for category i.e. Categories =\'{}\'

for trans in foodie_data:
    print 'Name={},Amount={},Date={}, Categories =\'{}\'\n'.format(
    trans['name'],
    trans['amount'],
    trans['date'],
    ', '.join(trans['category']))

answered Apr 26, 2015 at 18:59

Abhijit

64k20 gold badges143 silver badges209 bronze badges

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

Comments

JuniorCompressor · Accepted Answer · 2015-04-26 18:55:58Z

2

You can join the elements of categories:

>>> categories = [u'Transfer', u'Withdrawal', u'ATM']
>>> ",".join(categories)
u'Transfer,Withdrawal,ATM'

and use it instead when printing your output:

",".join(trans['category'])

answered Apr 26, 2015 at 18:55

JuniorCompressor

20.1k4 gold badges33 silver badges58 bronze badges

Comments

Padraic Cunningham · Accepted Answer · 2015-04-26 19:08:37Z

0

You can also you the dict directly with str.format to access the rest of the values:

for trans in foodie_data:
    print "Name={name},Amount={amount},Date={date}," \
       "Categories='{}'\n".format(",".join(trans["category"]),**trans)


 Name=ATM Withdrawal,Amount=200,Date=2014-07-21,Categories='Transfer,Withdrawal,ATM'

edited Apr 26, 2015 at 19:08

answered Apr 26, 2015 at 19:03

Padraic Cunningham

181k30 gold badges264 silver badges327 bronze badges

Collectives™ on Stack Overflow

How can I access elements inside a list within a dictionary python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related