kedrigern/data-table

Manipulation with table organized collection of data (csv, excel). Contains functions for work with whole columns, rows, filtering etc.

Tuesday, March 14, 2017
by Kedrigern
Repository
2 Watchers
2 Stars
9 Installations

PHP
0 Dependents
0 Suggesters
0 Forks
0 Open issues
7 Versions
0 % Grown

The README.md

Data table

For robust manipulation with table organized collection of data (excel, csv tables)., _(*1)

Provide ability to work with whole rows and columns, call callbacks, resort, rename, filter. Include few predefined callbacks. See examples., _(*2)

Import csv and array. Export to plain array, text, html, csv. Export is suitable for DB frameworks (Nette\Database)., _(*3)

, _(*4)

Install

The best way how to install is use Composer:, _(*5)

php composer.phar require kedrigern/data-table

Run tests: vendor/bin/tester -c test/ test/, _(*6)

Examples

Suppose:, _(*7)

$table = new \Kedrigern\DataTable\RecordTable();

$table->loadFromArray(array(
    array("Name", "Surname", "Age"),
    array("Jane", "Roe", 29),
    array("John", "Doe", 30)
));
$table->useFirstRowAsHeader();

// Sum the ages = 59
$ageSum = $table->colSum("Age");

$table->sortByCol("Surname");
$table->callToCol("Surname", 'strtoupper');

$newCol = range(1,$table->getRowsNum());
$table->appendCol($newCol, "Unique");

$newTable = $table->resortColsByNewHeader(array("Unique", "Surname", "Name"));

$newTable contains:, _(*8)

1 DOE John
2 ROE Jane

CSV with header

Very common issue when you have some data in csv with header and you need only subset:, _(*9)

$table->loadFromCsvFile(__DIR__ . '/../data/data4.csv');
$table->useFirstRowAsHeader();

$map = array(
    "Alpha" => "A",
    "Beta" => "B",
);

$table2 = $table->renameColumns($map);

Where table2 contains column Alpha renamed to A and column Beta renamed to B. See test., _(*10)

Remove if

Remove all rows with even number in first column:, _(*11)

$isEven = function($row) {
  return ($row[0] % 2) == 0;
};

$removed = $t->removeRowsIf($isEven);

In removed are number of modified rows., _(*12)

Parse datetime

$table->loadFromArray(array(
    array("Name", "Surname", "Age", "Born", "Registered"),
    array("Jane", "Roe", 29, "1990-1-1", "2013-12-30 01:02:03"),
    array("John", "Doe", 30, "1990-1-1", "2014-12-30 01:02:03")
));
$table->useFirstRowAsHeader();

$func = array('\Kedrigern\DataTable\Callback','toDatetime');

$table->callToCol(3, $func, array('Y-m-d', 'M y'));
$table->callToCol(4, $func, array('Y-m-d H:i:s', 'U', 'Europe/London'));

Now Born seems: ["Jan 90", "Feb 91"], and registered: ["1388361723", "1419897723"], _(*13)

Join and split columns

$table->loadFromArray(array(
    array("Name", "Surname"),
    array("Jane", "Roe"),
    array("John", "Doe")
));

$table->joinCols(["Name", "Surname"], "Fullname");

In Fullname column you get: ["Jane Roe", "John Doe"]., _(*14)

Or opposite way:, _(*15)

$table->loadFromArray(array(
    array("Fullname"),
    array("Jane Roe"),
    array("John Doe")
));

$table->splitCol("Fullname", ["Name", "Surname"]);