我有一个警察的办公室:
import pandas as pd
column1 = [None,None,None,4,8,9,None,None,None,2,3,5,None]
column2 = [None,None,None,None,5,1,None,None,6,3,3,None,None]
column3 = [None,None,None,3,None,7,None,None,7,None,None,1,None]
df = pd.DataFrame(np.column_stack([column1, column2,column3]),columns=['column1', 'column2', 'column3'])
print(df)
column1 column2 column3
0 None None None
1 None None None
2 None None None
3 4 None 3
4 8 5 None
5 9 1 7
6 None None None
7 None None None
8 None 6 7
9 2 3 None
10 3 3 None
11 5 None 1
12 None None None
我希望将第3列中的值之间的行设为子集,并删除所有空行.我想要的结果是:
print (df1)
column1 column2 column3
0 4 None 3
1 8 5 None
2 9 1 7
print(df2)
column1 column2 column3
0 None 6 7
1 2 3 None
2 3 3 None
3 5 None 1
我不关心实际值列3.第3列的值用于指示"开始"和"停止".