KwickClips Python · 42 sec · free
Why is there a blank row after every CSV row?
Short answer. The writer adds a line ending, and Windows text mode adds another.
How do you fix it?
Open the file with newline="".
Remember
| Always use newline="" |
| Mode w erases old rows |
A blank row after every CSV row? Here is why. The csv writer adds its own line ending. On Windows, text mode adds one more. Newline equals empty quotes stops it. Always use newline equals empty quotes. The mode w erases old rows.
This clip is from the full lesson: CSV Files with the csv Module — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 12 Computer Science (083), CBSE Class 12 Computer Science (083), CBSE Class 11 Artificial Intelligence (843), Programming All levels Python
More KwickClips from this lesson
What does CSV stand for?38 sec
What does writerows() take?41 sec![Code looping csv.reader over two lines and printing ['Om', '88'] and ['Anu', '76'].](/images/learn/clips/PY26-R3.webp)
Is 88 read from a CSV a number?38 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.