search

ucam-department-of-psychiatry / camcops

Cambridge Cognitive and Psychiatric Test Kit (CamCOPS)
Other
12 stars 8 forks source link

Allow columns to be specified for basic spreadsheet dump #228

Open martinburchell opened 2 years ago

martinburchell commented 2 years ago

The post-Covid Clinic would like to be able to specify which columns to include when exporting tasks to a spreadsheet

RudolfCardinal commented 2 years ago

Pointlessly complex? Having too many columns is unlikely to be a significant burden. They can ignore ones they don't care about, the current system means they are guaranteed to get all relevant data, and sensible analytical strategies are not manual. Close and advise them accordingly, or is there some reason why this might be sensible?

martinburchell commented 2 years ago

The original request was:

if I ask for a specific task - say PHQ9 - there is a lot of extraneous info put into the spreadsheet - so much so that I don't think our research nurses will be able to use it (I think I can, but then I know the measures extremely well!). Is there a way to specify so that only the: patient ID, questionnaire totals and individual values are dumped? (ie removing all the columns of camcops version etc etc).

RudolfCardinal commented 2 years ago

OK! Fair enough. But a few are important for good research practice, the CamCOPS version numbers among them. 51 removed, so I take their point ;) Implemented in https://github.com/RudolfCardinal/camcops/pull/229.

RudolfCardinal commented 2 years ago

On further thought: people wanting the simplified version aren't after GCP-type auditability (which remains there if they want) so version numbers out. Also, spreadsheet downloads offer a schema-style sheet (which adapts to being simplified). Also, the maximum version of numpy available for Python 3.7 might be lower than the minimum for the pointless security alerts, but one more try.