insert: Insert a row or column into a data.frame

In spatialEco: Spatial Analysis and Modelling Utilities

Insert a row or column into a data.frame

Description

Inserts a new row or column into a data.frame at a specified location

Usage

insert(x, MARGIN = 1, value = NULL, idx, name = NULL)

Arguments

x	Existing data.frame
MARGIN	Insert a 1 = row or 2 = column
value	A vector of values equal to the length of MARGIN, if nothing specified values with be NA
idx	Index position to insert row or column
name	Name of new column (not used for rows, MARGIN=1)

Details

Where there are methods to easily add a row/column to the end or beginning of a data.frame, it is not straight forward to insert data at a specific location within the data.frame. This function allows for inserting a vector at a specific location eg., between columns or rows 1 and 2 where row/column 2 is moved to the 3rd position and a new vector of values is inserted into the 2nd position.

Value

A data.frame with the new row or column inserted

Author(s)

Jeffrey S. Evans <[e-mail]>

Examples

d <- data.frame(ID=1:10, y=runif(10))

# insert row
insert(d, idx=2)
insert(d, value=c(20,0), idx=2)

# insert column
insert(d, MARGIN=2, idx=2)
insert(d, MARGIN = 2, value = rep(0,10), idx=2, name="x")

spatialEco documentation built on Nov. 18, 2023, 1:13 a.m.