Templates

Our course project template can be found here, or on Anvil:

/anvil/projects/tdm/etc/think_summer_project_template.ipynb

Students can use and modify this as a template as needed, for all project submissions. This template is a starting point for all projects.

By default, the think-summer kernel runs Python code. To run other types of code, see below.

Running R code using the think-summer kernel

%%R

my_vec <- c(1,2,3)
my_vec

As you can see, any cell that begins with %%R will run the R code in that cell. If a cell does not begin with %%R, it will be assumed that the code is Python code, and run accordingly.

Running SQL queries using the think-summer kernel

  1. First, you need to establish a connection with the database. If this is a sqlite database, you can use the following command.

    %sql sqlite:///my_db.db
    # or
    %sql sqlite:////home/class/datamine/path/to/my_db.db

    Otherwise, if this is a mysql database, you can use the following command.

    %sql mariadb+pymysql://username:[email protected]_url.com/my_database
  2. Next, to run SQL queries, in a new cell, run the following.

    %%sql
    
    SELECT * FROM my_table;

As you can see, any cell that begins with %%sql will run the SQL query in that cell. If a cell does not begin with %%sql, it will be assumed that the code is Python code, and run accordingly.

Running bash code using the think-summer kernel

To run bash code, in a new cell, run the following.

%%bash

ls -la

As you can see, any cell that begins with %%bash will run the bash code in that cell. If a cell does not begin with %%bash, it will be assumed that the code is Python code, and run accordingly.

Code cells that start with % or %% are sometimes referred to as magic cells. To see a list of available magics, run %lsmagic in a cell.

The commands listed in the "line" section are run with a single % and can be mixed with other code. For example, the following cell contains (in order) some Python code, uses a single line magic, followed by some more Python code.

import pandas as pd

%time myDF = pd.read_parquet("/anvil/projects/tdm/data/whin/weather.parquet")

myDF.head()

The commands listed in the "cell" section are run with a double %% and apply to the entire cell, rather than just a single line. For example, %%bash is an example of a cell magic.

You can read more about some of the available magics in the official documentation.

Including an image in your notebook

To include an image in your notebook, use the following Python code.

from IPython import display
display.Image("./cloud.png")

Here, ./cloud.png is the path to the image you would like to include.

If you choose to include an image using a Markdown cell, and the ![](…​) syntax, please note that while the notebook will render properly in our ondemand.anvil.rcac.purdue.edu environment, it will not load properly in any other environment where that image is not available. For this reason it is critical to include images using the method shown here.