我將此資料框作為串列：
l = [["a",1,2,"","",""],["a",1,2,3,"",""], ["a","",2,"3","4",""],["a",1,"","",4,5]]
我想結合所有這些行來獲得最后一行：
理想情況下，我會展平串列串列以在需要時填充空白值。這樣做的pythonest方法是什么？
uj5u.com熱心網友回復：
嘗試：
import pandas as pd
import numpy as np
l = [["a",1,2,"","",""],["a",1,2,3,"",""], ["a","",2,"3","4",""],["a",1,"","",4,5]]
df = pd.DataFrame(l)
df.replace('',np.nan).ffill().tail(1)
df_out = df.replace('', np.nan).ffill().tail(1)
print(df_out)
輸出：
0 1 2 3 4 5
3 a 1.0 2.0 3 4 5.0
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/434722.html