How to add table title in python preferably with pandas
Have you tried this doing this?
df.style.set_caption("Hello World")
Source: Pandas Styling
EDIT:
Here's an alternative way to present your table if you're okay with using matplotlib
import matplotlib.pyplot as plt
import pandas as pd
my_frame = pd.DataFrame(data={'simulation1':[71,4.8,65,4.7],
'simulation2':[71,4.8,69,4.7],
'simulation3':[70,3.8,68,4.9],
'experiment':[70.3,3.5,65,4.4]})
#my_frame Display pandas table
fig = plt.figure(figsize = (8, 2))
ax = fig.add_subplot(111)
ax.table(cellText = my_frame.values,
rowLabels = my_frame.index,
colLabels = my_frame.columns,
loc = "center"
)
ax.set_title("Top 10 Fields of Research by Aggregated Funding Amount")
ax.axis("off");
It appears this does not set the caption 'inplace', like:
df.reset_index(drop=True, inplace=True)
is the same as:
df = df.reset_index(drop=True)
Instead try:
df = df.style.set_caption('Top 10 Fields of Research by Aggregated Funding Amount')