How can I replace comma separated ids in a string by doing a lookup in json response in python

by

You can use pandas with isin:

>>> import pandas as pd
>>> df = pd.DataFrame(dealfields)
>>> df
    id label
0  214    BE
1  215    CH
2  274    DE
3  216    ES
4  416    EU
5  218    GB
6  278    HR
7  418    US
>>> data = [{

  "target_country": "214,216,278,418"
}]
>>> fields = df[df['id'].isin(map(int,data[0]["target_country"].split(',')))
                ]['label'].tolist()
>>> target_country = ', '.join(fields)
>>> target_country
'BE, ES, HR, US'

More Related Contents:

  1. a pythonic way of doubling consecutive binary bits [closed]
  2. how to scrape web page that is not written directly using HTML, but is auto-generated using JavaScript? [closed]
  3. TypeError: ‘NoneType’
  4. TypeError: unsupported operand type(s) for -: ‘str’ and ‘int’
  5. How do chained assignments work?
  6. How to save a dictionary to a file?
  7. Pip – Fatal error in launcher: Unable to create process using ‘”‘
  8. Django TemplateDoesNotExist?
  9. Installing scipy in Python 3.5 on 32-bit Windows 7 Machine
  10. Schedule a repeating event in Python 3
  11. What is sys.maxint in Python 3?
  12. How to melt 2 columns at the same time?
  13. Why is there no xrange function in Python3?
  14. Get all keys of a nested dictionary [duplicate]
  15. Configure Django and Google Cloud Storage?
  16. Sorting by absolute value without changing to absolute value
  17. (discord.py) Getting a list of all of the members in a specific voice channel
  18. Why isn’t .ico file defined when setting window’s icon?
  19. How to capitalize the first letter of every sentence?
  20. Python 3 urllib produces TypeError: POST data should be bytes or an iterable of bytes. It cannot be of type str
  21. Printing result of the zip() function in Python 3 gives “zip object at ” [duplicate]
  22. Meaning of python -m flag
  23. Attempt to call an undefined function glutInit
  24. ImportError: Cannot load backend ‘TkAgg’ which requires the ‘tk’ interactive framework, as ‘headless’ is currently running
  25. Is there a way to get a line number from an ElementTree Element
  26. Python making combined bar and line plot with secondary y-axis
  27. Is there a way to use asyncio.Queue in multiple threads?
  28. How to get value of variable entered from user input?
  29. Add custom form fields that are not part of the model (Django)
  30. Writing to a new file if it doesn’t exist, and appending to a file if it does

Leave a Comment