def monthly_data_analysis():
output_data = table.idol_street_ranking(3)
od = pd.DataFrame(output_data, columns=["Rank", "Name", "Yell", "ID"])
articles = []
for i in range(1, 4):
a = get_article_date(i, monthly=True)
for j in a:
articles.append([len(j)])
od = od.apply(pd.to_numeric, errors="ignore")
od = od.sort_values(by="ID")
od = od.reset_index(drop=True)
c = pd.DataFrame(articles, columns=["Posts"])
target_g = pd.concat([od, c], axis=1, join="inner")
target_g = target_g.sort_values(by="Yell", ascending=False)
target_g = target_g.drop("ID", axis=1)
target_g = target_g.drop("Rank", axis=1)
target_g["art/day"] = target_g["Posts"] / datetime.datetime.now().day
target_g["hoge/art"] = target_g["Yell"] / target_g["Posts"]
target_g = target_g.replace(numpy.inf, numpy.nan)
target_g["hoge/art"] = target_g["hoge/art"].astype(int, raise_on_error=False)
target_g["hoge/day"] = target_g["Yell"] / datetime.datetime.now().day
target_g = target_g.round({"art/day": 2, "hoge/art": 1, "hoge/day": 1})
col_labels = [u"名前", u"総Yell", u"総投稿数", u"投稿数(1日当)", u"Yell数(1投稿当)", u"Yell数(1日当)"]
target_g.columns = col_labels
return target_g.sort_values(by=u"投稿数(1日当)", ascending=False), col_labels
idol_list.extend(idol_list_SG)
idol_list.extend(idol_list_CP)
idol_list.extend(idol_list_GEM)
if len(param) > 1:
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)
if os.path.exists("log") == False:
os.mkdir("log")
if os.path.exists("pics") == False:
os.mkdir("pics")
if param[1] == "idol_ranking":
output_data = table.idol_street_ranking(param[2])
#output_data_extra = data_analysis.increase_yell(output_data)
ntime = datetime.datetime.now()
if int(param[2]) == 1:
title = str(ntime.year) + "/" + str(ntime.month) + "/" + str(ntime.day) + " " + str(ntime.hour) + u"時" + str(ntime.minute) + u"分時点でのdmm.yellランキング(Daily)"
filename = "log/ist_idol_daily_" + str(datetime.datetime.now().strftime('%Y%m%d%H%M')) + ".csv"
if int(param[2]) == 3:
title = str(ntime.year) + "/" + str(ntime.month) + "/" + str(ntime.day) + " " + str(ntime.hour) + u"時" + str(ntime.minute) + u"分時点でのdmm.yellランキング(Monthly)"
filename = "log/ist_idol_monthly_" + str(datetime.datetime.now().strftime('%Y%m%d%H%M')) + ".csv"
heading = ["Rank",'Name','Yell','ID']
#heading_extra =["Rank",'Name','Yell', 'Increase','ID']
table.output_table(output_data,title,heading,"pics/hoge.png",(6,7),1.08,[0.09,0.55,0.15,0.13])#0.15,0.13])
