Data transformation
Input file: deal_level_data.csv
Output file: quarter_level_data.csv
Requirement:
1. Write a code to convert data in deal_level_data.csv to quarter_level_data.csv.
2. The code must directly read the input file and write the output file.
3. It is your own responsibility to understand the data structures in input and output files.
4. To receive full credit, your code must satisfy the following criteria:
• Running time must be shorter than 1 minute
• Code should be concise, clear and well organized
• Include comments at appropriate places for easier understanding
• Avoid highly repetitive lines