Python Statistics_order_split примеры использования

Пример #1

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_Inm as db_Inm
import os

# DB作成
db_path = "./analysis/db_ranking/Inm.db"
table_name = "inm"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_Inm.db_create()

# タグ別のリストと動画総数のインスタンス生成 #
stats_Inm = stats.Statistics_order_split()

videoid_list = stats_Inm.video_id_taglist("真夏の夜の淫夢")
contributorid_list = stats_Inm.contributor_id_taglist("真夏の夜の淫夢")
view_list = stats_Inm.view_taglist("真夏の夜の淫夢")
comment_list = stats_Inm.comment_taglist("真夏の夜の淫夢")
mylist_list = stats_Inm.mylist_taglist("真夏の夜の淫夢")
total_list = stats_Inm.total_taglist("真夏の夜の淫夢")

db.db_insert(videoid_list, contributorid_list, view_list, comment_list,
             mylist_list, total_list, db_path, table_name)

Пример #2

Файл: VOICEROIDtheater_ranking.py Проект: Dhikigame/Niconico-Contributor-TagRanking

import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/VOICEROIDtheater.db"
table_name = "voiceroid_theater"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_VOICEROIDtheater = stats.Statistics_order_split()

videoid_list = stats_VOICEROIDtheater.video_id_taglist("VOICEROID劇場")
contributorid_list = stats_VOICEROIDtheater.contributor_id_taglist(
    "VOICEROID劇場")
title_list = stats_VOICEROIDtheater.title_taglist("VOICEROID劇場")
view_list = stats_VOICEROIDtheater.view_taglist("VOICEROID劇場")
comment_list = stats_VOICEROIDtheater.comment_taglist("VOICEROID劇場")
mylist_list = stats_VOICEROIDtheater.mylist_taglist("VOICEROID劇場")
total_list = stats_VOICEROIDtheater.total_taglist("VOICEROID劇場")

