擅长:python、mysql、java
<p>在中读取CSV文件。按公司和质量问题索引,然后在质量问题上取消标记。最后,替换由于没有找到匹配数据而出现的<code>Nan</code>值</p>
<pre><code>In [341]: d1
Out[341]:
Company Name Quality Issue Cases
0 Co 1 Equipment 15
1 Co 2 User 1
2 Co 2 Equipment 5
3 Co 3 Equipment 3
4 Co 3 User 10
5 Co 3 Neither 13
In [342]: d2 = d1.set_index(["Company Name", "Quality Issue"])
In [343]: d2
Out[343]:
Cases
Company Name Quality Issue
Co 1 Equipment 15
Co 2 User 1
Equipment 5
Co 3 Equipment 3
User 10
Neither 13
In [344]: d3 = d2.unstack("Quality Issue")
In [345]: d3.fillna(0)
Out[345]:
Cases
Quality Issue Equipment Neither User
Company Name
Co 1 15 0 0
Co 2 5 0 1
Co 3 3 13 10
</code></pre>