I am searching for a particular name in column 'names' and its value. for e.g, I want to search for string 'pqr' in column 'names' and get its values from 'Total' column, which is 304 so the final output is 304.
Input:
names Total
0 abc 186
1 xyz 545
2 pqr 304
3 lmn 405
4 def 0
Use DataFrame.loc with mask and then select for first match value converted values to array and select first one:
df.loc[df['names'] == 'pqr', 'Total'].to_numpy()[0]
#or select first match value by position
df.loc[df['names'] == 'pqr', 'Total'].iat[0]
Or for more general solution working also if no match use:
next(iter(df.loc[df['names'] == 'pqr', 'Total']), 'no match')
This code fits your example:
df[df['names'] == 'pqr']['Total']
df.loc[df['names']=='pqr','Total']
2 304
Name: Total, dtype: int64
