The app is basically analyzing two separate files to check over each other and generate a text document probe check report. The purpose of developing this app is to target which fixed route buses are not probed and which dates are their last time probing.
This project is used by the following file formats:
- probing summary csv file, which is downloaded from GenFare
- daily operation log folder, which is provided by LeeTran Operdation Department
To deploy this project run, the following modules are needed to be imported as belows.
import pandas as pd
import os
import math
import datetime
from datetime import datetime
from contextlib import redirect_stdout
import tkinter as tk
import tkinter.font as font
from tkinter import filedialog
from PIL import Image, ImageTk
To convert .py into .exe, copy the following command onto your Anaconda Prompt
auto-py-to-exe
- (1) only pick up 3-digit Bus number
- (2) remove text in stand-by list
- (3) remove '/' and ' / " from stand_by_list
- (4) remove nvarchar text from daily line up tab
File Name | Type | Description |
---|---|---|
ProbeCheck V4 |
.py |
Required. It is the main file, updated to 4th version |
All uploaded .xlsm files are used for testing.
File Name | Type | Description |
---|---|---|
test for opt logs hurr ian |
.py |
Test file |
M.S. in Civil Engineering, specializing in Transportation Engineering and M.S. in Information System & Analytics -- “Graduating with Pride, Striving to Make SNU Proud”
Python, R, SQL, ArcGIS, Javascript, HTML, CSS, Nlogit, Synchro, Vissim, AutoCAD, Stata