How to transpose data frame

Question

I am working on a data frame which initially looks like :

         Date            Unnamed: 0  ...               Co             Ca
0           0                   NaN  ...              NaN            NaN
1  2022-01-21               Blablab  ...  33333333.333333  555555.555555
2  2022-01-21  BlaBlaBlaBlaBlaBlaBl  ...  44444444.444444  666666.666666

When I do :

MyData.iloc[-2]

It returns :

Name: 1, dtype: object
Date                2022-01-21
Unnamed: 0             Blablab
Unnamed: 1              WWWWWW
Unnamed: 2    123456789.123456
Co             33333333.333333
Ca               555555.555555

How would I get the below output :

1  2022-01-21               Blablab  ...  33333333.333333  555555.555555

I tried :

MyData.iloc[-2].T

But it is still in the same format ... What am I doing wrong ?

Somehow I don't understand your question - do you want to have all the records in one row? — teoML, Mar 29 '22 at 08:47

score 1 · Answer 1 · answered Mar 29 '22 at 08:49

1

This displays the row as you need it:

df.iloc[-2].to_frame().T

answered Mar 29 '22 at 08:49

vtasca

1,660
11
17

score 1 · Accepted Answer · answered Mar 29 '22 at 08:49

1

iloc[i] returns a Series, which outputs as you showed. You want to output it in the way DataFrame is output. It so happens that .iloc[i:j] is a DataFrame. Just make it a one-row one:

MyData.iloc[-2:-2+1]

answered Mar 29 '22 at 08:49

Amadan

191,408
23
240
301

Thank you, I am new to it so what would it be for the third row ? `MyData.iloc[-3:-2+2]` ? – TourEiffel Mar 29 '22 at 09:21

JED HK · Answer 3 · 2022-03-29T09:27:23.750

1

The problem you're encountering here is that when you use iloc. to isolate a row, it's being returned as a series (not a dataframe).

Whatever it is you're wanting to do with this information, it may be best to leave it as a series.

edited Mar 29 '22 at 09:27

answered Mar 29 '22 at 08:50

JED HK

216
1
8

How to transpose data frame

3 Answers3