Python print regex in json string

Question

So, I'm using a small python script to try to simply print out every occurrence of a website 'northwest.hall.' where the wildcard() is a number, in a very large json string pulled from a url.

I have this so far: import urllib, json, re

url = 'http://graphite.website.com/render/?target=stats.web.northwest.hall.*&format=json'
response = urllib.urlopen(url)
data = json.loads(response.read())
code = re.findall('northwest', data)
print code

This should return a list of the 30 regexpressions of northwest.hall.number in the json string being parsed, but I get the following error instead:

Traceback (most recent call last):
  File "/Users/arin/Desktop/scripts/code_parser2.py", line 7, in <module>
    code = re.findall('community', data)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/re.py", line 177, in findall
    return _compile(pattern, flags).findall(string)
TypeError: expected string or buffer

New to Python (sure you can tell). Thanks in advance.

Have you verified that the data you are pulling down looks like what you think it does before applying the regex? — merlin2011
– merlin2011, Commented Jun 19, 2014 at 23:08
When I try your URL, I get 404 - File or directory not found. — merlin2011
– merlin2011, Commented Jun 19, 2014 at 23:11
I get 404 too so I use httpbin.org/headers to get some json from server httpbin.org — furas
– furas, Commented Jun 19, 2014 at 23:15

furas · Accepted Answer · 2014-06-19 23:36:36Z

1

Use

data = response.read()

to get json string from server.

Using

data = json.loads(response.read())

you change this string into python dictionary.

EDIT:

import re

data = """
stats.web.northwest.hall.01
stats.web.northwest.hall.223
stats.web.northwest.hall.31
stats.web.northwest.hall.4
"""

print re.findall(r'stats.web.northwest.hall.(\d+)', data)

['01', '223', '31', '4']

edited Jun 19, 2014 at 23:36

answered Jun 19, 2014 at 23:14

furas

149k12 gold badges121 silver badges171 bronze badges

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

4 Comments

a ekandem Over a year ago

Awesome furas, always humbling hearing from a pro. I get back 30 instances of 'northwest'. How do I get just the numbers following the string stats.web.northwest.hall. ? Thanks again!

furas Over a year ago

Do you mean something like example in my answer ?

a ekandem Over a year ago

Perfect! If you're ever in San Francisco, I want to buy you a beer. In fact, many.

furas Over a year ago

San Francisco is too far for me :( I'm from Poland in Europe ;)

Collectives™ on Stack Overflow

Python print regex in json string

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related