Please enable JavaScript.
Coggle requires JavaScript to display documents.
Copilot prompts - Coggle Diagram
Copilot prompts
to do
add in blank issns
ask to remove to work on later
create method for separating into sections
may be more sensible to identify problems with each unique section first and cross check batches against the original spreadsheet
rows 1 - 499
5 need to remove vol.s and no.s
1 - need to transfer supplements to separate sheet
used last issue date column data as separator ...
3 need to copy all titles in parentheses to new row alongside new issn
need to remove all ISSNs in round brackets as well
questions
do we need to copy across the dates/item data
easier to delete than manually enter again
2 need to transfer all titles with blank issn to new sheet
need to standardise dates
4 remove ,month and hyphen
can't separate into sections based on row no. as may lead to supplements being left behind
find a column where the main title has data entered but associated supplements do not
step by step process
remove blank issns into separate sheet
check original spreadsheet against openrefine
separating supplements and issns from main titles
problems
supplements recorded with title as supplied on title page leading to absence of suitable words/phrases to match with
title-based rules shouldn't work for all rows
can't always use issns to match supplements with main titles as sometimes the issn is different
also as with AIDs the issn will also change with the main title
session 2
see aids supplements
copilot already attempted to strip out supplements from main titles so there was actually no supplementary data to copy across to the remaining rows sheet
worked fine for example for 0002-9343 american journal of medicine though
can't be fixed
non-standardised dates (can't tell decade)