Selenium WebDriver Write data line by line into CSV

Question

I am trying to Write some data in a CSV file using Selenium

While running the Code

labels = browser.find_elements_by_xpath('.//a[@class="question-hyperlink"]')
text = [x.text for x in labels]
data.append(text)
print(text)
with open('output.csv', 'wb') as data_file:
    writer = csv.writer(data_file)
    writer.writerows(data)

the output am getting is

data1  data2  data3  data4  data5
data6  data7  data8  data9  data10
data11 data12 data13 data14 data15

But I want to write the data as below

data1
data2
data3
data4
.....
data15

How can I do that?
please help me.

Nihal · Accepted Answer · 2018-07-28 12:47:42Z

1

use writer = csv.writer(data_file, delimiter='\n') delimiter

labels = browser.find_elements_by_xpath('.//a[@class="question-hyperlink"]')
text = [x.text for x in labels]
data.append(text)
print(text)
with open('output.csv', 'wb') as data_file:
    writer = csv.writer(data_file, delimiter='\n')
    writer.writerows(data)

answered Jul 28, 2018 at 12:47

Nihal

5,3547 gold badges26 silver badges41 bronze badges

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

Comments

taras · Accepted Answer · 2018-07-28 12:54:11Z

1

Change data.append(text) to data.extend(text). In such a way you will have a flat list data instead of list of lists.

In order to have a single value per row, you need to make each item in data a singleton list

 writer.writerows(map(lambda x: [x], data))

answered Jul 28, 2018 at 12:54

taras

6,93510 gold badges46 silver badges54 bronze badges

Collectives™ on Stack Overflow

Selenium WebDriver Write data line by line into CSV

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related