回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个名为'data'的numpy数组-</p>
<pre><code>array([['ksr-usconeng101', 'C', '632.3', '1'],
['ksr-usconeng101', 'D', '242.9', '2'],
['ksr-usconeng158', 'C', '1044.5', '3'],
['ksr-usconeng158', 'D', '2771.2', '4'],
['ksr-usconeng158', 'G', '7.3', '5'],
['ksr-usconeng163', 'C', '1597.0', '6'],
['ksr-usconeng163', 'D', '1676.3', '7'],
['server', 'drive', 'size', '']],
dtype='<U15')
</code></pre>
<p>我想把它转换成数据帧-</p>
<pre><code>pd.DataFrame(data=data[0:-1,0:3],
index = data[0:-1,-1],
columns = data[-1:, 0:-1])
</code></pre>
<p>数据-</p>
<pre><code>data[0:-1,0:3]
Out[145]:
array([['ksr-usconeng101', 'C', '632.3'],
['ksr-usconeng101', 'D', '242.9'],
['ksr-usconeng158', 'C', '1044.5'],
['ksr-usconeng158', 'D', '2771.2'],
['ksr-usconeng158', 'G', '7.3'],
['ksr-usconeng163', 'C', '1597.0'],
['ksr-usconeng163', 'D', '1676.3']],
dtype='<U15')
</code></pre>
<p>索引-</p>
<pre><code>data[0:-1,-1]
Out[146]:
array(['1', '2', '3', '4', '5', '6', '7'],
dtype='<U15')
</code></pre>
<p>列-</p>
<pre><code>data[-1:, 0:-1]
Out[147]:
array([['server', 'drive', 'size']],
dtype='<U15')
</code></pre>
<p>然而,python并不同意,并以-</p>
<pre><code>ValueError: Shape of passed values is (3, 7), indices imply (1, 7)
</code></pre>
<p>请说明我遗漏了什么。。你知道吗</p>