csv file written using python , is empty when opened in linux

Question

i have copied the values from list to csv file like

there are 2 lists say

list1 =['a','b','c','d','e','f','g','h','i','j','k','l','m','n']
list2 = ['1','2','3','4','5','6','7','8','9','10','11','12','13']

and i am writting the 2 lists to csv file using the below code

import csv
from itertools import izip
with open('output1.csv', 'wb') as f:
    writer = csv.writer(f)
    writer.writerows(izip(list1, list2))

when i open output1.csv in linux after executing the above thing , it is empty

but when i print it , using print(open("output1.csv").read()) in python script is printing the contents of the csv file propery

can you please let me know why the file is empty when i opened it in linux

even if i remove b means if it is modified in script like below with open('output1.csv', 'w') as f: , then also not working — SACHIN S SARANGAMATH
– SACHIN S SARANGAMATH, Commented Jan 11, 2018 at 9:53
Is the code indentation correct? Or did you make a mistake in this question? — kuro
– kuro, Commented Jan 11, 2018 at 10:10
ya it is correct , in question it came like that , actually i am able to read the output through open("output1.csv").read() , but file is empty when opened in linux vi output1.csv — SACHIN S SARANGAMATH
– SACHIN S SARANGAMATH, Commented Jan 11, 2018 at 10:14
open("output1.csv")qualifies as opening the file. If you are unable to open it with vi maybe your vi installation is corrupt or you are not using it correctly. — Stop harming Monica
– Stop harming Monica, Commented Jan 11, 2018 at 10:18

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Next time when you are stuck then please be more specific about the error and output you expect so we don't have to waste time assuming your expected output. Now coming to the your problem when i open output1.csv in linux after executing the above thing , it is empty I think you need to read up more about iterators and also about file operations. So running your script in my machine gave me this error which is pretty easy to understand.

TypeError: a bytes-like object is required, not 'str'

Python and it's errors are so readable isn't it !? This error was correct as python was expecting a bytes-like object as the error says! Change that to w+ ( and read more about permissions in the links given in the answer). Now this writer.writerows(izip(list1, list2)) has to understood clearly ( also provided in the links in this answer). When life gives you an iterator, you just iterate it! Grab a reference to iterate the iterator and you are good. Please read more about it.

import csv
from itertools import izip

list1 = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n']
list2 = ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13']

with open('output1.csv', 'w+') as f:
    writer = csv.writer(f)
    writer.writerows([i for i in izip(list1, list2)]) # your homework to figure out what this means and does.

Let me know if this answer worked for you by accepting it!

Cheers!

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 11, 2018 at 10:24

d-coder

14.2k4 gold badges28 silver badges39 bronze badges

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

3 Comments

SACHIN S SARANGAMATH Over a year ago

No again the csv files are empty , above solution dint help to solve the problem

d-coder Over a year ago

What did you try actually ? Are there any errors ? What about helping me helping you with a traceback ?

SACHIN S SARANGAMATH Over a year ago

No errors are there , i can see the output of file through readlines but the file is empty when i open though vi editor

Collectives™ on Stack Overflow

csv file written using python , is empty when opened in linux

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related