擅长:python、mysql、java
<pre><code>import pandas as pd
df = pd.DataFrame({'Type': {0: 'Hello-HEL-HE-A6123-123A-12T_TYPE-v.A',
1: 'Hello-HEL-HE-A6123-123A-12T_TYPE-v.E',
2: 'Hello-HEL-HE-A6123-123A-50T_TYPE-v.C',
3: 'Hello-HEL-HE-A6123-123A-50T_TYPE-v.A',
4: 'Happy-HAP-HA-R650-570A-90T_version-v.A',
5: 'Kind-KIN-KI-T490-NET_14T-A.0',
6: 'Kind-KIN-KI-T490-NET_14T-A.0'}})
df.Type = df.Type.str.split('-').str[0] + ' ' + df.Type.str.extract('(\d+T)')
(df.groupby('Type').size() / len(df) * 100).to_frame('Percent').reset_index()
</code></pre>
<p>输出</p>
<pre><code> Type Percent
0 Hello 12T 28.571429
1 Hello 14T 28.571429
2 Hello 50T 28.571429
3 Hello 90T 14.285714
</code></pre>