Download the PHP package koolreport/cleandata without Composer

On this page you can find all versions of the php package koolreport/cleandata. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package cleandata

Introduction

Missing data is always a problem with data analysis and data mining. The cleandata package give you methods to solve this data missing issue.

Installation

By downloading .zip file

  1. Download
  2. Unzip the zip file
  3. Copy the folder cleandata into koolreport folder so that look like below

By composer

Documentation

The missing value normally comes to KoolReport in form of null value. We solve this by either drop the row or fill new value for it.

DropNull

The DropNull process will drop the row which has null value or meet certain number of null occurrences.

Let look at an example:

Above is simplest example of using DropNull process. All the row which has null value will be dropped. As a result, return data will be those customers with full informations.

Target a certain columns only

Sometime you only drop the row if some certain columns has null values:

Exclude some columns

If you want to target all columns except some because it is not important, you do:

Target specific type of columns

For example, You can target number columns only, if any of those columns has null value, the row will be dropped:

You can target to other column types which are string,date,datetime,time

Threshold

For example, if data row contains more than 2 null values, drop the row:

Targeted value

What if you do not want to drop null value but the 0 value. The missing data to you is the 0 value, you can do

Of course, you can set any target values regardless number type or string type. The default value of targetValue is null.

Stricly Null

By default the the null could be empty string or 0 value. To enable strict comparison of both value and type, you set the following:

FillNull

The FillNull value is another method of cleaning data. We do not drop row with null value, rather we fill null value with the new value.

Above code will fill all the null value with 10.

Targeted value

What if you want to target at 0 value, you can do:"

Fill missing value with MEDIAN and MEAN

In above example, we fill missing value with the value we want. However the better method is to fill them with mean or median of the column values. This solution seems more elegant. You can do:

For median, you do

Target some specific columns

You can apply fulling action to some of specified columns:

Exclude some columns

Some columns are not important and missing value does not affect, you can do:

Target some specific column type

If you want you can apply the the fill to certain number columns:

Strictly Null

By default the the null could be empty string or 0 value. To enable strict comparison of both value and type, you set the following:

Support

Please use our forum if you need support, by this way other people can benefit as well. If the support request need privacy, you may send email to us at [email protected].


All versions of cleandata with dependencies

PHP Build Version
Package Version
No informations.
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package koolreport/cleandata contains the following files

Loading the files please wait ....