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

Question

数据

a	b	c	d
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'}

a	b	c	d
1	1	1	'ProcessInfo0': 'abcd'
1	1	1	'ProcessInfo1': 'cdef'
1	1	1	'ProcessInfo2': 'fghf'
2	2	2	'ProcessInfo0': 'abyd'
2	2	2	'ProcessInfo1': 'cdse'
2	2	2	'ProcessInfo2': 'fghh'
3	3	3	'ProcessInfo0': 'atbc'
3	3	3	'ProcessInfo1': 'cdue'
3	3	3	'ProcessInfo2': 'fgih'
4	4	4	'ProcessInfo0': 'a1bc'
4	4	4	'ProcessInfo1': 'cdbe'
4	4	4	'ProcessInfo2': 'fgkh'
5	5	5	'ProcessInfo0': 'ablc'
5	5	5	'ProcessInfo1': 'cnde'
5	5	5	'ProcessInfo2': 'fgmh'

我想要达到的结果

Answer 1

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

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)