{
  "_id": "6a103a85acfb0bcc41c9b3cc",
  "Package": "TidyPanel",
  "Title": "Universal Messy Panel Data Cleaner",
  "Version": "0.1.2",
  "Authors@R": "person(\"Tony\", \"Lu\", email = \"xulunt123@gmail.com\", role = c(\"aut\", \"cre\"))",
  "Description": "A robust toolkit designed to standardize and clean complex\ntabular data from commercial enterprise systems, healthcare\nrecords, logistics software, and HR databases. Features include\nintelligent regex parsing for domain-specific noise\n(currencies, percentages), gap-based block clustering, and\nautomated messy table resolution. Methods draw on tidy data\nprinciples described in Wickham (2014)\n<doi:10.18637/jss.v059.i10> and the 'readxl' parsing\ninfrastructure described in Wickham & Bryan (2023)\n<https://readxl.tidyverse.org>.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.3",
  "VignetteBuilder": "knitr",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-11 22:18:00 UTC",
    "User": "root"
  },
  "Author": "Tony Lu [aut, cre]",
  "Maintainer": "Tony Lu <xulunt123@gmail.com>",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-05-11 21:45:29 UTC",
  "RemoteUrl": "https://github.com/cran/TidyPanel",
  "RemoteRef": "HEAD",
  "RemoteSha": "9c732603bb6061579fa695febc0e3f51659e942e",
  "MD5sum": "d0fb00bd632e55df82f1d39f5264c5cd",
  "_user": "cran",
  "_type": "src",
  "_file": "TidyPanel_0.1.2.tar.gz",
  "_fileid": "3979e7378ed953ae8ef22851479c719cb9dab23428f007c1d8a20ccf26f3ef76",
  "_filesize": 122931,
  "_sha256": "3979e7378ed953ae8ef22851479c719cb9dab23428f007c1d8a20ccf26f3ef76",
  "_created": "2026-05-11T22:18:00.000Z",
  "_published": "2026-05-22T11:14:13.613Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77368419585,
      "time": 126,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6931206171"
    },
    {
      "job": 77368419854,
      "time": 122,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6931206667"
    },
    {
      "job": 77368419253,
      "time": 179,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6931173704"
    },
    {
      "job": 77368419071,
      "time": 112,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7159145462"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/25700097462",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/TidyPanel",
  "_commit": {
    "id": "9c732603bb6061579fa695febc0e3f51659e942e",
    "author": "Tony Lu <xulunt123@gmail.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 0.1.2\n",
    "time": 1778535929
  },
  "_maintainer": {
    "name": "Tony Lu",
    "email": "xulunt123@gmail.com",
    "login": "tonyisfool",
    "uuid": 280893128
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "readxl",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "writexl",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-20",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "0.1.2",
      "date": "2026-05-11"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "tonyisfool",
      "count": 1,
      "uuid": 280893128
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/TidyPanel"
  },
  "_searchresults": 0,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/readme.html",
    "extra/readme.md",
    "extra/TidyPanel.html",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.1.2",
      "date": "2026-05-11"
    }
  ],
  "_exports": [
    "clean_variable_names",
    "infer_data_types",
    "normalize_units",
    "read_messy_panel"
  ],
  "_help": [
    {
      "page": "clean_variable_names",
      "title": "Standardize and Clean Variable Names",
      "topics": [
        "clean_variable_names"
      ]
    },
    {
      "page": "infer_data_types",
      "title": "Smart Type Coercion & NA Recognition",
      "topics": [
        "infer_data_types"
      ]
    },
    {
      "page": "normalize_units",
      "title": "Normalize Numeric Columns Based on Header Unit Declarations",
      "topics": [
        "normalize_units"
      ]
    },
    {
      "page": "read_messy_panel",
      "title": "Robust Parsing and Extraction of Messy Excel Panel Data",
      "topics": [
        "read_messy_panel"
      ]
    }
  ],
  "_readme": "https://github.com/cran/TidyPanel/raw/HEAD/README.md",
  "_rundeps": [
    "cellranger",
    "cli",
    "cpp11",
    "crayon",
    "dplyr",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "R6",
    "readxl",
    "rematch",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "TidyPanel_introduction.Rmd",
      "filename": "TidyPanel_introduction.html",
      "title": "Introduction to TidyPanel",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Welcome to TidyPanel",
        "Features",
        "Basic Usage",
        "Cleaning Variable Names",
        "Advanced Features: Hierarchies and Audit Logs"
      ],
      "created": "2026-05-11 21:45:29",
      "modified": "2026-05-11 21:45:29",
      "commits": 1
    }
  ],
  "_score": 2.6989700043360187,
  "_indexed": true,
  "_nocasepkg": "tidypanel",
  "_universes": [
    "cran",
    "tonyisfool"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.2",
      "date": "2026-05-11T22:20:03.000Z",
      "distro": "noble",
      "commit": "9c732603bb6061579fa695febc0e3f51659e942e",
      "fileid": "ca91546884b597d5b73dc7d7e44d4fc0730ee3d49edead00021734f916a11273",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25700097462"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.2",
      "date": "2026-05-11T22:20:06.000Z",
      "distro": "noble",
      "commit": "9c732603bb6061579fa695febc0e3f51659e942e",
      "fileid": "750e7ee239a6e347e7dfce861a468a6bfaebc09a4abda9ed68ad6532f4ac0b1b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25700097462"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.2",
      "date": "2026-05-22T11:14:00.000Z",
      "commit": "9c732603bb6061579fa695febc0e3f51659e942e",
      "fileid": "cd8aaebf40c6999f48d88c231f0952430196ae0b425bf1e821e7d09194d4fa43",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25700097462"
    }
  ]
}