Pandas: create a new dataframe using the index values of other dataframe

Question

I have one data frame and I would like to create a second dataframe using only select index values from the first data frame.

for example:

If I wanted dataframe 2 to be only index values- (47,55,69) from dataframe 1 I would like all of the data within the row from each index value to be transferred

df2 = df.iloc[[47,55,69]] ?

Umar.H
– Umar.H

2020-05-02 20:31:31 +00:00
Commented May 2, 2020 at 20:31 — Umar.H
– Umar.H, Commented May 2, 2020 at 20:31
In addition, read the documentation carefully.

swiss_knight
– swiss_knight

2020-05-02 22:23:48 +00:00
Commented May 2, 2020 at 22:23 — swiss_knight
– swiss_knight, Commented May 2, 2020 at 22:23

Matthew Borish · Accepted Answer · 2020-05-03 18:37:05Z

3

There are several different options for slicing dfs. Using .iloc is one of the simpler ways for integer index selections and it has good performance. You can also use the .isin() method. It is generally a little slower than .iloc, although it offers additional flexibility for more complicated selection scenarios.

slice_list = [47,55,69]

df_2 = df_1.iloc[df_1.index.isin(slice_list)]

edited May 3, 2020 at 18:37

answered May 2, 2020 at 20:32

Matthew Borish

3,1162 gold badges18 silver badges29 bronze badges

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

1 Comment

Mark Rotteveel Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

Collectives™ on Stack Overflow

Pandas: create a new dataframe using the index values of other dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related