HY3 Result File Parser

[jgol...@vols.utk.edu]

Hi all,

I found this forum a few years back when I was in school and managing Tennessee Swimming and Diving. Fast forward a few years and I’m a Data Scientist specializing in machine learning and have gotten quite a bit better at coding! I picked this back up as a pet project (I still help out with the team some- Go Vols!) and published it to GitHub and created a bare-bones web-app. 

It definitely needs a few tweaks and some clean up, but ultimately it’s a package for extracting meet results from .hy3 files. I tried to make it as generic as possible (i.e., the underlying classes could be used to represent any type of meet results, regardless of source).

I also want to say thank you to Troy DeLano, who shared the .hy3 file format, and Eddie Rowe, who provided an extraction script a few years back. 

Right now, there are a few ways to use hyparse:

Web App

I deployed a very simple web app that enables users to upload a hy3 (no zip!) file and the service processes the results and provides a .zip file containing individual results file and relay results file. This is hosted on a free service, so it might be slow/take some time to spin up depending on if it's asleep or not. 

On Your Own

The hyparse package is available on GitHub and can be installed through pip by running `pip install git+https://github.com/jgolliher/hyparse.git@main`. I built it in Python 3.12, but the only requirement is Pandas > 2.2. 

Up Next

I built this because obtaining swim meet results in a "useful" format is near impossible. I'm working on a NCAA swimming analysis project and I cannot find data for the NCAA championships that I need: psych times, prelim times, and final times in one place. SwimCloud is close, but they don't provide an API and do not keep psych times. This (hopefully) solves some of that. 

For what's next: 

• The code definitely needs to be reworked some, and I know I'm missing some fields. I have a copy of Meet Manager, so I'll try to fill in the gaps with random test meets. 
• I help run swim meets at UT and oftentimes find record management to be a nightmare. I may dig into that as well.
• Event entries are not on my radar, but I'm happy to be convinced otherwise :)

Would love to hear thoughts (and definitely some bugs I'm sure I missed!)