Cell Magic Functions along with examples
1. %%time:
Measures the execution time of the entire cell
Example:
Python3
%%timefor i in range(1000000): pass |
Output:
CPU times: user 19 ms, sys: 2 ms, total: 21 ms
Wall time: 24.6 µs
2. %%timeit:
Measures the execution time and performs multiple runs for more accurate timing.
Example:
Python3
%%timeitsum(range(100)) |
Output:
584 ns ± 6.66 ns per loop (mean ± std. dev. of 7 runs, 1,000,000 loops each)
3. %%writefile:
Writes the content of the cell to a file with the specified filename.
Example:
Python3
%%writefile my_script.pyprint("Hello, world!") |
Output:
Writing my_script.py
4. %%markdown or %%md:
Renders the content of the cell as Markdown.
Example:
Python3
%%markdown# This is a Markdown Heading* This is a bullet point |
Output:
Renders as formatted Markdown text.
5. %%bash:
Allows you to run Bash shell commands within the cell.
Example:
Python3
%%bashls -l |
Output:
total 24568
-rw-r--r-- 1 root root 761835 Oct 9 16:14 bodyPerformance.csv
drwxr-xr-x 5 root root 4096 Oct 10 18:00 catboost_info
-rw-r--r-- 1 root root 179414 Oct 10 18:01 CatBoost.ipynb
-rw-r--r-- 1 root root 210263 Oct 9 17:47 catboost_model.pkl
-rw-r--r-- 1 root root 88229 Oct 16 14:10 Correlation.png
-rw-r--r-- 1 root root 6706326 Oct 26 18:30 LightGBM1.ipynb
-rw-r--r-- 1 root root 1039742 Oct 9 18:18 LightGBM .ipynb
-rwxrwxrwx 1 root root 15583484 Sep 26 16:25 LightGBM.ipynb
-rw-r--r-- 1 root root 51773 Oct 19 14:12 model.bin
-rw-r--r-- 1 root root 62296 Oct 19 13:59 model.h5
-rw-r--r-- 1 root root 23 Oct 26 18:27 my_script.py
-rw-r--r-- 1 root root 447296 Oct 26 17:50 placementdata.csv
6. %%html:
This cell magic function renders contents of code cell as html script.
Example:
Python3
%%html<font size=10 color='hotpink'>Hello World</font> |
Output:
Renders as HTML
7. %%debug:
Activates the interactive debugger for the cell.
Example:
%%debug
Code executations
Python3
%%debugx = 5y = 0result = x / y |
Output:
NOTE: Enter 'c' at the ipdb> prompt to continue execution.
> <string>(2)<module>()
ipdb> c
---------------------------------------------------------------------------
ZeroDivisionError Traceback (most recent call last)
ZeroDivisionError: division by zero
8. %%javascript:
Allows you to execute JavaScript code within the cell.
Example:
Python3
%%javascriptalert("This is a JavaScript alert!") |
Output:
Executes the JavaScript code and displays an alert.
9. %%latex:
Renders LaTeX equations and expressions in the cell.
Example:
Python3
%%latex$e^{i\pi} + 1 = 0$ |
Output:
Renders as a LaTeX equation.
Screenshot Output:
10. %%matplotlib
Enable inline plotting of Matplotlib figures in Jupyter Notebook
Example:
Python3
%matplotlib inlineimport matplotlib.pyplot as plt# Generate some datadata = [1, 2, 3, 4, 5]# Create a plotplt.plot(data)plt.title("Simple Line Plot")plt.xlabel("X-axis")plt.ylabel("Y-axis")plt.show() |
Ouput:
11. %%sql
%sql allows you to execute SQL queries directly in a code cell when using a SQL kernel:
Example:
Python3
%load_ext sql%sql sqlite:///mydatabase.db%%sqlSELECT * FROM Employees WHERE department = 'Sales'; |
Output:
Runs the sql query
There are a lot of cell magic functions which you can find in the official documentation of python and try it on your own, in this article we have only covered the most commonly used cell magic functions.
Jupyter Notebook – Cell Magic Functions
In this article, we will cover Cell Magic Functions in Jupyter Notebook we will discuss various functions. But first, we look at what Jupyter Notebook and Cell Magic functions and why we use them. There are a lot of cell magic functions but in this article, we discuss the most commonly used cell magic functions.