In this page briefly introduce the main components of the Jupyter Notebookenvironment. For a more complete overview see References.
Contents
- What is the Jupyter Notebook?
Notebook documents (or “notebooks”, all lower case) are documentsproduced by the Jupyter Notebook App, which contain both computer code (e.g. python)and rich text elements (paragraph, equations, figures, links, etc…).Notebook documents are both human-readable documents containing the analysisdescription and the results (figures, tables, etc..) as well as executable documentswhich can be run to perform data analysis.
In a workbook with multiple worksheets, we can create a formula that will reference a cell in a different worksheet from the one you are working in. Select the cell where the formula should go ex: C7 Press the equal sign, and then click on the sheet you wish to reference.
When you start Excel, click Blank workbook to create an Excel workbook from scratch. 3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets. When writing a formula in Microsoft Excel, you can press the F4 key on your keyboard to switch between relative, absolute, and mixed cell references, as shown in the video below. This is an easy way to quickly insert an absolute reference.
References: Notebook documents in the project homepage and in the official docs.
Excel Jupyter Notebook
The Jupyter Notebook App is a server-client application that allowsediting and running notebook documentsvia a web browser.The Jupyter Notebook App can be executed on a local desktoprequiring no internet access (as described in this document)or can be installed on a remote server and accessed through the internet.
In addition to displaying/editing/running notebook documents,the Jupyter Notebook App has a “Dashboard” (Notebook Dashboard),a “control panel” showing local files and allowing toopen notebook documents or shutting down their kernels.
References: Jupyter Notebook Appin the project homepage andin the official docs.
A notebook kernel is a “computational engine”that executes the code contained in a Notebook document.The ipython kernel, referenced in this guide, executes python code.Kernels for many other languages exist(official kernels).
When you open a Notebook document, the associated kernel is automatically launched.When the notebook is executed (either cell-by-cell or with menu Cell -> Run All),the kernel performs the computation and produces the results.Depending on the type of computations, the kernel may consume significantCPU and RAM. Note that the RAM is not released until the kernel is shut-down.
See also Close a notebook: kernel shut down.
References: from the official docsOpening Notebooks andDecoupled two-process model.
The Notebook Dashboard is the component whichis shown first when you launch Jupyter Notebook App.The Notebook Dashboard is mainly used to open notebook documents,and to manage the running kernels (visualize and shutdown).
The Notebook Dashboard has other features similar to a file manager, namelynavigating folders and renaming/deleting files.
References: from the official docsOpening Notebooks.
Official Jupyter Project Pages:
Official Documentation:
Excel Notebook Paper
See also:
- Notebook Basics, an example notebook
- Jupyter Notebook: The Definitive Guide, an introductory tutorial to Jupyter
Jupyter Notebook Excel
The Next button will bring you to the next section (Installation).