# Getting started

## Set up the dataset

This tutorial uses a publicly-available dataset ([download titanic\_dataset.csv](../../../assets/1a36445553362d35b52ede3ba5a5f2f5712ee62b8aa2ef8520232c9cba259bd7.csv)) containing information about passengers on the Titanic.

The dataset includes name, age, sex, and other identifying information about passengers on the Titanic. Navigate to Foundry and open your personal Project. Create a folder named `Code Workbook Tutorial` and upload the Titanic dataset there, naming it `titanic_dataset`.

## Set up a Code Workbook

Click the **New** button in the Project and select **Code Workbook** to create a new Workbook.

## Import a dataset

Click **Import Dataset** to begin. In the dialog that appears, search for `titanic_dataset`. Choose the file you created during the setup process, which should be in `/user/Code Workbook Tutorial/titanic_dataset`.

Once you have identified the desired dataset, click on the file and then click Select to add the dataset to your graph.

## Transforming data using Python

Now that `titanic_dataset` is imported into the workbook, we can transform it using code and pieces of reusable logic. Add a downstream transform by hovering over `titanic_dataset` and clicking the **+** sign. This brings up a dropdown showing various transformation options - choose Python.

![Selecting Python as transform language](../../../assets/664d70913d71fb2a47e8458ccfaaa5fddea061c6b87c9456528671b4bc0bcb06.webp)

A Python code node now appears on the graph, with a connecting line showing it is a child of `titanic_dataset`. Give this transform an alias, `titanic_filtered`, by clicking into the text box at the top of the logic tab.

By default, newly created transforms are not saved as datasets in Foundry. You can choose to save the results of a transform as a dataset by clicking on the **Save as dataset** toggle. [Learn more about saving transforms as datasets.](../optional-data-persistence/index.md) Transforms that are saved as datasets have two names: the alias, and the name of the Foundry dataset.

## Using a Pandas dataframe

If you are more comfortable using Pandas syntax, you are able to use Pandas in Python nodes. Update `titanic_filtered` to use Pandas.

First, we need to change the input type of `titanic_dataset`. Click into the Inputs tab in the logic panel and expand the sidebar. You will see that the Input Type is set as Spark dataframe. Click the dropdown and select Pandas dataframe to change the input type of `titanic_dataset` to a Pandas dataframe.

Next, update your code to work with a Pandas dataframe, performing the same filter.

```python
def titanic_filtered(titanic_dataset):
    output_df = titanic_dataset[(titanic_dataset['Survived'] == 1) & (titanic_dataset['Sex'] == 'female')]
    return output_df
```

This code will output a Pandas dataframe with the female Titanic survivors.

## Using Console

The console provides a REPL (read-evaluate-print loop) for Code Workbook, enabling rapid, ad-hoc analysis of any transform or input dataset on the graph. To allow for quick iteration in your preferred language, there is a console for each enabled language in your workbook.

Open the console, located on the right hand side of the page. Choose the Python console:

<img src="../../../assets/7e435d6741079e7aadd70d7f66ac15d9f0847dee0d44bb000de40d85b2ff075c.webp" alt="Python console" width="300" />

You can quickly experiment with the data by executing commands in Python. You can also send code from a transform to run in the console by highlighting the code and using the [keyboard shortcut](../keyboard-shortcuts/index.md) `Cmd+Shift+Enter` (macOS) or `Ctrl+Shift+Enter` (Windows).

First, you must import the following PySpark SQL functions in the Python console:

```python
import pyspark.sql.functions as F
```

Then, determine the maximum age of female Titanic survivors:

```python
titanic_filtered.select(F.max('Age')).show()
```

You can also use the SQL console to calculate the same statistic:

```sql
SELECT max(Age) AS max_age FROM titanic_filtered
```