Create new Dataframe with rows from another Dataframe given the rows index

Asked Jan 09 '23 at 08:31

Active Jan 09 '23 at 08:31

Viewed 11 times

I have a pandas dataframe and I need to create a new dataframe only with the rows which satisfy a certain condition. I got these rows indexes using:

position = df.index[df.iloc[:, 0] == value].tolist()

How should I create the new dataframe using only the rows which indexes are in the position variable?

asked Jan 09 '23 at 08:31

Guillem

1

`df1 = df.loc[position]` ? – jezrael Jan 09 '23 at 08:32
1

`df1 = df[df.iloc[:, 0] == value]` – jezrael Jan 09 '23 at 08:33
1

That was just it! I did not really think about that, thank you so much! – Guillem Jan 09 '23 at 08:34

0 Answers0