需要為每個(gè)符合以下條件的數(shù)據(jù)幀分配一個(gè)特定的IDfd = df[(df['B'].str.match('.*Color:.*') | df['B'].str.match('.*colorFUL:.*')) & df.A.isnull()]fd2 = df[(df['B'].str.match('.*Type:.*')) & df.A.isnull()]在輸出文件中，兩個(gè)數(shù)據(jù)幀都被寫(xiě)在另一個(gè)數(shù)據(jù)幀的下面。需要添加列 C，其中 ID“1”分配給 fd，ID“2”分配給 fd2。這將有助于過(guò)濾數(shù)據(jù)幀。這是當(dāng)前的輸出A Bnan this has Color:Rednan Color: Blue,red, greennan Color: Yellownan This has many colors. Color: green, red, Yellownan Filter oil Type: Synthetic Motor oilnan Oil Type : High Mileage Motor oil預(yù)期輸出A B Cnan this has Color:Red 1nan Color: Blue,red, green 1nan Color: Yellow 1nan This has many colors. Color: green, red, Yellow 1nan Filter oil Type: Synthetic Motor oil 2nan Oil Type : High Mileage Motor oil 2
1 回答
慕田峪4524236
TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超5個(gè)贊
添加新列 C 并根據(jù)與正則表達(dá)式匹配的數(shù)據(jù)幀為該列分配 ID“1”或“2”。
In [17]: df
Out[17]:
A B
0 NaN this has Color:Red
1 NaN Color: Blue,red, green
2 NaN Color: Yellow
3 NaN This has many colors. Color: green, red, Yellow
4 NaN Filter oil Type: Synthetic Motor oil
5 NaN Oil Type : High Mileage Motor oil
您構(gòu)造了兩個(gè)條件：
In [18]: one = (df['B'].str.match('.*Color:.*') | df['B'].str.match('.*colorFUL:.*')) & df.A.isnull()
In [19]: one
Out[19]:
0 True
1 True
2 True
3 True
4 False
5 False
dtype: bool
In [20]: two = (df['B'].str.match('.*Type:.*')) & df.A.isnull()
In [21]: two
Out[21]:
0 False
1 False
2 False
3 False
4 True
5 False
dtype: bool
這是制作新專(zhuān)欄的一種方法。
In [22]: df['C'] = 0
使用條件的布爾系列根據(jù)這些條件分配值。
In [23]: df.loc[one,'C'] = 1
In [24]: df.loc[two,'C'] = 2
In [25]: df
Out[25]:
A B C
0 NaN this has Color:Red 1
1 NaN Color: Blue,red, green 1
2 NaN Color: Yellow 1
3 NaN This has many colors. Color: green, red, Yellow 1
4 NaN Filter oil Type: Synthetic Motor oil 2
5 NaN Oil Type : High Mileage Motor oil 0
如果 df 是輸入數(shù)據(jù)幀，fd 是與模式匹配的輸出數(shù)據(jù)幀，如何直接將 id 分配給 fd 而不進(jìn)行布爾檢查
fd = df.loc[one]
fd['C'] = 1
添加回答
舉報(bào)
0/150
提交
取消