Python sort list of dictionary using another list

Question

Here is my data

pricing = [
    {
      "link": "https://www.kohls.com/product/prd-3751773/laura-geller-iconic-baked-sculpting-lipstick.jsp?skuid=75792684",
      "price": "21",
      "stock": true,
      "title": "Laura Geller Iconic Baked Sculpting Lipstick, Red Overfl",
      "seller": "Kohl's"
    },
    {
      "link": "https://www.macys.com/shop/product/laura-geller-beauty-iconic-baked-sculpting-lipstick-cream?ID=5713197&PartnerID=LINKSHARE&cm_mmc=LINKSHARE-_-4-_-41-_-MP441",
      "price": "21.00",
      "stock": true,
      "title": "Laura Geller Beauty Iconic Baked Sculpting Lipstick - Cream",
      "seller": "Macy's"
    },
            {
      "link": "https://www.macys.com/shop/product/laura-geller-beauty-iconic-baked-sculpting-lipstick-cream?ID=5713197&PartnerID=LINKSHARE&cm_mmc=LINKSHARE-_-4-_-41-_-MP441",
      "price": "21.00",
      "stock": true,
      "title": "Laura Geller Beauty Iconic Baked Sculpting Lipstick - Cream",
      "seller": "Wal-Mart.com"
    }
  ]

Below code i am writing make them sort as per the list

retailers = ["Amazon", "Wal-Mart.com", "Target", "CVS",  "Walgreens","Macy’s", "Nordstrom", "MassGenie", "Kohl's", "Kmart"]
data = sorted(pricing, key=lambda x: retailers.index(x['seller']))

error:

ValueError at /api/product/
"Macy's" is not in list

Here i am trying to sort data by seller key as per the list retailers but, i am getting key error while sorting the data. Please have a look where i am making mistake

I am expecting result:

pricing = [
    {
      "link": "https://www.macys.com/shop/product/laura-geller-beauty-iconic-baked-sculpting-lipstick-cream?ID=5713197&PartnerID=LINKSHARE&cm_mmc=LINKSHARE-_-4-_-41-_-MP441",
      "price": "21.00",
      "stock": true,
      "title": "Laura Geller Beauty Iconic Baked Sculpting Lipstick - Cream",
      "seller": "Wal-Mart.com"
    },
    {
      "link": "https://www.macys.com/shop/product/laura-geller-beauty-iconic-baked-sculpting-lipstick-cream?ID=5713197&PartnerID=LINKSHARE&cm_mmc=LINKSHARE-_-4-_-41-_-MP441",
      "price": "21.00",
      "stock": true,
      "title": "Laura Geller Beauty Iconic Baked Sculpting Lipstick - Cream",
      "seller": "Macy's"
    },
    {
      "link": "https://www.kohls.com/product/prd-3751773/laura-geller-iconic-baked-sculpting-lipstick.jsp?skuid=75792684",
      "price": "21",
      "stock": true,
      "title": "Laura Geller Iconic Baked Sculpting Lipstick, Red Overfl",
      "seller": "Kohl's"
    }
  ]

Please have a look

Selcuk · Accepted Answer · 2020-09-08 05:38:46Z

2

Your code is correct. The problem is "Macy’s" is not the same as "Macy's" (note the different apostrophe character).

edited Sep 8, 2020 at 5:38

answered Sep 8, 2020 at 5:36

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

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

2 Comments

Joe Ferndz Over a year ago

change the. data in retailer's list to reflect the same as dictionary

Selcuk Over a year ago

Just change ’ to '.

Joe Ferndz · Accepted Answer · 2020-09-08 05:44:54Z

1

Your current retailers list shows this way:

  retailers = ["Amazon", "Wal-Mart.com", "Target", "CVS",  "Walgreens","Macy’s", "Nordstrom", "MassGenie", "Kohl's", "Kmart"]

Change it to

  retailers = ["Amazon", "Wal-Mart.com", "Target", "CVS",  "Walgreens","Macy's", "Nordstrom", "MassGenie", "Kohl's", "Kmart"]

All I did was to change ’ to '

Btw, Kohl's looks correct

answered Sep 8, 2020 at 5:44

Joe Ferndz

8,5282 gold badges15 silver badges37 bronze badges

Comments

Sandrin Joy · Accepted Answer · 2020-09-08 06:03:11Z

0

There where 2 errors in your code

macy’s in retailers list. instead of macy's
true in pricing list. instead of True (Boolean starts with capital Letter in python)

answered Sep 8, 2020 at 6:03

Sandrin Joy

1,17414 silver badges32 bronze badges

Collectives™ on Stack Overflow

Python sort list of dictionary using another list

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related