Name: Electronic Card Transactions From 2017-2020
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Electronic Card Transactions From 2017-2020

Electronic Card Transactions from 2017-2020

Exploring Retail Spending Trends

By data.govt.nz [source]

About this dataset

This dataset contains valuable information about electronic card transactions from 2017-2020. The data is sourced from a trustable source and was last updated on 2020-08-10. It paints a comprehensive picture of electronic payments made during this period and includes important variables such as the series reference, period, data value, suppresed status, units magnitude, subject, group and five titles (series_title). This data is useful for exploring timely trends in electronic card spending activity over the 4 year period between 2017 to 2020 making it an invaluable asset for researchers looking to better understand purchasing habits in New Zealand. This dataset offers analysts unprecedented insight into consumer behavior allowing them to develop strategies aimed at increasing transaction volumes or customer loyalty initiatives

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains information about electronic card transactions from 2017-2020. It includes data on the series reference, period, data value, suppressed status, units of measurement, magnitude, subject and group. Using this dataset can provide you with insightful information that can help you improve your business operations and make better decisions.

For example, you could use the data values to identify patterns and trends in sales over time. You could also use the period data to determine whether certain months have more sales than others. Finally, you could utilize the suppressed status to understand which transactions should or should not be included when making conclusions from your dataset.

In order to use this dataset effectively it would be helpful for you to be familiar with database software such as Microsoft Access or SQLite database manager which is free and open source software for managing a variety of databases. Once familiar with database software of your choice it is important to understand how different fields interact together in order create meaningful results from queries such as finding out what kind of expenditure is done during different times of year or discovering what kind of products contribute most revenue during certain periods etc..
It is also sensible for one become knowledgeable in some basic coding languages like Python - that have modules designed specifically for statistical analysis - so they are well equipped when it comes down crunching these kinds complex datasets into tangible insights!

Research Ideas

Visualizing changes in spending habits of consumers over time by analyzing the Data_value, UNITS and Magnitude columns.

Analyzing the correlation between areas with higher spending volumes and socioeconomic factors such as income level or population density by leveraging Subject and Group details.

Predicting future trends in electronic card transactions through machine learning algorithms that use historical data from the dataset to make predictions on changing patterns of consumer spending behaviors over time based on all columns in the dataset eg Series_title_1, STATUS etc.

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: electronic-card-transactions-feb-2018-csv-tables.csv

Column name	Description
Series_reference	Unique identifier for each series. (String)
Period	Date of the transaction. (Date)
Data_value	Value of the transaction. (Integer)
Suppressed	Boolean value indicating whether the data has been suppressed or not. (Boolean)
STATUS	Status of the transaction. (String)
UNITS	Units of the transaction. (String)
Magnitude	Magnitude of the transaction. (Integer)
Subject	Subject of the transaction. (String)
Group	Group of the transaction. (String)
Series_title_1	Title of the series. (String)
Series_title_2	Title of the series. (String)
Series_title_3	Title of the series. (String)
Series_title_4	Title of the series. (String)
Series_title_5	Title of the series. (String)

File: august-2019-ect-tables-69.csv

File: september-2018-ect-tables-3.csv

File: may-2019-ect-tables-28.csv

File: june-2018-ect-tables-16.csv

File: june-2019-ect-tables-14.csv

File: july-2019-ect-tables-17.csv

File: january-2019-ect-tables-45.csv

File: february-2018-ect-tables-7.csv

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit data.govt.nz.

Tables

Electronic Card Transactions December 2019 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_december_2019_tables

194.7 kB
16,568 rows
15 columns

CREATE TABLE electronic_card_transactions_december_2019_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Feb 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_feb_2018_tables

174.5 kB
14,900 rows
15 columns

CREATE TABLE electronic_card_transactions_feb_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Feb 2020 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_feb_2020_tables

195.82 kB
16,678 rows
15 columns

CREATE TABLE electronic_card_transactions_feb_2020_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Jan 2017 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_jan_2017_tables

173.91 kB
14,843 rows
15 columns

CREATE TABLE electronic_card_transactions_jan_2017_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions January 2020 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_january_2020_tables

195.31 kB
16,621 rows
15 columns

CREATE TABLE electronic_card_transactions_january_2020_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Jul 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_jul_2018_tables

178.75 kB
15,300 rows
15 columns

CREATE TABLE electronic_card_transactions_jul_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions July 2019 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_july_2019_tables

