The aim of the assignment is to prepare a data file for the company KommatiPara, which deals with bitcoin tradings. Using 2 datasets, which contains client details and their financial details. The company needs to have one dataset including details from the two datasets without personal information and for specific countries.
For the assignment a user should upload two .csv files.
The first file with client details, consists of the following columns:
id | first_name | last_name | country |
---|
The second file with financial details consists of the followig columns:
id | btc_a | cc_t | cc_n |
---|
For both datasets applied following modifications:
- Filtered the first dataset by the country column to obtain only records for United Kingdom and Netherlands
- Dropped unneccesary columns which consisted personal informations like first_name and last_name
- Joined both datasets on id column
- Renamed columns, as follows:
- btc_a -> bitcoin_address
- cc_t -> credit_card_type
- id -> client_identifier
The output file contains only id, email, btc_a, cc_t and cc_n columns which are also renamed. The file should look like as follows:
client identifier | country | bitcoin_address | credit card type |
---|
After package installation, run the following comand:
Codac --file_one "./datasets/dataset_one.csv" --file_two "./datasets/dataset_two.csv" --countries "Netherlands" "United Kingdom"
Explanation:
- --file_one is the argument name for the first dataset file
- "./datasets/dataset_one.csv" is the path for the fist dataset file
- --file_two is the argument name for the second dataset file
- "./datasets/dataset_two.csv" is the path for the second dataset file
- --countries is the argument for the list containing country names by which the first dataset will be filtered, this argument is default so user do not need to put it.
- "Netherlands" is the country by which the first dataset will be filtered, this argument is default so user do not need to put it.
- "United Kingdom" is also the country by which the first dataset will be filtered, this argument is default so user do not need to put it.