R Lesson 4: dplyr — filter, mutate, summarise
Analyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise — the R equivalent of filters, formulas and pivot tables.
Read article →Analyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise — the R equivalent of filters, formulas and pivot tables.
Read article →ROW returns the row number of a reference (or of the cell it is in). It is the quiet engine behind serial numbers and many array tricks.
Read article →IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.
Read article →OCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Learn SQL from the very beginning: tables, SELECT, WHERE, ORDER BY, aggregates, GROUP BY, JOINs, NULLs, subqueries, CTEs, window functions and changing data — with examples you can run in your browser.
Read article →InformationLevel: BeginnerAvailable in: Excel 2007+ISODD returns TRUE for odd numbers (decimals are truncated first).Syntax=ISODD(number)ArgumentWhat it.
Read article →SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Read article →OCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Write decision formulas that stay readable: nested IF in the right order, IFS, AND/OR combinations, SWITCH, lookup tables instead of deep nesting, and IFERROR/IFNA used carefully.
Read article →EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2DEC reads hex text — colour codes, error codes from logs — as a.
Read article →EngineeringLevel: IntermediateAvailable in: Excel 2013+DECIMAL reverses BASE.Syntax=DECIMAL(text, radix)ArgumentWhat it meansradix2 to 36.ExamplesExample.
Read article →BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.
Read article →