検索
# 全行表示 # select * from data_frame data_frame # 行数取得 # select count(*) from data_frame nrow(data_frame) # 列指定 # select refer from data_frame data_frame[,'refer'] # 先頭のみ表示 # select * from data_frame limit 10 head(data_frame, 10) # 条件指定(数値) # select * from data_frame where x=1 data_frame[data_frame$x==1,'refer'] # 条件指定(文字) # select * from data_frame where y='a' data_frame[data_frame$y=='a','refer'] # 条件指定(部分一致) # select * from data_frame where z like '%keyword%' data_frame[grep('keyword',data_frame$refer),] # 複数条件指定 # select * from data_frame where x=1 and y='a' data_frame[data_frame$x==1 & data_frame$y=='a','refer'] # 複数条件指定(条件抽出関数使用時) # select * from data_frame where z like '%keyword%' and x=1 subset(data_frame[grep("keyword",data_frame$z),], x==1)
0 件のコメント:
コメントを投稿