| [[ {SparkR} | R Documentation |
Return subsets of DataFrame according to given conditions
## S4 method for signature 'DataFrame,numericOrcharacter' x[[i]] ## S4 method for signature 'DataFrame,missing' x[i, j, ..., drop = TRUE] ## S4 method for signature 'DataFrame,Column' x[i, j, ..., drop = TRUE] ## S4 method for signature 'DataFrame' subset(x, subset, select, ...)
x |
A DataFrame |
subset |
(Optional) A logical expression to filter on rows |
select |
expression for the single Column or a list of columns to select from the DataFrame |
A new DataFrame containing only the rows that meet the condition with selected columns
Other DataFrame functions: $,
$<-, select,
select,
select,DataFrame,Column-method,
select,DataFrame,list-method,
selectExpr; DataFrame-class,
dataFrame, groupedData;
agg, agg,
count,GroupedData-method,
summarize, summarize;
arrange, arrange,
arrange, orderBy,
orderBy; as.data.frame,
as.data.frame,DataFrame-method;
attach,
attach,DataFrame-method;
cache; collect;
colnames, colnames,
colnames<-, colnames<-,
columns, names,
names<-; coltypes,
coltypes, coltypes<-,
coltypes<-; columns,
dtypes, printSchema,
schema, schema;
count, nrow;
describe, describe,
describe, summary,
summary,
summary,PipelineModel-method;
dim; distinct,
unique; dropna,
dropna, fillna,
fillna, na.omit,
na.omit; dtypes;
except, except;
explain, explain;
filter, filter,
where, where;
first, first;
groupBy, groupBy,
group_by, group_by;
head; insertInto,
insertInto; intersect,
intersect; isLocal,
isLocal; join;
limit, limit;
merge, merge;
mutate, mutate,
transform, transform;
ncol; persist;
printSchema; rbind,
rbind, unionAll,
unionAll; registerTempTable,
registerTempTable; rename,
rename, withColumnRenamed,
withColumnRenamed;
repartition; sample,
sample, sample_frac,
sample_frac;
saveAsParquetFile,
saveAsParquetFile,
write.parquet, write.parquet;
saveAsTable, saveAsTable;
saveDF, saveDF,
write.df, write.df,
write.df; selectExpr;
showDF, showDF;
show, show,
show,GroupedData-method; str;
take; unpersist;
withColumn, withColumn;
write.json, write.json;
write.text, write.text
Other subsetting functions: $,
$<-, select,
select,
select,DataFrame,Column-method,
select,DataFrame,list-method,
selectExpr; filter,
filter, where,
where
## Not run:
##D # Columns can be selected using `[[` and `[`
##D df[[2]] == df[["age"]]
##D df[,2] == df[,"age"]
##D df[,c("name", "age")]
##D # Or to filter rows
##D df[df$age > 20,]
##D # DataFrame can be subset on both rows and Columns
##D df[df$name == "Smith", c(1,2)]
##D df[df$age %in% c(19, 30), 1:2]
##D subset(df, df$age %in% c(19, 30), 1:2)
##D subset(df, df$age %in% c(19), select = c(1,2))
##D subset(df, select = c(1,2))
## End(Not run)