droid icon indicating copy to clipboard operation
droid copied to clipboard

Published 20 hours ago • verified publisher icon digital-preservation

Change to the CSV export

Open CaptainBrad opened this issue 2 years ago • 4 comments

Currently, if you ask for 'one row per file', any additional identified formats are added as extra columns - but they are not given a column header. Can this be included, e.g. PUID2 etc. The missing header makes the csv difficult to use in Excel and also for scripting where you have to work around the missing headers (e.g. Python pandas read_csv). I'm using 6.5.2.

CaptainBrad avatar Jan 06 '23 10:01 CaptainBrad

@CaptainBrad this looks like it's connected to: https://github.com/digital-preservation/droid/issues/118 there's some additional discussion there.

ross-spencer avatar Jan 06 '23 14:01 ross-spencer

Thanks for the heads up @ross-spencer , we will look into 118.

CaptainBrad avatar Jan 09 '23 17:01 CaptainBrad

I understand the problem now and I have investigated and started making changes to add the missing header values. The number of columns will vary from one CSV file to another, but each file will be valid within itself. The number of values in each row will match the number of values in the header row.

paulwellsagilej avatar Jan 20 '23 17:01 paulwellsagilej

Existing tests pass now. Working on new tests to check new behaviour.

paulwellsagilej avatar Jan 25 '23 13:01 paulwellsagilej