Package: dplyr 1.2.1.9000

Hadley Wickham

dplyr: A Grammar of Data Manipulation

A fast, consistent tool for working with data frame like objects, both in memory and out of memory.

Authors:Hadley Wickham [aut, cre], Romain François [aut], Lionel Henry [aut], Kirill Müller [aut], Davis Vaughan [aut], Posit Software, PBC [cph, fnd]

dplyr_1.2.1.9000.tar.gz
dplyr_1.2.1.9000.zip(r-4.7)dplyr_1.2.1.9000.zip(r-4.6)dplyr_1.2.1.9000.zip(r-4.5)
dplyr_1.2.1.9000.tgz(r-4.6-x86_64)dplyr_1.2.1.9000.tgz(r-4.6-arm64)dplyr_1.2.1.9000.tgz(r-4.5-x86_64)dplyr_1.2.1.9000.tgz(r-4.5-arm64)
dplyr_1.2.1.9000.tar.gz(r-4.7-arm64)dplyr_1.2.1.9000.tar.gz(r-4.7-x86_64)dplyr_1.2.1.9000.tar.gz(r-4.6-arm64)dplyr_1.2.1.9000.tar.gz(r-4.6-x86_64)
dplyr_1.2.1.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
dplyr/json (API)

# Install 'dplyr' in R:
install.packages('dplyr', repos = c('https://tidyverse.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/tidyverse/dplyr/issues

Pkgdown/docs site:https://dplyr.tidyverse.org

Uses libs:
  • c++– GNU Standard C++ Library v3
Datasets:

On CRAN:

Conda:

data-manipulationgrammarcpp

25.39 score 5.0k stars 9.2k packages 858k scripts 1.9M downloads 1.2k mentions 284 exports 14 dependencies

Last updated from:d5e94e7fa8. Checks:10 OK, 3 NOTE. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-arm64OK256
linux-devel-x86_64OK235
source / vignettesOK241
linux-release-arm64OK245
linux-release-x86_64OK245
macos-release-arm64OK188
macos-release-x86_64OK475
macos-oldrel-arm64NOTE220
macos-oldrel-x86_64NOTE442
windows-develOK350
windows-releaseOK194
windows-oldrelNOTE338
wasm-releaseOK127

Exports:.data%>%acrossadd_countadd_count_add_rowadd_rownamesadd_tallyadd_tally_all_equalall_ofall_varsanti_joinany_ofany_varsarrangearrange_arrange_allarrange_atarrange_ifas_data_frameas_labelas_tibbleas.tblauto_copybetweenbind_colsbind_rowsc_acrosscase_matchcase_whencheck_dbplyrcoalescecollapsecollectcombinecommon_bycomputeconsecutive_idcontainscopy_tocountcount_cross_joincumallcumanycume_distcummeancur_columncur_datacur_data_allcur_groupcur_group_idcur_group_rowsdata_framedb_analyzedb_begindb_commitdb_create_indexdb_create_indexesdb_create_tabledb_data_typedb_descdb_drop_tabledb_explaindb_has_tabledb_insert_intodb_list_tablesdb_query_fieldsdb_query_rowsdb_rollbackdb_save_querydb_write_tabledense_rankdescdim_descdistinctdistinct_distinct_alldistinct_atdistinct_ifdistinct_preparedodo_dplyr_col_modifydplyr_reconstructdplyr_row_sliceends_withenexprenexprsenquoenquosensymensymseverythingexplainexprfilterfilter_filter_allfilter_atfilter_iffilter_outfirstfull_joinfunsfuns_glimpsegroup_bygroup_by_group_by_allgroup_by_atgroup_by_drop_defaultgroup_by_ifgroup_by_preparegroup_colsgroup_datagroup_indicesgroup_indices_group_keysgroup_mapgroup_modifygroup_nestgroup_rowsgroup_sizegroup_splitgroup_trimgroup_varsgroup_walkgrouped_dfgroupsidentif_allif_anyif_elseinner_joinintersectis_grouped_dfis.grouped_dfis.srcis.tbljoin_bylaglastlast_collast_dplyr_warningsleadleft_joinlstmake_tblmatchesmin_rankmutatemutate_mutate_allmutate_atmutate_eachmutate_each_mutate_ifnn_distinctn_groupsna_ifnearnest_bynest_joinnew_grouped_dfnew_rowwise_dfnthntilenum_rangeone_oforder_bypercent_rankpickprogress_estimatedpullquoquo_namequosrecoderecode_factorrecode_valuesreframerelocaterenamerename_rename_allrename_atrename_ifrename_withreplace_valuesreplace_whenright_joinrow_numberrows_appendrows_deleterows_insertrows_patchrows_updaterows_upsertrowwisesame_srcsample_fracsample_nselectselect_select_allselect_atselect_ifsemi_joinsetdiffsetequalshow_querysliceslice_slice_headslice_maxslice_minslice_sampleslice_tailsqlsql_escape_identsql_escape_stringsql_joinsql_selectsql_semi_joinsql_set_opsql_subquerysql_translate_envsrcsrc_dfsrc_localsrc_mysqlsrc_postgressrc_sqlitesrc_tblsstarts_withsummarisesummarise_summarise_allsummarise_atsummarise_eachsummarise_each_summarise_ifsummarizesummarize_summarize_allsummarize_atsummarize_eachsummarize_each_summarize_ifsymsymdiffsymstallytally_tbltbl_dftbl_nongroup_varstbl_ptypetbl_varstibbletop_fractop_ntransmutetransmute_transmute_alltransmute_attransmute_iftribbletype_sumungroupunionunion_allvalidate_grouped_dfvalidate_rowwise_dfvarswhen_allwhen_anywherewith_groupswith_orderwrap_dbplyr_obj

Dependencies:cligenericsgluelifecyclemagrittrpillarpkgconfigR6rlangtibbletidyselectutf8vctrswithr

Column-wise operations
Basic usage | Multiple functions | Current column | Gotchas | Other verbs | filter() and filter_out() | _if, _at, _all | Why do we like across()? | Why did it take so long to discover across()? | How do you convert existing code?

Last update: 2026-02-11
Started: 2020-03-03

dplyr <-> base R
Overview | One table verbs | arrange(): Arrange rows by variables | distinct(): Select distinct/unique rows | filter(): Return rows with matching conditions | mutate(): Create or transform variables | pull(): Pull out a single variable | relocate(): Change column order | rename(): Rename variables by name | rename_with(): Rename variables with a function | select(): Select variables by name | summarise(): Reduce multiple values down to a single value | slice(): Choose rows by position | Two-table verbs | Mutating joins | Filtering joins

Last update: 2026-02-11
Started: 2020-02-22

Grouped data
group_by() | Group metadata | Changing and adding to grouping variables | Removing grouping variables | Verbs | summarise() | select(), rename(), and relocate() | arrange() | mutate() | filter() | slice() and friends

Last update: 2026-02-11
Started: 2020-02-23

Introduction to dplyr
Data: starwars | Single table verbs | The pipe | Filter rows with filter() | Arrange rows with arrange() | Choose rows using their position with slice() | Select columns with select() | Add new columns with mutate() | Change column order with relocate() | Summarise values with summarise() | Commonalities | Combining functions with |> | Patterns of operations | Selecting operations | Mutating operations

Last update: 2026-02-11
Started: 2017-04-04

Programming with dplyr
Introduction | Data masking | Data- and env-variables | Indirection | Name injection | Tidy selection | The tidyselect DSL | How-tos | User-supplied data | One or more user-supplied expressions | Any number of user-supplied expressions | Creating multiple columns | Transforming user-supplied variables | Loop over multiple variables | Use a variable from an Shiny input

Last update: 2026-02-11
Started: 2017-03-22

Row-wise operations
Creating | Per row summary statistics | Row-wise summary functions | List-columns | Motivation | Subsetting | Modelling | Repeated function calls | Simulations | Multiple combinations | Varying functions | Previously | rowwise() | do()

Last update: 2026-02-11
Started: 2020-03-03

Window functions
Types of window functions | Ranking functions | Lead and lag | Cumulative aggregates | Recycled aggregates

Last update: 2026-02-11
Started: 2013-10-02

Recoding columns and replacing values
Introduction | case_when() | replace_when() | Type stability | recode_values() | replace_values() | Comparisons | if_else() | coalesce() | na_if() | SQL

Last update: 2026-01-23
Started: 2026-01-23

Two-table verbs
Mutating joins | Controlling how the tables are matched | Types of join | Observations | Filtering joins | Set operations | Multiple-table verbs

Last update: 2025-09-18
Started: 2014-11-24

Using dplyr in packages
Join helpers | Data masking and tidy selection NOTEs | Deprecation | Multiple dplyr versions | Deprecation of mutate_*() and summarise_*() | Data frame subclasses

Last update: 2025-09-18
Started: 2023-02-22

Readme and manuals

Help Manual

Help pageTopics
Apply a function (or functions) across multiple columnsacross if_all if_any
Apply predicate to all variablesall_vars any_vars
Order rows using column valuesarrange arrange.data.frame
Copy tables to same source, if necessaryauto_copy
Band membershipband_instruments band_instruments2 band_members
Detect where values fall in a specified rangebetween
Bind multiple data frames by columnbind_cols
Bind multiple data frames by rowbind bind_rows
Combine values from multiple columnsc_across
A general vectorised if-elsecase-and-replace-when case_when replace_when
Find the first non-missing elementcoalesce
Force computation of a database querycollapse collect compute
Generate a unique identifier for consecutive combinationsconsecutive_id
Information about the "current" group or variablecontext cur_column cur_group cur_group_id cur_group_rows n
Copy a local data frame to a remote srccopy_to
Count the observations in each groupadd_count add_tally count count.data.frame tally
Cross joincross_join
Cumulative versions of any, all, and meancumall cumany cummean
Descending orderdesc
Keep distinct/unique rowsdistinct
Per-operation grouping with '.by'/'by'dplyr_by
Explain details of a tblexplain show_query
Keep or drop rows that match a conditionfilter filter_out
Filtering joinsanti_join anti_join.data.frame filter-joins semi_join semi_join.data.frame
Get a glimpse of your dataglimpse
Group by one or more variablesgroup_by ungroup
Select grouping variablesgroup_cols
Apply a function to each groupgroup_map group_modify group_walk
Trim grouping structuregroup_trim
Flag a character vector as SQL identifiersident
Vectorised if-elseif_else
Join specificationsclosest join_by overlaps within
Compute lagged or leading valueslag lead lead-lag
Create, modify, and delete columnsmutate mutate.data.frame
Mutating joinsfull_join full_join.data.frame inner_join inner_join.data.frame join join.data.frame left_join left_join.data.frame mutate-joins right_join right_join.data.frame
Count unique combinationsn_distinct
Convert values to 'NA'na_if
Compare two numeric vectorsnear
Nest joinnest_join nest_join.data.frame
Extract the first, last, or nth value from a vectorfirst last nth
Bucket a numeric vector into 'n' groupsntile
A helper function for ordering window function outputorder_by
Proportional ranking functionscume_dist percent_rank
Select a subset of columnspick
Extract a single columnpull
Recode valuesrecode recode_factor
Recode and replace valuesrecode-and-replace-values recode_values replace_values
Transform each group to an arbitrary number of rowsreframe
Change column orderrelocate
Rename columnsrename rename_with
Integer ranking functionsdense_rank min_rank row_number
Manipulate individual rowsrows rows_append rows_delete rows_insert rows_patch rows_update rows_upsert
Group input by rowsrowwise
Operate on a selection of variablesscoped
Keep or drop columns using their names and typesselect
Set operationsintersect setdiff setequal setops symdiff union union_all
Subset rows using their positionsslice slice_head slice_max slice_min slice_sample slice_tail
SQL escaping.sql
Starwars charactersstarwars
Storm tracks datastorms
Summarise each group down to one rowsummarise summarize
Create a table from a data sourceis.tbl tbl
Select variablesvars
Elementwise 'any()' and 'all()'when-any-all when_all when_any