The infamous **djagitit** python package is developed and maintained with love by the CEA Data kommunity.  
If it's not here, you won't need it!  
The name is a play on words. Did you get it?

This package is designed to be a utility python package to help with the most common tasks we all do over and over in many python projects.   
It's also an attempt to standardise the way we do those kind of tasks across the community, which will be helpful for code sharing :)

Examples of tasks are:   

+ connecting and retrieving data from our internal databases (reportingDB, Delphi...)    
+ writing data to those databases   
+ connecting to various apis such as Spotify API, AppleMusic API, Luminate API   
+ managing Tableau Datasets/Extracts    
+ building and sending newsletters   

The current version of the package is in no way definitive.   
Everyone is welcome to contribute to add awesome features to it so that we all benefit from each other work.   

Documentation is not fully completed yet, but don't hesitate to reach to Julien and Matti for any questions.


!!! tip "**Lastest version: v1.1.0**"
  
    * module: **[db](db.md)**
    * module: **[tableau](tableau.md)**
    * subpackage: **[api](api.md)**
        * module: **[spotify][module-spotify]**
        * module: **[apple][module-apple]**
    * subpackage: **[mailing](mailing.md)**
        * module: **[smtp][module-smtp]**
        * module: **[html][module-html]**

!!! abstract "Dependencies"
    All these librairies and their own dependencies are installed automatically when you install the djagitit package

    wheel>=0.42.0  
    setuptools==75.1.0  
    boto3==1.29.4  
    jupyterlab>=4.0.9  
    pandas==2.1.3  
    papermill>=2.5.0  
    pathlib>=1.0.1  
    psycopg2-binary==2.9.9  
    pyarrow>=14.0.1  
    openpyxl>=3.1.2  
    python-dotenv>=1.0.0  
    requests>=2.31.0  
    snowflake-sqlalchemy==1.5.1  
    SQLAlchemy==1.4.50  
    sqlalchemy-redshift==0.8.14  
    spotipy==2.23.0  
    apple-music-python==1.0.5  
    html2image>=2.0.4.3  
    pillow>=10.3.0  
    tableauserverclient==0.28.0  
    tableau_tools  
    tableauhyperapi