Formatting and splitting a list

Question

I have been provided with data that contains multiple strings. I am to break it and split the data into three parts which are name, cost and items. I was thinking about creating empty lists and then appending the names/costs/items to after it's been sorted out. But as I try to append them it just gives me a loop of the split list.

sample_data = [
    'Laaibah,208.10,10',
    'Arnold,380.999,9',
    'Sioned,327.01,1',
    'Shayaan,429.50,2',
    'Renee,535.29,4'
]

Outcome:

    Name                Cost  Items
    Laaibah             208.10   10
    Arnold              381.00    9
    Sioned              327.01    1
    Shayaan             429.50    2
    Renee               535.29    4

The following was provided for the formatting.

Name : Left justified in 20 places
Cost : Right justified in 6 place, 2 decimal places
Items: Right justified in 5 places

Can you share an example of your data? – Vishakha Lall Jan 29 '20 at 05:01 — Vishakha Lall, Jan 29 '20 at 05:01
Can you share your expected output format ??? – Nizam Uddin Jan 29 '20 at 05:05 — Nizam Uddin, Jan 29 '20 at 05:05

Vishakha Lall · Answer 1 · 2020-01-29T05:11:39.483

Here's what you can do:

impost pandas as pd
sample_data = [
    'Laaibah,208.10,10',
    'Arnold,380.999,9',
    'Sioned,327.01,1',
    'Shayaan,429.50,2',
    'Renee,535.29,4'
]
final_data = dict()
final_data['Name'] = list()
final_data['Cost'] = list()
final_data['Item'] = list()
for data in sample_data:
    split_data = data.split(",")
    final_data['Name'].append(split_data[0])
    final_data['Cost'].append(float(split_data[1]))
    final_data['Item'].append(int(split_data[2]))
output = pd.DataFrame(data=final_data)

Formatting and splitting a list

1 Answers1