CSV writer writing way less than half of displayed values- very agitated and confused

[fallow trout]

My code is in this pastebin:
https://pastebin.com/2yujb5Cw

You can see from my debugger image that myValue, readings, timestamp, and station_id are all valid. But I just cannot get it to write to the csv. You can see that it clearly tricks me into thinking it's written, but there's nothing in the csv file!

It even creates the .csv so it's obvious that it knows where the file is.

I googled, I'm not opening the file twice in the loop, it's just insistently not writing???????

I'm panicking. I don't understand why this is happening??

[zealous siren]

Add a logger or print in each loop, log what is the item, so that you ensure items are not empty

[dawn granite]

I googled, I'm not opening the file twice in the loop, it's just insistently not writing???????
good guess - looks like you actually are opening the file twice. Look at your open calls.

[fallow trout]

i see it now. so how should i change it?

should I should only open it in initiate_download? and then pass the opened file as a variable into export_to_csv?