List names in column that match a given word in another column

Hey guys,

I would like to list all lines in column 1 that match a given expression in column 3. For example,

1 2 3
A B C
D E F
G H C
...

So, I would like to list A and G, because they match the C on column 3. Btw, the match in column 3 has spaces! Thank you!

sequence genome

• 1,071 views • link

updated 7.0 years ago by GenoMax

• written 7.0 years ago by genomes_and_MGEs •

What have you tried? Did you search for a solution on stack overflow? Or do you want us to do your job for you?

NB. What is the bioinformatics here?

• 0 views • link

written 7.0 years ago by Benn

0 answers

No answers yet.

More posts like this

Matching samples between big datasets
written 3.8 years ago by janhenk2333 •

Hi all, I am new here and trying to figure out a specific task: Lets say I have the following `data_frame`: ```r gene = c("a","b","c","d","e","f","g","h","i","j","k", …
awk command merge files on one common column
written 4.2 years ago by Confused_human •

Hi, I have two files file 1 ``` A B B C D E E E ``` file 2 ``` A P Q B R …
R ggplot2 creating separate plots for different subsets of rows
written 5.3 years ago by moritz.lasse •

Hi there, I have a dataframe of gene expression (one row per gene). I would like to only plot certain subsets of genes (e.g. by …
Problem getting tree bipartitions
written 5.8 years ago by chaperoneline •

I wanted to get all the bipartitions from a tree: [tree image][1] It should give the following bipartitions: 1. A,B,C,D,E,F,G,H 2. A,B,C,D,I,J 3. E,F,G,H,I,J 4. …
Get distance matrix based on node tree
written 6.4 years ago by Chvatil

Hi, I need some help getting a phylogenetic distance matrix. Here are two examples: Example one: tree=ete3.Tree('(((A,B),C),D);') print(tree) /-A /-| /-| \-B | | --| …
Populating values of each parameter of dataframe1 to another dataframe2 under same parameter field …
written 8.4 years ago by sofie_carolina •

How to populate parameters values present in rows of one dataframe(df1) to dataframe(df2) under same parameter field in R? Dataframe1 contain: df1 Col1 Col2 Col3 …
compare two gene lists
written 8.6 years ago by fufuyou

Hi All, Merry Christmas, I have two gene list, for example, file1 A B C D file2 B C D E F G H I …
data file format
written 10.2 years ago by ahmedakhokhar

I am working with a tab separated files: A B C D a d ii domain a d g domain a h g domain a …
combining rows in sequance file
written 12.1 years ago by Tohamy •

Dear All, I do not have much experience with R and I need your help. I have a data from like this: 1_1 A B …
Retrieving values specific to a column
written 12.2 years ago by Sathya •

How to retrieve values specific to a column in comparison to other columns. Say , there is a matrix of a dimension 10*3 a1 a1.1 …