How to write a list of floats into a CSV file in Python-CodePudding

I'm trying to get my code to write the following list( a list of 3 floats) in a CSV file in 3 rows.

least_scores=[14.285714285714286, 14.375, 16.5]

I want it to be saved in rows in the CSV file like below:

14.285714285714286
14.375
16.5

but the program save all the numbers in one row or when I change the code I get the error that float is not iterable. I have tried many things and checked a lot of similar questions here and there, but I can not find the solution to my problem.

the following codes are the things that I have tried so far:

import csv
from statistics import mean
with open("E:\\Chapter5\input_file_name.csv") as inputi:
    data_list=[]
    score_list=[]
    mean_list=[]
    reader=csv.reader(inputi)
    for rows in reader:
        data_list.append(rows)
    #print(len(data_list))
    for i in range(0,len(data_list)):
        score_list.append(data_list[i][1:])
    #print(score_list)
    new_list=[
        [float(x) for x in nested_lists]
        for nested_lists in score_list
    ]
    #print(new_list)
    for items in new_list:
        mean_list.append(mean(items))
    #print(mean_list)
    least_scores=sorted(mean_list)
    least_scores=least_scores[0:3]
    print(least_scores)
    with open("E:\\Chapter5\output_file_name.csv",'w',newline='') as outi:
        writer=csv.writer(outi)
        writer.writerow(least_scores)

with the above code the list items will all be saved in a single row.

so I tries writer.writerows instead of writer.writerow but I got the error "iterable expected, not float"

the I tried the following code:

with open("E:\\Chapter5\output_file_name.csv",'w',newline='') as outi:
        writer=csv.writer(outi)
        for nums in least_scores:
            writer.writerows(nums)

and got the error "'float' object is not iterable" Could you please help me solve this issue please?

CodePudding user response：

writerow() is looking for an iterable, the value in nums can be passed within a list to satisfy that:

with open("file_name.csv", 'w', newline='') as outi:
    writer = csv.writer(outi)
    for nums in least_scores:
        writer.writerow([nums])

CodePudding user response：

Well done on including a shorter bit of code, that helps with debugging. Can you share the full stack next time as well please?

I think in this case, the issue is that least_scores is MEANT to be a list of floats, but you just have a float there.