- Notifications
You must be signed in to change notification settings - Fork0
A Python implementation to parse and query CSV data for risk in event descriptions, for the AEP challenge in HackOHI/O 12.
License
henry7720/AEP-Hack12
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
The Hackathon was a 2-day event, although we made this in probably one day for the purpose of experiential learning. This was my first time making a Python project for a real-world use case, so it was valuable in its own right!
For the AEP challenge, then, our objective was to take in a 20,000-line CSV data source, parse it, then categorize each event listed based on its safety risk by the presence of "high energy" situations, using the power of LLMs. These events had lengthy descriptions and titles, with many being red-herrings. We used Ollama withllama3.2:3b running locally to maintain data privacy. Unfortunately, I can't share the source data CSV at American Electric Power's request for privacy. However, I am happy to share more about the process.
This was run on Python 3.12 (although the version shouldn't matter a great deal), withollama,csv,pandas, andplotly.express libraries installed and imported.
Please seechat.py to see the main processing andllama3.2 prompting script andgraph.py to see my graphing methodology.