How to export multiple arrays from IronPython to CSV

Question

I'm trying to export Two float arrays into a CSV file using IronPython, here's my code

import System
from System import Array

iData = Array.CreateInstance(System.Single, 1024)
qData = Array.CreateInstance(System.Single, 1024)

import csv
with open(r'c:\test.csv', 'w') as fp:
writer = csv.writer(fp, delimiter=',')
for i in range(0, 1024):
    val = repr(iData[i]) + repr(qData[i])
    writer.writerow(val)
print("done")

the above code works fine, but when I open test.csv file I see the following [EXCEL]

enter image description here

[NotePad++]

enter image description here

but what I want to achieve is this (iData[i],qData[i]),

enter image description here

any suggestions please?

@LutzHorn, If I'm not wrong. Excel recognizes CSV files with delimiter (,) — SanVEE
– SanVEE, Commented Jan 30, 2015 at 10:48
The picture shown above is what I see, I had to crop due to higher number of rows(i.e 1024) — SanVEE
– SanVEE, Commented Jan 30, 2015 at 10:52
Please open test.csv in a plain text editor like Notepad++ and add the content (some lines are enough) to your question. — user1907906
– user1907906, Commented Jan 30, 2015 at 10:52

user1907906 · Accepted Answer · 2015-01-30 10:59:40Z

1

Try this:

for i in range(0, 1024):
    writer.writerow([iData[i], qData[i]])

answered Jan 30, 2015 at 10:59

user1907906

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

Collectives™ on Stack Overflow

How to export multiple arrays from IronPython to CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related