Skip to content

Using Pandas and Python to create a cross- joined DataFrame, then create CQL expression and a JSON file for the API

Notifications You must be signed in to change notification settings

charthop/Cross-Join-Fun-for-CQL

Repository files navigation

Cross Join Fun

When the client needs every combination of everything all at once

In this repository we use Pandas and Python to imitate an SQL cross-join. This gives us a DataFrame with all the combinations of all the rows of data (staying in order left to right). Using that data frame, we then concat a CQL expression for each combination and convert the data frame into a JSON file for the API push into ChartHop.

Tools to Get Started:

Tool Link
Pandas https://pandas.pydata.org/docs/getting_started/install.html
VS Studio https://code.visualstudio.com/download
Jupyter Notebook Package https://pypi.org/project/jupyter/

About

Using Pandas and Python to create a cross- joined DataFrame, then create CQL expression and a JSON file for the API

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published