擅长:python、mysql、java
<p>您可以按<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.iloc.html" rel="nofollow noreferrer">^{<cd1>}</a>选择前2行,并用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.fillna.html" rel="nofollow noreferrer">^{<cd3>}</a>替换{<cd2>}s。在</p>
<p>然后按空格连接,但需要按<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.strip.html" rel="nofollow noreferrer">^{<cd4>}</a>删除尾随空格:</p>
<pre><code>cols = df.iloc[:2].fillna('')
df.columns = (cols.iloc[0] + ' ' + cols.iloc[1]).str.strip()
df = df.iloc[2:]
print (df)
A D B E C F
2 one two three four
3 five six sev egght
</code></pre>
<p>或者最好将所有非<code>NaN</code>的值与<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.apply.html" rel="nofollow noreferrer">^{<cd6>}</a>和{a5}连接起来:</p>
^{pr2}$