def send(): csv = pull() for record in csv.iterrows(): if int(record[1]["DaysLeft"]) >= 0: record = record[1] print(record["Name"]) india_rec, state_rec, district_rec = data(record["State"], record["District"]) india_conf = int(india_rec["Confirmed"]) india_recovered = int(india_rec["Recovered"]) india_des = int(india_rec["Deceased"]) state_conf = int(state_rec["Confirmed"]) state_recovered = int(state_rec["Recovered"]) state_des = int(state_rec["Deceased"]) dist_conf = int(district_rec["Confirmed"]) dist_act = int(district_rec["Active"]) dist_recovered = int(district_rec["Recovered"]) dist_dec = int(district_rec["Deceased"]) rec_str = "The record according to sources as on {}-\n \ India\n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ State-{} \n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ District-{} \n \ Confirmed {} \n \ Active {}\n \ Recovered {} \n \ Deceased {} \n \ To visit the Covid website for more information\ https://bit.ly/3djKf0C\ ".format(date.today(), india_conf, india_recovered, india_des, record["State"], state_conf, state_recovered, state_des, record["District"], dist_conf, dist_act, dist_recovered, dist_dec) if int(record["DaysLeft"]) == 0: message( record["Country Code"], record["Phone Number"], "Your plan is over. Please recharge to avail service.") else: message(record["Country Code"], record["Phone Number"], rec_str) sleep(4) csv["DaysLeft"] = csv["DaysLeft"] - 1 csv.to_csv("db.csv") commit()
def district_to_daywise(): global data, dist_list lst = list(data.values()) pxd = [] c = 0 for x in lst: dat = x["districtData"] lstx = [[x, y] for x, y in dat.items()] for z in lstx: b = z[1] act = b["active"] conf = b["confirmed"] dec = b["deceased"] rec = b["recovered"] pxd.append([z[0], conf, act, rec, dec]) pxd = pd.DataFrame.from_records(pxd) pxd.columns = ["District", "Conf", "Act", "Rec", "Des"] cum = pull("distcum.csv") cum.columns = ["District", "Conf", "Act", "Rec", "Des"] dcum = cum.drop(["District"], axis=1) dpxd = pxd.drop(["District"], axis=1) sub = dpxd.subtract(dcum, axis=1) print(sum(list(sub.mean()))) if sum(list(sub.mean())) != 0.0: final = pd.concat([cum["District"], sub], axis=1) pxd.to_csv("distcum.csv") final.to_csv("distdaily.csv") commit("distcum.csv") commit("distdaily.csv") else: final = pull("distdaily.csv") return final
def add_user(name, country_code, phone_number, state, district): csv = pull() if phone_number not in (csv["Phone Number"]): csv.loc[-1] = [ str(name), str(country_code), str(phone_number), 3, str(state), str(district) ] csv.to_csv("db.csv") commit() return 1 else: return 0
def send(): csv = pull("db.csv") for record in csv.iterrows(): record = record[1] try: if int(record["DaysLeft"]) >= 0: print(record["Name"]) india_data_cum, state_data_cum, district_data_cum, india_data_daily, state_data_daily, district_data_daily = data( record["State"], record["District"]) #Cum india_conf = int(india_data_cum["Confirmed"]) india_recovered = int(india_data_cum["Recovered"]) india_des = int(india_data_cum["Deceased"]) state_conf = int(state_data_cum["Confirmed"]) state_recovered = int(state_data_cum["Recovered"]) state_des = int(state_data_cum["Deceased"]) dist_conf = int(district_data_cum["Confirmed"]) dist_act = int(district_data_cum["Active"]) dist_recovered = int(district_data_cum["Recovered"]) dist_dec = int(district_data_cum["Deceased"]) #Daily india_conf_d = int(india_data_daily["Confirmed"]) india_recovered_d = int(india_data_daily["Recovered"]) india_des_d = int(india_data_daily["Deceased"]) state_conf_d = int(state_data_daily["Confirmed"]) state_recovered_d = int(state_data_daily["Recovered"]) state_des_d = int(state_data_daily["Deceased"]) dist_conf_d = int(district_data_daily["Confirmed"]) dist_act_d = int(district_data_daily["Active"]) dist_recovered_d = int(district_data_daily["Recovered"]) dist_dec_d = int(district_data_daily["Deceased"]) # rec_str ="h" # rec_str = "The record according to sources as on {}-\n \ # Cummilative\n \ # India\n \ # Confirmed {} \n \ # Recovered {} \n \ # Deceased {} \n\n \ # State-{} \n \ # Confirmed {} \n \ # Recovered {} \n \ # Deceased {} \n\n \ # District-{} \n \ # Confirmed {} \n \ # Active {}\n \ # Recovered {} \n \ # Deceased {} \n\n\ # Yesturdays' report\n \ # India\n \ # Confirmed {} \n \ # Recovered {} \n \ # Deceased {} \n\n \ # State-{} \n \ # Confirmed {} \n \ # Recovered {} \n \ # Deceased {} \n\n \ # District-{} \n \ # Confirmed {} \n \ # Active {}\n \ # Recovered {} \n \ # Deceased {} \n\n\ # To visit the Covid website for more information \ # \nhttps://bit.ly/3djKf0C. If the link is not clickable please do reply. \n\ # ".format(date.today(),india_conf, india_recovered, india_des, record["State"],state_conf, # state_recovered,state_des,record["District"],dist_conf, # dist_act,dist_recovered,dist_dec, # india_conf_d, india_recovered_d, india_des_d, record["State"],state_conf_d, # state_recovered_d,state_des_d,record["District"],dist_conf_d, # dist_act_d,dist_recovered_d,dist_dec_d) rec_str = "The record according to sources as on {}-\n \ Cummilative\n \ India\n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ State-{} \n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ District-{} \n \ Confirmed {} \n \ Active {}\n \ Recovered {} \n \ Deceased {} \n\n\ Yesturdays' report\n \ India\n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ State-{} \n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ To visit the Covid website for more information \ \nhttps://bit.ly/3djKf0C. If the link is not clickable please do reply. \n\ ".format(date.today(), india_conf, india_recovered, india_des, record["State"], state_conf, state_recovered, state_des, record["District"], dist_conf, dist_act, dist_recovered, dist_dec, india_conf_d, india_recovered_d, india_des_d, record["State"], state_conf_d, state_recovered_d, state_des_d) if int(record["DaysLeft"]) == 0: message( record["Country Code"], record["Phone Number"], "Your plan is over. Please recharge to avail service.") else: message(record["Country Code"], record["Phone Number"], rec_str) except Exception as e: print("Not sent:", record["Name"]) csv["DaysLeft"] = csv["DaysLeft"] - 1 csv.to_csv("db.csv") commit("db.csv")
def send(): csv = pull() for record in csv.iterrows(): record = record[1] try: if int(record["DaysLeft"]) >= 0: print(record["Name"]) india_rec, state_rec, district_rec = data( record["State"], record["District"]) india_conf = int(india_rec["Confirmed"]) india_recovered = int(india_rec["Recovered"]) india_des = int(india_rec["Deceased"]) state_conf = int(state_rec["Confirmed"]) state_recovered = int(state_rec["Recovered"]) state_des = int(state_rec["Deceased"]) dist_conf = int(district_rec["Confirmed"]) dist_act = int(district_rec["Active"]) dist_recovered = int(district_rec["Recovered"]) dist_dec = int(district_rec["Deceased"]) rec_str = "The record according to sources as on {}-\n \ India\n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ State-{} \n \ Confirmed {} \n \ Recovered {} \n \ Deceased {} \n\n \ District-{} \n \ Confirmed {} \n \ Active {}\n \ Recovered {} \n \ Deceased {} \n \ To visit the Covid website for more information\ https://bit.ly/3djKf0C .Please do reply with a '.' to keep a two way conversation. This is a must as to keep the connection established. If by any chance you dont get the updates then send 'join mountain-quarter' to this number again. \n\ ".format(date.today(), india_conf, india_recovered, india_des, record["State"], state_conf, state_recovered, state_des, record["District"], dist_conf, dist_act, dist_recovered, dist_dec) if int(record["DaysLeft"]) == 0: message( record["Country Code"], record["Phone Number"], "Your plan is over. Please recharge to avail service.") else: message(record["Country Code"], record["Phone Number"], rec_str) sleep(5) except: print("Not sent:", record["Name"]) csv["DaysLeft"] = csv["DaysLeft"] - 1 csv.to_csv("db.csv") commit()