Reformat dataset using python script
Budget: $30 – $250 NZD
I have developed a python script that does the following:
1. takes JSON message and converts it to human-readable CSV format with all data in separate columns
2. convert timestamp from epoch to human-readable timestamps.
3. calculate daily averages
4. print daily averages onto a new sheet
5. calculate weekly averages
6. print weekly averages onto a different sheet
7. calculate & print monthly averages on a different sheet.
The current output is hard to graph as each sensor has its own row and each column is the reading for that sensors data for that WEEK/DAY/Month.
I need to reformat the output (no calculations need to be changed) so that it is in an easy to graph format. The desired output would be to have each sensor's data in a separate file for daily/weekly/monthly averages
eg. sensor 301 will have its own file for:
raw data
daily averages
weekly averages
monthly averages
this separate files will be required for each sensor's output
1. takes JSON message and converts it to human-readable CSV format with all data in separate columns
2. convert timestamp from epoch to human-readable timestamps.
3. calculate daily averages
4. print daily averages onto a new sheet
5. calculate weekly averages
6. print weekly averages onto a different sheet
7. calculate & print monthly averages on a different sheet.
The current output is hard to graph as each sensor has its own row and each column is the reading for that sensors data for that WEEK/DAY/Month.
I need to reformat the output (no calculations need to be changed) so that it is in an easy to graph format. The desired output would be to have each sensor's data in a separate file for daily/weekly/monthly averages
eg. sensor 301 will have its own file for:
raw data
daily averages
weekly averages
monthly averages
this separate files will be required for each sensor's output