v1.1.1

Implement `DataFrameCore.sortValues` (#28)

v1.1.0 Release

Updated PHPUnit version, project now requires PHP 7.1 (though more of a dev requirement which should be looked into)

Tested and implemented new quality of life core features.

Brought coverage metrics back up to where they should be.

Version 1.0.0 Release

Added ability to manipulate the DataFrame using SQL
Added primitive and basic type operations
Added groupBy feature

Reordered fromSQL and toSQL functions to take table name and query as first argument and PDO instance as second argument.

0.4.1

Updated CSV with improved whitespace/empty line handling and added re…

0.4.0 - to/fromJSON

Converting to JSON:

$json = $df->toJSON(['pretty' => true]);

Creating from JSON:

$df = DataFrame::fromJSON('[
    {"a": 1, "b": 2, "c": 3},
    {"a": 4, "b": 5, "c": 6},
    {"a": 7, "b": 8, "c": 9}
]');

0.3.0 - to/fromXLSX - fromSQL

Able to read and write XLSX spreadsheets:

Reading an XLSX spreadsheet:

$dfA = DataFrame::fromXLSX($fileName, ['sheetname' => 'Sheet A']);
$dfB = DataFrame::fromXLSX($fileName, ['sheetname' => 'Sheet B']);
$dfC = DataFrame::fromXLSX($fileName, ['sheetname' => 'Sheet C']);

Writing an XLSX spreadsheet:

$phpExcel = new PHPExcel();
$dfA->toXLSXWorksheet($phpExcel, 'Sheet A');
$dfB->toXLSXWorksheet($phpExcel, 'Sheet B');
$dfC->toXLSXWorksheet($phpExcel, 'Sheet C');
$writer = new PHPExcel_Writer_Excel2007($phpExcel);
$writer->save($fileName);

Able to read SQL:

Querying from a database:

$pdo = new PDO('sqlite::memory:');
$df = DataFrame::fromSQL($pdo, 'SELECT foo, bar, baz FROM table_name;');

0.2.0 Release - toSQL

Removed support for PHP 5.4 due to lack of finally keyword and lack of support for newer versions of SQLite

Included the ability to commit a DataFrame to a relational database, given an instance of PDO and an existing table.

$df = DataFrame::fromArray([
    ['a' => 1, 'b' => 2, 'c' => 3],
    ['a' => 4, 'b' => 5, 'c' => 6],
    ['a' => 7, 'b' => 8, 'c' => 9],
]);

$pdo = new PDO('sqlite::memory:');

$pdo->exec("CREATE TABLE testTable (a TEXT, b TEXT, c TEXT);");

$df->toSQL($pdo, 'testTable');

0.1.1 Release

Improved HTML implementation:

• Added options for specifying CSS class and id
• Added ability to specify options for rendering HTML tables as a DataTable

0.1.0 - to/fromCSV - fromFWF - toHTML

Supports CSV, FWF, and HTML operations.

Basic relational assignment, co-assignment, function application.

Fully docblocked, and tested with 100% coverage.

Using Composer:

composer require archon/dataframe

{
    "require": {
        "archon/dataframe": "0.1.0"
    }
}