<jupyter_start><jupyter_text>writefile will create a file and write the given content on it. If file already exists then it will overwrite.<jupyter_code>%%writefile test.txt      
this is written from a jupyter 
%notebook
%ls<jupyter_output>MyFirstNotebook.ipynb        [34mmachinelearning[m[m/
Untitled.ipynb               test.txt
juypyterMagicFunction.ipynb<jupyter_text>html will let you insert images and videso to the notebook.<jupyter_code>%%HTML
<i> Image in jupyter notebook </i>
<img src="http://imgs.xkcd.com/comics/correlation.png"alt="image in jupyter notebook"></img>
%%latex       #this lets you write formulas in the standard format
\begin{align}
Gradient : \nabla J = - 2H^T (Y-HW)
\end{align}<jupyter_output><empty_output><jupyter_text>load_ext  this can be used to load other extension, we can use it to plug the sql code in this notebook.<jupyter_code>!pip install ipython-sql       #install the sql
%load_ext sql<jupyter_output>The sql extension is already loaded. To reload it, use:
  %reload_ext sql<jupyter_text>sql sqlite: is used to connect to any database<jupyter_code>%sql sqlite://
%%sql
CREATE TABLE classroom(name, age, totalmarks);
INSERT INTO classroom VALUES ('Neeraj', 25, 99);
INSERT INTO classroom VALUES ('SWATI', 22, 100);
%sql SELECT * from classroom;<jupyter_output>* sqlite://
Done.
{'fraction_non_alphanumeric': 0.10082768999247554, 'fraction_numerical': 0.009029345372460496, 'mean_word_length': 4.9375, 'pattern_counts': {'":': 0, '<': 18, '<?xml version=': 0, '>': 18, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '4', 'dir': 'jupyter-structured-clean-dedup', 'id': '379293', 'license': 'MIT', 'n_tokens_mistral': 469, 'n_tokens_neox': 438, 'n_words': 144, 'path': 'notebooks/5.0-extralearning-juypyterMagicFunction.ipynb', 'repo_name': 'neerajmachinelearning/DataScienceEnd2End', 'size': '1329'}