More '\n' when write csv file using python

Question

I want to write my data crawl to .csv file, but it have more '\n'. This is my code:

for data in soup.find_all('b', {'class' : 'tur highlight'}):
        write.writerow([word, data.get_text()])

And this is the result:

How to remove the blank rows? I use python 3.5

try adding `newline=''` when you open the file to write to or open it with "wb" instead of "w" — Rayhane Mama, Jul 11 '17 at 08:05
no problem, I added some reference to my answer if you want to check it out @RiefSapthana — Rayhane Mama, Jul 11 '17 at 08:20

Exprator · Answer 1 · 2017-07-11T08:20:51.917

2

you can try this

for data in soup.find_all('b', {'class' : 'tur highlight'}):
        if word == '\n' and data.get_text() == '\n':
           pass
        else:
           write.writerow([word, data.get_text()])

or you can use

with open('test_csv.csv','w',newline='') as file:

for python 3

and

with open('test_csv.csv','wb') as file:

for python2

edited Jul 11 '17 at 08:20

answered Jul 11 '17 at 08:03

Exprator

26,992
6
47
59

score 2 · Accepted Answer · answered Jul 11 '17 at 08:17

this problems occurs when using python on windows:

if you're using Python 3.x, add this parameter when opening the file to write to:

newline=''

example:

with open('test_csv.csv','w',newline='') as file:

if you're using Python 2, open the file using "wb" instead of "w".

with open('test_csv.csv','wb') as file:

reference : here

Hope this was helpful.

More '\n' when write csv file using python

2 Answers2