+- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums)
+-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area)
+--- Forum: Software Support Forum (https://www.apneaboard.com/forums/Forum-Software-Support-Forum)
+--- Thread: Way to convert .csv pulse oximeter data into a format OSCAR can read? (/Thread-Way-to-convert-csv-pulse-oximeter-data-into-a-format-OSCAR-can-read)
Way to convert .csv pulse oximeter data into a format OSCAR can read? - .alchemist. - 02-07-2022
Hi all,
This is my first post on here, very glad that this community exists.
I have mild OSA and started PAP therapy last week. I'm starting to feel better, which is encouraging
.My doctor and I are considering a MAD and/or a potential tonsillectomy + adenoidectomy. I was hoping to build a long-term "dataset" for what my sleep looks like on my APAP vs. MAD vs. potential post-op and recovery. I'm using OSCAR for the APAP (Resmed Airsense 10) and also got a wearable pulse oximeter ring a few weeks ago to try to get pre- and post-PAP therapy data. I see now that it's not compatible with OSCAR, so I ordered one of the ones that is and it should come in soon.
However, the ring I currently have exports heart rate in BPM and blood oxygen saturation in Sp02 in both PDF "report" and .csv "raw data" formats. Is there a way to convert the .csv into a file type that OSCAR can read? I'm happy to move a bunch of things manually in Excel to get the formatting right, it's ultimately going to be ~9-14 days worth of data so I'm fine doing that by hand.
I'm not sure if this is possible at all, but I wanted to check! I'd love to be able to have everything side by side so I can try to use both feel and some consistent metrics to track my progress as I try different things out.
Thank you for your time!
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - kappa - 02-07-2022
What's the exact SpO2 device?
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - 2SleepBetta - 02-08-2022
Been there, done and still do that.
Might an accelerometer masquerade as an oximeter and be put into OSCAR? | Apnea Board
The data structure works well for OSCAR's Somnopose Import.
I've routinely used it and Excel prep sheets to display curves from these data sources:
3-axis accelerometer sleep position and "seismic" effects
Breath by breath tidal volumes
Breath by breath inspiration time
Breath by breath duty cycle
'Think I fiddled with and used a CSV file from a CMS-50Is oximeter once, but there was no need, given other software did the job for OSCAR import.
You will need to apply a "100 X factor" to your SpO2 if data are cast as decimal fractions.
The curves will appear in OSCAR's viewing windows "Inclination" and "Orientation" which I wish could be edited to label graph content directly.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - 2SleepBetta - 02-08-2022
The following link shows the key timing parts of one adaptation of a more complex Excel template for getting data into Somnopose format and zero-time sync. Ignore the blue and green cells and fragments from old data work at lower left
http://www.apneaboard.com/forums/attachment.php?aid=38719
The full sheet, as used, will have my CSV file columns data pasted in Columns A, B, C, D, as needed. If massage of it is needed that work begins in Column E and, ultimately the correctly formatted values get fed to the Orientation and Inclination columns.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - kappa - 02-08-2022
Yes, you could use the somnopose input format but OSCAR won't do any of the regular calculations it does.
For all we know the device could be a Wellue/Viatom/rebranded O2Ring for which OSCAR supports import of the raw datafiles, but not exported pdf or csv from the associated software. If it's a different device which is readily available and used we can look at adding support in to OSCAR.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - .alchemist. - 02-08-2022
(02-07-2022, 10:18 PM)kappa Wrote: What's the exact SpO2 device?Sorry, it's a Wellue 02 Ring!
(02-08-2022, 07:34 AM)kappa Wrote: Yes, you could use the somnopose input format but OSCAR won't do any of the regular calculations it does.I didn't realize that it was a rebranded ring that possibly could have support already. Do you happen to know if the Wellue 02Ring™ Continuous Oxygen Monitor is one of them?
For all we know the device could be a Wellue/Viatom/rebranded O2Ring for which OSCAR supports import of the raw datafiles, but not exported pdf or csv from the associated software. If it's a different device which is readily available and used we can look at adding support in to OSCAR.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - Crimson Nape - 02-08-2022
(02-08-2022, 12:47 AM)2SleepBetta Wrote: The curves will appear in OSCAR's viewing windows "Inclination" and "Orientation" which I wish could be edited to label graph content directly.
I think this is the second time you mentioned this. Doesn't changing the Name and Label fields in Preferences > Waveforms to reflect the new names not work? Other than the Daily graph title for these parameters that requires a OSCAR reboot to take effect, the Daily statistic label and the Overview label will change. One note I discovered the hard way, the names in the name field are listed in alphabetical order. This column will re-sort after changing the channel's name. You will need to make sure you are editing the correct label parameter after changing the name, because it may change its listing order.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - .alchemist. - 02-08-2022
(02-08-2022, 12:47 AM)2SleepBetta Wrote: Been there, done and still do that.
(Link removed due to new user restriction)
The data structure works well for OSCAR's Somnopose Import.
I've routinely used it and Excel prep sheets to display curves from these data sources:
3-axis accelerometer sleep position and "seismic" effects
Breath by breath tidal volumes
Breath by breath inspiration time
Breath by breath duty cycle
'Think I fiddled with and used a CSV file from a CMS-50Is oximeter once, but there was no need, given other software did the job for OSCAR import.
You will need to apply a "100 X factor" to your SpO2 if data are cast as decimal fractions.
The curves will appear in OSCAR's viewing windows "Inclination" and "Orientation" which I wish could be edited to label graph content directly.
(02-08-2022, 01:08 AM)2SleepBetta Wrote: The following link shows the key timing parts of one adaptation of a more complex Excel template for getting data into Somnopose format and zero-time sync. Ignore the blue and green cells and fragments from old data work at lower left
(Link removed due to new user restriction)
The full sheet, as used, will have my CSV file columns data pasted in Columns A, B, C, D, as needed. If massage of it is needed that work begins in Column E and, ultimately the correctly formatted values get fed to the Orientation and Inclination columns.
Awesome, I'm really glad that this is possible if the Wellue ring is indeed not supported. Thanks so much for sharing your process and some of the nuts and bolts on this!
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - Crimson Nape - 02-08-2022
The Wellue is fully supported. Read this Wiki on importing its data into OSCAR. Link to: Wiki - Viatom File Import
Viatom and Wellue are the same product, just a different name depending on where they are marketed in the world.
RE: Way to convert .csv pulse oximeter data into a format OSCAR can read? - .alchemist. - 02-08-2022
(02-08-2022, 09:11 AM)Crimson Nape Wrote: The Wellue is fully supported. Read this Wiki on importing its data into OSCAR. Link to: (Link removed due to new user restriction)
Viatom and Wellue are the same product, just a different name depending on where they are marketed in the world.
That's great news, thank you very much!