How to add data from one dataframe to another using Pandas transpose?

Question

Objective: to fill in one dataframe with another using transpose

df = pd.DataFrame({'Attributes': ['love', 'family','tech']})
df.T

Produces this output:

               0         1     2
Attributes  love    family  tech

Secondarily, I have another dataframe that is empty:

data = pd.DataFrame(columns = ['Attribute_01',
                'Attribute_02',
                'Attribute_03']

I would like to bring the two dataframes together to produce the following:

Attribute_01  Attribute_02  Attribute_03
love          family        tech

cs95 · Accepted Answer · 2018-03-22 02:36:08Z

4

Setup

df
  Attributes
0       love
1     family
2       tech

Option 1
rename

df.T.rename(dict(enumerate(data.columns)), axis=1)

           Attribute_01 Attribute_02 Attribute_03
Attributes         love       family         tech

Option 2
set_index

df.set_index(data.columns).T

           Attribute_01 Attribute_02 Attribute_03
Attributes         love       family         tech

answered Mar 22, 2018 at 2:36

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Comments

BENY · Accepted Answer · 2018-03-22 02:36:00Z

3

I think you just need to change the column name in df1

df.columns=data.columns
df
Out[741]: 
           Attribute_01 Attribute_02 Attribute_03
Attributes         love       family         tech

answered Mar 22, 2018 at 2:36

BENY

324k22 gold badges176 silver badges250 bronze badges

Comments

jpp · Accepted Answer · 2018-03-22 02:28:06Z

0

Use .loc accessor to set the first row of data using a listified df['Attributes'].

data.loc[0] = df['Attributes'].tolist()

Result:

  Attribute_01 Attribute_02 Attribute_03
0         love       family         tech

answered Mar 22, 2018 at 2:28

jpp

166k37 gold badges301 silver badges362 bronze badges

Collectives™ on Stack Overflow

How to add data from one dataframe to another using Pandas transpose?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related