How to plot table from pandas dataframe
+2
−0
MWE
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.DataFrame(np.random.rand(9, 4), columns=['a', 'b', 'c', 'd'])
df.plot.bar(table=True) # don't want plot, just want table
# df.plot.table() # what I would hope
plt.show()
Question
How do I generate a table in its own figure from a pandas dataframe?
Notes
Notice the table appended to the graph above is hardly legible and gets cut off. I am not looking to fix legibility as is though, I need a separate figure for use in a paper.
I do not want to have to mess with generating matplotlib axes objects like for pandas.plotting.table() or in this example.
I want to be able to create the table just using and providing the df, as opposed to manually formatting the data into a latex table.
1 answer
+3
−0
Works for me
The following users marked this post as Works for me:
| User | Comment | Date |
|---|---|---|
| young_souvlaki | (no comment) | Aug 2, 2022 at 00:42 |
If you want a table for including in a latex document, then DataFrame.to_latex should be the best way.
import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.rand(9, 4), columns=['a', 'b', 'c', 'd'])
print(df.to_latex())
Output:
\begin{tabular}{lrrrr}
\toprule
{} & a & b & c & d \\
\midrule
0 & 0.883901 & 0.910674 & 0.306624 & 0.470303 \\
1 & 0.922612 & 0.219801 & 0.611842 & 0.743910 \\
2 & 0.996779 & 0.379242 & 0.674361 & 0.782147 \\
3 & 0.765185 & 0.011737 & 0.884637 & 0.162817 \\
4 & 0.845882 & 0.916658 & 0.244468 & 0.497107 \\
5 & 0.304585 & 0.047682 & 0.180011 & 0.399425 \\
6 & 0.720945 & 0.906463 & 0.845129 & 0.151063 \\
7 & 0.998912 & 0.631897 & 0.504105 & 0.633605 \\
8 & 0.523401 & 0.322309 & 0.507168 & 0.843320 \\
\bottomrule
\end{tabular}
0 comment threads
1 comment thread