Python and Dataiku DSS

Python and Dataiku DSS

Learn how to integrate Python code into Dataiku DSS

About this course

Dataiku allows you to seamlessly integrate Python code and visual recipes in a flow.

In this course, we will show you how to:

  • Integrate Python as part of your data pipeline through code recipes
  • Use Jupyter notebooks to prototype and test code
  • Transfer a Dataiku dataset into a pandas dataframe and back, using the dataiku Python package
  • Read and write data without using the dataiku package
  • Run SQL queries directly from a Python recipe, which lets you:
    • Sequence several SQL queries
    • Dynamically generate some new SQL queries to execute in the database
    • Use SQL to obtain some aggregated data for further numerical processing in Python
  •  

Curriculum

  • Basics of Python in Dataiku DSS
  • Reading or writing a dataset with custom Python code
  • How-To: Use SQL from a Python Recipe in DSS
  • Sessionization in SQL, Hive, Pig and Python

About this course

Dataiku allows you to seamlessly integrate Python code and visual recipes in a flow.

In this course, we will show you how to:

  • Integrate Python as part of your data pipeline through code recipes
  • Use Jupyter notebooks to prototype and test code
  • Transfer a Dataiku dataset into a pandas dataframe and back, using the dataiku Python package
  • Read and write data without using the dataiku package
  • Run SQL queries directly from a Python recipe, which lets you:
    • Sequence several SQL queries
    • Dynamically generate some new SQL queries to execute in the database
    • Use SQL to obtain some aggregated data for further numerical processing in Python
  •  

Curriculum

  • Basics of Python in Dataiku DSS
  • Reading or writing a dataset with custom Python code
  • How-To: Use SQL from a Python Recipe in DSS
  • Sessionization in SQL, Hive, Pig and Python