Converting csv row into csv columns

Question

Hello I am trying to make one csv from another csv file.

Below is my input file in csv.

1  2
3  4
5  6

And my desired output like

Basically I am trying to convert each row into column.

csvfile = open('main.csv', 'r')
textcsv = csv.reader(csvfile, delimiter=',')


for row in textcsv:
    list_ = list(row)
    column = pd.DataFrame(list_)
    outputDF = pd.concat([outputDF, column], axis=1)
outputDF.to_csv(output.csv, sep=',',  index=False)

I got the output which convert row in column but not repeated.

You desired input and output look equals. Are you trying to transpose the dataframe? Or do you want a single column as output? — Valentino
– Valentino, Commented Sep 8, 2019 at 21:28
@Valentino its not same. It's kind of multiple column. Each row value will be new column. — Shamji Solanki
– Shamji Solanki, Commented Sep 8, 2019 at 22:06

Trenton McKinney · Accepted Answer · 2019-09-08 22:07:36Z

2

Use `pd.DataFrame.stack`:

df = pd.read_csv('test.csv')
print(df)

df2 = pd.DataFrame(df.stack())
df2.reset_index(inplace=True, drop=True)
print(df2)

df2.to_csv('output.csv', sep=',',  index=False)

edited Sep 8, 2019 at 22:07

answered Sep 8, 2019 at 21:38

Trenton McKinney

63.2k41 gold badges169 silver badges212 bronze badges

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

3 Comments

Shamji Solanki Over a year ago

Thanks but I want multiple type of output. Like each row convert into column.

Trenton McKinney Over a year ago

@ShamjibhaiSolanki Updated with .stack

Shamji Solanki Over a year ago

Voyla its something helpful. Thanks buddy.

Collectives™ on Stack Overflow

Converting csv row into csv columns

1 Answer 1

Use `pd.DataFrame.stack`:

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Use pd.DataFrame.stack:

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related

Use `pd.DataFrame.stack`: