Download the PHP package archon/dataframe without Composer
On this page you can find all versions of the php package archon/dataframe. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download archon/dataframe
More information about archon/dataframe
Files in archon/dataframe
Package dataframe
Short Description Archon: PHP Data Analysis Library
License BSD-3-Clause
Homepage https://github.com/HWGehring/Archon
Informations about the package dataframe
Archon: PHP Data Analysis Library
Archon is a PHP library designed to make working with tabular/relational data, files, and databases easy. The core component of the library is the DataFrame class - a tabular data structure which raises the level of abstraction when working with tabular, two-dimensional data.
Installation
Using Composer:
Requirements
- PHP 7.1 or higher
- php_pdo_sqlite extension
- php_mbstring extension
Dependencies
- PHPOffice/PHPExcel: 1.8.1
- gajus/dindent: 2.0.2
License
Data Format Examples
Instantiating from an array:
Reading a CSV file:
Writing a CSV file:
Reading a fixed-width file:
Reading an XLSX spreadsheet:
Writing an XLSX spreadsheet:
Querying from a database:
Committing to a database:
Displaying an HTML table:
a | b | c |
---|---|---|
a | b | c |
1 | 2 | 3 |
4 | 5 | 6 |
7 | 8 | 9 |
With support for DataTables.js:
Converting to JSON:
Creating from JSON:
Extracting the underlying two-dimensional array:
Basic Operations
Getting column names:
Adding columns:
Removing columns:
Counting rows:
Iterating over rows:
Advanced Operations
Applying functions to rows:
Applying functions to columns directly:
Applying values to columns via function application of other columns:
Applying types:
Manipulating DataFrame using SQL:
All versions of dataframe with dependencies
ext-mbstring Version *
ext-pdo_sqlite Version *
phpoffice/phpexcel Version 1.8.1
gajus/dindent Version 2.0.2