擅长:python、mysql、java
<p>你可以这样做:</p>
<pre><code>df['Type'].str.split('_').str[0].value_counts(normalize=True)
Hello-HEL-HE-A6123-123A-12T 0.500000
Hello-HEL-HE-A6123-123A-50T 0.333333
Happy-HAP-HA-R650-570A-90T 0.166667
</code></pre>
<p>如果您需要该特定表格,则:</p>
<pre><code>tmp = df['Type'].str.split('_').str[0].value_counts(normalize=True).reset_index(name='percentage').rename(columns={'index': 'Type'})
tmp['percentage'] = tmp['percentage'].apply(lambda x: '{:.2f}%'.format(100*x))
tmp
Type percentage
Hello-HEL-HE-A6123-123A-12T 50.00%
Hello-HEL-HE-A6123-123A-50T 33.33%
Happy-HAP-HA-R650-570A-90T 16.67%
</code></pre>