Hi all
I am complete novice in coding 6 weeks in… I am working on large data set 18 columns with 1,282,354 entries about customer complaints for my assignment and I’m stuck on this issue:
The data set contains Date_Received column in this format YYYY-MM-DD, there is 1,282,354 rows.
I want to create a graph that will show seasonality of complaints. I want to count how many complaints were received in each month in each year and put it on the graph.
I’ve added at the end column Yeah and Month in hopes this will help me but it only confused me more
Any direction i greatly appreciated as I’m trying to figure this out for few hours now
Thank you,
Date_Received Product Sub-product Issue Sub-issue Complaint_Detail Public_Response Company State ZIP_Code Consumer_Consent Medium Date_Sent Response_Detail Timely_Response Disputed Complaint ID Year Month
0 2019-05-10 Checking or savings account Checking account Managing an account Problem using a debit or ATM card No Data No Data NAVY FEDERAL CREDIT UNION FL 328XX N/A Web 2019-05-10 In progress Yes N/A 3238275 2019 5
1 2019-05-10 Checking or savings account Other banking product or service Managing an account Deposits and withdrawals No Data No Data BOEING EMPLOYEES CREDIT UNION WA 98204 N/A Referral 2019-05-10 Closed with explanation Yes N/A 3238228 2019 5
2 2019-05-10 Debt collection Payday loan debt Communication tactics Frequent or repeated calls No Data No Data CURO Intermediate Holdings TX 751XX N/A Web 2019-05-10 Closed with explanation Yes N/A 3237964 2019 5
3 2019-05-10 Credit reporting, credit repair services, or o... Credit reporting Incorrect information on your report Old information reappears or never goes away No Data No Data Ad Astra Recovery Services Inc LA 708XX N/A Web 2019-05-10 Closed with explanation Yes N/A 3238479 2019 5
4 2019-05-10 Checking or savings account Checking account Managing an account Banking errors No Data No Data ALLY FINANCIAL INC. AZ 85205 N/A Postal mail 2019-05-10 In progress Yes N/A 3238460 2019 5