Convert Series to Dataframe where series index is Dataframe column names

Question

I am selecting row by row as follows:

for i in range(num_rows):
    row = df.iloc[i]

as a result I am getting a Series object where row.index.values contains names of df columns.

But I wanted instead dataframe with only one row having dataframe columns in place.

When I do row.to_frame() instead of 1x85 dataframe (1 row, 85 cols) I get 85x1 dataframe where index contains names of columns and row.columns outputs

Int64Index([0], dtype='int64').

But all I want is just original data-frame columns with only one row. How do I do it? Or how do I convert row.index values to row.column values and change 85x1 dimension to 1x85

BENY · Accepted Answer · 2019-08-01 01:21:42Z

2

You just need to adding T

row.to_frame().T

Also change your for loop with adding []

for i in range(num_rows):
    row = df.iloc[[i]]

answered Aug 1, 2019 at 1:21

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Convert Series to Dataframe where series index is Dataframe column names

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related