Parsing with Python

Question

I am attempting to parse a file. Currently, I have this file:

word1 52345325
word2 12312314
word3 7654756
word4 421342342

I am attempting to store word1 word2 word3 and word4 into an array and the numbers adjacent to those words into another array.

So if i say a[0] i should get word1, and if I say b[0] i should get 52345325 and so on.

I was thinking about making a key-valued pair dictionary object but that may be a little complex at this point as I am just getting into python.

I currently am doing this but of course, it ain't working :P

def csvStringParser():
    a = {}
    b = {}
    i = 0
    f = open('/Users/settingj/Desktop/NOxMultiplier.csv')
    for line in f.readlines():
    reader = csv.reader(line.split('\t'), delimiter='\t')
        for row in reader:
            #print '\t'.join(row)                                                                                                                                                                                                                                             
            #print i                                                                                                                                                                                                                                                          
            a[i] = '\t'.join(row)
            b[i] = '\t'.join(row)
            print a[i]
            print b[i]
            i+=1

This is honestly my first hour of using python. I could easily do this in C++ but I'm am currently just trying to learn python to understand it's greater benefits/simplicity over c++.

Viktor Kerkez · Accepted Answer · 2013-08-13 00:32:48Z

2

import csv

a = {}
with open('/Users/settingj/Desktop/NOxMultiplier.csv') as f:
    reader = csv.reader(f, delimiter='\t')
    for row in reader:
        a[row[0]] = row[1]
print a

For two arrays:

a = []
b = []
with open('/Users/settingj/Desktop/NOxMultiplier.csv') as f:
    reader = csv.reader(f, delimiter='\t')
    for row in reader:
        a.append(row[0])
        b.append(row[1])
print a
print b

of even just similar solution with the zip:

with open('/Users/settingj/Desktop/NOxMultiplier.csv') as f:
    a, b = zip(*csv.reader(f, delimiter='\t'))
print a
print b

edited Aug 13, 2013 at 0:32

answered Aug 13, 2013 at 0:24

Viktor Kerkez

46.8k13 gold badges109 silver badges88 bronze badges

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

3 Comments

jsetting32 Over a year ago

haha amazing... dam easy... You get a vote up for copy and paste code, but I am still wondering, how would I create 2 arrays instead of one that are mapped to one another like how I explained in my questions?

jsetting32 Over a year ago

In the end, I feel like the first answer is my final desired goal, but I am not able to use it..

Viktor Kerkez Over a year ago

Added two arrays example.

mingaleg · Accepted Answer · 2013-08-13 00:31:37Z

2

Ok, in fact, there is only one line of code:

a, b = zip(*(map(lambda x: x.rstrip('\n\r').split('\t'), open('file.csv').readlines())))

Some links:

edited Aug 13, 2013 at 0:31

answered Aug 13, 2013 at 0:22

mingaleg

2,09716 silver badges28 bronze badges

1 Comment

jsetting32 Over a year ago

your answer is perfect for a dictionary solution like how I specified in the question, and it's so compact :) I like it.

cordoro · Accepted Answer · 2013-08-13 00:30:46Z

1

Here's my implementation that does what you describe with the input you describe: #!/usr/bin/python

def csvStringParser(filename):
    a = []
    b = []
    f = open(filename)
    for line in f.readlines():
        tok = line.split()
        a.append(tok[0])
        b.append(tok[1])
    print a
    print b

if __name__=="__main__":
    csvStringParser('temp.txt')

You could use other separators in split() such as split('\t') if you use tab delimiters, but you probably don't need the csv package for what you describe.

answered Aug 13, 2013 at 0:30

cordoro

1071 gold badge1 silver badge7 bronze badges

2 Comments

jsetting32 Over a year ago

this is basically the same as the accepted answer but you get a vote up since it works :)

cordoro Over a year ago

Yeah, I saw the accepted answer after I posted mine. Glad you got a working code sample.

Collectives™ on Stack Overflow

Parsing with Python

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related