pyensae documentation

Build status Build Status Windows GitHub Issues MIT License Code Health Requirements Status Waffle

Links: pypi, github, documentation, wheel, travis, README, blog, Issues

What is it?

This project contains helpers used at the ENSAE for teaching purposes but not only. It requires github/pyquickhelper.

Data used for teachings at the ENSAE are available through function:

download_data("", website = "xd")

The data comes from The module also implements magic commands to access an Hadoop cluster (Azure, Cloudera), to run SQL queries on SQLite, parsing financial data from Yahoo Finance.


  • retrieve data for practical lessons (see download_data)
  • import a tsv file into a database (see import_flatfile_into_database)
  • retrieve stock prices from Yahoo Finance (see StockPrices)
  • magic commands to easily use SQLite3 from a notebook (see MagicSQL)
  • magic commands to access a Cloudera Cluster and run PIG jobs (see MagicRemoteSSH)
  • magic commands to access Azure Blob Storage and HDInsight (see MagicAzure)
  • magic commands to display content of a folder in DataFrame (see MagicFile)
  • magic commands to display an autamated menu in a notebook (see MagicFile)


For the class StockPrices:
The ASSHClient requires:
The AzureClient requires:

The function register_magics_ssh defines magic commands to send commands to a remote commands through a SSH connection:

  • %remote_open, %remote_close
  • %remote_cmd, %remote_up, %remote_down

The magic commands will be automatically enabled if the module is imported from a notebook. It also proposes others magic commands such as %head, %tail, %textdiff, %hhelp, %runpy, %lsr, %compress. Type <magic_command> -h to get their usage.


pip install pyquickhelper or to avoid installing the dependencies pip install pyquickhelper --no-deps.