papermill VS cheatsheets

Pandas docs > Comparison with spreadsheets: https://pandas.pydata.org/docs/getting_started/comparison/co...

Pandas docs > I/O > Excel files: https://pandas.pydata.org/docs/user_guide/io.html#excel-file...

nteract/papermill: https://github.com/nteract/papermill :

> papermill is a tool for parameterizing, executing, and analyzing Jupyter Notebooks. [...]

> This opens up new opportunities for how notebooks can be used. For example:

> - Perhaps you have a financial report that you wish to run with different values on the first or last day of a month or at the beginning or end of the year, using parameters makes this task easier.

"The World Excel Championship is being broadcast on ESPN" (2022) https://news.ycombinator.com/item?id=32420925 :

> Computational notebook speedrun ideas:

There is Papermill ... https://github.com/nteract/papermill

https://github.com/jupyter/enhancement-proposals/pull/103#is...

Papermill is one tool for running Jupyter notebooks as reports; with the date in the filename. https://papermill.readthedocs.io/en/latest/

You may be interested in papermill to address the parametrized analysis problem [1]. I think (but I'm not positive) this is what the data team at a previous job used to automate running notebooks for all sorts nightly reports.

[1] https://papermill.readthedocs.io/en/latest/#

I'm using Papermill to operationalize Notebooks (https://github.com/nteract/papermill), it e.g. also has airflow support. I'm really happy with papermill for automatic notebook execution, in my field it's nice that we can go very quickly from analysis to operations -- while having super transparent "logging" in the executed notebooks.

papermill bcpandas fastapi

But you can execute your notebook using Jupyter-run or papermill.

As a first option, we will use Papermill, which has a Python API that allows us to run different notebooks using some functions:

Papermill can also target cloud storage outputs for hosting rendered notebooks, execute notebooks from custom Python code, and even be used within distributed data pipelines like Dagster (see Dagstermill). For more information, see the papermill documentation.

Papermill Source Code

If you're an R user, stringr + its cheatsheet gets you very close to remembering what to do without needing to look further!

For more information on how to use ggplot2 and create charts consult the ggplot2 official page or the ggplot2 cheat graphic.

I'd suggest you have a look at cheatsheets (or download them from GitHub) if you want to get to know your way around a package or set if functions, it saves you a lot of time.

You could use geom_hline and geom_vline, geom_abline, or geom_segment for this. (The ggplot cheat sheet is very useful for answering these kinds of questions, BTW.)

I can't say for sure because I don't know what your ultimate aim is for your visualization. Check out the cheat sheet for ggplot2 here.

Finally just do your analysis. You should also should give a try and see the cheat sheet for data importing on the tidyverse package.

That said, when I’m trying to come up with an interesting way to visualize data, I find the ggplot cheat sheet very helpful: https://github.com/rstudio/cheatsheets/raw/main/data-visualization-2.1.pdf

Here's a cheat sheet: https://github.com/rstudio/cheatsheets/blob/main/strings.pdf

The cheat sheet of the stringr package should give you good overview of string manipulation/ regex in R.

I would very highly recommend that rather than trying to get started by translating an existing graph, you check out some documentation about ggplot first. If nothing else, the ggplot cheat sheet from RStudio should help explain what the component parts of the code are, and that might help you figure out what you actually want to do.