Ambulance Billing Invoice Report Tool
Project Title: Ambulance Billing Invoice Report Tool
Technology Used: Python, pandas, CSV Processing, Data Cleaning, Data
Merging
Industry Partner: Viewpoint Ambulance
Overview
This system automates the billing report generation process by integrating data from Viewpoint Ambulance's CAD system (Traumasoft) and Call the Car (CTC) records. Originally, manual compilation delayed monthly billing and payment processes. Now, the tool quickly extracts, cleans, and merges essential trip details, ensuring accurate and timely invoicing.
Features
- Combines CSV files from both Traumasoft and Call the Car systems.
- Removes extraneous or trailing rows with missing data for cleaner reports.
- Extracts key details such as wait times and oxygen requirements from comments.
- Standardizes patient names and normalizes address formats for consistency.
- Merges data on common fields like patient name, service date, and pick-up address.
- Generates a consolidated CSV report ready for billing and further analysis.
Code Overview
The project is organized into two main modules: data_processing.py and
main.py.
data_processing.py handles CSV file combination, data cleaning, normalization of
addresses, and extraction
of specific details, while main.py orchestrates data loading, merging, and report
generation.
This structure leverages Python's pandas library to efficiently manipulate and transform data.
Screenshots
Due to HIPAA restrictions, screenshots cannot be displayed.
Interested in More?
Source Code: Ambulance Billing Invoice Report Tool