回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在用零件号从网站上划掉价格。
逻辑是:</p>
<ol>
<li>输入零件编号列表</li>
<li>每个零件的价格将从网站上的数据库中返回</li>
<li>该部分属于五家公司之一,因此生成了5个不同的列表</李>
</ol>
<p>例如,下面是零件号的初始列表(输入):<br/>
b123<br/>
nadsf<br/>
功率<br/>
韦奥阿</p>
<p>他们各自属于一个公司:</p>
<pre><code>Part # Company A B C D
b123 1.5
nadsf 3.4
ower 47
weoa 33
</code></pre>
<p>现在csv的输出是:</p>
<pre><code> 0
0 1.5
1 0
2 0
3 0
0 0
1 3.4
2 0
3 0
0 0
1 0
2 33
3 0
0 0
1 0
2 0
3 47
0 0
1 0
2 0
3 0
</code></pre>
<p>我只想要一张单子而不是5张;所需输出为:</p>
<pre><code>0 1.5
1 3.4
2 33
3 47
</code></pre>
<p>我不知道该怎么做</p>
<p>感谢您的帮助/建议</p>
<p>请看下面我的代码:</p>
<pre><code>import pandas as pd
df = pd.read_excel(r'C:\Users\212677036\Documents\Copy of MIC Parts Review.xlsx')
PN = pd.DataFrame(df, columns=['Product code'])
i = 0
Total_rows = PN.shape[0]
partnumlist = []
partnumlist1 = []
partnumlist2 = []
partnumlist3 = []
partnumlist4 = []
partnumlist5 = []
while i < Total_rows:
data = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "17155"}}
r = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data).json()
partnumlist.append(r['Data']['PartOptions'][0]['YourPrice'])
data1 = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "17475"}}
r1 = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data1).json()
partnumlist1.append(r1['Data']['PartOptions'][0]['YourPrice'])
data2 = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "16880"}}
r2 = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data2).json()
partnumlist2.append(r2['Data']['PartOptions'][0]['YourPrice'])
data3 = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "47221"}}
r3 = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data3).json()
partnumlist3.append(r3['Data']['PartOptions'][0]['YourPrice'])
data4 = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "17045"}}
r4 = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data4).json()
partnumlist4.append(r4['Data']['PartOptions'][0]['YourPrice'])
data5 = {"partOptionFilter": {"PartNumber": PN.iloc[i, 0], "AlternativeOemId": "17055"}}
r5 = requests.post('https://www.partsfinder.com/Catalog/Service/GetPartOptions', json=data5).json()
partnumlist5.append(r5['Data']['PartOptions'][0]['YourPrice'])
i=i+1
list_of_dataframes = [pd.DataFrame(partnumlist),pd.DataFrame(partnumlist1),
pd.DataFrame(partnumlist2), pd.DataFrame(partnumlist3),
pd.DataFrame(partnumlist4), pd.DataFrame(partnumlist5)]
pd.concat(list_of_dataframes).to_csv(r'C:\Users\212677036\Documents\output25.csv')
</code></pre>