Question to Loc

[Jack_Sparrow]

Hi there,
this is my table:
State Gender Year Top Name Occurences
0 AK F 1910 Mary 14
1 AK F 1911 Mary 12
2 AK F 1912 Mary 9

(Tha table has a lot of different names, state etc.)

I want to select the column "Top Name", where Name == Michael.
This is my code:
df= babynames.loc[babynames.'Top Name'=='Michael', :]

The problem is, that this column name has an "escape" Top_Name
So I don't know how to write this in my code...

Thank you!
J

[volcano63]

....

df= babynames.loc[babynames.'Top Name'=='Michael', :]

This should have given you exception. You may use dot reference to a column only if it can be tokenized to a legal Python name - which is not the case. Second selector is redundant

df= babynames.loc[babynames['Top Name']=='Michael']

will do the trick

PS And now mods will give you grief for bad formatting - and they will be right

[Jack_Sparrow]

Great! Thank you!