188.55 kB
16,189 rows
15 columns

CREATE TABLE electronic_card_transactions_july_2019_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Jun 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_jun_2018_tables

178.18 kB
15,247 rows
15 columns

CREATE TABLE electronic_card_transactions_jun_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions June 2019 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_june_2019_tables

187.97 kB
16,136 rows
15 columns

CREATE TABLE electronic_card_transactions_june_2019_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions June 2020 Lower Level Data

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_june_2020_lower_level_data

80.28 kB
6,611 rows
15 columns

CREATE TABLE electronic_card_transactions_june_2020_lower_level_data (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions June 2020 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_june_2020_tables

200.02 kB
17,025 rows
15 columns

CREATE TABLE electronic_card_transactions_june_2020_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Mar 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_mar_2018_tables

175.78 kB
15,027 rows
15 columns

CREATE TABLE electronic_card_transactions_mar_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions March 2020 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_march_2020_tables

197.66 kB
16,805 rows
15 columns

CREATE TABLE electronic_card_transactions_march_2020_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions May 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_may_2018_tables

176.99 kB
15,141 rows
15 columns

CREATE TABLE electronic_card_transactions_may_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions May 2020 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_may_2020_tables

198.75 kB
16,919 rows
15 columns

CREATE TABLE electronic_card_transactions_may_2020_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Nov 2017 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_nov_2017_tables

171.85 kB
14,684 rows
15 columns

CREATE TABLE electronic_card_transactions_nov_2017_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions November 2019

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_november_2019

193.4 kB
16,462 rows
15 columns

CREATE TABLE electronic_card_transactions_november_2019 (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions October 2019 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_october_2019_tables

192.92 kB
16,405 rows
15 columns

CREATE TABLE electronic_card_transactions_october_2019_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions Sep 2018 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_sep_2018_tables

180.44 kB
15,463 rows
15 columns

CREATE TABLE electronic_card_transactions_sep_2018_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

Electronic Card Transactions September 2019 Tables

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.electronic_card_transactions_september_2019_tables

190.4 kB
16,352 rows
15 columns

CREATE TABLE electronic_card_transactions_september_2019_tables (
  "index" BIGINT,
  "series_reference" VARCHAR,
  "period" DOUBLE,
  "data_value" DOUBLE,
  "suppressed" VARCHAR,
  "status" VARCHAR,
  "units" VARCHAR,
  "magnitude" BIGINT,
  "subject" VARCHAR,
  "group" VARCHAR,
  "series_title_1" VARCHAR,
  "series_title_2" VARCHAR,
  "series_title_3" VARCHAR,
  "series_title_4" VARCHAR,
  "series_title_5" VARCHAR
);

February 2018 Ect Tables 7

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.february_2018_ect_tables_7

7.86 kB
22 rows
10 columns

CREATE TABLE february_2018_ect_tables_7 (
  "index" BIGINT,
  "electronic_card_transactions_february_2018" VARCHAR  -- Electronic Card Transactions: February 2018,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

February 2019 Ect Tables 53

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.february_2019_ect_tables_53

7.83 kB
22 rows
10 columns

CREATE TABLE february_2019_ect_tables_53 (
  "index" BIGINT,
  "electronic_card_transactions_february_2019" VARCHAR  -- Electronic Card Transactions: February 2019,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

February 2020 Ect Tables 20

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.february_2020_ect_tables_20

7.83 kB
22 rows
10 columns

CREATE TABLE february_2020_ect_tables_20 (
  "index" BIGINT,
  "electronic_card_transactions_february_2020" VARCHAR  -- Electronic Card Transactions: February 2020,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

January 2018 Ect Tables 58

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.january_2018_ect_tables_58

7.82 kB
22 rows
10 columns

CREATE TABLE january_2018_ect_tables_58 (
  "index" BIGINT,
  "electronic_card_transactions_january_2018" VARCHAR  -- Electronic Card Transactions: January 2018,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

January 2019 Ect Tables 45

@kaggle.thedevastator_uncovering_insights_from_electronic_card_transac.january_2019_ect_tables_45

7.82 kB
22 rows
10 columns

CREATE TABLE january_2019_ect_tables_45 (
  "index" BIGINT,
  "electronic_card_transactions_january_2019" VARCHAR  -- Electronic Card Transactions: January 2019,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);