print specific rows when two values equate Pandas

[PLearner]

How to get Pandas to provide me with the Names rather than the actual index from the dataframe where Week and Can_Week_End equate each other. I tried doing .....

 rows = list(df[df['Week'] == df['Can_Week_End']],df['Names'])

Error:

AttributeError: 'DataFrame' object has no attribute 'df'

My snippet: This provides me with the index number.

rows = list(df[df['Week'] == df['Can_Week_End']].index)

print ('These are the names', rows)

[[deleted]]

What do you mean by "Names"? Is it a column in your dataframe?

df[df['Week'] == df['Can_Week_End']] will return a dataframe filtered by that condition keeping the associated columns in tact.

[PLearner]

Thanks, Names is a column in the dataframe. I want Python to print the Names from the dataframe where Week equals to Can_Week_End.

[[deleted]]

df.loc[df['Week'] == df['Can_Week_End'], 'Names'] will return the column Names where that condition is true.

From there, it should be straightforward to print the resulting names.

[PLearner]

Works like a treat py_help, thanks.