我在名為“Features”的 csv 中有資料，格式如下：
0 [Shops: Close by, Passing trade: Yes]
1 [Lift: Yes, No of Bedrooms: 1, Bedroom 1 Dims:...
2 [Lift: Yes, No of Bedrooms: 2, Bedroom 1 Dims:...
3 [No of Bedrooms: 4, Bedroom 1 Dims: 4.80 x 5.0...
4 [Finish: Excellent, Airconditioning: Yes, Shop...
...
并想為臥室數量創建新的 pandas 列。
0 [N/A]
1 [1]
2 [2]
3 [4]
4 [N/A]
...
我在python中嘗試過類似的東西：
csvname['No of Bedrooms'] = [s for s in csvname['Features'] if 'No of Bedrooms' in s]
這沒有用。有沒有一種簡單的方法可以做到這一點？任何幫助將不勝感激。
uj5u.com熱心網友回復：
你可以試試.str.extract
csvname['No of Bedrooms'] = csvname['Features'].astype(str).str.extract('No of Bedrooms: (\d )')
print(csvname)
Features No of Bedrooms
0 [Shops: Close by, Passing trade: Yes] NaN
1 [Lift: Yes, No of Bedrooms: 1, Bedroom 1 Dims:... 1
2 [Lift: Yes, No of Bedrooms: 2, Bedroom 1 Dims:... 2
3 [No of Bedrooms: 4, Bedroom 1 Dims: 4.80 x 5.0... 4
4 [Finish: Excellent, Airconditioning: Yes, Shop... NaN
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/473596.html
標籤：Python python-3.x 熊猫 数据框 数据争吵
上一篇：使用函式更新Panda資料框的值