topic Re: Basic Statistics in Incorta (using Python if necessary) in Dashboards & Analytics Discussions

Basic Statistics in Incorta (using Python if necessary)

olekern — Tue, 03 Jan 2023 22:00:02 GMT

Are there much simpler examples of projects using Python then the ML Data Science in the video? For example, the software running our manufacturing machinery produces samples of production times in a database table. I would like to graph these in violin plots using Python and wondering how to go about doing this (I'm rather new to Python)...probably showing them in a daily report (changes every day).

Also, my company is on the cloud version 4.9.13 June 3rd, 2021. Is this an issue for using Python? Does the cloud version not auto update with each new version?

Some of the examples in the link below look great.

https://plotly.com/python/violin/

Re: Basic Statistics in Incorta (using Python if necessary)

LukeG — Thu, 05 Jan 2023 20:26:10 GMT

Hi @olekern,

Is your goal to show a violin chart in a dashboard and have it refresh on a daily basis, or are you looking to visualize the data using python in an interactive notebook?

I'm happy to help explore both options 🙂

Re: Basic Statistics in Incorta (using Python if necessary)

olekern — Tue, 10 Jan 2023 21:40:05 GMT

Hi Luke,

I'd say either/both?

First to clarify...we're actually using the on-premise version....4.9.13. I don't see any violin plot options so guessed it would need Python.

We don't have it installed currently and the data hasn't been uploaded into Incorta yet, but I think it could happen in a few days or at least a couple weeks. Attached is sample.

I'd like to maybe default to the current (or prior) date with the option to have it change with the user filtering to a different date.

Re: Basic Statistics in Incorta (using Python if necessary)

LukeG — Thu, 12 Jan 2023 16:29:13 GMT

Hi @olekern,

You are correct. In your version of Incorta, there is no option for violin plot. However, current cloud versions support the Component SDK. In the future there may be a violin component created that is compatible with your version as you upgrade.

In the meantime, you have the option to use the plotly library using a pyspark notebook. The sample code from your original post is close to functional, but I had to make a couple of updates. Here is a sample code block that should work:

#import libraries import plotly import plotly.express as px #get sample dataset df = px.data.tips() #create visualization fig = px.violin(df, y="total_bill") #show visualization Incorta.show_plotly(fig)

The same result can be achieved with any dataset that has a numeric column to visualize. Please let me know if there are any other questions you have. Happy to help 🙂

Thank you @dylanwan for helping me find a solution here.