Writing into csv file would export in excel wrong

Question

i have a problem with writing into a csv file. First the "lists" in the code would return a list that has the usernames with a lot of gaps and does not show properly. Secondly once I try to write it in the csv file I would get each character of the username in a different cell in excel.

for i in range(0,33):
    link = (df.link.iloc[i])
    source1 = urllib.request.urlopen(link).read()
    soup1 = bs.BeautifulSoup(source1,'lxml')
    for username in soup1.find_all('div', class_="user-name"):
        lists.append(username.text)
#    for time in soup1.find_all('div',class_="thread-ago"):
example = open('generalinfo.csv','w')
wr = csv.writer(example,quoting = csv.QUOTE_ALL)        
wr.writerows(lists)    
example.close()

Stephen Rauch · Accepted Answer · 2017-01-20 07:30:06Z

1

writerows() needs a list of lists, try::

for username in soup1.find_all('div', class_="user-name"):
    lists.append([username.text])

answered Jan 20, 2017 at 7:30

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

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

Comments

DYZ · Accepted Answer · 2017-01-20 07:29:51Z

0

wr.writerows(lists) expects a list of lists of strings. In your snippet, it is a list of strings. Each string (being a sequence) is implicitly converted to a list of characters, and each character is written in its own cell. Here's how to fix:

lists.append([username.text])

answered Jan 20, 2017 at 7:29

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

1 Comment

Data1234 Over a year ago

Thank you! Do you happen to know how can I avoid having all this gaps in the lists on python?

Collectives™ on Stack Overflow

Writing into csv file would export in excel wrong

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related