Reading a column value in Pandas Dataframe

Question

My df looks like:

ID     IntakeDate Quantity Converge
6001   3-Jul-52       WB        T
6001  17-May-57       WB        F
6001   3-Jul-52       AD        T
6001  17-May-57       AD        F

I want to read the 'Converge' column for IntakeDate == '3-Jul-52' and Quantity =='WB'. Here's my code:

df_1 = df.loc[(df['IntakeDate']=='3-Jul-52')]
df_2 = df_1.loc[(df_1['Quantity']=='WB')]
convergence = df_2.loc[df_2,'Converge']

Is there a better or easier way to do this?

jezrael · Accepted Answer · 2017-09-21 14:44:10Z

3

You can chain conditions with & for bitwise AND or | for bitwise OR:

df_1 = df.loc[(df['IntakeDate']=='3-Jul-52') & (df['Quantity']=='WB'), 'Converge']

Or use query:

df_1 = df.query("IntakeDate=='3-Jul-52' & Quantity=='WB'")['Converge']

print (df_1)
0    T
Name: Converge, dtype: object

answered Sep 21, 2017 at 14:44

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Zero Over a year ago

df.loc[(df['IntakeDate']=='3-Jul-52') & (df['Quantity']=='WB'), 'Converge'].item() or df.loc[(df['IntakeDate']=='3-Jul-52') & (df['Quantity']=='WB'), 'Converge'].iloc[0]

jezrael Over a year ago

I think there are possible 3 ways of output, so better is use this solution.

jezrael Over a year ago

and instead a = df.loc[df['Col 1'] == a, 'Col 2'] use a = df.loc[(df['IntakeDate']=='3-Jul-52') & (df['Quantity']=='WB'), 'Converge'] or a = df.query("IntakeDate=='3-Jul-52' & Quantity=='WB'")['Converge']

Collectives™ on Stack Overflow

Reading a column value in Pandas Dataframe

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related