Need to create an array of arrays for each string

Question

So I have data that looks something like this:

>> print data
"12345","string1","string2","string3","string4","string5"
"67890","string6","string7","string8","string9","string10"

I want to be able to put each line as an array, into an array. So in the end, I want it to look something like this:

>> print array_data
[["12345","string1","string2","string3","string4","string5"],
["67890","string6","string7","string8","string9","string10"]]

I have tried a few things and this is the closest I got:

>> temp_list = []
>> for line in data.splitlines(): temp_list.append([line])
>> print temp_list
[['"12345","string1","string2","string3","string4","string5"'],
['"67890","string6","string7","string8","string9","string10"']]

I am getting that single quote around each array. How should I proceed to get the result that I am looking for?

Thanks in advance!

If you're still confused, check out how quotes work in Python to indicate strings: docs.python.org/2.0/ref/strings.html — Joooeey
– Joooeey, Commented Jul 4, 2018 at 0:30

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

You can use ast and split

setup

import ast
d = '''
"12345","string1","string2","string3","string4","string5"
"67890","string6","string7","string8","string9","string10"
'''
templist=[]

Then just

for line in d.strip().splitlines(): 
    templist.append([ast.literal_eval(st) for st in line.split(',')])

Notice that you can also make a oneliner using list comprehension

templist = [[ast.literal_eval(st) for st in line.split(',')] for line in d.strip().splitlines()]

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 4, 2018 at 0:20

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anton vBR · Accepted Answer · 2018-07-04 00:31:12Z

1

Using pandas:

import pandas as pd

d = '''\
"12345","string1","string2","string3","string4","string5"
"67890","string6","string7","string8","string9","string10"'''

l = pd.read_csv(pd.compat.StringIO(d), header=None, dtype='object').values

And you have l:

[['12345', 'string1', 'string2', 'string3', 'string4', 'string5'],
 ['67890', 'string6', 'string7', 'string8', 'string9', 'string10']]

edited Jul 4, 2018 at 0:31

answered Jul 4, 2018 at 0:25

Anton vBR

19k6 gold badges47 silver badges47 bronze badges

Comments

jpp · Accepted Answer · 2018-07-04 00:32:02Z

1

Using csv and io modules from the standard library:

import csv
from io import StringIO

d = '''"12345","string1","string2","string3","string4","string5"
"67890","string6","string7","string8","string9","string10"'''

res = list(csv.reader(StringIO(d)))

print(res)

[['12345', 'string1', 'string2', 'string3', 'string4', 'string5'],
 ['67890', 'string6', 'string7', 'string8', 'string9', 'string10']]

answered Jul 4, 2018 at 0:32

jpp

166k37 gold badges301 silver badges362 bronze badges

Comments

dawg · Accepted Answer · 2018-07-04 00:36:28Z

1

Given:

>>> data
'"12345","string1","string2","string3","string4","string5"\n"67890","string6","string7","string8","string9","string10"'

You can do (if the ' do not otherwise indicate csv fields that might have , in them!):

>>> [line.replace('"','').split(',') for line in data.splitlines()]
[['12345', 'string1', 'string2', 'string3', 'string4', 'string5'], ['67890', 'string6', 'string7', 'string8', 'string9', 'string10']]

Or you can use csv to properly handle commas in the fields:

>>> import csv
>>> [list(e) for e in csv.reader(data.splitlines())]
[['12345', 'string1', 'string2', 'string3', 'string4', 'string5'], ['67890', 'string6', 'string7', 'string8', 'string9', 'string10']]

edited Jul 4, 2018 at 0:36

answered Jul 4, 2018 at 0:25

dawg

105k24 gold badges142 silver badges217 bronze badges

Comments

Rishikesh Jha · Accepted Answer · 2018-07-04 08:35:14Z

-1

You are almost there.

>> temp_list = []
>> temp_list = [list(eval(line)) for line in data.splitlines()]
>> print temp_list
[['12345', 'string1', 'string2', 'string3', 'string4', 'string5'], ['67890', 'string6', 'string7', 'string8', 'string9', 'string10']]

answered Jul 4, 2018 at 8:35

Rishikesh Jha

5503 silver badges11 bronze badges

1 Comment

Rishikesh Jha Over a year ago

If you downvote a answer, also provide a reason for it.

Collectives™ on Stack Overflow

Need to create an array of arrays for each string

5 Answers 5

setup

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

setup

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related