Thanks for your reply. I tried your proposal, but it seems that to_csv does not support in-memory compression, it only appears to work if a file handle or file is passed as input.
RuntimeWarning: compression has no effect when passing file-like object as input.
I thing the issue is described here
So, I went ahead and naively tried to save to local find and download that