pyensae 1.1.689

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

• magic commands to access a Cloudera Cluster and run PIG jobs

• magic commands to access Azure Blob Storage and HDInsight

• magic commands to display content of a folder in DataFrame

Dependencies

• numpy

• pandas

• pyquickhelper

Class StockPrices requires:

• dateutil

• six

Class ASSHClient requires:

• paramiko

• pycrypto

• ecdsa

Class AzureClient requires:

• azure

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

1.1.???? (2017-??-??)

Bug

• 15: StockPrices: start and end date are not taking into account with the default data provider

Features

• 9: switch from Yahoo Finance to Google as the default provider for financial data

• 11: create graph image with blockdiag

• 13: add a class TableFormula as an example to extend pandas dataframe