readabs icon indicating copy to clipboard operation
readabs copied to clipboard

Published 20 hours ago • verified publisher icon MattCowgill

Add lookup tables for catalogue number and series ID

Open MattCowgill opened this issue 3 years ago • 3 comments

MattCowgill avatar Aug 22 '22 00:08 MattCowgill

I am not sure if this is helpful or not, but I have built a lookup table for the 6202.0 release that contains all 2946 unique Series IDs with tidied up metadata. I should also add that I am a fairly inexperienced R user, so the code is probably not as elegant as it could be.

xIncubakerx avatar Sep 27 '22 00:09 xIncubakerx

Hi @xIncubakerx , sure, please share! This should be straightforward to do with readabs, I just haven't got around to it yet...

MattCowgill avatar Sep 27 '22 01:09 MattCowgill

@MattCowgill what is the best way to do this? I'm not really familiar with the workings of github.

It took me quite a while to figure out how to tidy up all of the metadata as the series metadata does not follow a consistent pattern across tables. There are also a whole bunch of Series IDs that are repeated across multiple tables, as well as duplicated data items that are listed under more than one Series ID!

xIncubakerx avatar Sep 27 '22 01:09 xIncubakerx