tidyxl - Read Untidy Excel Files

Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <https://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.

Last updated 11 months ago

excelreaderrcppspreadsheettidy

10.30 score 248 stars 10 packages 348 scripts 2.6k downloads

unpivotr - Unpivot Complex and Irregular Data Layouts

Tools for converting data from complex or irregular layouts to a columnar structure. For example, tables with multilevel column or row headers, or spreadsheets. Header and data cells are selected by their contents and position, as well as formatting and comments where available, and are associated with one other by their proximity in given directions. Functions for data frames and HTML tables are provided.

Last updated 2 years ago

excelpivot-tablesspreadsheet

9.52 score 185 stars 2 packages 250 scripts 515 downloads

meltr - Read Non-Rectangular Text Data

The goal of 'meltr' is to provide a fast and friendly way to read non-rectangular data, such as ragged forms of csv (comma-separated values), tsv (tab-separated values), and fwf (fixed-width format) files.

Last updated 11 months ago

5.55 score 30 stars 1 packages 13 scripts 217 downloads

govdown - GOV.UK Style Templates for R Markdown

A suite of custom R Markdown formats and templates for authoring web pages styled with the GOV.UK Design System.

Last updated 4 years ago

5.06 score 46 stars 7 scripts 215 downloads

nzpullover - Driving Offences in New Zealand Between 2009 and 2017

Datasets of driving offences and fines in New Zealand between 2009 and 2018. Originally published by the New Zealand Police at <http://www.police.govt.nz/about-us/publication/road-policing-driver-offence-data-january-2009-march-2018>.

Last updated 6 years ago

datasetgovernment-datanew-zealandpoliceroads

3.00 score 2 stars 1 scripts 120 downloads