Nested list of strings, split by whitespace

Question

Hi there this is my first post here so sorry if im formatting it weirdly or something. Anyways so i am currently in python trying to solve a challenge. And im supposed to read a table of text into my program and what i want it to do is basically split each line of words into a list and then have each word be at its own index. this is the code im currently using:

with open(database, "r") as data:
    datatext = data.read()

datatext = datatext.replace(",", " ")

datarr = datatext.split("\n")

reader = csv.reader(datarr)

print([word for word in [row for row in reader]])

where database is representing the file of text. What this does is it makes each line of text in database its own nested list however it takes all of the word separated by whitespace and turns it in to one single string, so each nested list only have index 0. like this:

[['name AGATC TTTTTTCT AATG TCTAG GATA TATC GAAA TCTG'], ['Albus 15 49 38 5 14 44 14 12'], ['Cedric 31 21 41 28 30 9 36 44'], ['Draco 9 13 8 26 15 25 41 39']... etc]

but what i in reality want is:

[['name', 'AGATC', 'TTTTTTCT', 'AATG', 'TCTAG', 'GATA', 'TATC', 'GAAA', TCTG'], ['Albus', '15', '49', '38', '5', '14', '44', '14', '12']... etc]

basically i want each word/string to be its own index inside of the nested list. Could anyone please help me with this? I have been trying to google around but havent been able to find the correct solution. Hopefully this was not vaguely written. Greatful for any answers :)

edit: How the text file is written:

name,AGATC,TTTTTTCT,AATG,TCTAG,GATA,TATC,GAAA,TCTG
Albus,15,49,38,5,14,44,14,12
Cedric,31,21,41,28,30,9,36,44
Draco,9,13,8,26,15,25,41,39

last edit: removing the datatext.replace(...) solved it :=)

Why do you replace , with space? If you didn't, csv.reader would separate the fields. — Paulo Almeida
– Paulo Almeida, Commented Jan 17, 2020 at 19:19
Thank you Paulo! Had no clue it was that easy, that solved it! :) — Mango88
– Mango88, Commented Jan 17, 2020 at 19:28

user2390182 · Accepted Answer · 2020-01-17 19:30:30Z

1

You're overcomplicating things. The following should suffice:

with open(database, "r") as data:
     reader = csv.reader(data)
     print([row for row in reader])

answered Jan 17, 2020 at 19:30

user2390182

73.7k6 gold badges71 silver badges95 bronze badges

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

Comments

Gripp · Accepted Answer · 2020-01-17 19:18:40Z

0

Hard to help without a sample of the database that you're opening. But I would imagine that it's the csv.reader that's splitting on the whitespace. Try playing the parameter delimiter in that function. I imagine something like csv.reader(datarr, delimiter=' ') would work. But, again, would need sample data to work with.

answered Jan 17, 2020 at 19:18

Gripp

16613 bronze badges

2 Comments

Mango88 Over a year ago

Hi sorry was uncertain if i should have included it anyways the text is written like this: name,AGATC,TTTTTTCT,AATG,TCTAG,GATA,TATC,GAAA,TCTG Albus,15,49,38,5,14,44,14,12 Cedric,31,21,41,28,30,9,36,44 Draco,9,13,8,26,15,25,41,39 Sorry dont know how to make a newline if thats even possible in the comments but each name is a new line in the text. Thanks gonna try it

Gripp Over a year ago

Put it in the original question, or people won't notice it.

Collectives™ on Stack Overflow

Nested list of strings, split by whitespace

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related