db.db_insert(videoid_list, contributorid_list, title_list, view_list,
             comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #3

Файл: Dance_ranking.py Проект: Dhikigame/Niconico-Contributor-TagRanking

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/DANCE.db"
table_name = "dance"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_DANCE = stats.Statistics_order_split()

videoid_list = stats_DANCE.video_id_taglist("踊ってみた")
contributorid_list = stats_DANCE.contributor_id_taglist("踊ってみた")
title_list = stats_DANCE.title_taglist("踊ってみた")
view_list = stats_DANCE.view_taglist("踊ってみた")
comment_list = stats_DANCE.comment_taglist("踊ってみた")
mylist_list = stats_DANCE.mylist_taglist("踊ってみた")
total_list = stats_DANCE.total_taglist("踊ってみた")

db.db_insert(videoid_list, contributorid_list, title_list, view_list,
             comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #4

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os


# DB作成
db_path = "./analysis/db_ranking/MusicMAD.db"
table_name = "music_mad"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_MusicMAD = stats.Statistics_order_split()

videoid_list = stats_MusicMAD.video_id_taglist("音MAD")
contributorid_list = stats_MusicMAD.contributor_id_taglist("音MAD")
view_list = stats_MusicMAD.view_taglist("音MAD")
comment_list = stats_MusicMAD.comment_taglist("音MAD")
mylist_list = stats_MusicMAD.mylist_taglist("音MAD")
total_list = stats_MusicMAD.total_taglist("音MAD")

db.db_insert(videoid_list, contributorid_list, view_list, comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #5

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/Kansai.db"
table_name = "kansai"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_Kansai = stats.Statistics_order_split()

videoid_list = stats_Kansai.video_id_taglist("関西クレーマー")
contributorid_list = stats_Kansai.contributor_id_taglist("関西クレーマー")
view_list = stats_Kansai.view_taglist("関西クレーマー")
comment_list = stats_Kansai.comment_taglist("関西クレーマー")
mylist_list = stats_Kansai.mylist_taglist("関西クレーマー")
total_list = stats_Kansai.total_taglist("関西クレーマー")

db.db_insert(videoid_list, contributorid_list, view_list, comment_list,
             mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #6

Файл: main_TableDesignation.py Проект: Dhikigame/Niconico-Contributor-FreeTagRanking

        print("登録したタグ" + str(i-1) + ": " + tags[i-2])
    else:
        break

# DB作成
db_path = "./analysis/db_ranking/" + db_name + ".db"
print("データベースのパス：" + db_path)
if os.path.exists(db_path) == True:
    os.remove(db_path)
    print("データベースを消去しましたので、再度作り直します：" + db_path)
db_create.db_create(db_path, table_name)
print("データベースを作成完了：" + db_path)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_tags = stats.Statistics_order_split()

print("1.動画IDをリストに保存")
videoid_list = stats_tags.video_id_taglist(tags)
print("2.投稿者IDをリストに保存")
contributorid_list = stats_tags.contributor_id_taglist(tags)
print("3.動画データ取得日時をリストに保存")
registdate_list = stats_tags.regist_date_taglist(tags)
print("4.動画投稿日時をリストに保存")
uploaddate_list = stats_tags.upload_date_taglist(tags)
print("5.動画タイトルをリストに保存")
title_list = stats_tags.title_taglist(tags)
print("6.再生数をリストに保存")
view_list = stats_tags.view_taglist(tags)
print("7.コメント数をリストに保存")
comment_list = stats_tags.comment_taglist(tags)

Пример #7

import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/RTA.db"
table_name = "RTA"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_RTA = stats.Statistics_order_split()

videoid_list = stats_RTA.video_id_taglist("RTA")
contributorid_list = stats_RTA.contributor_id_taglist("RTA")
registdate_list = stats_RTA.regist_date_taglist("RTA")
uploaddate_list = stats_RTA.upload_date_taglist("RTA")
title_list = stats_RTA.title_taglist("RTA")
view_list = stats_RTA.view_taglist("RTA")
comment_list = stats_RTA.comment_taglist("RTA")
mylist_list = stats_RTA.mylist_taglist("RTA")
total_list = stats_RTA.total_taglist("RTA")

db.db_insert(videoid_list, contributorid_list, registdate_list,
             uploaddate_list, title_list, view_list, comment_list, mylist_list,
             total_list, db_path, table_name)

Пример #8

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/Kankore.db"
table_name = "kankore"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_Kankore = stats.Statistics_order_split()

videoid_list = stats_Kankore.video_id_taglist("艦これ")
contributorid_list = stats_Kankore.contributor_id_taglist("艦これ")
title_list = stats_Kankore.title_taglist("艦これ")
view_list = stats_Kankore.view_taglist("艦これ")
comment_list = stats_Kankore.comment_taglist("艦これ")
mylist_list = stats_Kankore.mylist_taglist("艦これ")
total_list = stats_Kankore.total_taglist("艦これ")

db.db_insert(videoid_list, contributorid_list, title_list, view_list,
             comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #9

Файл: BBSenpaitheater_ranking.py Проект: Dhikigame/Niconico-Contributor-TagRanking

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/BBSenpaitheater.db"
table_name = "BBSenpai_theater"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_BBSenpaitheater = stats.Statistics_order_split()

videoid_list = stats_BBSenpaitheater.video_id_taglist("BB先輩劇場")
contributorid_list = stats_BBSenpaitheater.contributor_id_taglist("BB先輩劇場")
title_list = stats_BBSenpaitheater.title_taglist("BB先輩劇場")
view_list = stats_BBSenpaitheater.view_taglist("BB先輩劇場")
comment_list = stats_BBSenpaitheater.comment_taglist("BB先輩劇場")
mylist_list = stats_BBSenpaitheater.mylist_taglist("BB先輩劇場")
total_list = stats_BBSenpaitheater.total_taglist("BB先輩劇場")

db.db_insert(videoid_list, contributorid_list, title_list, view_list,
             comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)

Пример #10

Файл: Carvideo_ranking.py Проект: Dhikigame/Niconico-Contributor-TagRanking

# coding:utf-8
import sqlite3
import analysis.db as db
import analysis.stats as stats
import analysis.db_create as db_create
import os

# DB作成
db_path = "./analysis/db_ranking/Carvideo.db"
table_name = "Carvideo"
if os.path.exists(db_path) == True:
    os.remove(db_path)
db_create.db_create(db_path, table_name)

# タグ別のリストと動画総数のインスタンス生成 #
print("【キーワードに合致する動画を全てDBに保存】")
stats_carvideo = stats.Statistics_order_split()

videoid_list = stats_carvideo.video_id_taglist("車載動画")
contributorid_list = stats_carvideo.contributor_id_taglist("車載動画")
title_list = stats_carvideo.title_taglist("車載動画")
view_list = stats_carvideo.view_taglist("車載動画")
comment_list = stats_carvideo.comment_taglist("車載動画")
mylist_list = stats_carvideo.mylist_taglist("車載動画")
total_list = stats_carvideo.total_taglist("車載動画")

db.db_insert(videoid_list, contributorid_list, title_list, view_list,
             comment_list, mylist_list, total_list, db_path, table_name)

print("【累計総合ポイント高い100人の投稿者の情報を全てDBに保存】")
db.db_best_100(db_path, table_name)