Created
March 10, 2015 23:03
-
-
Save nipunbatra/0f13566f42c16545ec8a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Last login: Tue Mar 10 18:55:22 on ttys000 | |
| nipunbatra@Nipuns-MacBook-Pro:~/Dropbox/Public/notebooks/eco$ ipython | |
| Python 2.7.9 |Anaconda 2.1.0 (x86_64)| (default, Dec 15 2014, 10:37:34) | |
| Type "copyright", "credits" or "license" for more information. | |
| IPython 2.2.0 -- An enhanced Interactive Python. | |
| Anaconda is brought to you by Continuum Analytics. | |
| Please check out: http://continuum.io/thanks and https://binstar.org | |
| ? -> Introduction and overview of IPython's features. | |
| %quickref -> Quick reference. | |
| help -> Python's own help system. | |
| object? -> Details about 'object', use 'object??' for extra details. | |
| In [1]: from nilmtk import Da | |
| DataSet DataStore | |
| In [1]: from nilmtk import DataSet | |
| In [2]: ds = DataSet("/Users/nipunbatra/Downloads/e | |
| /Users/nipunbatra/Downloads/eScholarship UC item 62d3456p.pdf | |
| /Users/nipunbatra/Downloads/eco.h5.download/ | |
| /Users/nipunbatra/Downloads/eenergy2015_anomaly_detection.pdf | |
| /Users/nipunbatra/Downloads/eenergy2015_batra.pdf | |
| /Users/nipunbatra/Downloads/eenergy2015_submission_21.pdf | |
| /Users/nipunbatra/Downloads/eenergy2015_submission_22.pdf | |
| /Users/nipunbatra/Downloads/eenergy2015_submission_32.pdf | |
| /Users/nipunbatra/Downloads/evaluation-jr cand Spring 2015.docx | |
| /Users/nipunbatra/Downloads/evaluation_sr candidate faculty 2015.docx | |
| In [2]: ds = DataSet("/Users/nipunbatra/Downloads/wi | |
| /Users/nipunbatra/Downloads/wiki-temp.h5 /Users/nipunbatra/Downloads/wikienergy-disag-fhmm.h5 | |
| /Users/nipunbatra/Downloads/wikienergy-2.h5 /Users/nipunbatra/Downloads/wikienergy-disag.h5 | |
| /Users/nipunbatra/Downloads/wikienergy-disag-co.h5 /Users/nipunbatra/Downloads/wikienergy.h5 | |
| In [2]: ds = DataSet("/Users/nipunbatra/Downloads/wikie | |
| /Users/nipunbatra/Downloads/wikienergy-2.h5 /Users/nipunbatra/Downloads/wikienergy-disag.h5 | |
| /Users/nipunbatra/Downloads/wikienergy-disag-co.h5 /Users/nipunbatra/Downloads/wikienergy.h5 | |
| /Users/nipunbatra/Downloads/wikienergy-disag-fhmm.h5 | |
| In [2]: ds = DataSet("/Users/nipunbatra/Downloads/wikienergy.h5") | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 119 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 151 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 17 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 196 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 30 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 48 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 59 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 62 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 65 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 7 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| /Users/nipunbatra/git/nilmtk/nilmtk/metergroup.py:76: RuntimeWarning: Building 95 has an empty 'appliances' list. | |
| .format(building_id.instance), RuntimeWarning) | |
| In [3]: b = ds.buildings[2] | |
| In [4]: b.elec | |
| Out[4]: | |
| MeterGroup(meters= | |
| ElecMeter(instance=1, building=2, dataset='WikiEnergy', site_meter, appliances=[]) | |
| ElecMeter(instance=2, building=2, dataset='WikiEnergy', appliances=[Appliance(type='air conditioner', instance=1)]) | |
| ElecMeter(instance=3, building=2, dataset='WikiEnergy', appliances=[Appliance(type='spin dryer', instance=1)]) | |
| ElecMeter(instance=4, building=2, dataset='WikiEnergy', appliances=[Appliance(type='electric furnace', instance=1)]) | |
| ElecMeter(instance=5, building=2, dataset='WikiEnergy', appliances=[Appliance(type='oven', instance=1)]) | |
| ElecMeter(instance=6, building=2, dataset='WikiEnergy', appliances=[Appliance(type='electric swimming pool heater', instance=1)]) | |
| ElecMeter(instance=7, building=2, dataset='WikiEnergy', appliances=[Appliance(type='fridge', instance=1)]) | |
| ) | |
| In [5]: b.mains() | |
| --------------------------------------------------------------------------- | |
| AttributeError Traceback (most recent call last) | |
| <ipython-input-5-8aa9634a3a3b> in <module>() | |
| ----> 1 b.mains() | |
| AttributeError: 'Building' object has no attribute 'mains' | |
| In [6]: b.elec.mains() | |
| Out[6]: ElecMeter(instance=1, building=2, dataset='WikiEnergy', site_meter, appliances=[]) | |
| In [7]: b.elec.ge | |
| b.elec.get_labels b.elec.get_timeframe | |
| In [7]: elec = b.elec | |
| In [8]: elec. | |
| elec.activation_series elec.meters | |
| elec.activity_histogram elec.meters_directly_downstream_of_mains | |
| elec.all_meters elec.mutual_information | |
| elec.appliances elec.name | |
| elec.available_ac_types elec.nested_metergroups | |
| elec.available_physical_quantities elec.on_power_threshold | |
| elec.available_power_ac_types elec.pairwise | |
| elec.average_energy_per_period elec.pairwise_correlation | |
| elec.building elec.pairwise_mutual_information | |
| elec.call_method_on_all_meters elec.plot | |
| elec.clear_cache elec.plot_activity_histogram | |
| elec.contains_meters_from_multiple_buildings elec.plot_autocorrelation | |
| elec.correlation elec.plot_good_sections | |
| elec.correlation_of_sum_of_submeters_with_mains elec.plot_lag | |
| elec.dataframe_of_meters elec.plot_multiple | |
| elec.dataset elec.plot_power_histogram | |
| elec.describe elec.plot_spectrum | |
| elec.disabled_meters elec.plot_when_on | |
| elec.dominant_appliance elec.power_series | |
| elec.dominant_appliances elec.power_series_all_data | |
| elec.draw_wiring_graph elec.proportion_of_energy | |
| elec.dropout_rate elec.proportion_of_energy_submetered | |
| elec.energy_per_meter elec.proportion_of_upstream | |
| elec.entropy elec.proportion_of_upstream_total_per_meter | |
| elec.entropy_per_meter elec.sample_period | |
| elec.fraction_per_meter elec.select | |
| elec.from_list elec.select_top_k | |
| elec.from_other_metergroup elec.select_using_appliances | |
| elec.get_labels elec.simultaneous_switches | |
| elec.get_timeframe elec.sort_meters | |
| elec.good_sections elec.submeters | |
| elec.groupby elec.switch_times | |
| elec.identifier elec.total_energy | |
| elec.import_metadata elec.train_test_split | |
| elec.instance elec.union | |
| elec.is_site_meter elec.upstream_meter | |
| elec.label elec.uptime | |
| elec.load elec.use_alternative_mains | |
| elec.load_series elec.values_for_appliance_metadata_key | |
| elec.mains elec.vampire_power | |
| elec.matches elec.when_on | |
| elec.matches_appliances elec.wiring_graph | |
| In [8]: elec.d | |
| elec.dataframe_of_meters elec.describe elec.dominant_appliance elec.draw_wiring_graph | |
| elec.dataset elec.disabled_meters elec.dominant_appliances elec.dropout_rate | |
| In [8]: elec.dat | |
| elec.dataframe_of_meters elec.dataset | |
| In [8]: df = elec.dataframe_of_meters() | |
| In [9]: df | |
| Out[9]: | |
| (1, 2, WikiEnergy) (2, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 433 0 | |
| 2014-04-01 00:01:00-05:00 424 0 | |
| 2014-04-01 00:02:00-05:00 423 0 | |
| 2014-04-01 00:03:00-05:00 424 0 | |
| 2014-04-01 00:04:00-05:00 339 0 | |
| 2014-04-01 00:05:00-05:00 317 0 | |
| 2014-04-01 00:06:00-05:00 314 0 | |
| 2014-04-01 00:07:00-05:00 312 0 | |
| 2014-04-01 00:08:00-05:00 312 0 | |
| 2014-04-01 00:09:00-05:00 308 0 | |
| 2014-04-01 00:10:00-05:00 309 0 | |
| 2014-04-01 00:11:00-05:00 319 0 | |
| 2014-04-01 00:12:00-05:00 315 0 | |
| 2014-04-01 00:13:00-05:00 315 0 | |
| 2014-04-01 00:14:00-05:00 313 0 | |
| 2014-04-01 00:15:00-05:00 313 0 | |
| 2014-04-01 00:16:00-05:00 314 0 | |
| 2014-04-01 00:17:00-05:00 552 0 | |
| 2014-04-01 00:18:00-05:00 718 0 | |
| 2014-04-01 00:19:00-05:00 727 0 | |
| 2014-04-01 00:20:00-05:00 830 0 | |
| 2014-04-01 00:21:00-05:00 1188 0 | |
| 2014-04-01 00:22:00-05:00 1611 0 | |
| 2014-04-01 00:23:00-05:00 1040 0 | |
| 2014-04-01 00:24:00-05:00 817 0 | |
| 2014-04-01 00:25:00-05:00 815 0 | |
| 2014-04-01 00:26:00-05:00 814 0 | |
| 2014-04-01 00:27:00-05:00 814 0 | |
| 2014-04-01 00:28:00-05:00 776 0 | |
| 2014-04-01 00:29:00-05:00 707 0 | |
| ... ... ... | |
| 2014-05-31 18:29:00-05:00 591 0 | |
| 2014-05-31 18:30:00-05:00 689 0 | |
| 2014-05-31 18:31:00-05:00 684 0 | |
| 2014-05-31 18:32:00-05:00 674 0 | |
| 2014-05-31 18:33:00-05:00 688 0 | |
| 2014-05-31 18:34:00-05:00 1332 0 | |
| 2014-05-31 18:35:00-05:00 1055 0 | |
| 2014-05-31 18:36:00-05:00 561 0 | |
| 2014-05-31 18:37:00-05:00 501 0 | |
| 2014-05-31 18:38:00-05:00 450 0 | |
| 2014-05-31 18:39:00-05:00 449 0 | |
| 2014-05-31 18:40:00-05:00 448 0 | |
| 2014-05-31 18:41:00-05:00 448 0 | |
| 2014-05-31 18:42:00-05:00 448 0 | |
| 2014-05-31 18:43:00-05:00 448 0 | |
| 2014-05-31 18:44:00-05:00 448 0 | |
| 2014-05-31 18:45:00-05:00 457 0 | |
| 2014-05-31 18:46:00-05:00 457 0 | |
| 2014-05-31 18:47:00-05:00 458 0 | |
| 2014-05-31 18:48:00-05:00 458 0 | |
| 2014-05-31 18:49:00-05:00 458 0 | |
| 2014-05-31 18:50:00-05:00 535 0 | |
| 2014-05-31 18:51:00-05:00 579 0 | |
| 2014-05-31 18:52:00-05:00 574 0 | |
| 2014-05-31 18:53:00-05:00 572 0 | |
| 2014-05-31 18:54:00-05:00 572 0 | |
| 2014-05-31 18:55:00-05:00 572 0 | |
| 2014-05-31 18:56:00-05:00 571 0 | |
| 2014-05-31 18:57:00-05:00 571 0 | |
| 2014-05-31 18:58:00-05:00 571 0 | |
| (3, 2, WikiEnergy) (4, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 0 18 | |
| 2014-04-01 00:01:00-05:00 0 18 | |
| 2014-04-01 00:02:00-05:00 0 19 | |
| 2014-04-01 00:03:00-05:00 0 19 | |
| 2014-04-01 00:04:00-05:00 0 19 | |
| 2014-04-01 00:05:00-05:00 0 19 | |
| 2014-04-01 00:06:00-05:00 0 19 | |
| 2014-04-01 00:07:00-05:00 0 19 | |
| 2014-04-01 00:08:00-05:00 0 19 | |
| 2014-04-01 00:09:00-05:00 0 19 | |
| 2014-04-01 00:10:00-05:00 0 19 | |
| 2014-04-01 00:11:00-05:00 0 19 | |
| 2014-04-01 00:12:00-05:00 0 19 | |
| 2014-04-01 00:13:00-05:00 0 19 | |
| 2014-04-01 00:14:00-05:00 0 19 | |
| 2014-04-01 00:15:00-05:00 0 19 | |
| 2014-04-01 00:16:00-05:00 0 19 | |
| 2014-04-01 00:17:00-05:00 0 18 | |
| 2014-04-01 00:18:00-05:00 0 18 | |
| 2014-04-01 00:19:00-05:00 0 18 | |
| 2014-04-01 00:20:00-05:00 0 18 | |
| 2014-04-01 00:21:00-05:00 0 17 | |
| 2014-04-01 00:22:00-05:00 0 17 | |
| 2014-04-01 00:23:00-05:00 0 18 | |
| 2014-04-01 00:24:00-05:00 0 18 | |
| 2014-04-01 00:25:00-05:00 0 18 | |
| 2014-04-01 00:26:00-05:00 0 18 | |
| 2014-04-01 00:27:00-05:00 0 18 | |
| 2014-04-01 00:28:00-05:00 0 18 | |
| 2014-04-01 00:29:00-05:00 0 18 | |
| ... ... ... | |
| 2014-05-31 18:29:00-05:00 0 24 | |
| 2014-05-31 18:30:00-05:00 0 24 | |
| 2014-05-31 18:31:00-05:00 0 24 | |
| 2014-05-31 18:32:00-05:00 0 24 | |
| 2014-05-31 18:33:00-05:00 0 24 | |
| 2014-05-31 18:34:00-05:00 0 23 | |
| 2014-05-31 18:35:00-05:00 0 23 | |
| 2014-05-31 18:36:00-05:00 0 24 | |
| 2014-05-31 18:37:00-05:00 0 24 | |
| 2014-05-31 18:38:00-05:00 0 24 | |
| 2014-05-31 18:39:00-05:00 0 24 | |
| 2014-05-31 18:40:00-05:00 0 24 | |
| 2014-05-31 18:41:00-05:00 0 24 | |
| 2014-05-31 18:42:00-05:00 0 24 | |
| 2014-05-31 18:43:00-05:00 0 24 | |
| 2014-05-31 18:44:00-05:00 0 24 | |
| 2014-05-31 18:45:00-05:00 0 24 | |
| 2014-05-31 18:46:00-05:00 0 24 | |
| 2014-05-31 18:47:00-05:00 0 24 | |
| 2014-05-31 18:48:00-05:00 0 25 | |
| 2014-05-31 18:49:00-05:00 0 25 | |
| 2014-05-31 18:50:00-05:00 0 24 | |
| 2014-05-31 18:51:00-05:00 0 24 | |
| 2014-05-31 18:52:00-05:00 0 24 | |
| 2014-05-31 18:53:00-05:00 0 25 | |
| 2014-05-31 18:54:00-05:00 0 25 | |
| 2014-05-31 18:55:00-05:00 0 24 | |
| 2014-05-31 18:56:00-05:00 0 25 | |
| 2014-05-31 18:57:00-05:00 0 24 | |
| 2014-05-31 18:58:00-05:00 0 24 | |
| (5, 2, WikiEnergy) (6, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 0 13 | |
| 2014-04-01 00:01:00-05:00 0 13 | |
| 2014-04-01 00:02:00-05:00 0 13 | |
| 2014-04-01 00:03:00-05:00 0 13 | |
| 2014-04-01 00:04:00-05:00 0 13 | |
| 2014-04-01 00:05:00-05:00 0 13 | |
| 2014-04-01 00:06:00-05:00 0 13 | |
| 2014-04-01 00:07:00-05:00 0 13 | |
| 2014-04-01 00:08:00-05:00 0 13 | |
| 2014-04-01 00:09:00-05:00 0 13 | |
| 2014-04-01 00:10:00-05:00 0 13 | |
| 2014-04-01 00:11:00-05:00 0 13 | |
| 2014-04-01 00:12:00-05:00 0 13 | |
| 2014-04-01 00:13:00-05:00 0 13 | |
| 2014-04-01 00:14:00-05:00 0 13 | |
| 2014-04-01 00:15:00-05:00 0 13 | |
| 2014-04-01 00:16:00-05:00 0 13 | |
| 2014-04-01 00:17:00-05:00 0 13 | |
| 2014-04-01 00:18:00-05:00 0 13 | |
| 2014-04-01 00:19:00-05:00 0 12 | |
| 2014-04-01 00:20:00-05:00 0 12 | |
| 2014-04-01 00:21:00-05:00 0 12 | |
| 2014-04-01 00:22:00-05:00 0 11 | |
| 2014-04-01 00:23:00-05:00 0 12 | |
| 2014-04-01 00:24:00-05:00 0 12 | |
| 2014-04-01 00:25:00-05:00 0 12 | |
| 2014-04-01 00:26:00-05:00 0 12 | |
| 2014-04-01 00:27:00-05:00 0 12 | |
| 2014-04-01 00:28:00-05:00 0 12 | |
| 2014-04-01 00:29:00-05:00 0 13 | |
| ... ... ... | |
| 2014-05-31 18:29:00-05:00 0 139 | |
| 2014-05-31 18:30:00-05:00 0 139 | |
| 2014-05-31 18:31:00-05:00 0 139 | |
| 2014-05-31 18:32:00-05:00 0 139 | |
| 2014-05-31 18:33:00-05:00 0 139 | |
| 2014-05-31 18:34:00-05:00 0 138 | |
| 2014-05-31 18:35:00-05:00 0 139 | |
| 2014-05-31 18:36:00-05:00 0 140 | |
| 2014-05-31 18:37:00-05:00 0 140 | |
| 2014-05-31 18:38:00-05:00 0 139 | |
| 2014-05-31 18:39:00-05:00 0 139 | |
| 2014-05-31 18:40:00-05:00 0 139 | |
| 2014-05-31 18:41:00-05:00 0 139 | |
| 2014-05-31 18:42:00-05:00 0 139 | |
| 2014-05-31 18:43:00-05:00 0 139 | |
| 2014-05-31 18:44:00-05:00 0 139 | |
| 2014-05-31 18:45:00-05:00 0 139 | |
| 2014-05-31 18:46:00-05:00 0 139 | |
| 2014-05-31 18:47:00-05:00 0 139 | |
| 2014-05-31 18:48:00-05:00 0 139 | |
| 2014-05-31 18:49:00-05:00 0 139 | |
| 2014-05-31 18:50:00-05:00 0 139 | |
| 2014-05-31 18:51:00-05:00 0 139 | |
| 2014-05-31 18:52:00-05:00 0 139 | |
| 2014-05-31 18:53:00-05:00 0 139 | |
| 2014-05-31 18:54:00-05:00 0 139 | |
| 2014-05-31 18:55:00-05:00 0 139 | |
| 2014-05-31 18:56:00-05:00 0 139 | |
| 2014-05-31 18:57:00-05:00 0 139 | |
| 2014-05-31 18:58:00-05:00 0 139 | |
| (7, 2, WikiEnergy) | |
| localminute | |
| 2014-04-01 00:00:00-05:00 8 | |
| 2014-04-01 00:01:00-05:00 8 | |
| 2014-04-01 00:02:00-05:00 8 | |
| 2014-04-01 00:03:00-05:00 8 | |
| 2014-04-01 00:04:00-05:00 8 | |
| 2014-04-01 00:05:00-05:00 8 | |
| 2014-04-01 00:06:00-05:00 8 | |
| 2014-04-01 00:07:00-05:00 8 | |
| 2014-04-01 00:08:00-05:00 8 | |
| 2014-04-01 00:09:00-05:00 8 | |
| 2014-04-01 00:10:00-05:00 8 | |
| 2014-04-01 00:11:00-05:00 8 | |
| 2014-04-01 00:12:00-05:00 8 | |
| 2014-04-01 00:13:00-05:00 8 | |
| 2014-04-01 00:14:00-05:00 8 | |
| 2014-04-01 00:15:00-05:00 8 | |
| 2014-04-01 00:16:00-05:00 8 | |
| 2014-04-01 00:17:00-05:00 8 | |
| 2014-04-01 00:18:00-05:00 8 | |
| 2014-04-01 00:19:00-05:00 8 | |
| 2014-04-01 00:20:00-05:00 8 | |
| 2014-04-01 00:21:00-05:00 8 | |
| 2014-04-01 00:22:00-05:00 8 | |
| 2014-04-01 00:23:00-05:00 8 | |
| 2014-04-01 00:24:00-05:00 8 | |
| 2014-04-01 00:25:00-05:00 8 | |
| 2014-04-01 00:26:00-05:00 8 | |
| 2014-04-01 00:27:00-05:00 8 | |
| 2014-04-01 00:28:00-05:00 8 | |
| 2014-04-01 00:29:00-05:00 8 | |
| ... ... | |
| 2014-05-31 18:29:00-05:00 8 | |
| 2014-05-31 18:30:00-05:00 8 | |
| 2014-05-31 18:31:00-05:00 8 | |
| 2014-05-31 18:32:00-05:00 8 | |
| 2014-05-31 18:33:00-05:00 8 | |
| 2014-05-31 18:34:00-05:00 8 | |
| 2014-05-31 18:35:00-05:00 8 | |
| 2014-05-31 18:36:00-05:00 8 | |
| 2014-05-31 18:37:00-05:00 8 | |
| 2014-05-31 18:38:00-05:00 8 | |
| 2014-05-31 18:39:00-05:00 8 | |
| 2014-05-31 18:40:00-05:00 8 | |
| 2014-05-31 18:41:00-05:00 8 | |
| 2014-05-31 18:42:00-05:00 8 | |
| 2014-05-31 18:43:00-05:00 8 | |
| 2014-05-31 18:44:00-05:00 8 | |
| 2014-05-31 18:45:00-05:00 8 | |
| 2014-05-31 18:46:00-05:00 8 | |
| 2014-05-31 18:47:00-05:00 8 | |
| 2014-05-31 18:48:00-05:00 8 | |
| 2014-05-31 18:49:00-05:00 8 | |
| 2014-05-31 18:50:00-05:00 8 | |
| 2014-05-31 18:51:00-05:00 8 | |
| 2014-05-31 18:52:00-05:00 8 | |
| 2014-05-31 18:53:00-05:00 8 | |
| 2014-05-31 18:54:00-05:00 8 | |
| 2014-05-31 18:55:00-05:00 8 | |
| 2014-05-31 18:56:00-05:00 8 | |
| 2014-05-31 18:57:00-05:00 8 | |
| 2014-05-31 18:58:00-05:00 8 | |
| [87539 rows x 7 columns] | |
| In [10]: df.columns | |
| Out[10]: Index([(1, 2, u'WikiEnergy'), (2, 2, u'WikiEnergy'), (3, 2, u'WikiEnergy'), (4, 2, u'WikiEnergy'), (5, 2, u'WikiEnergy'), (6, 2, u'WikiEnergy'), (7, 2, u'WikiEnergy')], dtype='object') | |
| In [11]: df.head() | |
| Out[11]: | |
| (1, 2, WikiEnergy) (2, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 433 0 | |
| 2014-04-01 00:01:00-05:00 424 0 | |
| 2014-04-01 00:02:00-05:00 423 0 | |
| 2014-04-01 00:03:00-05:00 424 0 | |
| 2014-04-01 00:04:00-05:00 339 0 | |
| (3, 2, WikiEnergy) (4, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 0 18 | |
| 2014-04-01 00:01:00-05:00 0 18 | |
| 2014-04-01 00:02:00-05:00 0 19 | |
| 2014-04-01 00:03:00-05:00 0 19 | |
| 2014-04-01 00:04:00-05:00 0 19 | |
| (5, 2, WikiEnergy) (6, 2, WikiEnergy) \ | |
| localminute | |
| 2014-04-01 00:00:00-05:00 0 13 | |
| 2014-04-01 00:01:00-05:00 0 13 | |
| 2014-04-01 00:02:00-05:00 0 13 | |
| 2014-04-01 00:03:00-05:00 0 13 | |
| 2014-04-01 00:04:00-05:00 0 13 | |
| (7, 2, WikiEnergy) | |
| localminute | |
| 2014-04-01 00:00:00-05:00 8 | |
| 2014-04-01 00:01:00-05:00 8 | |
| 2014-04-01 00:02:00-05:00 8 | |
| 2014-04-01 00:03:00-05:00 8 | |
| 2014-04-01 00:04:00-05:00 8 | |
| In [12]: df2 = elec.mains().load().next() | |
| In [13]: df2 | |
| Out[13]: | |
| physical_quantity power | |
| type active | |
| localminute | |
| 2014-04-01 00:55:00-05:00 389 | |
| 2014-04-01 00:56:00-05:00 390 | |
| 2014-04-01 00:57:00-05:00 391 | |
| 2014-04-01 00:58:00-05:00 391 | |
| 2014-04-01 00:59:00-05:00 391 | |
| 2014-04-01 01:00:00-05:00 391 | |
| 2014-04-01 01:01:00-05:00 391 | |
| 2014-04-01 01:02:00-05:00 390 | |
| 2014-04-01 01:03:00-05:00 388 | |
| 2014-04-01 01:04:00-05:00 343 | |
| 2014-04-01 01:05:00-05:00 308 | |
| 2014-04-01 01:06:00-05:00 308 | |
| 2014-04-01 01:07:00-05:00 308 | |
| 2014-04-01 01:08:00-05:00 329 | |
| 2014-04-01 01:09:00-05:00 426 | |
| 2014-04-01 01:10:00-05:00 415 | |
| 2014-04-01 01:11:00-05:00 413 | |
| 2014-04-01 01:12:00-05:00 413 | |
| 2014-04-01 01:13:00-05:00 411 | |
| 2014-04-01 01:14:00-05:00 412 | |
| 2014-04-01 01:15:00-05:00 412 | |
| 2014-04-01 01:16:00-05:00 411 | |
| 2014-04-01 01:17:00-05:00 380 | |
| 2014-04-01 01:18:00-05:00 304 | |
| 2014-04-01 01:19:00-05:00 304 | |
| 2014-04-01 01:20:00-05:00 305 | |
| 2014-04-01 01:21:00-05:00 305 | |
| 2014-04-01 01:22:00-05:00 302 | |
| 2014-04-01 01:23:00-05:00 311 | |
| 2014-04-01 01:24:00-05:00 1083 | |
| ... ... | |
| 2014-05-31 18:29:00-05:00 591 | |
| 2014-05-31 18:30:00-05:00 689 | |
| 2014-05-31 18:31:00-05:00 684 | |
| 2014-05-31 18:32:00-05:00 674 | |
| 2014-05-31 18:33:00-05:00 688 | |
| 2014-05-31 18:34:00-05:00 1332 | |
| 2014-05-31 18:35:00-05:00 1055 | |
| 2014-05-31 18:36:00-05:00 561 | |
| 2014-05-31 18:37:00-05:00 501 | |
| 2014-05-31 18:38:00-05:00 450 | |
| 2014-05-31 18:39:00-05:00 449 | |
| 2014-05-31 18:40:00-05:00 448 | |
| 2014-05-31 18:41:00-05:00 448 | |
| 2014-05-31 18:42:00-05:00 448 | |
| 2014-05-31 18:43:00-05:00 448 | |
| 2014-05-31 18:44:00-05:00 448 | |
| 2014-05-31 18:45:00-05:00 457 | |
| 2014-05-31 18:46:00-05:00 457 | |
| 2014-05-31 18:47:00-05:00 458 | |
| 2014-05-31 18:48:00-05:00 458 | |
| 2014-05-31 18:49:00-05:00 458 | |
| 2014-05-31 18:50:00-05:00 535 | |
| 2014-05-31 18:51:00-05:00 579 | |
| 2014-05-31 18:52:00-05:00 574 | |
| 2014-05-31 18:53:00-05:00 572 | |
| 2014-05-31 18:54:00-05:00 572 | |
| 2014-05-31 18:55:00-05:00 572 | |
| 2014-05-31 18:56:00-05:00 571 | |
| 2014-05-31 18:57:00-05:00 571 | |
| 2014-05-31 18:58:00-05:00 571 | |
| [87538 rows x 1 columns] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment