python - How to organise columnar data into a network table -
i have tab delimited file text file 2 columns. need find way prints values “hit” each other 1 line.
for example, input looks this:
a b c d b c b d c d b e d e b f c f f g f h h k l
my desired output should this:
a b c d b d e b c f f g h h k l
my actual data file larger if makes difference. prefer in unix or python possible.
can help?
thanks in advance!
there's no way put input file .csv
? easier parse delimiters.
if wouldn't posible, try next example:
from itertools import groupby operator import itemgetter open('example.txt','rb') txtfile: cleaned = [] #store file information in list of lists line in txtfile.readlines(): cleaned.append(line.split()) #group py first element of nested list elt, items in groupby(cleaned, itemgetter(0)): row = [elt] item in items: row.append(item[1]) print row
hope helps you.
solution using .csv
file:
from itertools import groupby operator import itemgetter import csv open('example.csv','rb') csvfile: reader = csv.reader(csvfile, delimiter='\t') row in reader: cleaned.append(row) #group py first element of nested list elt, items in groupby(cleaned, itemgetter(0)): row = [elt] item in items: row.append(item[1]) print row
Comments
Post a Comment