Category "time-series"

question about creating upper case database name or table name in TDengine database

In TDengine shell, any upper case letter is automatically converted to a lower case letter like below: taos> create database TEST; Query OK, 0 of 0 row(s) in

median in pandas dropping center value

I am working in pandas and want to implement an algorithm that requires I assess a modified centered median on a window, but omitting the middle value. So for i

TDengine import from csv file

Just found the speed for importing sorted csv file is faster than the speed for importing unsorted csv file in TDengine database, each csv file has 1000000 rows

How to read edf data in Python 3

How can I read edf data using Python? I want to analyze data of a edf file, but I cannot read it using pyEDFlib. It threw the error OSError: The file is discont

How can we make use of feature variables whose future values are fixed to predict target value?

With regard to time series features in a regression ML model. Suppose, we are living in a space colony. The temperature there is accurately under control, so we

Timeseries dataframe returns an error when using Pandas Align - valueError: cannot join with no overlapping index names

My goal: I have two time-series data frames, one with a time interval of 1m and the other with a time interval of 5m. The 5m data frame is a resampled version o

Use multiple time-series to train model

Is there any way to use multiple time-series to train one model and use this model for predictions given a new time-series as an input? It is rather a theoretic

Impute missing data in multivariate time series

I have a problem where I have to predict the sales of 4000 products in 3 months for a certain store. Within the 4000 time series I have many null values and esp

Identifying lead/lags using multivariate regression analysis

I have three time-series variables (x,y,z) measured in 3 replicates. x and z are the independent variables. y is the dependent variable. t is the time variable

FInding fft gives keyerror :'Aligned ' pandas

I have a time series data I am trying to find the fft .But it gives keyerror :Aligned when trying to get the value my data looks like below this is the code: i

FInding fft gives keyerror :'Aligned ' pandas

I have a time series data I am trying to find the fft .But it gives keyerror :Aligned when trying to get the value my data looks like below this is the code: i

How to implement regressors in a Hierarchical Series in R, with the Fable package?

I am new to exploring the fable package, and I was wanting to implement Regressors in a Hierarchical Time Series model. How should the Dimensionality of the dat

C3 chart - How to set X-Axis a DateTime interval 1 week?

I am very new to building charts with c3. I've done a search, but I could not find an answer. Could anyone help? How can I force to set in X-Axis a DateTime int

How/Where can I write time series data? As Parquet format to Hadoop, or HBase, Cassandra?

I have real-time time series sensor data. My primary goal is to keep the raw data. I should do this so that the cost of storage is minimal. My scenario like th

Plot elapsed time on x axis using date indexed time-series data

In my pandas dataframe, my time series data is indexed by absolute time (a date of format YYYY-MM-DD HH24:MI:SS.nnnnn): 2017-01-04 16:25:25.143493 58 2017-0

Is there a way to forecast sales for multiple products across multiple stores?

My Data is in this format(Both Multiple and Multivariate Timeseries) I need to predict number of units sold is gonna be for every product across different st

Compute annual mean using x-arrays

I have a python xarray dataset with time,x,y for its dimensions and value1 as its variable. I'm trying to compute annual mean of value1 for each x,y coordinate

multivariate xgboost time series

I implemented a univariate xgboost time series using the following code, def series_to_supervised(data, n_in=1, n_out=1, dropnan=True): n_vars = 1 if type(d

Plotly: How to highlight weekends without looping through the dataset?

I am trying to plot three different timeseries dataframes (each around 60000 records) using plotly, while highlighting weekends (and workhours) with a different

Pandas TimeSeries resample produces NaNs

I am resampling a Pandas TimeSeries. The timeseries consist of binary values (it is a categorical variable) with no missing values, but after resampling NaNs ap