Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Concatenate the values of a list after inputting multiple column / row raw input in python

I’m trying to use a program in here to convert a copy and pasted list from excel into a list that I can manipulate using concatenate in Python. When I input the multiple column / row values I get a list that I’m having trouble manipulating. See the below example:

  • the program is below:
def detail_input():
     try:
        while True:
            data=raw_input()
            if not data: break
            yield data
     except KeyboardInterrupt:
        return
  • the raw input is copied from excel onto a unix command line:

123 56
321 42
987 24

  • I then get a return that looks like this:
userInput = list(detail_input())

[[‘123\t56’],[‘321\t42’],[‘987\t24’]]

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

  • My desired output would look like this:

the group is 123 and their profile is 56
the group is 321 and their profile is 42
the group is 987 and their profile is 24

I’ve tried to use the below to remove the tab delimiter:

values = list(csv.reader(userInput, delimiter='\t'))
  • but it converts the list into a tuple and I can’t extract the individual values – I can only extract both values inside of each bracket :\

[[‘123′,’56’],[‘321′,’42’],[‘987′,’24’]]

Please help if you have any ideas

>Solution :

you can do this.

values = list(csv.reader(userInput, delimiter='\t'))
# add the following line to print what you need.
[print("the group is {} and their profile is {}".format(each[0], each[1])) for each in values]

or something as easy as following.

values = list(csv.reader(userInput, delimiter='\t'))

for each in values:
    group = each[0]
    profile = each[1]
    print("the group is {} and their profile is {}".format(group,profile))
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading