transpose column to row - python

Question

How can I transpose the ouput of many rows to one row which is comma separated?

with open(filein, 'r') as rh:
    for line in rh:
        clm = line.split(',')[0] #Returns first column
        print(clm)

Current Output - Many Rows:

abc
def
ghi
jkl

Desired Output - One Row, Comma Separated:

abc,def,ghi,jkl

Valentin · Accepted Answer · 2015-07-16 17:59:34Z

1

In python 2.x, to suppress the automatic newline of print, add a trailing , (comma). Now a space will be used instead of a newline.

with open(filein, 'r') as rh:
    for line in rh:
        clm = line.split(',')[0] #Returns first column
        print clm, ',',

In python 3.x, add end=' ' argument:

with open(filein, 'r') as rh:
    for line in rh:
        clm = line.split(',')[0] #Returns first column
        print(clm, end=',')

answered Jul 16, 2015 at 17:59

Valentin

1,06616 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1