This lib allows you to integrate qlik with jupyter notebook.
PyToQlik is a library that allows you to integrate Qlik Desktop with Jupyter notebooks. With it you can:
- Open and edit a Qlik app inside a Jupyter notebook;
- Create a Qlik object with data from a pandas DataFrame data structure and/or;
- Import data from a Qlik object and create a pandas DataFrame to work with in Python.
Latest Updates (24/jun/2021)
:star2: Just added some basic Qlik Cloud SaaS functionalities! :star2:
Be a more powerful data scientist by importing and extracting data from Qlik objects in Cloud applications inside your tenant!
For this library to work you might want to have a functioning Qlik Desktop App installed and running on your local machine, or, if using the Cloud version, you will need an API Key to your tenant. There are tutorials on here and on Qlik's website about API Keys. You will also find having the pandas library useful, and either a Jupyter Notebook local server or use something like Google Colaboratory
You can then download and install PyToQlik using:
pip install pytoqlik
Creating a Qlik app and feeding it data
from pytoqlik import Pytoqlik import seaborn df = seaborn.load_dataset('tips') # df is just some example data provided by the seaborn library p2q = Pytoqlik() app = p2q.toQlik(df)
Importing data from a Qlik object to Python
from pytoqlik import Pytoqlik import seaborn df = seaborn.load_dataset('tips') # df is just some example data provided by the seaborn library p2q = Pytoqlik() app = p2q.toQlik(df) app.toPy('your ObjectID')
Step by step guide
PyToQlik current documentation can be found HERE.
Comprehensive Qlik Cloud tutorial
A case-study based tutorial has been developed and is available HERE.
Features in development
- Qlik Enterprise support
- Qlik Cloud robustness (easy-to-use embedding, more global functionality)
- Data fetching based on dimension and measure names
- More robust embedding objects and sheets
- More robust script editing (appending and replacing)
- Object creation and manipulation via Python
- Auxiliary functions, app listing and object listing
- Task creation and managing
- ETL features in Python
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for pytoqlik-0.0.10-py3-none-any.whl