Python，Zeep 对 pandas 的响应 [英] Python, Zeep response to pandas

问题描述

我正在尝试连接到 SOAP 网络服务并使用 Pandas 放在桌子上.

I am tryng to conenct to a SOAP webservice and use pandas to put in on a table.

Zeep 给我这个列表:

Zeep give me this list:

[{
    'ssPeca': '103',
    'ssQtd': '1',
    'ssUn': 'un'
}, {
    'ssPeca': '291A',
    'ssQtd': '8',
    'ssUn': 'un'
}, {
    'ssPeca': '406B',
    'ssQtd': '8',
    'ssUn': 'un'
}]

我的代码是这样的:

client = zeep.Client(wsdl=wsdl)
pecas=client.service.TabelaPecas("C-160","CR")

pd.DataFrame.from_dict(pecas)

该代码生成:

      0     1    2
0  ssPeca ssQtd ssUn 
1  ssPeca ssQtd ssUn 
2  ssPeca ssQtd ssUn 

但我想要这个:

      0     1    2
0    103    1   un 
1    291A   8   un 
2    406B   8   un 

有人可以帮忙吗?我只是 Python 初学者.

can anyone help? i am just a beginner in python.

推荐答案

它是这样工作的:

from zeep import Client
import pandas as pd

labels = ['Peça', 'Qtd']
desenho="C-160"
montagem="CR"

client = Client('xxxxxxxxxxxxxxxxxxxxxxxx')
resposta=list(client.service.TabelaPecas(desenho,montagem))

pecas=[]
for record in resposta:
    peca = record.ssPeca
    qtd  = record.ssQtd
    pecas.append([peca,qtd])


print('Desenho', desenho ,' Montagem', montagem)
pd.DataFrame(data=pecas,columns=labels ) 

可能是因为我是 Python 的初学者，这可能是一种解决方法，但适用于 zeep 响应.将 pd.DataFrame 与列表一起使用有效，但不适用于 zeep 响应.

Probably it is because i am a beginner in python and probably this is a workaround but works with the zeep response. Using pd.DataFrame with a list works but not with zeep response.

也许有一天会帮助像我这样的初学者.

Maybe some day will help a beginner like me.

这篇关于Python，Zeep 对 pandas 的响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！