Just a simple CSV ETL test using Ruby and Kiba!
Rakefile would be the starting point to read the code.
The item
field is transformed to lowercase; and, the price
field is
transformed to integer from float and then multiplied by 2.
Source:
$ cat data/source.csv
id,item,price
1,ABC,6.00
2,XYZ,3.00
Destination:
$ cat data/destination.csv
id,item,price
1,abc,12
2,xyz,6
Written and tested on:
- Ubuntu 20.04
- Ruby 2.7.2p137
Clone:
git clone github.com:iamazeem/kiba-etl-test.git
Install dependencies:
bundle install
bundle exec rake test
See input and output files under data directory.