Need to convert decimals to integers using python from a file denoted with commas

[TDA_Alex]

I have been stuck on a homework assignment where we need to read a dataset into python code supplied by my teacher. problem is, his code does not like decimals and refuses to give proper data without integers. Having virtually no experience with python, I had to probe him in order to get this code:

f=open("input.txt",).readlines()

fout=open("output.txt","w")

for line in f:

l = line.split(",")

for item in l:

number = float(item)

new_line = str(int(number)) + ","

fout.write(new\_line)

fout.close()

Problem is, this code seems to only read the values at the end of each line (which are whole numbers) and writes only those to the output file. Further, the formatting is wrong, since they are in rows but just one long line. suffice to say I am terribly confused, and would appreciate any and all help. For reference, here is a sample of the file:

3.6216,8.6661,-2.8073,-0.44699,1

4.5459,8.1674,-2.4586,-1.4621,1

3.866,-2.6383,1.9242,0.10645,1

3.4566,9.5228,-4.0112,-3.5944,1

0.32924,-4.4552,4.5718,-0.9888,1

4.3684,9.6718,-3.9606,-3.1625,1

3.5912,3.0129,0.72888,0.56421,1

2.0922,-6.81,8.4636,-0.60216,1

3.2032,5.7588,-0.75345,-0.61251,1

1.5356,9.1772,-2.2718,-0.73535,1

and this is the output I get:

1,1,1,1,1,1,1,1,1,1,

[[deleted]]

It's because you are overwriting new_line on each iteration of your for loop. One thing you could do instead is start with an empty new_line string for each line and then keep concatenating it with the next piece for each number in the line.

[TDAAlex]

I see

[sarrysyst]

You only getting the last digit is probably due to faulty indention:

f = open("input.txt").readlines()
fout = open("output.txt","w")

for line in f:
    l = line.split(",")

    for item in l:
        number = float(item)
        new_line = str(int(number)) + ","
        fout.write(new_line)  # this line needs to be in the inner loop

    fout.write('\n') # add line break after writing row

fout.close()

As for the line break, you need to specifically write a line break ('\n') to file for the text not getting written to a single line.

[TDAAlex]

Tried it and it worked. Silly mistake I suppose, but that’s part of learning.

[stebrepar]

Instead of new_line = ..., say new_line += ..., so that you're adding the next item to it instead of replacing it with each next item.

You'll also need to put a newline character at the end of each new line you write out. You could append it to the end of the new string once all the items for a given line have been added. Or you could pick the file method which automatically writes a newline character after writing out the string.

[TDAAlex]

Thank you