Easy method to move rows from df to another with coditions?

Question

ListOfNames = ['AA', 'BA', CF']

df:

ID Name Gene Chr Info
1  DD   S     3   441
2  AA   S     5   444
3  DD   F     3   744
4  DD   VV    1   448
5  BA   S     3   445

I need to delete all rows from Name same like in a list and move it to another df.

I do something like that:

newDF= pd.DataFrame()
for i in range(len(ListOfNames )):
    a = df.where(df.Name == ListOfNames[i]).dropna()
    newDF= newDF.append(a[0:])

In old df should stay all rows without deleted. Deleted should be move to new df. My code return empty df and I don't know why.

If I run:

a = df.where(df.Name == ListOfNames[1]).dropna()

I got normally row from df with AA name.

Why it's doesn't works?

Possible duplicate of [Select rows from a DataFrame based on values in a column in pandas](https://stackoverflow.com/questions/17071871/select-rows-from-a-dataframe-based-on-values-in-a-column-in-pandas) — razdi, Jul 31 '19 at 06:31

score 3 · Accepted Answer · answered Jul 31 '19 at 06:30

3

Use the isin function:

df = df[~df.Name.isin(ListOfNames)]

answered Jul 31 '19 at 06:30

Ankur Sinha

2

Damn, so simple... Thank u very much. I need to more practice with pandas to not `for`ed everything :D – martin Jul 31 '19 at 06:33

1 Answers1