Open MattCowgill opened 2 years ago
Hi @xIncubakerx , sure, please share! This should be straightforward to do with readabs
, I just haven't got around to it yet...
@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!
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.