reading csv file and writing to another file using python

Question

Hi I am new to python and I want to write a program which will read the csv file and write the data to another file.

Below is the code:

    #!/usr/bin/python

import csv

FEED_FILE = '/proj/ctc/temp/sanjay/REC-754/20170529_MUREX_EOD_REC_RATES_20170531.csv'
OUT_FILE = '/proj/ctc/temp/sanjay/REC-754/20170529_MUREX_EOD_REC_RATES_20170531_out.csv'

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
    writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
        row[3] = sorted(list(row[3].split(','))
                writer.writerow(row)

but I am getting below error, which I am not able to understand why?

$./Csvreader.py
  File "./Csvreader.py", line 14
    writer.writerow(row)
         ^
SyntaxError: invalid syntax

Please help me with the solution, thanks in advance.

check the parentheses on the previous line. you forgot to close sorted(... — juanpa.arrivillaga
– juanpa.arrivillaga, Commented Jun 16, 2017 at 10:00

Arun · Accepted Answer · 2017-06-16 10:08:04Z

1

Try the following code:

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
        writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
            row[3] = sorted(list(row[3].split(',')))
            writer.writerow(row)

answered Jun 16, 2017 at 10:08

Arun

2,0232 gold badges34 silver badges50 bronze badges

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

Comments

Keerthana Prabhakaran · Accepted Answer · 2017-06-17 16:42:07Z

0

The problem is with the indentation!

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
        writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
            row[3] = sorted(list(row[3].split(','))
            writer.writerow(row)

EDIT: For your updated question, there is an indentation problem again!

this

           row[3] = sorted(list(row[3].split(','))
                writer.writerow(row)

should be

                row[3] = sorted(list(row[3].split(','))
                writer.writerow(row)

edited Jun 17, 2017 at 16:42

answered Jun 16, 2017 at 9:57

Keerthana Prabhakaran

3,8071 gold badge16 silver badges25 bronze badges

2 Comments

juanpa.arrivillaga Over a year ago

A different error would have been thrown in that case. If you look, the sorted call on the previous line is missing the closing parenthesis

user2779202 Over a year ago

Thanks for your response .. even this code is also giving the same error

Collectives™ on Stack Overflow

reading csv file and writing to another file using python

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related