Datatable: Variable code and description

Variable inspection

get parameter units

[1] "parameter_cd"       "parameter_group_nm" "parameter_nm"       "casrn"             
[5] "srsname"            "parameter_units"   
# readr
# library(readr)
my_files <- dir("Data/spreadsheets-in-csv-format", full.names = TRUE)
all_csv.l <- purrr::map(my_files,readr::read_csv) # why is it so much bigger?
# read in basin id
# str(all_csv.l, max.level = 1)
# all_csv.l[[1]]

basinid <- all_csv.l[[3]]
basinid <- basinid %>% filter(!is.na(LAT_GAGE)) %>% # remove the na
  mutate(gage_id = as.factor(STAID)) %>% 
  datatable(filter = 'top')
# datatable(head(basinid))

```

LS0tDQp0aXRsZTogIkdhZ2VzIElJIHZhcmlhYmxlIHJlZmVyZW5jZSINCm91dHB1dDogaHRtbF9ub3RlYm9vaw0KLS0tDQoNCiMjIyBEYXRhdGFibGU6IFZhcmlhYmxlIGNvZGUgYW5kIGRlc2NyaXB0aW9uDQoNCmBgYHtyIFNldE9wdGlvbnMsIHdhcm5pbmc9RkFMU0UsZWNobz1GQUxTRX0NCiMgTG9hZCBrbml0ciBhbmQgc2V0IGtuaXR0aW5nIG9wdGlvbnMgZm9yIGRvY3VtZW50LiBUaGUgY29udGVudCBpbiB0aGlzIGNodW5rIGlzIG5vdCBuZWVkZWQgdG8gcnVuLiBGb3IgZXhhbXBsZSwgeW91IGNhbiBjb250cm9sIHRoZSBiZWhhdmlvciBvZiBFQUNIIGNodW5rIHRocm91Z2ggaXRzIG93biAiY2h1bmsgb3B0aW9ucyIgc2V0dGluZ3MuIFdoYXQgSSBkbyBoZXJlIGlzIHByb3ZpZGUgYSBzZXQgb2YgR0xPQkFMIG9wdGlvbnMgdGhhdCBhcHBseSB0byBldmVyeSBjaHVuayBpbiB0aGUgZG9jdW1lbnQuIEluIHRoaXMgY2FzZSwgSSdtIHNldHRpbmcgZmlndXJlIHdpZHRoIGFuZCBoZWlnaHQgYW5kIGNob29zaW5nIHdoZXRoZXIgb3Igbm90IHRvIHByaW50IHRoZSBzb3VyY2UgY29kZSBhbG9uZyB3aXRoIHRoZSBvdXRwdXQgaW4gbXkgcmVuZGVyZWQgcmVwb3J0LiBUaGlzIGFsc28gaXMgYW4gZXhhbXBsZSBvZiBob3cgeW91IGNhbiB1c2UgY29tbWVudHMgaW4gY2h1bmtzIHRvIGFsbG93IHlvdSB0byBxdWlja2x5IHN3aXRjaCBiZXR3ZWVuIG9wdGlvbnMuIFRvIHN3aXRjaCBiZXR3ZWVuIHRoZSB0d28gb3B0aW9ucyBiZWxvdywgc2ltcGx5IHVuY29tbWVudCAocmVtb3ZlIHRoZSAiIyIgY2hhcmFjdGVyIGF0IHRoZSBzdGFydCBvZiBlYWNoIGxpbmUpIHRoZSBzZWxlY3Rpb24geW91IHdhbnQgdG8gcnVuIGFuZCBjb21tZW50IG91dCB0aGUgc2VjdGlvbiB5b3UgZG9uJ3Qgd2FudCBydW4uDQojIFRJUDogdXNlIHRoZSBoYW5keSBrZXlib2FyZCBzaG9ydGN1dCBDdHJsK1NoaWZ0K0MgdG8gcXVpY2tseSBjb21tZW50L3VuY29tbWVudCBsaW5lcyBvciBzZWN0aW9ucyBvZiBjb2RlLiANCg0KbGlicmFyeShrbml0cikgIw0KDQojICMjIyBPcHRpb24gIzE6IERpc3BsYXkgY29kZSBpbiB0aGUgZmluYWwgb3V0cHV0ICh0aGlzIGlzIHRoZSBkZWZhdWx0KSANCiMgIyBTZXQgY2h1bmsgb3B0aW9ucyBnbG9iYWx5DQojIG9wdHNfY2h1bmskc2V0KHdhcm5pbmcgPSBGQUxTRSwgZWNobyA9IFRSVUUsIGZpZy53aWR0aD02LCBmaWcuaGVpZ2h0PTYpDQojICMjIw0KDQojIyMgT3B0aW9uICMyOiBTdXBwcmVzcyBwcmludGluZyBvZiBjb2RlIGluIHRoZSBmaW5hbCBvdXRwdXQgDQojIFNldCBjaHVuayBvcHRpb25zIGdsb2JhbHkNCm9wdHNfY2h1bmskc2V0KG1lc3NhZ2UgPSBGQUxTRSwgd2FybmluZyA9IEZBTFNFLCBlY2hvID0gRkFMU0UsIGZpZy53aWR0aD03LCBmaWcuaGVpZ2h0PTYpDQojIyMNCg0KDQpgYGANCg0KDQoNCmBgYHtyIFBrZywgd2FybmluZz1GQUxTRSxlY2hvPUZBTFNFLG1lc3NhZ2U9RkFMU0V9DQpsaWJyYXJ5KERUKQ0KIyBsaWJyYXJ5KHBseXIpDQpsaWJyYXJ5KHRpZHl2ZXJzZSkNCiMgbGlicmFyeShkcGx5cikNCiMgbGlicmFyeShnZ3Bsb3QyKQ0KbGlicmFyeShodG1sdG9vbHMpDQoNCmxpYnJhcnkoY2FycGVudGVyKQ0KIyBsaWJyYXJ5KG1ldHJpY3NncmFwaGljcykNCiMgbGlicmFyeShSQ29sb3JCcmV3ZXIpDQojIFIgQ2hhcnRzIC0tIGxvb2tzIHNoaXpuZWxseS4gaHR0cHM6Ly9naXRodWIuY29tL3JhbW5hdGh2L3JDaGFydHMNCiMgcmVxdWlyZShkZXZ0b29scykNCiMgaW5zdGFsbF9naXRodWIoJ3JhbW5hdGh2L3JDaGFydHMnKQ0KIyBsaWJyYXJ5KHJDaGFydHMpDQojIGxpYnJhcnkoc2NhbGVzKQ0KIyBpbnN0YWxsLnBhY2thZ2VzKCJodG1sd2lkZ2V0cyIpDQpsaWJyYXJ5KGh0bWx3aWRnZXRzKQ0KIyBpbnN0YWxsLnBhY2thZ2VzKCJsZWFmbGV0IikNCiMgbGlicmFyeShsZWFmbGV0KQ0KIyBkMyBoZWF0bWFwcyENCiMjIFVuY29tbWVudCBvbiBmaXJzdCBpbnN0YWxsDQojIGlmICghcmVxdWlyZShkZXZ0b29scykpIGluc3RhbGwucGFja2FnZXMoImRldnRvb2xzIikNCiMgZGV2dG9vbHM6Omluc3RhbGxfZ2l0aHViKCdoYWRsZXkvc2NhbGVzJykNCiMgZGV2dG9vbHM6Omluc3RhbGxfZ2l0aHViKCJyc3R1ZGlvL2QzaGVhdG1hcCIpDQojIGxpYnJhcnkoZDNoZWF0bWFwKQ0KIyBsaWJyYXJ5KHRyZWxsaXNjb3BlKQ0KIyBsaWJyYXJ5KGNvcnJyKQ0KIyBsaWJyYXJ5KGdnc3RhbmNlKQ0KDQpgYGANCg0KDQoNCiMjIyBWYXJpYWJsZSBpbnNwZWN0aW9uDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFfQ0KDQojIyB2YXJpYWJsZSBpbnNwZWN0aW9uDQp2YXIuZGVzYyA8LSByZWFkX2NzdihmaWxlID0gIk1ldGEvdmFyaWFibGVfZGVzY3JpcHRpb25zLnR4dCIpDQoNCnZhci5kZXNjICU+JSANCiAgIyBuYW1lcygpDQogIGRwbHlyOjpzZWxlY3QoVkFSSUFCTEVfVFlQRSwgVkFSSUFCTEVfTkFNRSwgREVTQ1JJUFRJT04sIGNvbnRhaW5zKCJVbml0IikpICU+JSANCiAgIyBmaWx0ZXIoVkFSSUFCTEVfVFlQRSwgVkFSSUFCTEVfTkFNRSwgREVTQ1JJUFRJT04pICU+JSANCiAgZGF0YXRhYmxlKGZpbHRlciA9ICJ0b3AiLGNhcHRpb24gPSAiR0FHRVMtSUkgYmFzaW4gdmFyaWFibGVzIikNCg0KDQojIHZhci5kZXNjICU+JSANCiMgICBkcGx5cjo6c2VsZWN0KFZBUklBQkxFX1RZUEUsIFZBUklBQkxFX05BTUUsIERFU0NSSVBUSU9OLCBjb250YWlucygiVW5pdCIpKSAlPiUgDQojICAgd3JpdGVfY3N2KCJWYXJpYWJsZUxpc3Q0ZXZhbC5jc3YiKQ0KDQojIGtuaXRyOjprYWJsZSh2YXIuZGVzYykNCg0KYGBgDQoNCg0KDQojIyBnZXQgcGFyYW1ldGVyIHVuaXRzDQpgYGB7cn0NCg0KcGFyYW1ldGVyQ2RGaWxlIDwtIGRhdGFSZXRyaWV2YWw6OnBhcmFtZXRlckNkRmlsZSANCg0KcGFyYW1ldGVyQ2RGaWxlICU+JSANCiAgbmFtZXMoKQ0KDQpmayA8LSBwYXJhbWV0ZXJDZEZpbGVbZ3JlcCgiMDAwNiIsDQogICAgICAgICAgICAgICAgICAgICBwYXJhbWV0ZXJDZEZpbGUkcGFyYW1ldGVyX2NkLA0KICAgICAgICAgICAgICAgICAgICAgaWdub3JlLmNhc2UgPSBUUlVFKSxdIA0KICANCmRhdGF0YWJsZShmaywgZmlsdGVyID0gInRvcCIpDQpgYGANCg0KDQpgYGB7ciBCYXNpbklETWFwLCBlY2hvPVRSVUUsIG1lc3NhZ2U9RkFMU0UsIGV2YWw9RkFMU0V9DQoNCiMgcmVhZHINCiMgbGlicmFyeShyZWFkcikNCm15X2ZpbGVzIDwtIGRpcigiRGF0YS9zcHJlYWRzaGVldHMtaW4tY3N2LWZvcm1hdCIsIGZ1bGwubmFtZXMgPSBUUlVFKQ0KYWxsX2Nzdi5sIDwtIHB1cnJyOjptYXAobXlfZmlsZXMscmVhZHI6OnJlYWRfY3N2KSAjIHdoeSBpcyBpdCBzbyBtdWNoIGJpZ2dlcj8NCiMgcmVhZCBpbiBiYXNpbiBpZA0KIyBzdHIoYWxsX2Nzdi5sLCBtYXgubGV2ZWwgPSAxKQ0KIyBhbGxfY3N2LmxbWzFdXQ0KDQpiYXNpbmlkIDwtIGFsbF9jc3YubFtbM11dDQpiYXNpbmlkIDwtIGJhc2luaWQgJT4lIGZpbHRlcighaXMubmEoTEFUX0dBR0UpKSAlPiUgIyByZW1vdmUgdGhlIG5hDQogIG11dGF0ZShnYWdlX2lkID0gYXMuZmFjdG9yKFNUQUlEKSkgJT4lIA0KICBkYXRhdGFibGUoZmlsdGVyID0gJ3RvcCcpDQojIGRhdGF0YWJsZShoZWFkKGJhc2luaWQpKQ0KDQoNCg0KYGBgDQoNCg0KYGBge3IgQmFzaW5JRExlYWZsZXQsIGVjaG89RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGV2YWw9RkFMU0V9DQoNCiMgYWxsIHJlY29yZHMNCiMgbGVhZmxldChkYXRhID0gZGF0KSAlPiUgYWRkVGlsZXMoKSAlPiUNCiMgICBhZGRNYXJrZXJzKH5MTkdfR0FHRSwgfkxBVF9HQUdFLCBwb3B1cCA9IH4oU1RBTkFNRSkpDQoNCiMgTGVhZmxldCBtYXAgb2YgQ08gcmVjb3Jkcw0KDQpiYXNpbmlkICU+JSBmaWx0ZXIoU1RBVEUgPT0gIkNPIikgJT4lIA0KICBsZWFmbGV0KCkgJT4lIGFkZFRpbGVzKCkgJT4lDQogIGFkZE1hcmtlcnMofkxOR19HQUdFLCB+TEFUX0dBR0UsIHBvcHVwID0gfihTVEFOQU1FKSkNCg0KDQojIFNob3cgZmlyc3QgMjAgcm93cyBmcm9tIHRoZSBgcXVha2VzYCBkYXRhc2V0DQpsZWFmbGV0KGRhdGEgPSBxdWFrZXNbMToyMCxdKSAlPiUgYWRkVGlsZXMoKSAlPiUNCiAgYWRkTWFya2Vycyh+bG9uZywgfmxhdCwgcG9wdXAgPSB+YXMuY2hhcmFjdGVyKG1hZykpDQoNCiMgU2hvdyBmaXJzdCAyMCByb3dzIGZyb20gdGhlIGBxdWFrZXNgIGRhdGFzZXQNCmxlYWZsZXQoZGF0YSA9IHF1YWtlc1sxOjIwLF0pICU+JSBhZGRUaWxlcygpICU+JQ0KICBhZGRNYXJrZXJzKH5sb25nLCB+bGF0LCBwb3B1cCA9IH5hcy5jaGFyYWN0ZXIobWFnKSkNCg0KYGBgDQoNCmBgYHtyIFNoYXBlZmlsZUltcG9ydCwgZXZhbD1GQUxTRX0NCmxpYnJhcnkocmdkYWwpICAjIHJlYWRzIGluIHNoYXBlIGZpbGVzDQpyZWFkT0dSDQoNCnNmIDwtIHJlYWRPR1IoZHNuID0gJ0RhdGEvc3BhdGlhbC9wb2ludHMnLCBsYXllciA9ICdnYWdlc0lJXzkzMjJfc2VwdDMwXzIwMTEnKQ0KIyBwbG90KHNmKQ0KDQojIHNoYXBlZmlsZS5jb252ZXJ0ZWQgPC0gc3BUcmFuc2Zvcm0oc2hhcGVmaWxlLCBDUlMoIitwcm9qPWxvbmdsYXQgK2RhdHVtPVdHUzg0IikpDQoNCnNoYXBlZmlsZS5jb252ZXJ0ZWQgPC0gc3BUcmFuc2Zvcm0oc2YsIENSUygiK3Byb2o9bG9uZ2xhdCArZGF0dW09V0dTODQiKSkNCg0KbGlicmFyeShybGVhZm1hcCkNCmxpYnJhcnkobGVhZmxldFIpDQpsaWJyYXJ5KGxlYWZsZXQpDQoNCg0KYmFzaW5pZCAlPiUgZHBseXI6OmZpbHRlcihTVEFURSA9PSAiQ08iKSAlPiUgDQogIGxlYWZsZXQoKSAlPiUgYWRkVGlsZXMoKSAlPiUNCiAgYWRkTWFya2Vycyh+TE5HX0dBR0UsIH5MQVRfR0FHRSwgcG9wdXAgPSB+KFNUQU5BTUUpKQ0KIw0KDQpgYGANCg0KDQpgYGB7ciBSTGVhZk1BcF9CYXNpbklELCBldmFsPSBGQUxTRX0NCg0KbGlicmFyeShybGVhZm1hcCkNCmRhdGEodmVsb3YpDQoNCnN0YW1lbi5ibSA8LSBiYXNlbWFwKCJzdGFtZW4udG9uZXIiKQ0KbWFwcXVlc3QuYm0gPC0gYmFzZW1hcCgibWFwcXVlc3QubWFwIikNCg0KdmVsb3Yuc3RhIDwtIHNwTGF5ZXIodmVsb3YsIHN0cm9rZSA9IEYsIHBvcHVwID0gdmVsb3Ykc3RhdGlvbnMubmFtZSkNCg0Kd3JpdGVNYXAoc3RhbWVuLmJtLCB2ZWxvdi5zdGEsIHdpZHRoID0gNTUwLCBoZWlnaHQgPSAyNTAsDQogICAgICAgICBzZXRWaWV3ID0gYyg0NS43NiwgNC44NSksIHNldFpvb20gPSAxMikgICAgICAgIA0KIyBOb3cgd2l0aCB0aGUgbWFwIHF1ZXN0IGJhc2VtYXANCiMgd3JpdGVNYXAobWFwcXVlc3QuYm0sIHZlbG92LnN0YSwgd2lkdGggPSA1NTAsIGhlaWdodCA9IDI1MCwNCiMgICAgICAgICAgc2V0VmlldyA9IGMoNDUuNzYsIDQuODUpLCBzZXRab29tID0gMTIpICAgICAgICANCiAgCQkJCQ0KDQpgYGANCg0KDQpgYGANCg0K