pyensae 1.3.825

Helpers for teaching purposes (includes sqllite helpers).

pyensae: hide complexity for teachings

This project contains helpers used at the ENSAE for teachings available at ENSAE - Programmation - Xavier Dupré. It was the first module created for that usage. It does not have a clear purpose except hiding some annoying logic and shorten notebooks. It can:

• retrieve data for practical lessons
• import a tsv file into a database
• retrieve stock prices from Yahoo Finance

It implements a couple of magic commands to play with SQLite3 in a notebook and easily show the head or tail of a text file. It can fill missing values in timeseries with add_missing_indices or download data from a website, a helper to change the size of folium maps or some grammar to parse language such as R or SQL. It also implements a basic way to convert a R script into nasty Python.

Links:

• GitHub/pyensae
• documentation
• Blog

History

current - 2019-09-19 - 0.00Mb

• 30: add a None ordered parameter (2019-09-19)
• 31: Remove strong dependency on qgrid (2019-09-19)
• 28: Python 2 vs Python 3 (2019-02-02)
• 29: StockPrice fails with pandas 0.24 (2019-02-02)
• 26: update default antlr4 version to 4.7.1 (2018-10-25)
• 25: update CSharp grammar (2018-10-25)

1.2.788 - 2018-07-31 - 0.48Mb

• 21: remove underscores in subfolders (2018-07-31)
• 24: fix download_data when url is a list or urls (2018-06-16)
• 23: fix add_missing_indices failing due to more strict comparisons in pandas 0.23 (2018-05-21)
• 19: velib collection, group files instead of having multiple files (moved to maydataapi) (2018-05-21)

1.2.776 - 2018-05-20 - 0.48Mb

• 22: move pandas_groupby_nan to pandas_streaming (2018-05-17)
• 20: move access to API to manydataapi (2018-05-05)

1.2.743 - 2018-04-14 - 0.49Mb

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)