Ask HN: Product/Tool suggestion request
A small medical practice has for years (going back to 1988)used written records for their patients. They have a book where they assign a number, add the name and postal address of patient. They then use a card with the assigned number to write the medical stuff (age, symptoms, prognosis, etc). As well, they give the patient a matching (smaller) card for follow up visits.
Patients often misplace their reference cards, and end up being given new files that make no reference to previous files.
To solve this, they had the book records (manually assigned, unique -but with clerical error repetitions and omissions- file numbers; name and P. O. Box addresses) typed into excel, hoping to be able to search in the excel file for multiple repeats by the same patient as well as for when a patient returns without their patient card. There's about 60,000 records in total.
The problem is that excel is not very useful when a search for John Someone yields 22 John Someones from a batch of 60K records. I want to give them a tool that, when they search for John Someone, it brings up all the 22 John Someones, but sorts them,say, in order of date (most recent first), and if the addresses are the same, it can flag records that represent the same patient. That sort of thing.
Can you recommend a tool for this? I've no idea how elastic search works, but reading about it makes me think using it for this would be akin to using a space-ship where a hand-glider (maybe?) might be enough.
5 comments
[ 93.0 ms ] story [ 293 ms ] threadHowever, if you really don't want to use Excel, and you have some programming chops, you could export the Excel spreadsheet into a database (say MySQL). Once the information is in a database, the queries you can run are only limited by your imagination.
In this example, you could filter the data by name, sort the results by the date, and highlight all duplicate addresses using conditional formatting.
If you really don't want to use Excel, you could load the csv in almost any programming language; read in the records, find the duplicates and spit the resulting records back out into whatever format you want.