I want to visualize electric load profile weekly wise. The electric load profile has the electric load readings taken for every hour on each day.
Typical CSV columns are date,day,hour,load.
In a day 24 readings are taken, in a week (7 multiplied by 24)=168 and in a month (168 multiplied by 4)=672 are taken. So there are around 700 rows for a typical month.
I want to have visualizations for weekly wise, day wise, hour range wise etc., As of now I am just using only two columns with serial number and load. And two visualizations I made.
One as x axis serial number from 1 to 700. And y axis as load.
Second as x axis load and y axis as count.
How to have different combinations of visualizations for day wise and hour wise.
I am using python client to create elasticsearch object and using CSV reader to read the file and populate elasticsearch object.
Please guide me. thanks,