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