擅长:python、mysql、java
<p>将<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html" rel="nofollow noreferrer">^{<cd1>}</a>与<code>sheet_name=None</code>一起用于数据帧字典中的所有图纸名称:</p>
<pre><code>dfs = pd.read_excel('a.xlsx', sheet_name=None, header=None)
print (dfs)
OrderedDict([('Bob', 0
0 a
1 b
2 c), ('Fed', 0
0 a1
1 b1
2 c1), ('Raj', 0
0 a1
1 b2
2 c2)])
</code></pre>
<p>然后通过<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html" rel="nofollow noreferrer">^{<cd3>}</a>连接在一起:</p>
<pre><code>df = pd.concat(dfs, axis=1)
print (df)
Bob Fed Raj
0 0 0
0 a a1 a1
1 b b1 b2
2 c c1 c2
</code></pre>
<p>最后通过<code>join</code>将行连接在一起,并转换为一列<code>DataFrame</code>:</p>
<pre><code>df1 = df.apply(' / '.join, axis=1).to_frame('out')
print (df1)
out
0 a / a1 / a1
1 b / b1 / b2
2 c / c1 / c2
</code></pre>