Application Requirements
In this lesson, we will look at the requirements of an application which makes computations on the data from a CSV file.
Imagine you’re working with some sales data and one task is to calculate a sum of orders for some products. Your shopping system is elementary, and instead of a database, you have CSV files with the order data. There’s one file per product.
For example, here are the book sales:
date | coupon code | price | discount | quantity |
---|---|---|---|---|
5-12-2018 | 10.0 | 0 | 2 | |
5-12-2018 | 10.0 | 0 | 1 | |
6-12-2018 | Santa | 10.0 | 0.25 | 1 |
7-12-2018 | 10.0 | 0 | 1 |
Each line shows a book sale on a specific date. For example on 5th Dec, there were three sales, 10$ each, and one person bought two books. On 6th Dec we had one sale with a coupon code.
The data is encoded as a CSV file: sales/book.csv
:
5-12-2018;;10.0;0;2;
5-12-2018;;10.0;0;1;
6-12-2018;Santa;10.0;0.25;1;
7-12-2018;;10.0;0;1;
The application should read the data and then calculate the sum, in the above case we have the following code:
Get hands-on with 1400+ tech skills courses.