client = Client(auth)
print "Start"
columns = ['phone','name', 'review_count', 'categories','rating']
new = []
j = 0
for i in df['SearchPhone'][:5000]:
print i, j, j/5000.0
try:
response = client.phone_search("'" + str(i) + "'")
new.append([response.businesses[0].phone
,response.businesses[0].name
,response.businesses[0].review_count
,response.businesses[0].categories
,response.businesses[0].rating])
except IndexError:
new.append([str(i),"","","",""])
else:
new.append([str(i),"","","",""])
j += 1
df2 = pd.DataFrame(new)
df2.to_csv("Yelp5000.csv", index=False, header=False)
auth = Oauth1Authenticator(consumer_key='XXXXXXXXXXXXXXXXXXXXXX',
consumer_secret='XXXXXXXXXXXXXXXXXXXXXXXXXXX',
token='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
token_secret='XXXXXXXXXXXXXXXXXXXXXXXXXXX')
client = Client(auth)
phones = []
phone_file = sys.argv[1]
with open(phone_file, 'r') as fh:
for line in fh:
line = line.rstrip()
if len(line) == 12:
phones.append(line)
responses = []
for i, phone in enumerate(phones):
try:
#print i+1
response = client.phone_search(phone)
if len(response.businesses) > 0:
biz = response.businesses[0]
catg = biz.categories[0].alias if biz.categories else ''
print('%s\t%s\t%s\t%s\t%s\t%s' %
(biz.name, biz.id, catg, biz.rating, biz.review_count,
biz.phone))
except:
pass
'sort':2
}
a=client.search('341+West+Tudor+Road+Anchorage+AK+99503', **params)
a.businesses
for item in a.businesses:
print item.name, item.rating, item.review_count
b = client.get_business('', **params)
"city": "Anchorage", "zip": "99503", "phone": "9077706652", "state": "AK", "address_2": "Suite 101", "address": "341 West Tudor Road"
b = client.get_business('Makar', **params)
a.businesses
for item in a.businesses:
print item.name, item.rating, item.review_count
params = {
'category': 'health'
}
c = client.phone_search('+19077706652', **params)
c.businesses
for item in c.businesses:
print item
for item in c.businesses:
print item.name, item.rating, item.review_count
