从数据帧中删除列中的某些特定关键字并将其保存到json

Question

如果数据帧有两列a和b，则必须从b列中的数据帧中删除前导141

a         b

mark     14150

john     14160

jack     14130

harry     14180

jacob     14110

如何从dataframe中删除前导141，然后像这样将dataframe保存到json

[{
        "a": "mark",
        "b": "50"
    },
    {
        "a": "john",
        "b": "60"

    }, {
        "a": "jack",
        "b": "30"

    }, {
        "a": "harry",
        "b": "80"
    },
    {
        "a": "jacob",
        "b": "10"

    }
]

Answer 1

要仅删除起始项141，需要使用regex 示例代码如下所示

df['b'] = df['b'].astype(str)
df.replace(to_replace={'b' : r'^141'}, value='', regex=True).to_json(orient='records')

这将为您提供以下输出

[{"a":"mark","b":"50"},{"a":"john","b":"60"},{"a":"jack","b":"30"},{"a":"harry","b":"80"},{"a":"jacob","b":"10"},{"a":"test","b":"241410"}]