Data Dictionary

The raw text file

We have 28 columns, but here's my take on the notable columns:

Column	Data-Type	Description
accountNumber	Integer	Account-Number of customer who made the transaction
customerId	Integer
creditLimit	Integer	Current credit-limit of customer who made the transaction
availableMoney	Float	Available credit for customer
transactionDateTime	String	Timestamp of transaction
transactionAmount	Float	Amount for transaction
merchantName	String	Name of merchant (POS)
acqCountry	String	Country where credit card was acquired
merchantCountryCode	String	Country code for merchant (POS)
posEntryMode	Float	2-digit code for info on how card was entered (https://help.globalmerchantportal.com/en/code-glossary/pos-entry-modes)
posConditionCode	Float	2-digit code to identifies mode of initiation of the transactions.
merchantCategoryCode	String	General category (fast food, entertainment, etc.)
currentExpDate	String	Card expiry date
accountOpenDate	String	Account opened (Start) date
dateOfLastAddressChange	String	Last updated date of address
cardCVV	Integer	Expected CVV available on credit-card
enteredCVV	Integer	Entered CVV at POS
cardLast4Digits	Integer	Last 4 digits of Credit Card
transactionType	String	Purchase, Reversal, Address Verification, etc.
currentBalance	Float	CreditLimit - AvailableMoney
merchantCity	Float	City for POS
merchantState	Float	State for POS
merchantZip	Float	Zipcode for POS
cardPresent	Boolean	True/False for card presented in-person
posOnPremises	Float	POS on premise of store
isFraud	Boolean	Target-Label for transaction being marked as Fraud