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)