Join


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Join
# 8  
Old 05-29-2009
Code:
#!/usr/bin/env python
file1={} # store file1 contents in a dictionary
for line in open("file1"):
    line=line.strip().split("|")     # split the line on "|"
    file1['|'.join(line[:3])] = line[-1] #  store the first 3 elements as the key and last element as the value

for line in open("file2"): #now iterate file 2
    line=line.strip().split("|")  # you should know what his does
    one='|'.join(line[:3]) # get the first 3 elements together
    if file1.has_key(one):    #check against file1 dictionary using the key
        print "%s|%s|%s" %(one,line[-1],file1[one]) #do the printing
    else:
        print "%s|%s|%s" %(one,line[-1],"0")

please review Python tutorial (see my sig) to see how Python is used.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies

2. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

3. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies

4. Shell Programming and Scripting

Join help

im trying to join 3 files together sort -n ${ASS1_DATA_DIR}Prac1 | sed '/^#/d' > ${ASS1_OUTPUT_DIR}Prac1temp sort -n ${ASS1_DATA_DIR}Prac2 | sed '/^#/d' > ${ASS1_OUTPUT_DIR}Prac2temp join -a1 -a2 -1 1 -2 1 -o "0 1.2 2.2" -e " " ${ASS1_OUTPUT_DIR}Prac1temp ${ASS1_OUTPUT_DIR}Prac2temp >... (6 Replies)
Discussion started by: bigubosu
6 Replies

5. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Hello, My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns: File A: (tab-delimited) PDB CHAIN Start End Fragment 1avq A 171 176 awyfan 1avq A 172 177 wyfany 1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies

6. UNIX for Dummies Questions & Answers

Use of join

I want basically to merge two config files each of them look like that File:Option1 value1 Optionx valuex .... One of those files is default config while the other is generated by my script. Now here is the problem, when my script generates an option that previously has been set by default i... (4 Replies)
Discussion started by: Adas
4 Replies

7. Shell Programming and Scripting

Join

joining two files: File1: ----- 1|M 2|M 3|F File2: ----- 1|abc|def 3|xyz|pqr join -t '|' 1.txt 2.txt gives(Itried many other ways) 1|M|abc|def 3|F|xyz|pqr but I need the result like following (14 Replies)
Discussion started by: greenworld
14 Replies

8. Programming

sql,multiple join,outer join issue

example sql: select a.a1,b.b1,c.c1,d.d1,e.e1 from a left outer join b on a.x=b.x left outer join c on b.y=c.y left outer join d on d.z=a.z inner join a.t=e.t I know how single outer or inner join works in sql. But I don't really understand when there are multiple of them. can... (0 Replies)
Discussion started by: robbiezr
0 Replies

9. Shell Programming and Scripting

join (pls help on join command)

Hi, I am a new learner of join command. Some result really make me confused. Please kindly help me. input: file1: LEO oracle engineer 210375 P.Jones Office Runner ID897 L.Clip Personl Chief ID982 S.Round UNIX admin ID6 file2: Dept2C ID897 6 years Dept5Z ID982 1 year Dept3S ID6 2... (1 Reply)
Discussion started by: summer_cherry
1 Replies
Login or Register to Ask a Question
cf(1)																	     cf(1)

   NAME
       cf - Confluence compiler

   SYNOPSIS
	   cf [options] [file] [arguments]

   DESCRIPTION
       Confluence  is  a functional programming language for reactive system design, including digital logic systems (ASIC, FPGA) and control ori-
       ented hard real-time software.

       The Confluence compiler (cf) translates a Confluence description into Verilog and VHDL (for digital logic synthesis), C (for simulation and
       software targets), and NuSMV (for formal verification, via model checking).

   OPTIONS
       -h OR -help Prints this information then exits.

       -b filename OR -base_env filename

	      Sets the base environment for the compilation.
		     Overrides the CF_ENV

	      environment variable.
		     If CF_ENV not defined and -base_env option not set, the base environment defaults to /usr/share/confluence/base.cf.

       -e integer OR -error_limit integer

	      Sets the maximum number of reported errors.
		     A negative number reports all errors.

       -c OR -compile_only Parses and compiles, but does not evaluate a program.

       -o name

	      Sets the output file name.
		     Default is out.fnf.

       -test Run the built in unit tests.

   ENVIRONMENT VARIABLES
       CF_ENV A filename that specifies the base environment (commonly base.cf).

       CF_LIB The directory location of the Confluence standard library (optional).

   VERSION
       0.10.6

   AUTHOR
       Tom Hawkins (tomahawkins@yahoo.com)

   SEE ALSO
       http://www.confluent.org/

   COPYRIGHT
       Copyright (C) 2003-2005 Tom Hawkins

								  31 January 2010							     cf(1)