Turn a DataFrame with multiple rows into a DataFrame with one row?

Question

I have a DataFrame that looks like this:

What I want is:

A_x	A_y	A_z	B_x	B_y	B_z
1	2	3	2	4	6

Is there a method in Python that allows me to do this? I tried pivot but I don't have an index - I only need one row.

Sunderam Dubey · Accepted Answer · 2022-05-30 16:01:27Z

4

Here is a simple way, using unstack and reworking the columns:

df2 = df.unstack().to_frame().T
df2.columns = df2.columns.map('_'.join)

output:

   A_x  A_y  A_z  B_x  B_y  B_z
0    1    2    3    2    4    6

Sunderam Dubey

8,83312 gold badges25 silver badges43 bronze badges

answered Aug 24, 2021 at 17:59

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

Scott Boston · Accepted Answer · 2021-08-24 18:08:08Z

3

Since @mozway had my exact answer here a different way:

df.unstack().to_frame().T.set_axis(
    ["_".join([a, b]) for a, b in pd.MultiIndex.from_product([df.columns, df.index])],
    axis=1,
)

Try:

dfi = df.unstack().to_frame().T
dfi.columns = dfi.columns.map('_'.join)
dfi

Output:

   A_x  A_y  A_z  B_x  B_y  B_z
0    1    2    3    2    4    6

answered Aug 24, 2021 at 17:59

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

:D we got synchronized!