colorexcel: Color outliers of excel data

In liuguofang/figsci: Let plotting figure and scientific visualization and information gain easier and more efficient.

Color outliers of excel data

Description

This function can be used to color outliers of excel data.

Usage

colorexcel(filename, threshold, variable, more = TRUE, sheetTh = 1, color=2)

Arguments

filename

the excel name.

threshold

condition threshold for contiguous variable.

variable

a variable name.

more

satisfy condition with its values of variable over threhold or not.

sheetTh

the order of excel sheet.

color

emphasized color and default is red.

Examples

data(leaflife,package='smatr')

data2excel(dat = leaflife, filename = 'leaflife.xlsx', sheetname = 'Sheet1', create = TRUE)

colorexcel(filename = 'leaflife.xlsx', threshold=3, variable = 'longev', more = TRUE, sheetTh = 1,col = 3)
	

liuguofang/figsci documentation built on Nov. 24, 2023, 1:45 p.m.