How to display multiple DataFrames like subplot [duplicate]

Question

I have a bunch of DataFrames to work on (let's say 8 DataFrames) and it is very confusing to run .head() line by line for looking the structure of data.

Then, I found this thread yet still not the answer that I want because it is difficult to look since it represents as 1 row, multiple columns and does not show DataFrames' names

Is there such a way to display more than 2 DataFrames which can specify the number of rows and columns to show like subplot of matplotlib in only one cell code?

For example, I want to display my 8 DataFrames into 2 rows, 4 columns:

   #name_df1           #name_df2           #name_df3           #name_df4
--|---------|--     --|---------|--     --|---------|--     --|---------|--
  |         |         |         |         |         |         |         |
  |   df1   |         |   df2   |         |   df3   |         |   df4   |
  |         |         |         |         |         |         |         |
--|---------|--     --|---------|--     --|---------|--     --|---------|--


   #name_df5           #name_df6           #name_df7           #name_df8
--|---------|--     --|---------|--     --|---------|--     --|---------|--
  |         |         |         |         |         |         |         |
  |   df5   |         |   df6   |         |   df7   |         |   df8   |
  |         |         |         |         |         |         |         |
--|---------|--     --|---------|--     --|---------|--     --|---------|--

Thank you in advance

If the answers in the duplicate doesn't solve your problem, then provide a Minimal, Complete, and Verifiable example — Sheldore
– Sheldore, Commented Jun 23, 2019 at 14:11

Ian-Fogelman · Accepted Answer · 2019-06-23 14:03:02Z

1

I think that this is what your asking:

import matplotlib.pyplot as plt
import pandas as pd
import numpy as np

df1 = pd.DataFrame(np.random.rand(19,2), columns=['A', 'B'])
df2 = pd.DataFrame(np.random.rand(19,2), columns=['A', 'B'])

fig, axes = plt.subplots(nrows=2, ncols=4)
df1.plot(ax=axes[0,0])
df1.plot(ax=axes[0,1])
df1.plot(ax=axes[0,2])
df1.plot(ax=axes[0,3])
df2.plot(ax=axes[1,0])
df2.plot(ax=axes[1,1])
df2.plot(ax=axes[1,2])
df2.plot(ax=axes[1,3])

answered Jun 23, 2019 at 14:03

Ian-Fogelman

1,6151 gold badge11 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to display multiple DataFrames like subplot [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related