Selecting data based on row index and cell value on Pandas

Question

I have a dataframe (df):

    a   b   c   d
0   G1  G2  G3  G4
1   1   2   3   4

I'd like to get the whole column data based on certain cell index (0) and cell content (G3) value:

input:

search("G3", df, 0)

output something like:

["c", "G3", 3]

How would you do that?

waitingkuo · Accepted Answer · 2014-04-25 10:10:27Z

1

I suggest that you can transpose your dataframe first and then do some simple compares:

In [14]: df.T[df.T[0] == 'G3']
Out[14]: 
    0  1
c  G3  3

answered Apr 25, 2014 at 10:10

waitingkuo

94.5k28 gold badges119 silver badges122 bronze badges

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

1 Comment

MarkokraM Over a year ago

Nice! How do you reach name c in this example? I get some object, and can't figure out go further... df.T[df.T[0] == 'G3'][0..3][0] seems to work for cells...

Collectives™ on Stack Overflow

Selecting data based on row index and cell value on Pandas

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related