Search code examples
pythonpandaslistdataframetabulate

Python List Manipulation for Pandas

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%
Solution

  • 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:

    Output: