I try to use new-style formatting to display the entry at a given/specified column:
np.random.seed(1234)
df = pd.DataFrame(np.random.randint(7, size=(2, 2)), columns=['a', 'b'])
c = df.iloc[0, :] # get row number 0
print("Here is {one[0]} and {two}".format(one=c, two=c['b'])) # Ok
But I'd like to do it as follows:
print("Here is {one['a']} and {two}".format(one=c, two=c['b'])) ## Unfortunately KeyError: "'a'"
Is it possible to do that and how?
I think you can remove '' in one['a']:
print("Here is {one[a]} and {two}".format(one=c, two=c['b']))
Here is 3 and 6
You can use loc to get the value of column a.
print("Here is {one} and {two}".format(one=c.loc['a'], two=c['b']))
Here is 3 and 6
You can also do it this way.
df['sum'] = df.sum(axis=1)
n = 0 # Get the first row.
>>> "{row[a]} and {row[b]} makes {row[sum]}".format(row=df.iloc[n, :])
'3 and 6 makes 9'
two=c['b'] while I just want to specify the correct column in the format string.
format() section and any formatting applied to it should go in the brackets, eg. {one: %.2f}. Although technically possible, you should not specify your data in the string itself. docs.python.org/2/library/string.html#formatstrings{0}, {2}, etc. or named arguments (e.g. {one}, {two}, etc). You then specify the formatting of that data, eg. ""Here is {one:.2f} and {two:%}". Here is PEP 3101 which explains in detail the rational for the change. python.org/dev/peps/pep-3101