Note - All dates must be in yyyy-MM-dd format in database
Q 1 -
Process Consumer Complaint file A only as per instructions below
1) Read file A, remove duplicates; load to table Consumer_Complaints;
2) Print no of records processing at the count of 5000, and total count in console
Q 2 –
Process multiple consumer complaints file as per instructions below –
1) Read Consumer Complaints file A, remove duplicates, load to table Consumer_Complaints (mysql) ordered by date_received
2) Reject data in Rejects file with blank Complaint ID
3) Read Consumer Complaints file B, remove duplicates and blank complaint ID and -
a) exactly same (same data in all fields) record must be rejected if it already exists in table
b) if Complaint ID exists, then update table else insert
4) Read data from DB Generate single excel report; with each of the following in different sheet within same excel
a) Sheet “Product Complaint” – Count Issues per product and State combined launched after 10/30/2014
b) Sheet “Medium” – Count issues submitted through different mediums per Company, State and Product combination
5) Create csv file for all data which has untimely response and consumer disputes