Create new pandas dataframe from existing dataframe, using row numbers from another dataframe

Question

So I have one dataframe like this, let's call it df1:

       Column1   Column2   Column3  
1258   .51       .38       .12

2674   .76       .21       .45

3098   .89       .34       .19

6012   .91       .78       .67

Then I also have another dataframe, let's call it df2, with about 10000 rows.

       a    b   c   d
0      0    1   0   0  
1      1    1   1   0
2      0    0   0   1
3      0    0   1   1
...
10000  1    1   0   1

Is there a way I can create a new dataframe from df2 with the row numbers from df1? So the output dataframe would be like this:

      a   b   c   d
1258  0   1   0   1
2674  1   0   0   1
3098  0   1   1   1
6012  1   0   0   0

Quang Hoang · Accepted Answer · 2019-12-02 16:39:50Z

2

IIUC, this is loc

df2.loc[df1.index]

answered Dec 2, 2019 at 16:39

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Comments

ansev · Accepted Answer · 2019-12-02 16:43:28Z

1

We can also use DataFrame.reindex:

df2.reindex(index=df1.index)

answered Dec 2, 2019 at 16:43

ansev

31k5 gold badges21 silver badges33 bronze badges

Comments

Benoit de Menthière · Accepted Answer · 2019-12-02 16:38:54Z

0

what about :

df2[df2.index.isin(df1.index)]

answered Dec 2, 2019 at 16:38

Benoit de Menthière

7334 silver badges14 bronze badges

Collectives™ on Stack Overflow

Create new pandas dataframe from existing dataframe, using row numbers from another dataframe

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related