Python List Manipulation for Pandas

Question

I have a List im trying to split and manipulate :

t = ['total percentage,Successful Divert 2935 95.9%,Operational Defect 67 2.2%,MHE Defect 59 1.9%,Load Balancing Defect 1 0.0%']

Im having a hard time figuring out the best way to manipulate for pandas.

Desired output:

t = [['Successful Divert','2935','95.9%'],'[Operational Defect','67','2.2%'],['MHE Defect','59','1.9%'],['Load Balancing Defect','1','0.0%']]

Pandas output:

Metrics	Total	Percentage
Successful Divert	2935	95.5%
Operational Defect	67	2.2%
MHE Defect	59	1.9%
Load Balancing Defect	1	0.0%

What happened to "total percentage" at the first part of the raw list? — TheFaultInOurStars, Apr 02 '22 at 14:33

score 2 · Accepted Answer · answered Apr 02 '22 at 14:41

2

This solution should works for you

t = [
    "total percentage,Successful Divert 2935 95.9%,Operational Defect 67 2.2%,MHE Defect 59 1.9%,Load Balancing Defect 1 0.0%"
]
t2 = [x.split(" ") for x in t[0].split(",")[1:]]
t3 = [(" ".join(x[:-2]), x[-2], x[-1]) for x in t2]
pd.DataFrame(t3, columns=["Metrics", "Total", "Percentage"])

Output:

answered Apr 02 '22 at 14:41

Volodymyr Rudyi

91
1
3

You are the man .. thanks . I really need to try harder haha – DATTO MOTORSPORTS Apr 02 '22 at 14:45
Or: `pd.DataFrame((el.rsplit(maxsplit=2) for el in t[0].partition(',')[2].split(',')), columns=["Metrics", "Total", "Percentage"])` – Jon Clements Apr 02 '22 at 14:46

Python List Manipulation for Pandas

1 Answers1