TA貢獻1993條經驗 獲得超6個贊
你可能str.findall需要tolist()
前任：
data['geometry'].str.findall("(?<=\()\d.*(?=\))").tolist()演示：
df = pd.DataFrame({'geometry': ['aa (123) bb (1.5)', 'aa (123) bb (1.5)', 'aa (123) bb (1.5)', 'aa (123) bb (1.5)']})
print(df['geometry'].str.findall("(?<=\()(\d.*?)(?=\))").tolist())輸出：
[['123', '1.5'], ['123', '1.5'], ['123', '1.5'], ['123', '1.5']]
TA貢獻2036條經驗 獲得超8個贊
我通過使用循環得到了自己的解決方案：
location = []
for l in data['geometry']:
latlon = re.findall("(?<=\()\d.*(?=\))", l)
location.append(z)
df_latlon = DataFrame(location)
df_latlon
TA貢獻2012條經驗 獲得超12個贊
用途str.extract：
data['geometry'].str.extract(r'\((\d.*)\)', expand=False).tolist()
請參閱正則表達式演示
解釋
EXPLANATION
--------------------------------------------------------------------------------
\( '('--------------------------------------------------------------------------------
( group and capture to \1:
--------------------------------------------------------------------------------
\d digits (0-9)
--------------------------------------------------------------------------------
.* any character except \n (0 or more times
(matching the most amount possible))
--------------------------------------------------------------------------------
) end of \1--------------------------------------------------------------------------------
\) ')'舉報