write on csv but getting empty file with no row and columns

Question

I am trying to use a CSV file to store some data. This code creates the file:

with open('keras_character_W.csv', 'w') as csvFile:
    fieldnames = ['images', 'result_character']
    writer = csv.DictWriter(csvFile, fieldnames=fieldnames)
    writer.writeheader()

later, when I am read to store the variables, a command 's' stores them:

state = cv2.waitKey(0)
if state == ord('q'):
   break

elif state == ord('s'):
     writer.writerow({'images': '  '})
     writer.writerow({'images': 'guess_right = ', 'result_character': x, })
     writer.writerow({'images': 'final  = ', 'result_character': y , })

but the CSV file is empty.

"I checked the caps and if the condition satisfied but didn't find anything the file even open on text editor not excel program "

state is user input? It’s difficult to understand what’s going, please include all relevant code and data. See: minimal reproducible example. — AMC
– AMC, Commented Nov 25, 2019 at 8:57
the state is an input from user keyboard obtained by clicking key and if the key was 's' then it will save — Hassan_mohammad
– Hassan_mohammad, Commented Nov 25, 2019 at 9:30
You shouldn’t be using ord() for that, if the input is ”s”. — AMC
– AMC, Commented Nov 25, 2019 at 9:32
the result of the cv2.waitKey(0) is not s i need to use ord to convert it to be matching the letter ord — Hassan_mohammad
– Hassan_mohammad, Commented Nov 25, 2019 at 9:40
Aaah, it wasn’t clear in your post that the input isn’t coming from stdin. — AMC
– AMC, Commented Nov 25, 2019 at 9:40

Charles Merriam · Accepted Answer · 2019-11-25 09:15:50Z

1

It is a bit unclear from your example, but I think you are closing the CSV early.

When you do with open('keras_character_W.csv', 'w') as csvFile:, you start a context in which:

The previous contents of keras_character_W.csv are erased
The file is open for writing
The file will be closed when you exit the with statement, meaning you stop indenting.

Hope this helps!

Keep hacking! Keep notes.

answered Nov 25, 2019 at 9:15

Charles Merriam

20.7k7 gold badges77 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

write on csv but getting empty file with no row and columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related