less-than-UsagiSan-greater-than: UsagiSan: A package for cleansing dataset and outputting...
In usagi-san-dayo/UsagiSan: Edit summary-tables on a Excel-file

Description excelColor excelHeadColor colorCells_xlsx csvToxlsx mkDirectories dataCleanser dataCleansing mergeRowAndColnamesWithData rowBind colBind getIndex getCount append_vecOrList extend_vecOrList insert_vecOrList remove_vecOrList pop_vecOrList isEqualData getSummaryTable See Also

The package UsagiSan provides you a lot of helps to reduce the time on data-clansing and editting the test results. this package contains four function: excelColor, excelHeadColor, mkDirectories and dataCleanser

The function excelColor helps you to edit the test results with coloring the signigicant variables with specific color.

The function excelHeadColor helps you to add colors on headers of any type of tables including summaty sheets and statistical test tables.

The function colorCells_xlsx colors columns with specified condition for rows in a EXCEL-sheet. This enables to color any EXCEL-sheets overwriting previous workbook data. you can freely intuitively edit EXCEL-sheets.

The function csvToxlsx converts a csv-file to a Excel-file.

The function mkDirectories organizes files in tha working directory.

The function dataCleanser helps you to cleans a dataset. This function modifies a dataset to the form much easier to handle in statistical analysis.

The class dataCleansing have several methods to operate dataCleanser. This provides how to classify a vector object into numeric, factor or Date type object.

The function mergeRowAndColnamesWithData reshapes a dataframe so that it has own rownames and colnames as its components.

The function rowBind is more useful and flexible than rbind. You can merge two objects without adjusting the number of rows or columns.

The function colBind is more useful and flexible than cbind. You can merge two objects without adjusting the number of rows or columns.

The function getIndex gives you the indices of an item in a vector or a list.

The function getCount gives you the number of an item in a vector or a list.

The function append_vecOrList appends two vector or list type objects.

The function getCount extend_vecOrList two vector or list type objects to make a extended vector or list.

The function insert_vecOrList inserts an item at the specified index in a vector or list type object.

The function remove_vecOrList removes an item from a vector or list type object.

The function pop_vecOrList pops an item from a vector or list type object.

The function isEqualData compares two data in txt, csv or xlsx files and returns results whether the two data are the same or not (if not, the row and column indices where components are not equal are printed out).

The function getSummarytable Creates a summary table for numeric and factor data in terms of each level of a factor data.

mergeRowAndColnamesWithData

rowBind

colBind

getIndex

getCount