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 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 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 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()