df['Year']=pd.to_numeric(df.MixCol,errors='coerce').ffill().astype(int)
df=df.loc[pd.to_numeric(df.MixCol,errors='coerce').isnull()]
df
Out[86]:
MixCol Year
1 January 2017
2 February 2017
4 January 2018
5 February 2018
数据输入
MixCol
2017
January
February
2018
January
February
2019
与
to_numeric
一起使用ffill
数据输入
相关问题 更多 >
编程相关推荐