Removing rows in list of strings

Question

I am trying to remove a list of accounts from a CSV and delete/exclude whatever row they were in. The accounts are in two separate columns.

I've tried using isin to exclude them, but it just removes the strings and not the whole row.

import pandas as pd
cols = ['samaccountname', 'employeeid', 'manager', 'title']
df = pd.read_csv('accounts.csv', usecols=[0,1,2,4], header=0, names=cols)
acs = ['josmith', 'jesmith']

samaccountname employeeid manager title
josmith        12345      adsmith president
jpsmith        67890      jesmith advisor
jadoe          10000      jpsmith supervisor

Output should look like this.

samaccountname employeeid manager title
jadoe          10000      jpsmith supervisor

```cols = ['samaccountname', 'employeeid', 'manager', 'title'] df = pd.DataFrame([["josmith", 12345, "adsmith", "president"], ["jpsmith", 67890, "jesmith", "advisor"], ["jadoe", 10000, "jpsmith", "supervisor"]]) df.columns = cols acs = ['josmith', 'jesmith'] df = df[~df.samaccountname.isin(acs)] df = df[~df.manager.isin(acs)] print(df)``` — Konstantin Grigorov, Apr 10 '19 at 15:01
@KonstantinGrigorov That was what I was looking for, thanks very much. — pystackit, Apr 10 '19 at 15:15

score 0 · Answer 1 · answered Apr 10 '19 at 14:46

0

Try this. I have not tested

 print (df.tail(1))

answered Apr 10 '19 at 14:46

Bharath

113
1
1
10

2

I don't think this is what the OP is after – Alex W Apr 10 '19 at 14:46
This would print the last row from the dataframe – Bharath Apr 10 '19 at 14:51

Removing rows in list of strings

1 Answers1