如下图，我想把下面图中左边的数据转换为右边的数据

数据
abcd
111{'a':'123','ProcessInfo0': 'abcd', 'b':'123','c':'123','ProcessInfo1': 'cdef','d':'456','ProcessInfo2': 'fghf'}
222{'a':'123','ProcessInfo0': 'abyd', 'b':'123','c':'123','ProcessInfo1': 'cdse','d':'456','ProcessInfo2': 'fghh'}
333{'a':'123','ProcessInfo0': 'atbc', 'b':'123','c':'123','ProcessInfo1': 'cdue','d':'456','ProcessInfo2': 'fgih'}
444{'a':'123','ProcessInfo0': 'a1bc', 'b':'123','c':'123','ProcessInfo1': 'cdbe','d':'456','ProcessInfo2': 'fgkh'}
555{'a':'123','ProcessInfo0': 'ablc', 'b':'123','c':'123','ProcessInfo1': 'cnde','d':'456','ProcessInfo2': 'fgmh'}
abcd
111'ProcessInfo0': 'abcd'
111'ProcessInfo1': 'cdef'
111'ProcessInfo2': 'fghf'
222'ProcessInfo0': 'abyd'
222'ProcessInfo1': 'cdse'
222'ProcessInfo2': 'fghh'
333'ProcessInfo0': 'atbc'
333'ProcessInfo1': 'cdue'
333'ProcessInfo2': 'fgih'
444'ProcessInfo0': 'a1bc'
444'ProcessInfo1': 'cdbe'
444'ProcessInfo2': 'fgkh'
555'ProcessInfo0': 'ablc'
555'ProcessInfo1': 'cnde'
555'ProcessInfo2': 'fgmh'
我想要达到的结果

img

不知道你的原始数据是什么格式。
我写段按列表处理的代码给你参考。

import pandas as pd
data_list1 = [['1', '1', '1', {'a': '123', 'ProcessInfo0': 'abcd', 'b': '123', 'c': '123', 'ProcessInfo1': 'cdef', 'd': '456', 'ProcessInfo2': 'fghf'}]
    , ['2', '2', '2', {'a': '123', 'ProcessInfo0': 'abyd', 'b': '123', 'c': '123', 'ProcessInfo1': 'cdse', 'd': '456', 'ProcessInfo2': 'fghh'}]
    , ['3', '3', '3', {'a': '123', 'ProcessInfo0': 'atbc', 'b': '123', 'c': '123', 'ProcessInfo1': 'cdue', 'd': '456', 'ProcessInfo2': 'fgih'}]
    , ['4', '4', '4', {'a': '123', 'ProcessInfo0': 'a1bc', 'b': '123', 'c': '123', 'ProcessInfo1': 'cdbe', 'd': '456', 'ProcessInfo2': 'fgkh'}]
    , ['5', '5', '5', {'a': '123', 'ProcessInfo0': 'ablc', 'b': '123', 'c': '123', 'ProcessInfo1': 'cnde', 'd': '456', 'ProcessInfo2': 'fgmh'}]]

data_list = []
for item in data_list1:
    for k,v in item[3].items():
        if k.find("ProcessInfo")>=0:
            data_list.append([item[0],item[1],item[2],"{}:{}".format(k,v)])

df = pd.DataFrame(data_list)
df.columns = ['a', 'b', 'c', 'd']
print(df)

img