mimic iii :difference between sofa and pivoted_sofa
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
hi, thanks for your works! a difference was found in our works
the materialized view of sofa : The score is calculated on the first day of each ICU patients' stay.
the materialized view of pivoted_sofa : The score is calculated for every hour of the patient's ICU stay
So, dose the 'sofa_24hours' mean the first day's sofa score of icustay when hr=24 in pivoted_sofa ?
But we found that many results are different between two views when hr=24 in pivoted_sofa.
if i want to find the first day's sofa ,which should i use?
thank you very much!
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by comparing the materialized views named sofa and pivoted_sofa, focusing on sofa_24hours and the hr=24 row. Confirm which view represents the first ICU day and document the result, including the reason for any differing scores.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100