How to print row x without knowing the index in pandas

Question

I have a Dataframe with 45 columns and 11k rows. This dataframe consist of players. Columns displaying their name, player_id, rating, height etc. Pretend you have the name of a player in the dataframe, or their ID, and you want to access the entire row of that player. You want to see all the information of that individual, but you only have one unique identifyer.

I tried using df.loc[[id_number]], but that only takes me to the index of the dataframe, which does not correspond to player_id.

Hopefully I explained it well enough. If you have any questions, please post them below.

Answer 1

df.loc[df['column_name'] == some_value]

Related to https://stackoverflow.com/a/17071908/17487637

Answer 2

You can try applying a mask:

df[df.playerId == id_number]

Assuming playerId is the name of the column containing the player ids.