擅长:python、mysql、java
<p>让我们试试</p>
<pre><code>df=df.assign(Value=df['Value'].str.split(','),Type=df.Type.str.split('_').str[0])
df2=(df['Type'].value_counts(normalize=True)*100).to_frame('%')
df2.rename_axis(index='Type')
%
Type
Hello-HEL-HE-A6123-123A-12T 50.000000
Hello-HEL-HE-A6123-123A-50T 33.333333
Happy-HAP-HA-R650-570A-90T 16.666667
</code></pre>