How do I get my python output into a csv or excel file?

Question

for i in range(len(H)):
            S=Y[1:,(0,1,m)]  # change 2=> 2:m
            S=S[S[0:,0] ==HN[k]]
            S=S[S[0:,1] ==H[i]]
            S=S[S[0:,2]!=''] #
            S=S[0:,2]  #
            for j in range(len(S)):
                print(HN[k],H[i],S[j],H[j]*H[I])

This prints output of almost 900-1000 rows on my jupyter notebook. However I want output to be directly a csv or xls file. So that I don't have to copy or paste, would also save me time if rows increases of my data.

There is a [`csv` module in python](https://docs.python.org/3/library/csv.html) — NiziL, Oct 24 '19 at 06:09
During the loop: `fileDesc.write('{},{},{},{}\n'.format(HN[k],H[i],S[j],H[j]*H[I]))`. — goodvibration, Oct 24 '19 at 06:12
@goodvibration thanks and where will this output(filename.csv) be saved ? — ANKIT BISHT, Oct 24 '19 at 06:17
Possible duplicate of [Create a .csv file with values from a Python list](https://stackoverflow.com/questions/2084069/create-a-csv-file-with-values-from-a-python-list) — Artog, Oct 24 '19 at 06:22
@goodvibration just one more question, I also want header column named in my file, how do we write them before loop. — ANKIT BISHT, Oct 24 '19 at 07:06

score 0 · Answer 1 · answered Oct 24 '19 at 06:20

You can just do the following.

Open the file with csv.writer
write row wise the data in the writer

import csv

...

writer = csv.writer(open("/path/to/my/csv/file", 'w'))
for i in range(len(H)):
    S=Y[1:,(0,1,m)]  # change 2=> 2:m
    S=S[S[0:,0] ==HN[k]]
    S=S[S[0:,1] ==H[i]]
    S=S[S[0:,2]!=''] #
    S=S[0:,2]  #

    for j in range(len(S)):
        writer.writerow(HN[k], H[i], S[j], H[j]*H[i])

score 0 · Answer 2 · answered Oct 24 '19 at 06:20

You can do something like this:

import csv

csvFile = open('example.csv', 'w')

with csvFile:
    writer = csv.writer(csvFile)
    for i in range(len(H)):
        S=Y[1:,(0,1,m)]
        S=S[S[0:,0] ==HN[k]]
        S=S[S[0:,1] ==H[i]]
        S=S[S[0:,2]!=''] #
        S=S[0:,2]  #
        for j in range(len(S)):
            writer.write('{},{},{},{}\n'.format(HN[k],H[i],S[j],H[j]*H[I]))

How do I get my python output into a csv or excel file?

2 Answers2