-
Notifications
You must be signed in to change notification settings - Fork 7
/
pyScrape_Leafly.py
221 lines (213 loc) · 10.9 KB
/
pyScrape_Leafly.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
##*********************HEADER*********************##
##Developer : Justin Suelflow
##Date : 2/25/2016
##Program Name : pyScrape_Leafly
##Description : Loop through all Leafly dispensary websites to find phone number, business name
## address, city, state, zip code, and url of leafly link
##Python Version: 2.7.11
##Prereqs Knowledge: Python, HTML, CSS, XPath
##Prereqs Hardware: Any computer that has a C++ compiler (libxml2 uses C++)
##Prereqs Software: Python, pip
##Python Libraries: LXML, requests, csv, json, re, os, libxml2, libxslt, datetime
## Unix install python lib command: "sudo pip install"
##Needed Python file: pyTimer.py
## pyTimer.py file is found at https://github.com/Test-BMOHB/Media-Monitoring/blob/master/pyTimer.py
##Log file saved at: /var/www/html/Logs/pylog_Leafly.txt
##CSV file saved at: /var/www/html/mmddyyyy_Leafly_Scrape.csv
##Run command: sudo python pyScrape_Leafly.py
##Static variables: 'setPreloadedResults', 'https://www.leafly.com', 'https:/www.leafly.com/dispensary-info/',
## header row in CSV, mainURL, mainXPath, paraXPath
##-----------------------------------------------------------------------------
## Version | mm/dd/yyyy | User | Changes
## 1 02/25/2016 Justin Suelflow Tested version of production code
## 2 02/25/2016 Justin Suelflow Added comments to code
## 3 03/01/2016 Justin Suelflow Standardized comments
## 4 03/07/2016 Justin Suelflow Datestamp file
## 4.1 03/08/2016 Justin Suelflow Change datestamp from YYYY-MM-DD to MMDDYYYY
## 4.2 03/30/2016 Justin Suelflow Updated CSV writer to take out quotes
## 4.3 03/31/2016 Justin Suelflow Added filename var to send to pyTimer
## 4.4 04/11/2016 Justin Suelflow Changed log file path
##-----------------------------------------------------------------------------
##*********************END HEADER*********************##
##*********************IMPORT*********************##
## Import needed python libraries
## Libraries must be installed using 'pip install'
## pyTimer is not installed using pip, the standalone file needs to be placed in the same location as this code file
from lxml import html
from lxml.etree import tostring
from datetime import datetime
import requests, csv, re, json, pyTimer, os.path
##*********************END IMPORT*********************##
##*********************FUNCTIONS*********************##
## Function : removeDuplicates
## Description : Remove exact duplicate list entries
## Parameters : dedup = list type
## Returns : list
def removeDuplicates(dedup):
finalList = []
for x in dedup:
if x not in finalList:
finalList.append(x)
return finalList
## Function : writeToLog
## Description : Write text to log
## Parameters : text = string type
## Returns :
def writeToLog(text):
## Open a log file and append to the end of the log
## If no log file is in directory, this will automatically create it
logFile = open('/var/www/html/Logs/pylog_Leafly.txt','a')
logFile.write(text)
## Close log file
logFile.close()
## Function : createCSV
## Description : Writes list to a CSV file
## Parameters : liCSV = list type, f1 = file type
## Returns :
def createCSV(liCSV, f1):
writeToLog("Writing to CSV\n")
## Use the ^ as a delimiter because the data on Leafly has lots of other special characters including commas
## Needed to find a special character that was not used by the data
writer = csv.writer(f1, delimiter='^', quoting=csv.QUOTE_NONE, escapechar=' ')
## Add a header row to the CSV
writer.writerow(["Company","PhoneNumber","Address","City","State","ZipCode","Website","Link"])
## Loop through all elements in the list
for i in liCSV:
rowStr = ''
## Some elements are lists so it is needed to loop through each element again
for e in i:
rowStr = rowStr + str(e)
rowStr = rowStr + '^'
## Take the last ^ off of the rowStr to finish the row
rowStr = rowStr[:-1]
## Write the row to the CSV file
writer.writerow([rowStr])
## Function : scrapeInfo
## Description : Scrapes name, phone number, address, city, state, zip code and url from all links on mainURL
## Parameters : mainURL = string type, mainContent = string type, mainXPath = string type, paraXPath = string type
## Returns : list
def scrapeInfo(mainURL, mainContent, mainXPath, paraXPath):
li = []
mainLinksXPath = mainContent.xpath(mainXPath)
## Creates a set of mainLinksXPath which takes out the duplicates and then format the set back to a list
mainLinksXPath = list(set(mainLinksXPath))
## Loop through elements in mainLinksXPath
for mainLinksElements in mainLinksXPath:
## Find all anchor tags in HTML element
link = mainLinksElements.find('a')
## Get the href parameter from the anchor tags
link = link.get('href')
link = 'https://www.leafly.com' + link
## Send a http request to the link
linkRequest = requests.get(link)
## Translate the content from the request to HTML
linkContent = html.fromstring(linkRequest.content)
## Use xpath to find the elements in the HTML
linkXPath = linkContent.xpath(paraXPath)
finList = []
writeToLog("Scraping " + link + "\n")
## Loop through elements in linkXPath
for linkXElement in linkXPath:
text = tostring(linkXElement)
## If the xpath text has 'setPreloadedResults' in the text, proceed
## 'setPreloadedResults' is the distinguishing factor on Leafly to find the needed script tag
if 'setPreloadedResults' in text:
text = text[(text.index('setPreloadedResults') + 21):]
text = text[:(text.index('}]);') + 1)]
strDict = ''
openLi = False
count = 0
## Loop through all characters in the xpath text
## This loop looks through the text to find the opening and closing brackets to create a proper dictionary
for t in text:
if t == '{':
openLi = True
count = count + 1
if openLi:
strDict = strDict + t
if t == '}':
count = count - 1
if count == 0:
openLi = False
## Need to use json.loads because the data is in JSON format; the entries are not all the same length
d = json.loads(strDict)
finList.append(d)
strDict = ''
## Loop through finList to translate elements and add to list
for i in finList:
## Filter will bypass all values that are None
## Join concatenates the values if there are multiple
name = ''.join(filter(None, [i["Name"]]))
address = ' '.join(filter(None, [i["Address1"],i["Address2"]]))
city = ''.join(filter(None, [i["City"]]))
state = ''.join(filter(None, [i["State"]]))
zipcode = ''.join(filter(None, [i["Zip"]]))
url = "https:/www.leafly.com/dispensary-info/" + str(i["UrlName"])
phone = ''.join(filter(None, [i["Phone"]]))
## Replace any letters in a phone number to digits
phone = phone.replace('.','').replace('-','').replace('(','').replace(')','')
phone = phone.replace('A','2').replace('B','2').replace('C','2')
phone = phone.replace('D','3').replace('E','3').replace('F','3')
phone = phone.replace('G','4').replace('H','4').replace('I','4')
phone = phone.replace('J','5').replace('K','5').replace('L','5')
phone = phone.replace('M','6').replace('N','6').replace('O','6')
phone = phone.replace('P','7').replace('Q','7').replace('R','7').replace('S','7')
phone = phone.replace('T','8').replace('U','8').replace('V','8')
phone = phone.replace('W','9').replace('X','9').replace('Y','9').replace('Z','9')
phones = []
## If the phone number is greater than 11 characters long, split the phone number on spaces to find multiple numbers
if len(phone) > 11:
phones = phone.split(' ')
## Loop through the multiple numbers and add to the list if the number is greater than 6 characters long
for p in phones:
if len(p) > 6:
p = p.replace(' ', '')
li.append([name,p,address,city,state,zipcode,url,link])
## If the phone number is 11 characters long or shorter, add to the list
else:
phone = phone.replace(' ', '')
li.append([name,phone,address,city,state,zipcode,url,link])
return li
##*********************MAIN FUNCTION*********************##
## Function : main
## Description : Opens file, http request mainURL and call other functions
## Parameters : mainURLList = list type
## Returns :
def main(mainURL, mainXPath, linkXPath, fileName):
liData = []
writeToLog('***********************************************************************\n')
## Open a file and overwrite the existing file or create a new file if needed
with open(fileName,'w') as scrapeFile:
## Http request the mainURL
mainRequest = requests.get(mainURL)
## Translate the request content to HTML
mainContent = html.fromstring(mainRequest.content)
## Add the information that comes from the scrapeInfo function to a list
## scrapeInfo needs the url, content and 2 xpath variables to call the function
## scrapeInfo returns a list when completed
liData.extend(scrapeInfo(mainURL, mainContent, mainXPath, linkXPath))
## Call function removeDuplicates
beforeDedup = len(liData)
liData = removeDuplicates(liData)
writeToLog(str(len(liData)) + " records of " + str(beforeDedup) + " left after deduplication\n")
## Call createCSV function to write the list data to the scrapeFile
## createCSV needs a list and an open file to run
createCSV(liData, scrapeFile)
##*********************END MAIN FUNCTION*********************##
##*********************END FUNCTIONS*********************##
##*********************PROGRAM*********************##
## If statement makes this program standalone
## Do not need this if statement if another program will be calling above functions
if __name__ == "__main__":
## Create start time
startTime = pyTimer.startTimer()
currDate = datetime.now()
fileDate = currDate.strftime('%m%d%Y')
currDate = currDate.strftime('%Y-%m-%d')
fileName = '/var/www/html/' + fileDate + '_Leafly_MMJScrape.csv'
main('https://www.leafly.com/finder/browse', '//*[@class="col-xs-6 col-md-4 spacer-bottom-xs"]', './/script', fileName)
## Find total time in seconds of program run
pName = os.path.basename(__file__)
endTime = pyTimer.endTimer(startTime, pName)
writeToLog("Program took " + endTime + " to complete.\n")
##*********************END PROGRAM*********************##