擅长:python、mysql、java
<p>如果有所需列的列表:</p>
<pre><code>cols = ['precipitant', 'precipitantcode', 'type']
</code></pre>
<p>然后可以对它们进行迭代并附加到字典中的数组:</p>
<pre><code>d = {}
for labelinteractions in LabelInteractions.findAll('labelinteraction'):
for c in cols:
if not c in d:
d[c] = [labelinteractions[c]]
else:
d[c].append(labelinteractions[c])
</code></pre>
<p>完成后,您可以请求数据帧:</p>
<pre><code>df = pd.DataFrame(d)
</code></pre>
<p>这是我从你的样品中得到的:</p>
<pre><code> precipitant precipitantcode type
0 ritonavir N0000007423 Unspecified interaction
1 gc stimulator NO MAP Unspecified interaction
2 riociguat N0000188995 Unspecified interaction
3 alcohol N0000007432 Pharmacodynamic interaction
</code></pre>