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 - Demographic
· Goal
· Domain
· Pre-Processing
· Accounts
· Clients
· Disposition
· Loans
· Permanent Orders
· Transactions
· Demographics
· Credit Cards
· Methodology
· Results
· Next Steps
· References
· Authors

DEMOGRAPHIC Table
Changes Made With Excel
Column Description Changes Missing or Invalid Values Notes
A1 District Identifier None N/A Primary Key
A2 District Name Replaced Spaces with underscore ("_") N/A  
A3 Region Name Replaced Spaces with underscore ("_") N/A Distribution of Values:

  Prague = 1%
  Central_Bohemia = 16%
  South_Bohemia = 10%
  West_Bohemia = 13%
  North_Bohemia = 13%
  East_Bohemia = 16%
  South_Moravia = 18%
  North_Moravia = 14%

A4 Number of Inhabitants None N/A  
A5 Number of municipalities with <499 inhabitants None N/A  
A6 Number of municipalities with 500-1499 inhabitants None N/A  
A7 Number of municipalities with 2000-9999 inhabitants None N/A  
A8 Number of municipalities with >10000 inhabitants None N/A  
A9 Number of cities None N/A  
A10 Ratio of urban inhabitants None N/A  
A11 Average salary None N/A  
A12 1995 unemployment rate None N/A  
A13 1996 unemployment rate None N/A  
A14 Entrepreneurs per 1000 inhabitants None N/A  
A15 Number of crimes committed in 1995 None N/A  
A16 Number of crimes committed in 1996 None N/A