擅长:python、mysql、java
<p>如果您有访问权限,可以使用pandas包来处理csv。你知道吗</p>
<p>标题为的文本文件值.txt你知道吗</p>
<pre><code>Leading Cause, Deaths
Diabetes Mellitus, 123
Influenza and Pneumonia, 325
Diabetes Mellitus, 1008
</code></pre>
<p>所需的数据帧可以通过以下方式实现:</p>
<pre><code>import pandas as pd
data = pd.read_csv('values.txt')
print(data)
sum_data = data.groupby(['Leading Cause']).sum()
print(sum_data)
print(sum_data.loc['Diabetes Mellitus'])
</code></pre>
<p>哪个会输出</p>
<pre><code> Leading Cause Deaths
0 Diabetes Mellitus 123
1 Influenza and Pneumonia 325
2 Diabetes Mellitus 1008
Deaths
Leading Cause
Diabetes Mellitus 1131
Influenza and Pneumonia 325
Deaths 1131
Name: Diabetes Mellitus, dtype: int64
</code></pre>