atoti is a free Python Business Intelligence (BI) analytics platform for Quants, Data Analysts, Data Scientists & Business Users to collaborate better, analyze faster and translate their data into business Key Performance Indicators (KPIs)
Questions tagged [atoti]
18 questions
3
votes
2 answers
How to change measure to hierarchy in atoti?
I have a categorical data (region code) with high ordinal value.
When I load this dataframe in atoti datastore it is being read as a measure but the data type is an object.
Hence, ideally it should be a hierarchy.
How can I change a measure to an…
Raghav Vashisht
- 81
- 4
3
votes
1 answer
How can I filter vectors dynamically in Atoti?
I'm trying to implement a rolling window value-at-risk aggregation, and wonder if it's possible in Atoti: my main problem is I don't know how to filter vectors by index for each of the "observation windows".
my data is 10 years of historical…
Anastasia Polyakova
- 63
- 4
2
votes
1 answer
How to open atoti link in streamlit application with python?
I'm trying to run atoti link in streamlit application where i want to create some plots with atoti.
I tried the below code but it's showing something else in place of the link.
new = pd.DataFrame()
new['Link'] =…
Nithin Reddy
- 580
- 2
- 8
- 18
2
votes
2 answers
Best method to upgrade atoti version?
I was trying to import atoti to my jupyterlab as
import atoti as tt
I encountered the below problem.
Exception Traceback (most recent call last)
in
----> 1 import atoti as…
Raghav Vashisht
- 81
- 4
1
vote
1 answer
Is there any way of conecting atoti cube with ActiveUI frontend?
We are trying to connect an atoti cube the same way that is on env.js on the Active UI frontend.
window.env = {
contentServerVersion: "5.11.x",
contentServerUrl: "https://activepivot-ranch.activeviam.com:5110",
// WARNING: Changing the…
RazvanVC
- 11
- 2
1
vote
1 answer
MissingPluginError: The atoti-jupyterlab plugin is missing, install it and try again
I am pretty new to working with atoti. While running the code
session.visualize('exploration 1')
I am encountered with the error
MissingPluginError Traceback (most recent call…
Diksha Nasa
- 135
- 3
- 13
1
vote
1 answer
Create an already populated dashboard with a displayed graph in Atoti using Django
I'm not sure how to word this differently but I'm integrating Atoti with a Django project using their project template, I've searched a lot in their documentation but I can't seem to get an answer about this.
What I need to do is after a button…
Dingo
- 93
- 1
- 9
1
vote
1 answer
How to create buckets based on an existing variable in atoti?
I have a store in atoti, where I would like to create buckets based on a continuous variable.
Here is the screenshot to the store:
I am trying to create buckets based on age.
One solution I could think of is to, create a new column in the original…
Raghav Vashisht
- 81
- 4
1
vote
1 answer
Recreate a store in atoti with the same name without restarting the kernel
Description
When calling twice the following code:
store = session.read_pandas(dataframe, 'my_store', keys=['id'])
We get the following exception:
AtotiJavaException: A store with the name my_store already exists!
If you want to recreate this…
Raghav Vashisht
- 81
- 4
1
vote
1 answer
How do I put a date in atoti's where condition?
I am trying to apply a condition on date hierarchy with the following:
m["additional_refrigerator_equipped2"] = tt.agg.sum(
tt.where(lvl["date"] > "2019-11-01", 500, 0))
I am getting the below error on visualization:
An error happened during…
Raghav Vashisht
- 81
- 4
1
vote
1 answer
How to load S3 data source with atoti?
Following the installation guide, I have installed atoti library:
(atoti) C:\Users>conda list
# packages in environment at C:\Apps\miniconda3\envs\atoti:
#
# Name Version Build Channel
abseil-cpp …
Radler Yeo
- 31
- 4
0
votes
2 answers
Can't connect to Atoti session or website
So, I want to mess around with atoti. I installed the library but I can't connect to session. I can't connect to the session using jupyter, and if I use google colab, I can't connect to the website. I don't know what's going on nor can I find any…
daza
- 37
- 3
0
votes
1 answer
Reading Data Frame in Atoti?
While reading Dataframe in Atoti using the following code error is occured which is shown below.
#Code
global_data=session.read_pandas(df,keys=["Row ID"],table_name="Global_Superstore")
#error
ArrowInvalid: Could not convert '2531' with type str:…
Ardhana
- 1
0
votes
0 answers
Atoti issues while loading dataset after instillation
I'm simpling running the following code:
import atoti as tt
import numpy as np
import pandas as pd
session = tt.Session()
sales_table = session.read_csv("data/sales.csv", keys=["Sale ID"])
I'm receiving an error code of:
AtotiJavaException:…
L. Kenneth Wells
- 11
- 2
0
votes
1 answer
How can I solve the atoti exception: "AtotiJavaException: Cannot make an array type non nullable"?
I am trying to generate a table in atoti using the standard method:
table = session.read_pandas( DF, keys = ["col1",...."coln"], table_name = "My_Table")
However, it is throwing me this error related to reading one column which consists of numpy…
