using python to return linked values

Question

Sorry for a stupid question. I think I need some basics refreshed to answer a problem I'm trying to solve.

Say I'm reading a list in excel like

x	y
a	team a
b	team a
c	team b
d	team b

If I wanted to look up each x values' y companion using pandas in python, how would I go about this? I'm a little unfamiliar with the process of linking data.

For example looking up c would return team b.

EDIT I'm basically trying to figure out, if y column == team a, then print all of the x values corresponding to team a.

for i in teams:

    if Table.loc[(Table['x']==i)]:
    print(Table.loc[(Table['y'])])

It's notable that groupby is iterable. for name, g_df in df.groupby('y'): where name is the name group, team a, team b and g_df is the corresponding DataFrame with those values. — Henry Ecker
– Henry Ecker ♦, Commented Jul 25, 2021 at 22:52

Idr · Accepted Answer · 2021-07-25 22:53:27Z

1

df.where(df.y=='teama').dropna().x

answered Jul 25, 2021 at 22:53

Idr

6,2816 gold badges36 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

using python to return linked values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related