Using grep to get the rows of a dataframe, instead of the row number

Question

I am trying to make a sub dataframe based on the already existing dataframe. My sub dataframe is being filled with the number of the row instead of the row itself.

rates = read.csv("file.txt")
genes = unique(gsub('_[0-9]+', '', rates[,1]))
for (k in unique(gsub('_[0-9]+', '', rates[,1])) ){
        sub = print(grep(k, rates[,1]), value=T)
        sub
}

file.txt

clothing,freq,temp
coat_1,0.3,10
coat_1,0.9,0
coat_1,0.1,20
coat_2,0.5,20
coat_2,0.3,15
coat_2,0.1,5
scarf,0.4,30
scarf,0.2,20
scarf,0.1,10

This is what is currently output

[1] 1 2 3 4 5 6
[1] 7 8 9

I would like something like this instead

  clothing freq temp
1   coat_1  0.3   10
2   coat_1  0.9    0
3   coat_1  0.1   20
4   coat_2  0.5   20
5   coat_2  0.3   15
6   coat_2  0.1    5

  clothing freq temp
1    scarf  0.4   30
2    scarf  0.2   20
3    scarf  0.1   10

Try this instead in the loop: sub = print(rates[grep(k, rates[,1]),] ) — Dave2e
– Dave2e, Commented Jul 22, 2017 at 1:15

Kevin · Accepted Answer · 2017-07-22 01:20:16Z

1

 rates <- read.csv("file.txt", stringsAsFactors = FALSE)
 rates
#  clothing freq temp
# 1   coat_1  0.3   10
# 2   coat_1  0.9    0
# 3   coat_1  0.1   20
# 4   coat_2  0.5   20
# 5   coat_2  0.3   15
# 6   coat_2  0.1    5
# 7    scarf  0.4   30
# 8    scarf  0.2   20
# 9    scarf  0.1   10

 rates[rates$clothing != "scarf",]
#  clothing freq temp
# 1   coat_1  0.3   10
# 2   coat_1  0.9    0
# 3   coat_1  0.1   20
# 4   coat_2  0.5   20
# 5   coat_2  0.3   15
# 6   coat_2  0.1    5
rates[rates$clothing == "scarf",]
#  clothing freq temp
#7    scarf  0.4   30
#8    scarf  0.2   20
#9    scarf  0.1   10

answered Jul 22, 2017 at 1:20

Kevin

3492 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using grep to get the rows of a dataframe, instead of the row number

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related