import glob
import os
import operator
hash={}
d=0
for file in glob.glob("file*"):
for n,line in enumerate(open(file)):
line=line.rstrip()
sl=line.split()
if not sl[0] in hash: d+=1
hash.setdefault(sl[0],[d])
hash[sl[0]].append(sl[-1])
for i in sorted(hash.iteritems(), key=operator.itemgetter(1)):
print "%s\t%s" % ( i[0],'\t'.join(i[1][1:]))
hi
i need to select a few columns of two txt files and write it to a new file. there is one common field for both of these files.
plz help me in this
thanks in advance (4 Replies)
Hello!
I wan't to extract columns from two files and later combine them for plotting with gnuplot. If the files file1 and file2 look like:
fiile1:
a, 0.62,x
b, 0.61,x
file2:
a, 0.43,x
b, 0,49,x
The desired output is
a 0.62 0.62
b 0.61 0.49
Thank you in advance! (2 Replies)
Hi,
I want to select columns from multiple files and combine them in one file. The files are simulation-data-files with 23 columns each and about 50 rows. I now use:
cut -f 11 Sweep?wing-30?scale=0.?0?fan2?.txt | pr -3 | awk '{printf("\n%s\t%s\t%s",$1,$2,$3)}' > ../Data_Processed/output.txtI... (1 Reply)
Hi there!
I have the following problem:
I have a set of files called rates_op_yyyyddmm with the format below (which corresponds to the file rates_op_20090130)
30-JAN-2009,ED,FEB09,C,96.375,,,0,,,,,,2.375,,,,,,
30-JAN-2009,ED,FEB09,C,96.5,,,0,,,,,,2.25,,,,,,... (2 Replies)
Hi everyone,
I got a problem with merging files and hoped one of you would have an idea how to approach this issue. I tried it with awk, but didn't get far. This is what I have:
I got 40 files looking like the ones below. All have three columns but the number of rows differs (20000 to 50000).... (6 Replies)
Hi,
I have two text files that I would like to merge/join. I would like to join them if the first columns of both text files match and the second column of the first text file matches the third column of the second text file.
Example input:
First file:
1334 10 0 0 1 5.2
1334 12 0 0 1 4.5... (4 Replies)
Hi guys,
I have very basic linux experience so I need some help with a problem.
I have 3 files from which I want to extract columns based on common fields between them.
File1:
--- rs74078040 NA 51288690 T G 461652 0.99223 0.53611 3
--- rs77209296 NA 51303525 T G 461843 0.98973 0.60837 3... (10 Replies)
Hi,
I am facing issues while accomplishing below task.
We have two files Test1.txt and Test2.txt. We have to match 1st column of Test1.txt file with 2nd column of Test2.txt and then merge 2nd file with the 1st file. In the output we should select column 1 and 2 from the 1st file and column 1... (5 Replies)
Discussion started by: Prathmesh
5 Replies
LEARN ABOUT DEBIAN
input
INPUT(5) File Formats Manual INPUT(5)NAME
input - input data file format
DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII
file, so can be edited manually if required. It is read by yagi or optimise. The program optimise also creates the same file format.
NOTES
FREQUENCY
MIN_FREQUENCY
MAX_FREQUENCY
STEP_FREQUENCY
ELEMENTS
DRIVEN
PARASITIC
ANGULAR_STEP
DATA_DRIVEN
DATA_PARASITIC
The
#
is used as a comment.
A typical file, for an antenna designed for the 2m amateur band (144-146
MHz) might be as shown below. Note:
1) Reflector is at position 0.0
2) All elements lengths/positions are in m.
NOTES This line can be up to 400 characters.
FREQUENCY 145.000000
MIN_FREQUENCY 144.000000
MAX_FREQUENCY 146.000000
STEP_FREQUENCY 0.100000
ELEMENTS 10
DRIVEN 1
PARASITIC 9
ANGULAR_STEP 180.000000
#DATA_DRIVEN x y length diameter voltage phase
DATA_DRIVEN 0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000
# DATA_PARASITIC x y length diameter
DATA_PARASITIC
0.00000 0.00000 1.01902 0.00630
0.49859 0.00000 0.95551 0.00630
1.07338 0.00000 0.93595 0.00630
1.81020 0.00000 0.92050 0.00630
2.58152 0.00000 0.91322 0.00630
3.30390 0.00000 0.91243 0.00630
4.03692 0.00000 0.90423 0.00630
4.64108 0.00000 0.89081 0.00630
5.37418 0.00000 0.83912 0.00630
FILES
filename ASCII description of antenna. filename.out binary file
SEE ALSO yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5).
AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov).
Yagi version 1.16 24th October 2000 INPUT(5)