6 python scrpts
Budget: $10 – $30 USD
I need simple 5 python scripts that will work in backend and calculate date
1. I already have a python scrpt that receivesd ata over MQTT and saves it to mysql database. I need to make sure exceptions are added and even if some data problem is there is the script does not crash
2. Log_summary report this will create an hourly summary from summary table for each entity so that we can easily create quick reports
3.Post paid bill generate it will search and calculate bills for certain customers and update the database. If they due date is crossed it will update datebase
4. Post paid bill generate it will search and calculate bills for certain customers and update the database. If baance is crossed it will update the database
5.It will create a 6 hour recrrd of all the meters under an area and compute the total usage , this will be compared with the total energy delivered at that area . The difference between two will be determined to see if any theft is happening
6.YOu will need to gnerate a time series forecasting for a few points based on the historical data and save it to the database.
All these are backend script and will not need any GUI . We will provide detailed info for this.
1. I already have a python scrpt that receivesd ata over MQTT and saves it to mysql database. I need to make sure exceptions are added and even if some data problem is there is the script does not crash
2. Log_summary report this will create an hourly summary from summary table for each entity so that we can easily create quick reports
3.Post paid bill generate it will search and calculate bills for certain customers and update the database. If they due date is crossed it will update datebase
4. Post paid bill generate it will search and calculate bills for certain customers and update the database. If baance is crossed it will update the database
5.It will create a 6 hour recrrd of all the meters under an area and compute the total usage , this will be compared with the total energy delivered at that area . The difference between two will be determined to see if any theft is happening
6.YOu will need to gnerate a time series forecasting for a few points based on the historical data and save it to the database.
All these are backend script and will not need any GUI . We will provide detailed info for this.