Credit Transaction data and Data Processing with Pandas…
1 Credit Transaction data(40 points) This dataset is simulated individual credit card transactions by one company. Please use this dataset to answer following question. Please notice that you may need to observe the dataset and clean it before answering the following question. 1. What is total amount spending captured in this dataset? 2. How much was spend at WW GRAINGER? 3. How much was spend at WM SUPERCENTER? 4. How much was spend at GROCERY STORES? 2 Data Processing with Pandas (60 points) In this practice, you are expected to play around Pandas and get familiar with it. The dataset is quarterly dataset downloading from WRDS. Please remember that you need to do data transformation based on the new dataset generated by previous step. Do not using other package other than numpy and pandas
