<p>我认为如果所有的df都具有相同的形状,那么将数据存储为<code>pandas.Panel</code>而不是DFs列表,这就是<a href="https://pandas-datareader.readthedocs.io/en/latest/remote_data.html" rel="nofollow">pandas_datareader</a>的工作原理</p>
<pre><code>import io
import pandas as pd
df1 = pd.read_csv(io.StringIO("""
Stock,Year,Profit,CountPercent
AAPL,2012,1,38.77
AAPL,2013,1,33.33
"""
))
df2 = pd.read_csv(io.StringIO("""
Stock,Year,Profit,CountPercent
GOOG,2012,1,43.47
GOOG,2013,1,32.35
"""
))
df3 = pd.read_csv(io.StringIO("""
Stock,Year,Profit,CountPercent
ABC,2012,1,40.0
ABC,2013,1,32.35
"""
))
store = pd.HDFStore('c:/temp/stocks.h5')
# i had to drop `Stock` column and make it Panel-Axis, because of ERROR:
# TypeError: Cannot serialize the column [%s] because its data contents are [mixed-integer] object dtype
# when saving Panel to HDFStore ...
p = pd.Panel({df.iat[0, 0]:df.drop('Stock', 1) for df in [df1,df2,df3]})
store = pd.HDFStore('c:/temp/stocks.h5')
store.append('stocks', p, data_columns=True, mode='w')
store.close()
# read panel from HDFStore
store = pd.HDFStore('c:/temp/stocks.h5')
p = store.select('stocks')
</code></pre>
<p>商店:</p>
^{pr2}$
<p>面板尺寸:</p>
<pre><code>In [19]: p['AAPL']
Out[19]:
Year Profit CountPercent
0 2012.0 1.0 38.77
1 2013.0 1.0 33.33
In [20]: p[:, :, 'Profit']
Out[20]:
AAPL ABC GOOG
0 1.0 1.0 1.0
1 1.0 1.0 1.0
In [21]: p[:, 0]
Out[21]:
AAPL ABC GOOG
Year 2012.00 2012.0 2012.00
Profit 1.00 1.0 1.00
CountPercent 38.77 40.0 43.47
</code></pre>