This is Python based tool with Tkinter UI for collecting transportation occupancy data. The tool works with input from touch, input device, or using the keyboard shortcuts. Log files record all actions taken by users, and the summary script exports a csv file of the results.
Running the tool requires Python 3+ and the Pandas library. If there are any other missing libraries they can be installed using the python package manager with the following command.
pip install [package]
The configuration.json file contains the configuration parameters for the script. The table below describes the JSON name used in the script. If you want to modify a parameter such as changing the single occupant passenger car one_passenger_car to a update the file as follows.
{
"keyboard_shortcuts": {
"one_passenger_car": "a",
"two_passenger_car": "2",
...
You can also make changes to the way data is stored. For example, you could change the single occupant passenger car storage value from the default of P1 to Passenger1.
...
"data_parameters": {
"one_passenger_car": "Passenger1",
"two_passenger_car": "P2",
"three_passenger_car": "P3",
...
| JSON name | Shortcut |
|---|---|
| one_passenger_car | Single occupant passenger car |
| two_passenger_car | Two occupant passenger car |
| three_passenger_car | Three occupant passenger car |
| four_passenger_car | Four occupant passenger car |
| motorcycle | Motorcycle |
| two_axle_truck | Two axle truck |
| three_axle_truck | Three axle truck |
| van | Passenger or work van |
| transit | Transit vehicle with government agency branding |
| transit_other | Non-governmental transit vehicle |
| undo | Undo last action |
To run the script enter the following in the command prompt
python occupancy_count.py
In the command prompt you will be required to enter a few fields to record who collected the data and where.
If you enter an invalid field you will get an error
If you want to make changes which fields are validated and how information is checked make updates to the validate_user_input_metadata function.
Start the collection process. You may enter data using an input device such as touch, keyboard, or using the shortcuts listed below each data field.
You can also monitor the system using the command window. It displays all actions taken by the operator.
When you are down simply close out the collection window.
To extract data to a csv all_data_extracted.csv file, run the other script that comes with this module. This file reads all logs in the collection directory, extracts the relevant information, and outputs the results to a csv file.
python extract_log_data.py
You can create a summary spreadsheet, summary_results.xlsx, if you utilize the summarize_log_data.py script. This summary closely matches what was done in previous years. The output creates a workbook with two worksheets, one for a data summary, and the other for an AM/PM summary for each type of vehicle.
python summarize_log_data.py