Adding multiple empty rows to a csv file

Question

I have a csv file with around 500 lines, i want to insert multiple empty rows for each row , i.e add 5 empty rows after each row, so i tried this

import csv
with open("new.csv", 'r') as infile:
    read=csv.reader(infile, delimiter=',')
    with open("output1.csv", 'wt') as output:
        outwriter=csv.writer(output, delimiter=',')
        i = 0
        for row in read:
             outwriter.writerow(row)
             i += 1
             outwriter.writerow([])

This creates 3 empty rows but not 5, i am not sure on how to add 5 rows for each row. what am i missing here

Update: CSV File sample

No,First,Sec,Thir,Fourth
1,A,B,C,D
2,A,B,C,D
3,A,B,C,D
4,A,B,C,D
5,A,B,C,D
6,A,B,C,D
7,A,B,C,D
8,A,B,C,D

Adding the output csv file for answer code

John Anderson · Accepted Answer · 2019-01-06 16:22:22Z

1

Your code actually only adds one blank line. Use a loop to add as many as you want:

import csv
with open("new.csv", 'r') as infile:
    read=csv.reader(infile, delimiter=',')
    with open("output1.csv", 'wt') as output:
        outwriter=csv.writer(output, delimiter=',')
        for row in read:
             outwriter.writerow(row)
             for i in range(5):
                 outwriter.writerow([])

answered Jan 6, 2019 at 16:22

John Anderson

39.4k4 gold badges19 silver badges41 bronze badges

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

9 Comments

foret Over a year ago

This actually adds 11 empty rows instead of 5

John Anderson Over a year ago

For my csv file, your original code adds one blank line after each line in the original file, and my code adds 5 blank lines for each line. Please show us a sample of you csv file. Perhap there is something odd in it.

John Anderson Over a year ago

Do your original csv lines happen to end with \n\n?

foret Over a year ago

Added the csv file sample

John Anderson Over a year ago

When I copy your csv example to new.csv and run my code, I get 5 blank lines after each line in the output1.csv file. There must be something else happening. How are you running the code?

|

foret · Accepted Answer · 2019-01-07 02:59:16Z

The following code fixes it from the answer given by John Anderson, adding an additional newline='' parameter inside the open method gives the exact number of empty rows in range

import csv
with open("new.csv", 'r') as infile:
    read=csv.reader(infile, delimiter=',')
    with open("output1.csv", 'wt',newline='') as output:
        outwriter=csv.writer(output, delimiter=',')
        for row in read:
             outwriter.writerow(row)
             for i in range(5):
                 outwriter.writerow([])

Collectives™ on Stack Overflow

Adding multiple empty rows to a csv file

2 Answers 2

9 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Related