我有一個具有以下結構的資料框：
[
{
"key1":"value1",
"key2":"2",
"key3":["a","b2","keep this exemple from work_text_reviews_count of 450"],
},
{
"key1":"value1",
"key2":"2",
"key3":[],
}
]
如何在不更改結構的情況下使用 pandas 從預定義字串中洗掉字串。
預定義字串= “來自 work_text_reviews_count of”
我要洗掉的文本“從 work_text_reviews_count of 450”
預期輸出：
[
{
"key1":"value1",
"key2":"2",
"key3":["a","b2","keep this exemple"],
},
{
"key1":"value1",
"key2":"2",
"key3":[],
}
]
uj5u.com熱心網友回復：
你在這里沒有太多選擇，只能回圈。
更新的問題：
pat = " from work_text_reviews_count of"
df['key3'] = [[x.split(pat)[0] for x in l] for l in df['key3']]
輸出：
key1 key2 key3
0 value1 2 [a, b2, keep this exemple]
1 value1 2 []
較舊的示例
要更新資料：
for l in df['details']:
for d in l:
if "average_rating" in d:
d["average_rating"] = d["average_rating"].split()[0]
輸出：
name details
0 Book1 [{'id': 30278752, 'isbn': ' 1594634025', 'average_rating': '3.92'}]
1 Book2 [{'id': 34006942, 'isbn': ' 1501173219', 'average_rating': '4.33'}]
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/446258.html
上一篇：如何根據另一個值重復列中的值