How to get a value from a Pandas DataFrame and not the index and object type

Say I have the following DataFrame

    Letter    Number
    A          1
    B          2
    C          3
    D          4

Which can be obtained through the following code

    import pandas as pd

    letters=pd.Series(('A', 'B', 'C', 'D'))
    numbers=pd.Series((1, 2, 3, 4))
    keys=('Letters', 'Numbers')
    df=pd.concat((letters, numbers), axis=1, keys=keys)

Now I want to get the value C from the column Letters.

The command line

    df[df.Letters=='C'].Letters

will return

    2    C
    Name: Letters, dtype: object

How can I get only the value C and not the whole two line output?

    df[df.Letters=='C'].Letters.item()

This returns the first element in the Index/Series returned from that selection. In this case, the value is always the first element.

EDIT:

Or you can run a loc() and access the first element that way. This was shorter and is the way I have implemented it in the past.

From: stackoverflow.com/q/30787901