def isSynced(): old_sheet_data = retTotalData('old') new_sheet_data = retTotalData('new') old_infected_count = new_infected_count = 0 old_dead_count = new_dead_count = 0 for state in old_sheet_data: for district in old_sheet_data[state]: old_infected_count += old_sheet_data[state][district]["infected"] old_dead_count += old_sheet_data[state][district]["dead"] for state in new_sheet_data: for district in new_sheet_data[state]: new_infected_count += new_sheet_data[state][district]["infected"] new_dead_count += new_sheet_data[state][district]["dead"] if (old_infected_count == new_infected_count and old_dead_count == new_dead_count): return 'Old and new sheets match perfectly!' else: if (old_infected_count >= new_infected_count): if (old_dead_count > new_dead_count): return 'Old sheet has {} more infected cases and {} more death cases'.format( old_infected_count - new_infected_count, old_dead_count - new_dead_count) elif (old_dead_count == new_dead_count): return 'Old sheet has {} more infected cases. Death count matches'.format( old_infected_count - new_infected_count) else: return 'Old sheet has {} more infected cases and a deficit of {} death cases'.format( old_infected_count - new_infected_count, new_dead_count - old_dead_count) else: if (new_dead_count > new_dead_count): return 'New sheet has {} more infected cases and {} more death cases'.format( new_infected_count - old_infected_count, new_dead_count - old_dead_count) elif (new_dead_count == new_dead_count): return 'New sheet has {} more infected cases. Death count matches'.format( new_infected_count - old_infected_count) else: return 'New sheet has {} more infected cases and a deficit of {} death cases'.format( new_infected_count - old_infected_count, new_dead_count - old_dead_count)
def districtData(sheet='old'): totalData = retTotalData(sheet) districtText = '' for state in totalData: districtText += '{} :\n'.format(state) for district in totalData[state]: districtText += district + ':\nInfected : {}'.format( totalData[state][district]["infected"] ) + '\nDead : {}\n\n'.format(totalData[state][district]["dead"]) return districtText
def distNAstate(stateName, sheet='old'): totalData = retTotalData(sheet) text = 'DIST_NAs in {} :\n'.format(stateName) if (stateName in totalData): if ("DIST_NA" in totalData[stateName]): text += 'Infected : {}\nDeath : {}'.format( totalData[stateName]['DIST_NA']["infected"], totalData[stateName]['DIST_NA']["dead"]) return text return "Good news! No DIST_NA for {}".format(stateName)
def stateData(sheet='old'): totalData = retTotalData(sheet) stateText = '' for state in totalData: infectedStateSum = 0 deadStateSum = 0 for district in totalData[state]: infectedStateSum += totalData[state][district]["infected"] deadStateSum += totalData[state][district]["dead"] stateText += state + '\nInfected : {}'.format( infectedStateSum) + '\nDead : {}\n\n'.format(deadStateSum) return stateText
def findDistrict(districtName, sheet='old'): totalData = retTotalData(sheet) districtText = '' if (districtName == 'DIST_NA'): return 'Use !distnatot to get all DIST_NA, or !distnastate statename for a particular state' for state in totalData: if districtName in totalData[state]: districtText = 'Values for {}, {}:\n'.format( districtName, state) + '\nInfected : {}'.format( totalData[state][districtName] ["infected"]) + '\nDead : {}'.format( totalData[state][districtName]["dead"]) return districtText return ('{} not found, check spelling and try again'.format(districtName))
def findState(stateName, sheet='old'): totalData = retTotalData(sheet) stateText = '' if stateName in totalData: infectedStateSum = 0 deadStateSum = 0 for district in totalData[stateName]: infectedStateSum += totalData[stateName][district]["infected"] deadStateSum += totalData[stateName][district]["dead"] stateText = 'Values for {}:\n'.format( stateName) + 'Infected : {}\nDead : {}'.format( infectedStateSum, deadStateSum) return stateText return ('{} not found, check spelling and try again'.format(stateName))
def stateDists(stateName, sheet='old'): totalData = retTotalData(sheet) infectedSum = 0 deadSum = 0 stateDistrictsText = 'Districts with numbers in {}:\n'.format(stateName) if stateName in totalData: for district in totalData[stateName]: infectedSum += totalData[stateName][district]["infected"] deadSum += totalData[stateName][district]["dead"] stateDistrictsText += district + '\nInfected : {}\nDead : {}\n\n'.format( totalData[stateName][district]["infected"], totalData[stateName][district]["dead"]) stateDistrictsText += 'Total infected : {}\nTotal dead : {}'.format( infectedSum, deadSum) return stateDistrictsText return "Found nothing for {}".format(stateName)
def totDistNA(sheet='old'): totalData = retTotalData(sheet) retText = 'DIST_NAs statewise :\n' distNAinfected = 0 distNAdead = 0 for state in totalData: for district in totalData[state]: if (district == 'DIST_NA'): retText += 'In {}:\n'.format( state) + 'Infected : {}\nDead : {}\n\n'.format( totalData[state][district]["infected"], totalData[state][district]["dead"]) distNAinfected += totalData[state][district]["infected"] distNAdead += totalData[state][district]["dead"] if (distNAdead != 0 and distNAinfected != 0): retText += 'Total DIST_NA count :\nInfected : {}\nDead : {}'.format( distNAinfected, distNAdead) return retText return 'Good News, ALL DIST_NA CLEARED!!! Party time'