Question

Help with Python

Example of scsv file :

TOXIC;U;Q;120;4;5;289;2;19;2;123;25;7;8;0.23;89.98745

APPLE;V;B;89;2;3;344;6;8;5;450;55;7;2;0.37;34.23205

Convert this format to the common csv file format

Use semicolons for those values that have commas in them.

1. Define the function named organize_table. It has 2 parameters a filename to be read (the scsv file) and a filename to be written (the csv file). Name them raw_file and organized_file.

2. Open, read, and parse the scsv file (i.e. raw_file)

3. Define the same contents to organized_file but separate the values (columns) with commas.

4. For those values that have commas in them, replace the commas with semicolons.

5. Be sure to end each line (except the last line) with a newline.

6. Return True from the function. Return a boolean indicating success or failure

7. Please don't use any libraries

Answer 1

Here is the completed code for this problem. Comments are included, go through it, learn how things work and let me know if you have any doubts or if you need anything to change. If you are satisfied with the solution, please rate the answer. If not, PLEASE let me know before you rate, I’ll help you fix whatever issues. Thanks

Note: Please maintain proper code spacing (indentation), just copy the code part and paste it in your compiler/IDE directly, no modifications required.

#code

#required method
def organize_table(raw_file, organized_file):
    #opening files inside a try-except block
    try:
        #opening raw_file in read mode, using the same variable name
        raw_file=open(raw_file,'r')
        #opening organized_file in write mode
        organized_file=open(organized_file,'w')
        #creating a variable to store the updated text
        formatted_text=''
        #looping through each line in raw_file
        for line in raw_file:
            #removing heading/trailing newline/spaces from line, splitting by semi colon
            fields=line.strip().split(';')
            #looping through each element in split array
            for i in range(len(fields)):
                #if current element contains comma, replacing with semi colon
                if ',' in fields[i]:
                    fields[i]=fields[i].replace(',',';')
            #combining fields array using comma as separator, appending to formatted_text
            #followed by a newline
            formatted_text+=','.join(fields)+'\n'
        #writing to organized_file after removing trailing newline
        organized_file.write(formatted_text.strip())
        #closing file(s), saving changes
        organized_file.close()
        raw_file.close()
        return True #success
    except:
        return False #failed