import java.util.*;
import java.io.*;

public class Merge {
    public static void main(String[] args) throws Exception {
        String dataPath = args[0];
        String metadataPath = args[1];
        String outputPath = args[2];
        Map<String, Map<String, String>> metadata = readAndIndexMetadata(metadataPath);
        convertData(dataPath, outputPath, metadata);
    }

    private static Map<String, Map<String, String>> readAndIndexMetadata(String metadataPath) throws Exception {
        Map<String, Map<String, String>> result = new HashMap<>();
        BufferedReader reader = new BufferedReader(new FileReader(new File(metadataPath)));
        String line = "";
        while ((line = reader.readLine()) != null) {
            String[] values = line.split(",");
            if (!result.containsKey(values[0])) {
                result.put(values[0], new HashMap<String, String>());
            }
            result.get(values[0]).put(values[1], values[2]);
        }
        reader.close();
        return result;
    }

    private static void convertData(String dataPath, String outputPath, Map<String, Map<String, String>> metadata) throws Exception {
        BufferedReader reader = new BufferedReader(new FileReader(new File(dataPath)));
        BufferedWriter writer = new BufferedWriter(new FileWriter(new File(outputPath)));
        String line = "";
        while ((line = reader.readLine()) != null) {
            String[] values = line.split(",");
            StringBuilder result = new StringBuilder("");
            result.append(metadata.get("AWS-Billing-Account").get(values[0])).append(",");
            result.append(metadata.get("AWS-Account").get(values[1])).append(",");
            result.append(metadata.get("AWS-Service-Category").get(values[2])).append(",");
            result.append(metadata.get("Past-12-Months").get(values[3])).append(",");
            result.append(values[4]);
            writer.write(result.toString());
        }
        writer.flush();
        writer.close();
        reader.close();
    }
}