Example: Data frame
Topic: Data reading
Code
<?php
declare(strict_types=1);
use function Flow\ETL\DSL\{data_frame, from_array, from_data_frame, lit, ref, to_stream};
require __DIR__ . '/../../../autoload.php';
data_frame()
->read(
from_data_frame(
data_frame()
->read(from_array(
[
['id' => 1],
['id' => 2],
['id' => 3],
['id' => 4],
['id' => 5],
]
))
->withEntry('timestamp', ref('id')->multiply(lit(10000)))
)
)
->collect()
->write(to_stream(__DIR__ . '/output.txt', truncate: false))
->run();
Output
+----+-----------+
| id | timestamp |
+----+-----------+
| 1 | 10000 |
| 2 | 20000 |
| 3 | 30000 |
| 4 | 40000 |
| 5 | 50000 |
+----+-----------+
5 rows