Find the column value based on condition

Question

I need to find unique name, whose age=2 and and cond=9 using python pandas?

Does this answer your question? [How to filter Pandas dataframe using 'in' and 'not in' like in SQL](https://stackoverflow.com/questions/19960077/how-to-filter-pandas-dataframe-using-in-and-not-in-like-in-sql) — INGl0R1AM0R1, Jun 24 '22 at 17:49

ArchAngelPwn · Answer 1 · 2022-06-24T18:56:38.587

1

This will find all distinct rows where age = 2 and cond = 9

df.loc[(df['age'] == 2) & (df['cond'] == 9)][['name', 'cc']].drop_duplicates()

edited Jun 24 '22 at 18:56

answered Jun 24 '22 at 17:35

ArchAngelPwn

i need unique value of column name..can you help me? – Jack Jun 24 '22 at 17:53
You just need the values of column 'name' where they are distinct? – ArchAngelPwn Jun 24 '22 at 17:56
yes...the unique column name value.. – Jack Jun 24 '22 at 18:20
Thankyou so much..if i need the column cc value with name..what i need to do? – Jack Jun 24 '22 at 18:48
Edited again to add cc to the list of columns to include – ArchAngelPwn Jun 24 '22 at 18:56
No problem, if this answers your question please make sure to make it as "answered" so that other seeking the same question can find an answer – ArchAngelPwn Jun 24 '22 at 19:06

CodeMonkey · Accepted Answer · 2022-06-27T22:00:51.483

1

The Pandas query function allows for SQL-like queries to filter a data frame. Then use unique() on the results to return the unique name.

rows = df.query('age == 2 and cond == 9')
print(rows["name"].unique())

For more query examples, see here.

edited Jun 27 '22 at 22:00

answered Jun 24 '22 at 17:57

CodeMonkey

score 0 · Answer 3 · edited May 18 '23 at 17:15

0

One potential solution is to put the columns in a zip() and then iterate through your dataframe like so:

for name, age, cond in zip(df['name'], df['Age'], df['cond']):
    if(age == 2 and cond ==9):
      print(name)

edited May 18 '23 at 17:15

pppery

answered Jun 24 '22 at 17:46

brendan baker

3 Answers3