Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

janitor

Simple Tools for Examining and Cleaning Dirty Data

The main janitor functions can: perfectly format data.frame column names; provide quick counts of variable combinations (i.e., frequency tables and crosstabs); and isolate duplicate records. Other janitor functions nicely format the tabulation results. These tabulate-and-report functions approximate popular features of SPSS and Microsoft Excel. This package follows the principles of the "tidyverse" and works well with the pipe function %>%. janitor was built with beginning-to-intermediate R users in mind and is optimized for user-friendliness. Advanced R users can already do everything covered here, but with janitor they can do it faster and save their thinking for the fun stuff.

Functions (37)

add_totals_col

Append a totals column to a data.frame.

add_totals_row

Append a totals row to a data.frame.

adorn_crosstab

Add presentation formatting to a crosstabulation table.

adorn_ns

Add underlying Ns to a tabyl displaying percentages.

adorn_pct_formatting

Format a data.frame of decimals as percentages.

adorn_percentages

Convert a data.frame of counts to percentages.

adorn_rounding

Round the numeric columns in a data.frame.

adorn_title

Add column name to the top of a two-way tabyl.

adorn_totals

Append a totals row and/or column to a data.frame.

as_tabyl

Add tabyl attributes to a data.frame.

chisq.test

Apply stats::chisq.test to a two-way tabyl

clean_names

Cleans names of an object (usually a data.frame).

compare_df_cols

Generate a comparison of data.frames (or similar objects) that indicates if they will successfully bind together by rows.

compare_df_cols_same

Do the the data.frames have the same columns & types?

convert_to_NA

Convert string values to true NA values.

convert_to_date

Convert many date and datetime formats as may be received from Microsoft Excel

crosstab

Generate a crosstabulation of two vectors.

describe_class

Describe the class(es) of an object

excel_numeric_to_date

Convert dates encoded as serial numbers to Date class.

fisher.test

Apply stats::fisher.test to a two-way tabyl

get_dupes

Get rows of a data.frame with identical values for the specified variables.

janitor

janitor

janitor_deprecated

Deprecated Functions in Package janitor

make_clean_names

Cleans a vector of text, typically containing the names of an object.

pipe

Pipe operator

remove_constant

Remove constant columns from a data.frame or matrix.

remove_empty

Remove empty rows and/or columns from a data.frame or matrix.

remove_empty_cols

Removes empty columns from a data.frame.

remove_empty_rows

Removes empty rows from a data.frame.

round_half_up

Round a numeric vector; halves will be rounded up, ala Microsoft Excel.

round_to_fraction

Round to the nearest fraction of a specified denominator.

row_to_names

Elevate a row to be the column names of a data.frame.

signif_half_up

Round a numeric vector to the specified number of significant digits; halves will be rounded up.

tabyl

Generate a frequency table (1-, 2-, or 3-way).

top_levels

Generate a frequency table of a factor grouped into top-n, bottom-n, and all other levels.

untabyl

Remove tabyl attributes from a data.frame.

use_first_valid_of

Returns first non-NA value from a set of vectors.

janitor

Simple Tools for Examining and Cleaning Dirty Data

v2.1.0

MIT + file LICENSE

Authors

Sam Firke [aut, cre], Bill Denney [ctb], Chris Haid [ctb], Ryan Knight [ctb], Malte Grosser [ctb], Jonathan Zadra [ctb]

Initial release

janitor

Functions (37)

janitor

We don't support your browser anymore