Credit Card Analysis of Czech Bank

ITCS6265 : Fall Semester of 2002
Instructor: Dr. Mirsad Hadzikadic

UNC-Charlotte  |  College of IT  |  Dr. Mirsad Hadzikadic  |  ITCS6265   


Site Index   Preprocessing - Credit Card
· Goal
· Domain
· Pre-Processing
· Accounts
· Clients
· Disposition
· Loans
· Permanent Orders
· Transactions
· Demographics
· Credit Cards
· Methodology
· Results
· Next Steps
· References
· Authors

CREDIT CARD Table
Changes Made With Excel
Column Description Changes Missing or Invalid Values Notes
Card_ID Record Identifier None N/A Primary Key
Disp_ID Disposition Identifier None N/A Foreign Key
Type Type of Credit Card None Classic Values and Distribution:   - Junior = 16%
  - Classic = 74%
  - Gold = 10%
Issued Date card issued Removed

Eliminated null time-stamp and changed date format from YYMMDD to MM/DD/YYYY

Ignore For our purposes, date card issued is not material