apop_db_to_crosstab command not found

Introduction

When you run more command in linux terminal / console, you get the following error message

apop_db_to_crosstab: command not found

or when using sudo you get the following error message

sudo: apop_db_to_crosstab: command not found

Solutions to apop_db_to_crosstab: command not found

How To Fix apop_db_to_crosstab: command not found in Ubuntu / Debian / Kali Linux / Raspbian

In Ubuntu apop_db_to_crosstab is provided by apophenia-bin package.

apophenia-bin is:

The Apophenia Statistical C Library is an open source C library for working with data sets and statistical models. It provides functions on the same level as those of the typical stats packages (such as OLS, probit, or singular value decomposition) but gives the user more flexibility to be creative in model-building.

Apophenia is meant to scale well, to comfortably work with gigabyte data sets, million-step simulations, or computationally-intensive agent-based models.

Apophenia builds upon the GNU Scientific and SQLite libraries, MySQL/mariaDB is also supported. The core functions are written in C, but experience has shown them to be easy to bind in Python, Julia, Perl, Ruby, etc. The source code is distributed under the GNU General Public License version 2 (GPL2).

This package provides several command line utility examples.

To fix this problem, we can install more using the command below.

sudo apt-get -y install apophenia-bin

This command might take some time to finish depending on your machine internet connection.

You can also use apt command to install apophenia-bin.

sudo apt -y install apophenia-bin

Or if you have aptitude installed you can use the following command.

sudo aptitude install apophenia-bin

Summary

In this tutorial we learn how to fix apop_db_to_crosstab command not found error in Ubuntu / Debian / Kali Linux or Raspbian distribution.