How I read the data in mention format in python with for loop

Question

How i read the following data in the the bellow format with for loop.

data = [
    [1,'Services',10],
    [2,'Cost Elements',20],
    [3, 'Rules',30],
    [4, 'Manpower', 40]
]

Expected output is::

p = [
    [1,2,3,4],
    ['services','Cost Elements','Rules','Manpower'],
    [10,20,30,40]
]

And:

{
        id:1,
        name:'services',
        value:10
    },
    {
        id:2,
        name:'Cost Elements',
        value:20
    },
    {
        id:1,
        name:'Rules',
        value:30
    },
    {
        id:1,
        name:'Manpower',
        value:40
    }

Please help ..I am beginner in python so couldn't..

Can you put your attempt and the result you obtained in your question? — Jerry, Oct 17 '18 at 11:42

timgeb · Answer 1 · 2018-10-17T11:50:50.050

0

It's easier to transpose your list with zip.

>>> data = [
...     [1,'Services',10],
...     [2,'Cost Elements',20],
...     [3, 'Rules',30],
...     [4, 'Manpower', 40]
... ]
>>> 
>>> p = list(zip(*data))
>>> p
[(1, 2, 3, 4), ('Services', 'Cost Elements', 'Rules', 'Manpower'), (10, 20, 30, 40)]

... or with additional transformation of the inner tuples to lists:

>>> p = list(map(list, zip(*data)))
>>> p
[[1, 2, 3, 4], ['Services', 'Cost Elements', 'Rules', 'Manpower'], [10, 20, 30, 40]]

zip will group together all the elements at corresponding positions (e.g. (sublist1[0], sublist2[0], ...)) for any number of iterable arguments.

~edit~

If it must be a for loop, you could do something like this.

>>> result = [[] for _ in range(len(data[0]))]
>>> 
>>> for sublist in data:
...     for i, element in enumerate(sublist):
...         result[i].append(element)
... 
>>> result
[[1, 2, 3, 4], ['Services', 'Cost Elements', 'Rules', 'Manpower'], [10, 20, 30, 40]]

This is clunky and I don't recommend it.

edited Oct 17 '18 at 11:50

answered Oct 17 '18 at 11:43

timgeb

76,762
20
123
145

Need output using for loop sir please – psw Oct 17 '18 at 11:45
@pavan if you insist... – timgeb Oct 17 '18 at 11:51
And guyz if i want like that:[ { id:1, name:'services', value:10 }, { id:2, name:'Cost Elements', value:20 }, { id:1, name:'Rules', value:30 }, { id:1, name:'Manpower', value:40 } ] – psw Oct 17 '18 at 11:52
thank you sir ......please guide me above one .....today i am learning lots of about python i think – psw Oct 17 '18 at 11:55
2

@pavan please don't ask follow up questions in comments. Don't be a [help vampire](https://meta.stackoverflow.com/a/258279/3620003). – timgeb Oct 17 '18 at 11:56
so should i ask by editing main one....i am new on stack...!!! – psw Oct 17 '18 at 11:59
@pavan you can ask a new question, but if you don't want to get it closed/downvoted read [ask] first. – timgeb Oct 17 '18 at 11:59
can't ask new one so edit the main so, please guide me. – psw Oct 17 '18 at 12:02
@pavan sorry, I'm already dizzy from loss of blood. – timgeb Oct 17 '18 at 12:04
please, i am new and trying to learn python so ..... – psw Oct 17 '18 at 12:09
@pavan: the site is not a tutoring or mentoring site, and to use it in this way risks being blocked from asking, so please be careful. – Hovercraft Full Of Eels Oct 17 '18 at 12:37

How I read the data in mention format in python with for loop

1 Answers1