add one row from another dataframe in pandas

Question

Here's the thing, I need to put one row from other dataframe to the top of main dataframe in pandas, above first row where are columns named.

Sample :

       1value  2value 3value 4value 5value
acity    4       3       6      2     6
bcity    2       6       6      4     1
ccity    5       11      53     6     3
dcity    5       1       4      6     3 
gcity    6       4       2      7     4

And the other sample:

1value 2value 3value 4value 5value
 2       5       2      6     3

And now I need to add value of second sample to the top of first sample. Desired output:

         2       5       2      6     3 
      1value  2value 3value 4value 5value
acity    4       3       6      2     6
bcity    2       6       6      4     1
ccity    5       11      53     6     3
dcity    5       1       4      6     3 
gcity    6       4       2      7     4

And just for mention, I have about 3000 rows, and 250 columns in this Sample dataframe.

I don't have any code yet, I tried to find here something...

I'm not really sure what you mean, I'm a beginner, but here it is. Values from second sample(that is dataframe too) are reference values and that's the reason why that should be above the first row, where are names of columns. @Psidom — jovicbg
– jovicbg, Commented Mar 24, 2017 at 17:04

akuiper · Accepted Answer · 2017-03-24 17:03:58Z

1

Not sure if this is what you need, but a multi index data frame looks like the output:

df1 or second sample:

df or the first sample:

Rename the columns with a multi-index columns:

df.columns = pd.MultiIndex.from_arrays([df1.values[0], df.columns])

answered Mar 24, 2017 at 17:03

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

5 Comments

jovicbg Over a year ago

Yeah, that's it, but I just have problem called : unhashable type: 'dict'

akuiper Over a year ago

I can't reproduce the problem. Are the two samples both data frames?

jovicbg Over a year ago

Yes, both are data frames. Type of both is pandas.core.frame.DataFrame

akuiper Over a year ago

You might have some issues somewhere else. I can't think of a way this can cause a unhashable error.

jovicbg Over a year ago

Okey, thank you anyway, this code is what I have look for. :)

Collectives™ on Stack Overflow

add one row from another dataframe in pandas

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related