This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Algorithm For Mining The Primary Key In A Comma-Separated File Having 20,000 Entries

Hello, I am working on a project, i have to write an algorithm for comparing two large databases by defining association rules, so firstly i want to distinguish the primary attributes. That's way i need some help to find primary key in large database of minimum 20,000 attributes. please give me some suggestions that what should i do. sorry if i could not explain properly.
BR Sameer

algorithm
• 4,396 views • link
updated by Kevin Blighe Kevin Blighe • written by Sameer • Sameer

How is it related to bioinformatics? As it is defined here, you'd better ask stackoverflow.com.

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Yes, please indicate bioinformatics relevance, or we'll have to close this one.

• 0 views • link
written by Neilfws Neilfws

also, provide an example of the data you want to analyze, and the output you want to get.

• 0 views • link
written by Giovanni M Dall'Olio Giovanni M Dall'Olio

A problem like this might occur in bioinformatics when trying to map datasets based on identifiers, then it is important to look for some attribute that could serve as primary key. Still I believe it is not bioinformatics specific enough to warrant it on BioStar instead of Stackoverflow without more explanation

• 0 views • link
written by Michael Dondrup Michael Dondrup

I think the relevance to bioinformatics is plainly obvious. I run into this problem a lot in bioinformatics, and find the question and potential answer informative for anyone in this field.

• 0 views • link
written by seidel seidel

Perhaps I should not have said "relevance". What I want to see is a specific bioinformatics problem, not a general computing problem. And the question could be clearer - it's CSV in the title, but then databases in the main text.

• 0 views • link
written by Neilfws Neilfws

1 answer

Use awk index arrays. With awk, it is also possible to read 2 files in the same command and cross-compare information between these.

Kevin

• 0 views • link
written by Kevin Blighe Kevin Blighe

Log in to answer this question.

More posts like this