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.
Download koolreport/cleandata
More information about koolreport/cleandata
Files in koolreport/cleandata
Package cleandata
Short Description Solve the missing data
License MIT
Homepage https://www.koolreport.com
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
- Download
- Unzip the zip file
- Copy the folder
cleandata
intokoolreport
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].