tableau / TabPy

Execute Python code on the fly and display results in Tableau visualizations:
https://tableau.github.io/TabPy/
MIT License
1.56k stars 598 forks source link

Unable to complete action An error occurred while communicating with the Analytics Extension. Error Code: 6116DD27 #438

Closed KelvinAduobey closed 4 years ago

KelvinAduobey commented 4 years ago

_Issue with Tableau/tabpy-server-0.2-py271

Im trying to do an arima forecast but receive this error;

Unable to complete action An error occurred while communicating with the Analytics Extension. Error Code: 6116DD27 Error processing script LinAlgError : SVD did not converge

This is my python script in the calculated field;

SCRIPT_REAL(" import statsmodels.api as sm

import pandas as pd import numpy as np import scipy.stats as scs from datetime import datetime df = pd.DataFrame({'Date':_arg1, 'NetRevenue':_arg2}) df['NetRevenue'] = df['NetRevenue'].astype('float64') df['Date'] = pd.to_datetime(_arg2) df = df[['Date','NetRevenue']].set_index('Date') df = df.fillna(0)

model=sm.tsa.ARIMA(endog = df['NetRevenue'], order=(min(_arg4),min(_arg5),min(_arg6))) results=model.fit() fitted_vals = list(results.fittedvalues.values)

return(fitted_vals) " ,ATTR([Date]), ATTR([NetRevenue]), MIN([Daysforecast]), MIN([AR (Time Lag)]), MIN([I (Seasonal Difference)]), MIN([MA (Moving Average)]) )

Please assist

image

0golovatyi commented 4 years ago

It seems like statsmodel failure. I found similar failure reported and resolved - https://github.com/statsmodels/statsmodels/issues/6360.

KelvinAduobey commented 4 years ago

It seems like statsmodel failure. I found similar failure reported and resolved - statsmodels/statsmodels#6360.

Tried that and got this error too;

ERROR: Could not find a version that satisfies the requirement statsmodels==0.11.0rc1 (from versions: none) ERROR: No matching distribution found for statsmodels==0.11.0rc1

0golovatyi commented 4 years ago

@KelvinAduobey https://github.com/statsmodels/statsmodels/issues is probably the best place to ask about that specific package issues.