How do I split a column of a csv file in excel using python 3.3?

[gesqo]

I have a column of some hundreds rows, obtained by a python program,each cell containing 4 unequal (in length) strings,like:
adfhyhh ihhgfdtykk red piuol
How can I split it with python in 4 colomns,with each cell containing one string?
Thanks.

[bvdet]

Perhaps I don't understand your question. It is somewhat vague.

>>> cell = "adfhyhh ihhgfdtykk red piuol"
>>> columns = cell.split()
>>> columns
['adfhyhh', 'ihhgfdtykk', 'red', 'piuol']
>>>

[gesqo]

More precise

This is a better illustration of what I need:
A B C D E
1 adfhyhh*ihhgfdt ykk*red*piuol adfhyhh ihhgfdt red piuol
2 ehethe tthy tytuiuu aaaaaaa ehethe tthy tytu aaaaa


[imgnothumb]http://bytes.com/attachments/attachment/6736d1353625474/screenshotexcel .jpg[/imgnothumb]

[bvdet]

You can directly read the Excel workbook contents with xlrd, and the data is formatted so you can access the cell elements. What does your data look like after is is read by "a python program"?

[gesqo]

I didn't say «read by a python program»,so I don't undrestand well your question.
If you meant how I created the cv file:with «f.write('file. csv','w')».
I expect a solution smth like «column.split».

[bvdet]

"What does your data look like?" Since you don't understand me and I don't understand you, I'll take a guess.

data = """3d3cd455 c6dd 4390 08712b657ec7
6b9754c7 761f 4b76 fe0c41e1fecb
05a9bd30 69c3 4631 73916e968dfe
047db4fd 3bb3 4bec 719313b2928b
db9e189c 0c8b 4fb0 b1c1d20e8d49
3427aeca d649 4286 4e2df66de67b
037189cd 63ec 4d5c bb7b8255c169
e95a4329 98d8 4ab3 1f4e902c147e
376773f8 a7da 4915 ec20af56c02b"""

You can create 4 columns in each row by replacing the space character with a comma.

data = data.replace(" ", ",")

If you want to do it in a more complicated way:

"\n".join([",".join(item.split()) for item in data.split("\n")])

[gesqo]

Thank you.Seems working.