INDEX: Basic INDEX function from excel

In ExcelFunctionsR: Imports Excel Functions to R

Description

It acts similiarly to Excel's INDEX function. It gives you the value from dataframe when you specify the array indices(row and column)

Usage

INDEX(array, row_num, column_num = 1)

Arguments

array	Which array/table should it use?
row_num	Which row should it return the value from?
column_num	Which column should it return the value from?

Value

In this example we get 3rd row and 2nd column from the dataframe. This function can return different classes numeric, character, logical etc. It depends on what is in array/dataframe.

Examples

INDEX(iris,3,2)

Example output

[1] 3.2

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.