Energy Utilities User Data

Watts Up! Spark your high-voltage insights with this energy usage dataset!

@kaggle.jamespauls_energy_utilities_application_data

Table List

1 table(91.13 KB)

Energy Utilities Sim

@kaggle.jamespauls_energy_utilities_application_data.energy_utilities_sim

91.13 KB
1253 rows
12 columns

user_id User Id	average_daily_consumption Average Daily Consumption	average_days_to_bill_payment Average Days To Bill Payment	customer_since Customer Since	area Area	age Age	marital_status Marital Status	educational_level Educational Level	prefecture Prefecture	average_monthly_visits Average Monthly Visits	average_web_monthly_visits Average Web Monthly Visits	average_mobile_monthly_visits Average Mobile Monthly Visits
1	7.797533126	-33.9328995	Thu May 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	136.2008052	40-55	Married	Master’s degree	Neon-Attika	0.865182082	0.538853785	0.33013072
2	25.0682245	-3.213220187	Tue Jun 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	97.65631283	30-39	Married	Bachelor’s degree	Corinthus Crossroads	4.154857623	0.697383844	3.491963884
3	7.875073055	16.36692793	Mon Jun 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	133.0723222	40-55	Married	Master’s degree	Neon-Attika	2.819235325	2.394293834	0.560969959
4	12.30978674	-2.479824613	Thu Mar 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	88.88408469	40-55	Married	Master’s degree	Neon-Attika	0.852767331	0.569274494	0.23812676
5	8.888037236	14.00553046	Fri Aug 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	64.4594685	30-39	Married	Bachelor’s degree	Evoa Conglomerate	11.05652392	3.527665386	7.13160574
6	19.6055655	1.398080629	Thu Mar 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	60.50739326	19-29	Married	Bachelor’s degree	Voitron	5.911657601	2.26141851	3.419086422
7	9.567541538	14.59473682	Fri Sep 25 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	110.1636742	30-39	Married	Bachelor’s degree	Neon-Attika	5.439527657	2.522253982	3.207347238
8	15.92607154	11.6002377	Tue Feb 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	74.72148374	40-55	Single	Bachelor’s degree	Neon-Attika	4.273455049	0.267399751	4.120846402
9	12.2235703	-21.80393903	Wed Aug 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	92.94899212	40-55	Married	High school graduate, diploma or the equivalent	Heartsteel Sector	4.406747518	2.29560822	2.168044031
10	6.363220429	6.691513146	Fri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	97.59836377	40-55	Single	Master’s degree	Magnetos Syndicate	6.027927334	1.694885664	4.762233712


CREATE TABLE energy_utilities_sim (
  "user_id" BIGINT,
  "average_daily_consumption" DOUBLE,
  "average_days_to_bill_payment" DOUBLE,
  "customer_since" TIMESTAMP,
  "area" DOUBLE,
  "age" VARCHAR,
  "marital_status" VARCHAR,
  "educational_level" VARCHAR,
  "prefecture" VARCHAR,
  "average_monthly_visits" DOUBLE,
  "average_web_monthly_visits" DOUBLE,
  "average_mobile_monthly_visits" DOUBLE
);