search

Ecohen4 / Delhi

Energy data for Delhi
http://ecohen4.github.io/Delhi
3 stars 7 forks source link

file for extracting data from 2012-13 ACTUAL.xls file #2

Closed smslee closed 10 years ago

smslee commented 10 years ago

Extracts data from 50 'ACTUAL.xls' files with dates ranging from 3/26/2012 - 3/4/2013

Ecohen4 commented 10 years ago

what does this do? What are the inputs and outputs?

smslee commented 10 years ago

Input: 50 Excel files with power loads (in mW) recorded at 15 minute intervals from five utilities (BRPL, BYPL, NDPL, NDMC, MES). Each file has 1 week's (7 days) loads and is organized by date and utility.

Output: The R script takes the raw Excel files and combines them to produce one "long" form data set with 6 variables: days - 5 digit number indicating days since 1899-12-30. This is converted to data using the as.Date function. timeslots - character vectors indicating the 15 minute interval in a day in which the load was recorded (e.g. "01:45 - 02:00") discom - This refers to the utilities, also referred to as distribution companies or discoms mW - the power load measures in mW timepoint - integer assigned to each timeslot (e.g., 00:00 - 00:15 = 1, 00:15 - 00:30 = 2... etc) date - 'days' variable converted into date in the format of dd/mm/yyyy