机器学习—如何创建含又NaN的二维矩阵以及如何修改

import numpy as np
import pandas as pd
t=pd.DataFrame(np.arange(24).reshape((4,6)),index=list("ABCD"),columns=list("UVWXYZ"))
t.loc["D","W"]=np.nan
t.loc["A","Z"]=np.nan
t.loc["B","Y"]=0
t.loc["A","U"]=np.nan
t
      U   V     W   X   Y     Z
A   NaN   1   2.0   3   4   NaN
B   6.0   7   8.0   9   0  11.0
C  12.0  13  14.0  15  16  17.0
D  18.0  19   NaN  21  22  23.0
t["Z"]=t["Z"].fillna(t["Z"].mean())
t["W"]=t["W"].fillna(t["W"].mean())
t["U"]=t["U"].fillna(t["U"].mean())
t
      U   V     W   X   Y     Z
A  12.0   1   2.0   3   4  17.0
B   6.0   7   8.0   9   0  11.0
C  12.0  13  14.0  15  16  17.0
D  18.0  19   8.0  21  22  23.0
t.loc["D","W"]=np.nan
t.loc["A","Z"]=np.nan
t.loc["A","U"]=np.nan
print(t)
      U   V     W   X   Y     Z
A   NaN   1   2.0   3   4   NaN
B   6.0   7   8.0   9   0  11.0
C  12.0  13  14.0  15  16  17.0
D  18.0  19   NaN  21  22  23.0
t.dropna(axis=1,how="any")
    V   X   Y
A   1   3   4
B   7   9   0
C  13  15  16
D  19  21  22
t.dropna(axis=0,how="any")
      U   V     W   X   Y     Z
B   6.0   7   8.0   9   0  11.0
C  12.0  13  14.0  15  16  17.0