Save different array into one csv file

Question

I have an array of scores with values like

[[0.66372503]
 [0.64839758]
 [0.63307013]]

Then, I have an array of scores2 with values like

[[0.65367322]
 [0.63598164]
 [0.62295124]]

How do I combine them and save into csv like

         scores         scores2              
1     0.66372503     0.65367322
2     0.64839758     0.63598164
3     0.63307013     0.62295124

? Thank you

When you say "I have an array of...", is that a python array ? a NumPy nparray ? or a pandas DataFrame ? Please include the code that creates the data, so we can copy/paste it. — joao
– joao, Commented Jul 6, 2021 at 14:21

sash_wash · Accepted Answer · 2021-07-06 14:23:36Z

2

df= pd.DataFrame(data={'scores': [0.66372503, 0.64839758, 0.63307013],
                       'scores2':[0.65367322, 0.63598164, 0.62295124]})
df.to_csv('filename.csv', index=False)

if you have 2d array, you can use numpy flatten methode before passing the arrays into pandas df:

scores= [[0.66372503], [0.64839758], [0.63307013]]
scores2=[[0.65367322], [0.63598164], [0.62295124]]

df= pd.DataFrame(data={'scores': np.array(scores).flatten(),
                       'scores2':np.array(scores2).flatten()})

df.to_csv('filename.csv', index=False)

edited Jul 6, 2021 at 14:23

answered Jul 6, 2021 at 14:21

sash_wash

1464 bronze badges

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

2 Comments

ernest_k Over a year ago

Can you pass 2D lists as columns?

sash_wash Over a year ago

Yes, you can, but then each value would be a list with a single value, which I think won't be what you want.

OldManSeph · Accepted Answer · 2021-07-06 14:23:20Z

0

if you have basic python arrays you could do something like this:

n = len(scores)
for x in range(0,n):
    key = x + 1
    newline = key + "\t" + scores[x] + "\t" + scores2[x] + "\n"
    outf.write(newline)

answered Jul 6, 2021 at 14:23

OldManSeph

2,79020 silver badges25 bronze badges

Comments

Scrappy Coco · Accepted Answer · 2021-07-06 14:24:15Z

0

Try this:

scores = list(scores)
scores2 = list(scores2)
d = [scores, scores2]
export_data = zip_longest(*d, fillvalue = '')
with open('<your_file_name>.csv', 'w', encoding="ISO-8859-1", newline='') as myfile:
        wr = csv.writer(myfile)
        wr.writerow(("scores", "scores2"))
        wr.writerows(export_data)
    myfile.close()

answered Jul 6, 2021 at 14:24

Scrappy Coco

1263 silver badges13 bronze badges

Collectives™ on Stack Overflow

Save different array into one csv file

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related