Python script debug

I have a small python script and the issue I am facing is is the code is unable to write data into csv file at the end.
The code says that file is generated, but when I check the directory, I can't seem to find the file.

https://we.tl/t-8mhoqubVKx
this is the python code