Do These Things in Python 3 in a Jupyter Notebook Preferably.

Link to datasets, dictionary, and database, and existing Python code https://mega.nz/#!U35HjTpD!NMg1SSD8J59JWbAH-9hlCWxdi6cojSLplzelnCKiBL0

Create a new pandas DataFrame of data that will be used for target marketing and write it out to a headered csv file.

(a) This DataFrame should have one row per customer. The customers included should be active buyers or lapsed buyers. (b) The row for each customer should include the customer's account identifier, and an indicator variable (Y/N, or 1/0) for each product category the customer has made at least one purchase in. (c) Include for each customer their buyer status, and the total dollar amount of the purchases they have made from XYZ using all data available for him or her. (d) Write your DataFrame to a csv file that has a header record of the column names, and also store it in a shelve database. (e) Verify that the files you wrote your customer DataFrame to were written correctly. (Commented code, of course.)