{ "_id": "6a200251b401979e73445da5", "Package": "uscoauditlog", "Type": "Package", "Title": "United States Copyright Office Product Management Division SR\nAudit Data Dataset Cleaning Algorithms", "Version": "1.0.3", "Author": "Frederick Liu [aut, cre]", "Maintainer": "Frederick Liu ", "Description": "Intended to be used by the United States Copyright Office\nProduct Management Division Business Analysts. Include\nalgorithms for the United States Copyright Office Product\nManagement Division SR Audit Data dataset. The algorithm takes\nin the SR Audit Data excel file and reformat the spreadsheet\nsuch that the values and variables fit the format of the online\ndatabase. Support functions in this package include\nclean_str(), which cleans instances of variable AUDIT_LOG;\nclean_data_to_excel(), which cleans and output the reorganized\nSR Audit Data dataset in excel format;\nclean_data_to_dataframe(), which cleans and stores the\nreorganized SR Audit Data data set to a data frame;\nformat_from_excel(), which reads in the outputted excel file\nfrom the clean_data_to_excel() function and formats and returns\nthe data as a dictionary that uses FIELD types as keys and\nNON-FIELD types as the values of those keys.\nformat_from_dataframe(), which reads in the outputted data\nframe from the clean_data_to_dataframe() function and formats\nand returns the data as a dictionary that uses FIELD types as\nkeys and NON-FIELD types as the values of those keys;\nsupport_function(), which takes in the dictionary outputted\neither from the format_from_dataframe() or format_from_excel()\nfunction and returns the data as a formatted data frame\naccording to the original U.S. Copyright Office SR Audit Data\nonline database. The main function of this package is\nclean_format_all(), which takes in an excel file and returns\nthe formatted data into a new excel and text file according to\nthe format from the U.S. Copyright Office SR Audit Data online\ndatabase.", "License": "GPL (>= 2)", "Encoding": "UTF-8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-03 10:27:01 UTC", "User": "root" }, "Config/pak/sysreqs": "libicu-dev", "Repository": "https://pakabuka.r-universe.dev", "Date/Publication": "2022-06-09 07:20:02 UTC", "RemoteUrl": "https://github.com/cran/uscoauditlog", "RemoteRef": "HEAD", "RemoteSha": "631755b0658e0487a98fa78be9203dd7d729f830", "MD5sum": "3104e4bb75e8c124e8293ac032394030", "_user": "pakabuka", "_type": "src", "_file": "uscoauditlog_1.0.3.tar.gz", "_fileid": "5142f2fdaa7af8bdf600a5876ff27aaa03b0b5db9adfd5753c057e063e0037bc", "_filesize": 87455, "_sha256": "5142f2fdaa7af8bdf600a5876ff27aaa03b0b5db9adfd5753c057e063e0037bc", "_created": "2026-06-03T10:27:01.000Z", "_published": "2026-06-03T10:30:41.891Z", "_distro": "noble", "_jobs": [ { "job": 79273391007, "time": 141, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7382082167" }, { "job": 79273391023, "time": 116, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7382074455" }, { "job": 79273390988, "time": 181, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7382083884" }, { "job": 79273391017, "time": 132, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7382071608" }, { "job": 79272920658, "time": 171, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7382034331" }, { "job": 79273390998, "time": 96, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7382068050" }, { "job": 79273391006, "time": 73, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7382060046" }, { "job": 79273391157, "time": 66, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7382057611" }, { "job": 79273391080, "time": 133, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7382080030" } ], "_buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/uscoauditlog", "_commit": { "id": "631755b0658e0487a98fa78be9203dd7d729f830", "author": "Frederick Liu ", "committer": "cran-robot ", "message": "version 1.0.3\n", "time": 1654759202 }, "_maintainer": { "name": "Frederick Liu", "email": "sliu85@u.rochester.edu" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.4.0", "role": "Depends" }, { "package": "stringr", "role": "Depends" }, { "package": "openxlsx", "role": "Depends" }, { "package": "readxl", "role": "Depends" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_userbio": { "uuid": 69220918, "type": "user", "name": "Pakabuka" }, "_downloads": { "count": 167, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/uscoauditlog" }, "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/uscoauditlog.html", "manual.pdf" ], "_realowner": "pakabuka", "_cranurl": false, "_releases": [ { "version": "1.0.3", "date": "2022-06-09" } ], "_exports": [ "clean_data_to_dataframe", "clean_data_to_excel", "clean_format_all", "clean_str", "format_from_dataframe", "format_from_excel", "support_function" ], "_help": [ { "page": "clean_data_to_dataframe", "title": "Helper Function", "topics": [ "clean_data_to_dataframe" ] }, { "page": "clean_data_to_excel", "title": "Helper Function", "topics": [ "clean_data_to_excel" ] }, { "page": "clean_format_all", "title": "Main Function", "topics": [ "clean_format_all" ] }, { "page": "clean_str", "title": "Helper Function", "topics": [ "clean_str" ] }, { "page": "format_from_dataframe", "title": "Helper Function", "topics": [ "format_from_dataframe" ] }, { "page": "format_from_excel", "title": "Helper Function", "topics": [ "format_from_excel" ] }, { "page": "support_function", "title": "Helper Function", "topics": [ "support_function" ] } ], "_rundeps": [ "cellranger", "cli", "cpp11", "crayon", "glue", "hms", "lifecycle", "magrittr", "openxlsx", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "Rcpp", "readxl", "rematch", "rlang", "stringi", "stringr", "tibble", "utf8", "vctrs", "zip" ], "_score": 1, "_indexed": true, "_nocasepkg": "uscoauditlog", "_universes": [ "pakabuka" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.3", "date": "2026-06-03T10:29:26.000Z", "distro": "noble", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "4686c1d0da0a922b317caa8c162421330e68b53ecf5387b4609c235865b5c918", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.6.0", "os": "linux", "version": "1.0.3", "date": "2026-06-03T10:29:01.000Z", "distro": "noble", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "731267b7e83ab3a1553c74435f8a76b674dcb4f89ca0fc417fbea4f220162747", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.5.3", "os": "mac", "version": "1.0.3", "date": "2026-06-03T10:29:32.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "e8bb5ea47609a85f750ace23552f7fa9743988156f347b8ec3b5e781552407f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.6.0", "os": "mac", "version": "1.0.3", "date": "2026-06-03T10:28:56.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "bedb4aeb02ca98df4377f091a66e8d6bc34744f07615154f4e485dfb5b1728b1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.3", "date": "2026-06-03T10:28:56.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "8ac04208d0748d18541c44d9de28703a6b8a2c510504e545dfca6690ae8bd762", "status": "success", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.7.0", "os": "win", "version": "1.0.3", "date": "2026-06-03T10:28:12.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "324d447464e85da19d9f192c6973fd86adc0541fc35faac3b6fd7368d38e7985", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.5.3", "os": "win", "version": "1.0.3", "date": "2026-06-03T10:28:07.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "8b34ca314bb1e16e4f7292dfbfb43520d11ceb2de6221e8460492c162d5e72e0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" }, { "r": "4.6.0", "os": "win", "version": "1.0.3", "date": "2026-06-03T10:29:08.000Z", "commit": "631755b0658e0487a98fa78be9203dd7d729f830", "fileid": "c0383273fb6d65811c8298bd719514071d43dc19949891e34633d18b167784ed", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pakabuka/actions/runs/26878716898" } ] }