1 回答

TA贡献1744条经验 获得超4个赞
如果可能,请使用一个元素仅列出标量,创建标量/列表字典并传递给DataFrame构造函数 - 所有列表必须具有相同的长度:
orderNumber = '123456789'
countryOfOrigin = 'United Kingdom'
sizeList = ['2', '4']
quantityList = ['10', '12']
d = {"OrderNumber": orderNumber, "COO":countryOfOrigin, "Size":sizeList, "QTY":quantityList}
order = pd.DataFrame(d)
print (order)
OrderNumber COO Size QTY
0 123456789 United Kingdom 2 10
1 123456789 United Kingdom 4 12
如果输入总是列表,您可以使用一些预处理:
orderNumber = ['123456789']
countryOfOrigin = ['United Kingdom']
sizeList = ['2', '4']
quantityList = ['10', '12']
vals = [orderNumber, countryOfOrigin, sizeList, quantityList]
header = ["OrderNumber", "COO", "Size", "QTY"]
d = {a: b[0] if len(b) == 1 else b for a, b in zip(header, vals)}
order = pd.DataFrame(d)
print (order)
OrderNumber COO Size QTY
0 123456789 United Kingdom 2 10
1 123456789 United Kingdom 4 12
添加回答
举报