Now, in this segment, you will get to know about the data set that you are dealing with in this project. Our expert Ganesh will walk you through the details of the data set in the next video.
As discussed in the video, you will be working on a Danish ATM Transactions Data Set in this project.
This dataset comprises around 2.5 million records of withdrawal data along with weather information at the time of the transactions from around 113 ATMs from the year 2017.
The actual data set is divided into two part files, both amounting to about 503 MB in total.
There is also a data dictionary present along with the data set, which defines all of the 33 columns present in the data set. The data dictionary is given below.
This data set contains various types of transactional data as well as the weather data at the time of the transaction, such as:
- Transaction Date and Time: Year, month, day, weekday, hour.
- Status of the ATM: Active or inactive.
- Details of the ATM: ATM ID, manufacturer name along with location details such as longitude, latitude, street name, street number and zip code.
- The weather of the area near the ATM during the transaction: Location of measurement such as longitude, latitude, city name along with the type of weather, temperature, pressure, wind speed, cloud and so on.
Transaction details: Card type, currency, transaction/service type, transaction amount and error message (if any).
Acknowledgement
Spar Nord Bank has