Wrangling steps¶
37 step types in the Wrangle tab.
| ID | Name | Plan |
|---|---|---|
select |
Select columns | Free |
mutate |
Mutate column | Free |
rename |
Rename column | Free |
filter |
Filter rows | Free |
arrange |
Sort rows | Free |
slice |
Keep first / last rows | Free |
sample |
Sample rows | Free |
distinct |
Keep distinct combinations | Free |
drop_na |
Drop missing rows | Free |
replace_na |
Replace missing values | Free |
group_by |
Group rows | Pro |
summarize |
Summarize | Pro |
pivot_longer |
Pivot longer | Pro |
pivot_wider |
Pivot wider | Pro |
bin |
Bin numeric column | Pro |
extract_date |
Extract date part | Pro |
recode |
Recode values | Pro |
standardize |
Standardize (z / min-max) | Pro |
clip |
Clip outliers (winsorize) | Pro |
split_col |
Split column | Pro |
unite |
Combine columns | Pro |
fill |
Fill missing (down / up) | Pro |
window |
Window function (lag, cumsum…) | Pro |
convert_type |
Convert column type | Free |
join |
Join second dataset | Pro |
append |
Append rows from second dataset | Pro |
clean_names |
Clean column names | Free |
count |
Count rows per group | Pro |
relocate |
Reorder columns | Pro |
text_clean |
Clean text (trim, case, replace) | Pro |
date_diff |
Date difference | Pro |
top_n |
Keep top / bottom N | Pro |
case_when |
Conditional column (case when) | Pro |
impute |
Impute missing (mean / median / mode) | Pro |
lump |
Lump rare categories | Pro |
transform |
Transform (log, sqrt…) | Pro |
pct_of_total |
Percent of total | Pro |