is it possible to use Format String Syntax in pandas DataFrame?

Question

this code is to plot a table like a joint probability mass function.

data = np.arange(6).reshape(2,3)
summation = np.sum(data)
arr2 = np.empty((2,3), dtype='U30')
for i in range(len(data)):
    for j in range(len(data[0])):
        arr2[i][j] = r'$\dfrac{{{}}}{{{}}}$'.format(data[i][j] , summation)
pd.DataFrame(arr2)

is there params/settings in pandas DataFrame to plot this kind of table directly from data array?

something like this

pd.DataFrame(data, formatter=r'$\dfrac{{{}}}{{{}}}$'.format(data[i][j] , summation)

user7217806 · Accepted Answer · 2019-10-20 07:29:21Z

1

You could use applymap, e.g. (using an f-string):

pd = pd.applymap(lambda x: fr'$\dfrac{{{x}}}{{{summation}}}$')

Depending on your use case you could also have a look at Styling.

answered Oct 20, 2019 at 7:29

user7217806

2,1192 gold badges12 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

is it possible to use Format String Syntax in pandas DataFrame?

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