Task for Lab 1
1. Download file with data (PV2013June.xlsx)
2. Pick the data from day XX-06-2013, where XX is your birth day. Open data file and save Data sheet corresponding to picked date. (15 in example).
3. Save data sheet in csv format (for example, as data pv).
4. Using data from column C (IntSolIrr) write code in Python or other languages to do the following:
4.1. Find maximum solar radiation for picked date.
4.2. Find average solar radiation for picked date.
4.3 Find earliest time sensor started to receive solar radiation.
4.4. Find latest time sensor received solar radiation.
4.5. Find time duration when sensor was receiving solar radiation (both in hours and the percentage of 24h). 4.6. Find average solar radiation during time sensor received solar radiation. 4.7. Display solar radiation graph.
5. Save code and do screenshots if necessary.
6. Submit a report, which should contain code and screenshots with results.