擅长:python、mysql、java
<p>还有其他选择,如切片列和追加,但这非常简单</p>
<pre><code>output = []
for index, row in df.iterrows():
r = row.dropna().values
if len(r) <= 4:
output.append([index,*r])
else:
for x in np.reshape(r, (int(len(r)/4),4)):
output.append([index,*x])
pd.DataFrame(output).set_index(0)
</code></pre>