> For example, I'm using it with org-capture to track sleep data straight into the table, which results in a table row for each day (with an auto-generated timestamp).
I'm curious how one would do that. Would you mind sharing your capture template?
You can keep it all in one file, along with the code and results of its execution.
That org capture template will feed new data into a table; below it, in the same .org file, you can keep your R code and your Python code and whatever other code you prototype (I often write Elisp code), and you can execute all that code inside the .org file.
This approach is not giving you any new features, it's just optimizing for convenience. Think of .org files as Jupyter notebooks on steroids :).
I'm curious how one would do that. Would you mind sharing your capture template?