pyensae 1.2.743

Helpers for teaching purposes (includes sqllite helpers)

README

Links:

• GitHub/pyensae

• documentation

• Blog

Description

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

Functionalities

• 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

Dependencies

• numpy

• pandas

• pyquickhelper

Class StockPrices requires:

• dateutil

• six

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.

Contributions

Started in 2013/08.

• First contributor: Xavier Dupré.

• Others contributors: ENSAE’s students.

History

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 (matplotlib.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)