如何將逗號分隔的值轉換為熊貓資料框中的整數串列?
輸入:

期望的輸出:

uj5u.com熱心網友回復:
有 2 個步驟 -split并轉換為整數,因為拆分后的值是字串串列,如果串列長度不同(未添加Nones),解決方案也能很好地作業:
df['qty'] = df['qty'].apply(lambda x: [int(y) for y in x.split(',')])
或者:
df['qty'] = df['qty'].apply(lambda x: list(map(int, x.split(','))))
替代解決方案:
df['qty'] = [[int(y) for y in x.split(',')] for x in df['qty']]
df['qty'] = [list(map(int, x.split(','))) for x in df['qty']]
uj5u.com熱心網友回復:
您可以.str.split(',')像下面這樣使用:
>>> df['qty'] = df['qty'].str.split(',').apply(lambda x: [int(i) for i in x])
uj5u.com熱心網友回復:
或嘗試expand=True:
df['qty'] = df['qty'].str.split(',', expand=True).astype(int).agg(list, axis=1)
uj5u.com熱心網友回復:
矢量化解決方案:
import ast
df["qty"] = ("[" df["qty"].astype(str) "]").apply(ast.literal_eval)
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/324841.html
