1. Cleansing Client Data The client has provided you with the following data files:
   a. unsold ticket sales revenue
   b. champion's club ticket revenue
   d. single-game ticket sales, by game
   e. issued tickets, by game
2. 
   Required:
   When using the above information for the purposes of performing analytical procedures, data must be cleansed prior to use. Consider the following common issues found in cleansing data and provide documentation of the number of instances of the following. You may also provide documentation of any other data anomalies you find.
   
   i. Duplicate listings
3. ii. Missing items from a sequence
4. iii. Dates outside of appropriate range
5. iv. Characters in a numeric column
6. v. Apparent issues with data truncation, either missing rows, or limited characters in a column

1.