def INFO_BOX_TPE_INIT(): row_data = read_excel("sells/data/TPE/info/total_rows_TPE.xlsx") # get the excel info info_boxes = [] for data in row_data: page = get_web_page(DETAIL_URL + data["url"], urlJumpIp) info_boxes += get_info_box(page, data["post_id"]) showProgess(__file__) save(info_boxes, "sells/data/TPE/info/info_box_TPE") print(str(__file__) + " complete")
def HOUSE_BOX_TPE_INIT(): row_data = read_excel("lease/data/TPE/info/total_rows_TPE.xlsx") # get the excel info house_boxes = [] for data in row_data: page = get_web_page(DETAIL_URL + data["url"], urlJumpIp) house_boxes += get_house_box(page, data["post_id"]) showProgess(__file__) save(house_boxes, "lease/data/TPE/info/house_box_TPE") print(str(__file__) + " complete")
def IMG_TPE_INIT(): row_data = read_excel( "sells/data/TPE/info/total_rows_TPE.xlsx") # get the excel info dir = "D:/Python/database/sells/images/TPE/" if os.path.exists(dir): # 先刪除原本的images資料夾 shutil.rmtree(dir, ignore_errors=True) for data in row_data: page = get_web_page(DETAIL_URL + data["url"], urlJumpIp) img_urls = get_images(page) save(img_urls, data["post_id"], dir) showProgess(__file__) print(str(__file__) + " complete")
import googlemaps import sys sys.path.append("lib/") from datetime import datetime from myio import read_excel, save def get_geoLoc(row_data): geo_result = [] for data in row_data: coordinate = gmaps.geocode(data["addr"])[0]["geometry"]["location"] print(data["addr"] + ":", coordinate) geo_result.append({"addr": data["addr"], "coordinate": coordinate}) return geo_result if __name__ == "__main__": gmaps = googlemaps.Client(key="AIzaSyDcixkMKgROY2tE_4VLPTioPtDOwbmzfcI") # data for lease NTC row_data = read_excel("lease/data/NTC/info/total_rows_NTC.xlsx") geo_result = get_geoLoc(row_data) save(geo_result, "lease/data/TPE/geo/coordinate/loc_NTC") # data for sells NTC row_data = read_excel("sells/data/NTC/info/total_rows_NTC.xlsx") geo_result = get_geoLoc(row_data) save(geo_result, "sells/data/TPE/geo/coordinate/loc_NTC")
def parseSave(totDist, totElev, floorVertex, floorNext, floorRouteCoord, floorRouteRot): floorNumber = len(totDist) # len(totDist) gets floor counts # parse and save each floor as a file for dist and next """for i in range(0, floorNumber): fileDist = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/dist/sf" + str(i + 1) + "f_dist" dist = [] # for saving dist to each floor from floor[i] # parsing the dist data for j in range(0, floorNumber): for k in range(0, len(totDist[i][j])): for l in range(0, len(totDist[i][j][k])): dist.append({ "floor": str(j), "start": str(k), "dest": str(l), "dist": totDist[i][j][k][l], "Elevator": totElev[i][j][k][l] }) save(dist, fileDist) # saving using myio function # parsing the next(middle points) data and save for i in range(0, floorNumber): fileNext = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/next/sf" + str(i + 1) + "f_next" middle = [] # for saving middle points between the route only on floor[i] for j in range(0, len(floorNext[i])): for k in range(0, len(floorNext[i][j])): middle.append({ "start": str(j), "dest": str(k), "next": floorNext[i][j][k], "coordinate": floorRouteCoord[i][j][k], "rotation": floorRouteRot[i][j][k] }) save(middle, fileNext) # saving using myio function #store each floor's vertexes for i in range(0, floorNumber): fileName = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/vertex/sf" + str(i + 1) + "f_vertex" vertexes = [] for vertex in floorVertex[i]: vertexes.append({ "ID": vertex.getID(), "_index_": vertex.getIndex(), "inct": vertex.getInct(), "coordinate": vertex.getCoordinate(), "rotation": vertex.getRotation() }) save(vertexes, fileName)""" # store each floor's poster for i in range(0, floorNumber): fileName = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/poster/sf" + str( i + 1) + "f_poster" posters = [] for poster in floorPoster[i]: posters.append({ "ID": poster.getID(), "coordinate": poster.getCoordinate(), "vertex_id": poster.getVertexID(), "rotation": poster.getRotation() }) save(posters, fileName)