Skip to main content
Help improve PyPI by participating in a 5-minute user interface survey!

Helpers for teaching purposes (includes sqllite helpers)

Project Description


Build status Build Status Windows MIT License Requirements Status GitHub Issues Waffle Notebook Coverage



This project contains helpers used at the ENSAE for teachings available at ENSAE - Programmation - Xavier Dupré.


  • retrieve data for practical lessons
  • import a tsv file into a database
  • retrieve stock prices from Yahoo Finance
  • magic commands to easily use SQLite3 from a notebook


Class StockPrices requires:

The function register_magics 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.


Started in 2013/08.

  • First contributor: Xavier Dupré.
  • Others contributors: ENSAE’s students.


current - 2018-04-14 - 0.00Mb

1.2.731 - 2018-03-22 - 0.50Mb

  • 18: fix urls to download data (google, yahoo) (2018-03-16)

1.2.722 - 2018-03-11 - 0.50Mb

  • 17: update candle plot for finance ( was removed in 2.2.0) (2018-03-10)

1.2.717 - 2018-02-20 - 0.50Mb

  • 16: split pyensae into pyenbc for remote access to clusters and the rest (2017-11-29)

1.1.689 - 2017-11-21 - 7.56Mb

  • 15: StockPrices: start and end date are not taking into account with the default data provider (2017-09-17)
  • 14: StockPrices: switch to google as default data provider (2017-09-17)
  • 13: add a class TableFormula as an example to extend pandas dataframe (2017-09-03)
  • 11: create graph image with blockdiag (2017-08-18)
  • 10: fix download_data (2017-08-12)
  • 9: Finance (2017-08-05)
  • 5: allow to submit a hive job on HDInsight from a notebook (2017-02-25)
  • 6: fix appveyor build (2016-06-22)
  • 4: use pyquickhelper magic parser to interpret python variable for azure magic commands (2016-05-14)

Release history Release notifications

This version
History Node


History Node


History Node


History Node


History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
pyensae-1.2.743-py3-none-any.whl (515.1 kB) Copy SHA256 hash SHA256 Wheel 3.6 Apr 14, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page