关于#python#的问题：我想根据DLL这列的数据生成字符序列

Question

这里有两列数据，我想根据DLL这列的数据生成字符序列

DLL str
Nmapi.dll 1
magnification.dll 2
magnification.dll 3
Npptools.dll 4
magnification.dll 5
Nmapi.dll 6
Npptools.dll 7
Npptools.dll 8
Msdmo.dll 9
Requires W3Filter.dll. 10
Msdmo.dll 11
Msdmo.dll 12
AppProxyPSProvider.dll 13
AppProxyPSProvider.dll 14
Msdmo.dll 15
MSCoree.dll 16
MSCoree.dll 17

生成如下的结果：Nmapi.dll的字符序列为[1,6];magnification.dll的字符序列为[2,3,5];Npptools.dll的字符序列为[4,7,8];然后以此类推，我的数据有一万多行，该怎么用循环写出这样的效果

Answer 1

import pandas as pd

data = {"DLL": ['Nmapi.dll', 'magnification.dll', 'magnification.dll', 'Npptools.dll', 'magnification.dll', 'Nmapi.dll'],
        "str": [1, 2, 3, 4, 5, 6]}

df = pd.DataFrame(data=data)
x = df.groupby('DLL').apply(lambda x: (list(set(x['DLL']))[0], x['str'].to_list()))
for i in x:
    print(i[0], i[1])
"""
--result
Nmapi.dll [1, 6]
Npptools.dll [4]
magnification.dll [2, 3, 5]
"""