How to write to csv?

Question

Python

Good evening, Toaster;)
I'm trying to write several values ​​from different sheets into a csv file.

list1 = ['1', '2', '3']
list2 = ['a', 'b', 'c']
list3 = ['x', 'y', 'z']

As a result, I want to get:

1, a, x
2, b, y
3, c, z

Now I write like this:

resultFile = open("test.csv",'wb')
wr = csv.writer(resultFile, delimiter='\n')
wr.writerow(list1)

But this only writes the elements from the first sheet, how to add the rest?

Answer 1

list1 = ['1', '2', '3']
list2 = ['a', 'b', 'c']
list3 = ['x', 'y', 'z']

with open('eggs.csv', 'wb') as f:
    wr = csv.writer(f)
    wr.writerows([(list1[i], list2[i], list3[i]) for i in range(len(list1))])

Answer 2

Well, what a stupid habit of handicraft - element-by-element loops and line-by-line saving.
Use high level tools.

import pandas as pd
list1 = ['1', '2', '3']
list2 = ['a', 'b', 'c']
list3 = ['x', 'y', 'z']
frame = pd.DataFrame([list1,list2,list3]) # собираем фрейм
frame.to_csv('my_csv_export.csv',index=False) #экспортируем в файл

Answer 3

What if the arrays are formed in a loop, how to write each array in a separate column? I just overwrite a column

def main():
    keyword = ['окна', 'окна ПВХ']

    for i in keyword:
        url = 'https://yandex.ru/search/?text='+i+'&lr=22&rstr=-22'
        all_links = get_all_links(get_html(url)) #получаем список ссылок по ключевому слову i
        for links in all_links:
            frame = pd.DataFrame(all_links, columns=[i])  # собираем фрейм
            frame.to_csv('my_csv_export.csv', index=False)  # экспортируем в файл