如何在python中将字符串转换为数据帧

Question

我有这根绳子

“id=IAfpK，val=58，id=WNVdi，val=64，id=jp9zt，val=47”

。我想用它创建一个熊猫数据框。有什么办法吗

Answer 1

import pandas as pd

data = "id=IAfpK, val=58, id=WNVdi, val=64, id=jp9zt, val=47"

data = [*map(lambda x: x.split('='), data.split(', '))]
ids = [*filter(lambda x: x[0] == 'id', data)]
vals = [*filter(lambda x: x[0] == 'val', data)]

df = pd.DataFrame.from_dict(
    data={
        'id': [*map(lambda x: x[1], ids)],
        'val': [*map(lambda x: x[1], vals)]
    }
)