csv to list

[newmaid]

hi all..

if i had a csv file that had data in the format:

1, male, 1997
2, male, 2000
3, female , 1977
etc

how would i pull all 3 columns out of the csv into lists

thanks for your help

[jlm699]

hi all..

if i had a csv file that had data in the format:

1, male, 1997
2, male, 2000
3, female , 1977
etc

how would i pull all 3 columns out of the csv into lists

thanks for your help

[CODE=python]
>>> list = []
>>> fh = open('test.csv' , 'r')
>>>
>>> for line in fh:
>>> list.append(lin e.strip().split (','))
>>>
>>> list
[['1', ' male', '1997'], ['2', 'male', '2000'], ['3', 'femail', '1977']]
[/CODE]

I'm not quite sure how you want your output data structured... but this is a guess.

[subeen]

You can also use the csv module. Look at the following link:

http://docs.python.org/lib/module-csv.html

regards,
Subeen

http://love-python.blogspot.com/

[bvdet]

[CODE=python]
>>> list = []
>>> fh = open('test.csv' , 'r')
>>>
>>> for line in fh:
>>> list.append(lin e.strip().split (','))
>>>
>>> list
[['1', ' male', '1997'], ['2', 'male', '2000'], ['3', 'femail', '1977']]
[/CODE]

I'm not quite sure how you want your output data structured... but this is a guess.

Good post jlm699 with one exception - using list for a variable name masks the built-in function list(). The following does basically the same as yours, but uses a list comprehension.
[code=Python]
data = '''1, male, 1997
2, male, 2000
3, female , 1977
'''
# data = open(file_name) .read()
# list comprehension
dataList = [line.split(',') for line in data.split('\n' ) if line][/code]In case the OP wants to transpose the rows and columns:
[code=Python]def transpose_lists (dataList):
# list comprehension
return [[item[j] for item in dataList] for j in range(len(dataL ist[0]))]

def transpose_lists (dataList):
resultList = []
for j in range(len(dataL ist[0])):
temList = []
for item in dataList:
temList.append( item[j])
resultList.appe nd(temList)
return resultList[/code]

Example:
>>> dataList
[['1', ' male', ' 1997'], ['2', ' male', ' 2000'], ['3', ' female ', ' 1977']]
>>> transpose_lists (dataList)
[['1', '2', '3'], [' male', ' male', ' female '], [' 1997', ' 2000', ' 1977']]
>>>

[jlm699]

Good post jlm699 with one exception - using list for a variable name masks the built-in function list().

lol, I tend to do that ALOT when I'm coming up with quick little examples... bit of a ditz I guess...

That's a really neat little function there for transposing the data.. Nice!

[bvdet]

lol, I tend to do that ALOT when I'm coming up with quick little examples... bit of a ditz I guess...

That's a really neat little function there for transposing the data.. Nice!

Thanks jlm699. That's happened to many people including myself.