Skip to main content
2025 Python Packaging Survey is now live!  Take the survey now

Helpers for teaching purposes (includes sqllite helpers).

Project description

https://github.com/sdpython/pyensae/blob/master/_doc/sphinxdoc/source/phdoc_static/project_ico.png?raw=true

pyensae: hide complexity for teachings

Build status Build Status Windows https://circleci.com/gh/sdpython/pyensae/tree/master.svg?style=svg https://badge.fury.io/py/pyensae.svg MIT License Requirements Status https://codecov.io/github/sdpython/pyensae/coverage.svg?branch=master GitHub Issues Notebook Coverage Downloads Forks Stars Downloads Forks Stars

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:

History

current - 2020-04-24 - 0.00Mb

  • 34: Extend the list of dependencies (2020-04-24)

  • 33: Failure when updating to pandas 1.0 (2020-02-02)

1.3.825 - 2019-09-20 - 0.45Mb

  • 31: Remove strong dependency on qgrid (2019-09-19)

  • 30: add a None ordered parameter (2019-09-19)

  • 29: StockPrice fails with pandas 0.24 (2019-02-02)

  • 28: Python 2 vs Python 3 (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)

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

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

  • 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)

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page