How to compare two file and print matching?

i have two files file 1

Genome_no.  Organism_name   Filename
1   Organism1   470.1359
2   Organism2   470.7416
3   Organism3   470.7433
4   Organism4   470.1550
5   Organism5   470.1551

and file2

Acinetobacter baumannii strain MRSN10372    470.7416
Acinetobacter baumannii strain MRSN11698    470.7433
Acinetobacter baumannii strain MRSN11737    470.7457

The output I want should be

Acinetobacter baumannii strain MRSN10372    470.7416 Organism2
Acinetobacter baumannii strain MRSN11698    470.7433 Organism3

sed awk perl

• 279 views • link

updated 5.5 years ago by Pierre Lindenbaum

• written 5.5 years ago by sharmatina189059 •

man join

• 0 views • link

written 5.5 years ago by Pierre Lindenbaum

join -t $'\t' -1 1 -2 1 <(sort -t $'\t' -k1,1 susceptible) <(sort -t $'\t' -k1,1 dataset)

This is not working in my case.

• 0 views • link

written 5.5 years ago by sharmatina189059 •

of course it doesn't work.

I'm sorry, but you have first to understand what you're doing...

• 0 views • link

written 5.5 years ago by Pierre Lindenbaum

Hello sharmatina189059!

Questions similar to yours can already be found at:

arranging columns and rows

We have closed your question to allow us to keep similar content in the same thread.

If you disagree with this please tell us why in a reply below. We'll be happy to talk about it.

Cheers!

• 0 views • link

written 5.5 years ago by Pierre Lindenbaum

I have read this but in my case the solution given is not working. Please do let me know what else can be done?

• 0 views • link

written 5.5 years ago by sharmatina189059 •

import pandas as pd
climate_temp = pd.read_csv("/dataset")
climate_precip = pd.read_csv("/susceptible")
inner_merged = pd.merge(climate_temp, climate_precip, on = "Filename")
inner_merged.head()

I tried this and this works well. Thanks

• 0 views • link

written 5.5 years ago by sharmatina189059 •

0 answers

No answers yet.