[Raro]

Codex has the capacity to write decent Python code. A large part of getting great results from it is writing clear, well separated, prompts. Also taking it off streaming mode, to get best N results, and penalizing repetition, improves the output dramatically. Even better if you can give further hints (e.g. import pandas) before submitting.

Of course, it's merely trained on code it's seen on GitHub, so it certainly has a particular smell to it (disclaimer: I focus on Data Science related code, which is not always of the highest quality and has its share of cargo-culting).

Most of the demos you will likely have seen are in streaming mode, have vague prompts with a high temperature setting.