tools.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "ujson module not found, using json\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "个人资料库加载成功!\n",
      "找到以下查询资料: ['5e_00_spell_by_pear.json', '5e_01_armor_weapon_phb_by_xe.json', '5e_01_feat_by_pear.json', '5e_01_phb_classes_by_pear_hze_xe.json', '5e_01_phb_races_by_pear.json', '5e_02_phb_rule_by_pear.json', '5e_03_tools_phb_by_zxa.json', '5e_05_spell_list_by_pear.json', '5e_06_magic_items_dmg_by_hze.json', '5e_07_dmg_rule_by_pear.json', '5e_08_mm_by_hze_pear_query.json', '5e_08_phb_background_by_pear.json', '5e_09_creature_phb_dmg_by_hze.json', '5e_10_exp_classes_by_hh_pear.json', '5e_10_exp_demon_lord_by_farevell.json', '5e_10_exp_magic_items_by_hh.json', '5e_10_exp_races_by_pear.json', '5e_10_xge_dm_tools_by_pear.json', '5e_19_egtw_by_pear_3_29.json', '5e_30_3r_gods.json', '5e_30_module_items_by_hh.json', 'syn_spell.json']\n",
      "成功加载同义词表syn_spell.json, 共44个条目\n",
      "查询资料库加载成功! 共4180个条目\n",
      "找到以下牌堆: ['00_狂野魔法浪涌表_deck.json', '01_万象无常牌_deck.json', '05_短暂性疯狂_deck.json', '05_长期性疯狂_deck.json', '06_休克_deck.json', '06_伤残_deck.json', '20_天气_deck.json', '20_天气_温度_deck.json', '20_天气_降水_deck.json', '20_天气_风_deck.json', '21_魔法物品表a_deck.json', '21_魔法物品表b_deck.json', '21_魔法物品表c_deck.json', '21_魔法物品表d_deck.json', '21_魔法物品表e_deck.json', '21_魔法物品表f_deck.json', '21_魔法物品表g_deck.json', '21_魔法物品表h_deck.json', '21_魔法物品表i_deck.json', '22_个体宝藏cr0-4_deck.json', '22_个体宝藏cr11-16_deck.json', '22_个体宝藏cr17+_deck.json', '22_个体宝藏cr5-10_deck.json', '22_库藏宝藏cr0-4_deck.json', '22_库藏宝藏cr11-16_deck.json', '22_库藏宝藏cr17+_deck.json', '22_库藏宝藏cr5-10_deck.json', '29_宝石1000gp_deck.json', '29_宝石100gp_deck.json', '29_宝石10gp_deck.json', '29_宝石5000gp_deck.json', '29_宝石500gp_deck.json', '29_宝石50gp_deck.json', '29_艺术品2500gp_deck.json', '29_艺术品250gp_deck.json', '29_艺术品25gp_deck.json', '29_艺术品7500gp_deck.json', '29_艺术品750gp_deck.json']\n",
      "牌库加载成功! 共38个牌堆\n",
      "找到以下菜谱: ['desert_menu.json', 'drink_menu.json', 'mix_menu.json']\n",
      "菜谱资料库加载成功! 共161个菜谱\n",
      "共414个有效图片\n",
      "笑话资料库加载成功! 共139个文字条目, 414个图片条目\n",
      "表情包加载成功! 共15个条目, 分别是dict_keys(['q版万能', '双重点赞', '哭', '完全搞懂了', '抛全1骰子', '抛骰子', '比心', '没有思考', '点赞', '疑惑翻书', '看书', '看卷轴', '看聊天记录', '祈祷', '蔑视'])\n",
      "姓名资料库加载成功! 共18个种类, 8个词库\n",
      "题库加载成功! 共2个条目, 分别是[('科目一 基础知识检定', 23), ('科目二 进阶知识检定', 53)]\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import os\n",
    "\n",
    "import plugins.custom_config as custom_config\n",
    "import plugins.bot_core as bot_core\n",
    "import plugins.tool_dice as tool_dice\n",
    "import plugins.info_help as info_help\n",
    "import plugins.info_game as info_game\n",
    "import plugins.utils as utils\n",
    "\n",
    "from plugins import bot\n",
    "\n",
    "b = bot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "520 239835\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[('973264010', '未知群名称', 3574, 0, 0, 84, 0, 0, '', 5, 595.6666666666666),\n",
       " ('785702914', '未知群名称', 5451, 0, 3, 22, 0, 0, '', 9, 545.1),\n",
       " ('681172889', '未知群名称', 1370, 0, 0, 23, 0, 0, '', 6, 195.71428571428572),\n",
       " ('387177803', '未知群名称', 4112, 1, 2, 4, 0, 0, '', 9, 411.2),\n",
       " ('881011227', '未知群名称', 4372, 1, 5, 0, 0, 0, '', 10, 397.45454545454544),\n",
       " ('623415279', '未知群名称', 1818, 1, 2, 215, 0, 0, '', 7, 227.25),\n",
       " ('1150498804', '未知群名称', 3000, 1, 7, 207, 0, 0, '', 4, 600.0),\n",
       " ('922577245', '未知群名称', 7503, 4, 15, 3, 0, 0, '', 37, 197.44736842105263),\n",
       " ('964121483', '未知群名称', 552, 0, 0, 27, 0, 0, '', 4, 110.4),\n",
       " ('834764198', '未知群名称', 36391, 38, 78, 259, 0, 0, '', 41, 866.452380952381),\n",
       " ('951064304', '未知群名称', 1695, 1, 2, 0, 0, 0, '', 4, 339.0),\n",
       " ('540533096', '未知群名称', 438, 0, 0, 11, 0, 0, '', 5, 73.0),\n",
       " ('475655228', '未知群名称', 2294, 2, 5, 14, 0, 0, '', 6, 327.7142857142857),\n",
       " ('1124522467', '未知群名称', 3887, 5, 8, 95, 0, 0, '', 8, 431.8888888888889),\n",
       " ('154920765', '未知群名称', 1832, 2, 2, 15, 0, 0, '', 9, 183.2),\n",
       " ('1047376866', '未知群名称', 243, 0, 0, 13, 0, 0, '', 5, 40.5),\n",
       " ('1035621713', '未知群名称', 6538, 11, 22, 9, 0, 0, '', 20, 311.3333333333333),\n",
       " ('1083806335', '未知群名称', 554, 0, 5, 0, 0, 0, '', 14, 36.93333333333333),\n",
       " ('1004920223',\n",
       "  '🏆3605🏆',\n",
       "  68356,\n",
       "  65,\n",
       "  916,\n",
       "  80,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  134,\n",
       "  506.3407407407407),\n",
       " ('904281359', '未知群名称', 269, 0, 0, 0, 0, 0, '', 6, 38.42857142857143),\n",
       " ('1028867775',\n",
       "  '奇怪的跑团增加了！',\n",
       "  43560,\n",
       "  58,\n",
       "  452,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  162,\n",
       "  267.23926380368096),\n",
       " ('808059251', '未知群名称', 2701, 7, 7, 64, 0, 0, '', 7, 337.625),\n",
       " ('965123373', '未知群名称', 2232, 4, 16, 6, 0, 0, '', 29, 74.4),\n",
       " ('937640817', '未知群名称', 13340, 106, 165, 381, 0, 0, '', 79, 166.75),\n",
       " ('292577401', '未知群名称', 29978, 59, 246, 10, 0, 2, '', 99, 299.78),\n",
       " ('1109975960', '未知群名称', 193, 0, 0, 4, 0, 0, '', 4, 38.6),\n",
       " ('1140498952', '未知群名称', 10305, 15, 125, 0, 0, 0, '', 83, 122.67857142857143),\n",
       " ('629303819', '未知群名称', 3956, 10, 18, 0, 0, 0, '', 36, 106.91891891891892),\n",
       " ('370821771', '未知群名称', 188, 0, 0, 0, 0, 0, '', 3, 47.0),\n",
       " ('780475437', '未知群名称', 561, 1, 3, 6, 0, 0, '', 4, 112.2),\n",
       " ('779332956', '未知群名称', 183, 0, 0, 0, 0, 0, '', 2, 61.0),\n",
       " ('1137853057', '未知群名称', 1590, 3, 15, 0, 0, 0, '', 55, 28.392857142857142),\n",
       " ('667938127', '未知群名称', 1741, 4, 12, 0, 0, 0, '', 9, 174.1),\n",
       " ('1097571753',\n",
       "  '未知群名称',\n",
       "  19030,\n",
       "  112,\n",
       "  455,\n",
       "  395,\n",
       "  1,\n",
       "  4,\n",
       "  '',\n",
       "  74,\n",
       "  253.73333333333332),\n",
       " ('958814953', '未知群名称', 11283, 35, 40, 0, 0, 0, '', 47, 235.0625),\n",
       " ('908215358', '未知群名称', 34831, 183, 212, 476, 4, 7, '', 52, 657.188679245283),\n",
       " ('593346928', '未知群名称', 5446, 17, 18, 1, 0, 0, '', 47, 113.45833333333333),\n",
       " ('1018575948', '未知群名称', 5578, 16, 41, 7, 0, 0, '', 35, 154.94444444444446),\n",
       " ('908968770', '未知群名称', 1636, 5, 6, 0, 0, 0, '', 27, 58.42857142857143),\n",
       " ('558965230', '未知群名称', 128, 0, 0, 8, 0, 0, '', 3, 32.0),\n",
       " ('1043385439', '未知群名称', 54746, 167, 377, 0, 0, 0, '', 53, 1013.8148148148148),\n",
       " ('959644552', '未知群名称', 2401, 8, 8, 0, 0, 0, '', 23, 100.04166666666667),\n",
       " ('1145340763', '未知群名称', 10006, 32, 75, 0, 0, 0, '', 30, 322.7741935483871),\n",
       " ('668191135', '未知群名称', 1357, 5, 6, 27, 0, 0, '', 2, 452.3333333333333),\n",
       " ('680769062', '未知群名称', 138, 0, 0, 0, 0, 0, '', 4, 27.6),\n",
       " ('723098364',\n",
       "  '未知群名称',\n",
       "  59869,\n",
       "  367,\n",
       "  958,\n",
       "  556,\n",
       "  0,\n",
       "  2,\n",
       "  '1324063019',\n",
       "  85,\n",
       "  696.1511627906976),\n",
       " ('1138707411', '未知群名称', 189, 0, 2, 0, 0, 0, '', 7, 23.625),\n",
       " ('827282362', '未知群名称', 9935, 29, 161, 25, 0, 0, '', 31, 310.46875),\n",
       " ('979199012', '未知群名称', 17713, 34, 399, 0, 0, 0, '', 75, 233.06578947368422),\n",
       " ('955691994', '未知群名称', 550, 2, 2, 0, 0, 0, '', 14, 36.666666666666664),\n",
       " ('489835320', '未知群名称', 10644, 28, 219, 9, 1, 5, '', 35, 295.6666666666667),\n",
       " ('491230403', '未知群名称', 1321, 4, 21, 1, 0, 0, '', 17, 73.38888888888889),\n",
       " ('1016878991', '未知群名称', 33777, 150, 293, 0, 0, 0, '', 62, 536.1428571428571),\n",
       " ('581492783', '未知群名称', 189, 0, 4, 1, 0, 0, '', 11, 15.75),\n",
       " ('916021220', '未知群名称', 324, 1, 2, 1, 0, 0, '', 2, 108.0),\n",
       " ('246222892', '未知群名称', 19040, 45, 531, 14, 0, 0, '', 34, 544.0),\n",
       " ('902217608', '未知群名称', 43, 0, 0, 12, 0, 0, '', 4, 8.6),\n",
       " ('795855254', '未知群名称', 1881, 19, 25, 50, 0, 0, '', 36, 50.83783783783784),\n",
       " ('980989740',\n",
       "  '未知群名称',\n",
       "  36482,\n",
       "  348,\n",
       "  875,\n",
       "  388,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  96,\n",
       "  376.10309278350513),\n",
       " ('611303926', '未知群名称', 97, 0, 0, 0, 0, 0, '', 6, 13.857142857142858),\n",
       " ('1147552229', '未知群名称', 6521, 26, 177, 14, 0, 0, '', 63, 101.890625),\n",
       " ('719276868', '未知群名称', 1111, 5, 14, 0, 0, 0, '', 46, 23.638297872340427),\n",
       " ('966731575', '未知群名称', 10953, 23, 423, 6, 0, 0, '', 22, 476.2173913043478),\n",
       " ('151877541', '未知群名称', 5527, 5, 280, 4, 0, 2, '', 99, 55.27),\n",
       " ('260113624', '未知群名称', 88460, 594, 619, 63, 0, 0, '', 67, 1300.8823529411766),\n",
       " ('1030920396', '未知群名称', 676, 4, 4, 0, 0, 0, '', 9, 67.6),\n",
       " ('855562131', '未知群名称', 3335, 9, 127, 4, 0, 2, '', 21, 151.5909090909091),\n",
       " ('726558950', '未知群名称', 1431, 10, 13, 16, 0, 0, '', 4, 286.2),\n",
       " ('316766096', '未知群名称', 13427, 89, 154, 0, 0, 0, '', 77, 172.14102564102564),\n",
       " ('589228625', '未知群名称', 77, 0, 0, 0, 0, 0, '', 6, 11.0),\n",
       " ('231645232', '未知群名称', 77, 0, 0, 0, 0, 0, '', 2, 25.666666666666668),\n",
       " ('542487873',\n",
       "  '未知群名称',\n",
       "  41856,\n",
       "  296,\n",
       "  368,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '1489850546',\n",
       "  85,\n",
       "  486.69767441860466),\n",
       " ('789398746', '未知群名称', 1785, 12, 16, 0, 0, 0, '', 16, 105.0),\n",
       " ('607041238', '未知群名称', 32087, 168, 792, 6, 0, 0, '', 83, 381.98809523809524),\n",
       " ('714395699', '未知群名称', 48, 0, 0, 7, 0, 0, '', 3, 12.0),\n",
       " ('732747988', '未知群名称', 34929, 234, 481, 10, 5, 5, '', 64, 537.3692307692307),\n",
       " ('727867855',\n",
       "  '幕间 钟鸣十三的幕起',\n",
       "  55717,\n",
       "  398,\n",
       "  816,\n",
       "  19,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  106,\n",
       "  520.7196261682243),\n",
       " ('922576049',\n",
       "  '未知群名称',\n",
       "  20840,\n",
       "  160,\n",
       "  240,\n",
       "  13,\n",
       "  0,\n",
       "  0,\n",
       "  '2778216003',\n",
       "  85,\n",
       "  242.32558139534885),\n",
       " ('1093797390', '未知群名称', 7378, 40, 191, 0, 0, 0, '', 16, 434.0),\n",
       " ('1139748002', '未知群名称', 1125, 7, 8, 1, 1, 1, '', 6, 160.71428571428572),\n",
       " ('516106171', '未知群名称', 552, 3, 6, 10, 1, 4, '', 17, 30.666666666666668),\n",
       " ('719876356', '未知群名称', 4677, 36, 51, 0, 0, 0, '', 16, 275.11764705882354),\n",
       " ('878551544', '未知群名称', 1193, 18, 31, 87, 0, 0, '', 13, 85.21428571428571),\n",
       " ('1146636351', '未知群名称', 556, 3, 13, 0, 0, 0, '', 5, 92.66666666666667),\n",
       " ('861930793', '未知群名称', 2075, 16, 25, 0, 0, 0, '', 22, 90.21739130434783),\n",
       " ('948560726', '未知群名称', 2848, 31, 31, 204, 1, 1, '', 4, 569.6),\n",
       " ('624411843',\n",
       "  '未知群名称',\n",
       "  91720,\n",
       "  703,\n",
       "  1509,\n",
       "  42,\n",
       "  7,\n",
       "  13,\n",
       "  '',\n",
       "  59,\n",
       "  1528.6666666666667),\n",
       " ('1075929459', '未知群名称', 64, 0, 0, 0, 0, 0, '', 2, 21.333333333333332),\n",
       " ('1039423727',\n",
       "  'The Classic Half\\xa0past\\xa0Nine',\n",
       "  161461,\n",
       "  1390,\n",
       "  1498,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  933.3005780346821),\n",
       " ('579736649', '未知群名称', 1542, 9, 36, 24, 2, 9, '', 15, 96.375),\n",
       " ('655241771', '未知群名称', 2080, 27, 28, 673, 2, 2, '', 1, 1040.0),\n",
       " ('726082823', '咸鱼跑团', 102741, 853, 1373, 1, 0, 0, '', 172, 593.878612716763),\n",
       " ('799851345', '未知群名称', 27357, 247, 261, 1, 0, 0, '', 83, 325.67857142857144),\n",
       " ('984212796', '未知群名称', 1381, 12, 12, 0, 0, 0, '', 14, 92.06666666666666),\n",
       " ('723849761', '未知群名称', 60, 0, 0, 0, 0, 0, '', 1, 30.0),\n",
       " ('1164348237', '未知群名称', 668, 4, 19, 0, 0, 0, '', 3, 167.0),\n",
       " ('682025639', '未知群名称', 83, 0, 2, 0, 0, 0, '', 2, 27.666666666666668),\n",
       " ('907284249', '未知群名称', 3223, 25, 68, 0, 0, 0, '', 41, 76.73809523809524),\n",
       " ('1165621180', '未知群名称', 169, 1, 2, 0, 0, 0, '514841214', 1, 84.5),\n",
       " ('527825234', '未知群名称', 63350, 612, 732, 0, 0, 0, '', 58, 1073.7288135593221),\n",
       " ('213867070', '未知群名称', 1116, 4, 68, 3, 0, 2, '', 29, 37.2),\n",
       " ('937752842', '未知群名称', 13260, 120, 255, 4, 0, 0, '', 54, 241.0909090909091),\n",
       " ('785905350',\n",
       "  '空白高考750分！！特别',\n",
       "  76740,\n",
       "  708,\n",
       "  1317,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  158,\n",
       "  482.64150943396226),\n",
       " ('1157082308', '未知群名称', 53, 0, 0, 0, 0, 0, '', 3, 13.25),\n",
       " ('442063266', '未知群名称', 23755, 275, 285, 71, 1, 1, '', 35, 659.8611111111111),\n",
       " ('1097228361', '未知群名称', 52, 0, 0, 0, 0, 0, '', 4, 10.4),\n",
       " ('932428987', '未知群名称', 3042, 40, 53, 117, 1, 1, '', 7, 380.25),\n",
       " ('826559388',\n",
       "  '伪杯战争v3.0 冰海之围',\n",
       "  36099,\n",
       "  910,\n",
       "  984,\n",
       "  396,\n",
       "  6,\n",
       "  12,\n",
       "  '',\n",
       "  114,\n",
       "  313.90434782608696),\n",
       " ('1105751424', '未知群名称', 923, 10, 10, 0, 0, 0, '', 14, 61.53333333333333),\n",
       " ('1149649755', '未知群名称', 7311, 81, 101, 0, 0, 0, '', 49, 146.22),\n",
       " ('549256248', '未知群名称', 40310, 468, 1037, 74, 0, 0, '', 73, 544.7297297297297),\n",
       " ('628548720', '未知群名称', 705, 6, 21, 0, 0, 0, '', 16, 41.470588235294116),\n",
       " ('761745309', '未知群名称', 8812, 70, 366, 0, 0, 0, '', 61, 142.1290322580645),\n",
       " ('1047353341', '未知群名称', 21454, 249, 279, 0, 0, 0, '', 46, 456.468085106383),\n",
       " ('966630645', '未知群名称', 8355, 100, 129, 3, 0, 0, '', 68, 121.08695652173913),\n",
       " ('647408085',\n",
       "  '未知群名称',\n",
       "  1416,\n",
       "  13,\n",
       "  50,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '1489850546',\n",
       "  85,\n",
       "  16.46511627906977),\n",
       " ('955038402', '未知群名称', 18589, 253, 282, 23, 0, 0, '', 48, 379.3673469387755),\n",
       " ('902124675',\n",
       "  '未知群名称',\n",
       "  52583,\n",
       "  849,\n",
       "  1555,\n",
       "  214,\n",
       "  0,\n",
       "  0,\n",
       "  '3203045067',\n",
       "  85,\n",
       "  611.4302325581396),\n",
       " ('671641192',\n",
       "  '未知群名称',\n",
       "  182487,\n",
       "  2509,\n",
       "  4404,\n",
       "  247,\n",
       "  1,\n",
       "  7,\n",
       "  '1309537158',\n",
       "  83,\n",
       "  2172.464285714286),\n",
       " ('1164768919', '未知群名称', 3301, 58, 64, 363, 0, 0, '', 2, 1100.3333333333333),\n",
       " ('1140938875', '未知群名称', 90, 1, 1, 5, 0, 0, '', 4, 18.0),\n",
       " ('1149410310', '未知群名称', 360, 4, 7, 0, 0, 0, '', 8, 40.0),\n",
       " ('881819877',\n",
       "  '未知群名称',\n",
       "  13294,\n",
       "  173,\n",
       "  449,\n",
       "  18,\n",
       "  0,\n",
       "  0,\n",
       "  '1024446301',\n",
       "  85,\n",
       "  154.58139534883722),\n",
       " ('593797742', '未知群名称', 4026, 42, 164, 1, 0, 1, '', 51, 77.42307692307692),\n",
       " ('1042789654', '未知群名称', 5636, 81, 107, 11, 1, 3, '', 17, 313.1111111111111),\n",
       " ('971364555', '未知群名称', 659, 9, 13, 0, 0, 0, '', 1, 329.5),\n",
       " ('1103392351',\n",
       "  '未知群名称',\n",
       "  54317,\n",
       "  795,\n",
       "  1331,\n",
       "  21,\n",
       "  0,\n",
       "  0,\n",
       "  '1840863667',\n",
       "  92,\n",
       "  584.0537634408602),\n",
       " ('310935554', '未知群名称', 766, 3, 77, 0, 0, 0, '', 12, 58.92307692307692),\n",
       " ('712160734', '未知群名称', 821, 85, 117, 79, 9, 23, '', 74, 10.946666666666667),\n",
       " ('613439613', '未知群名称', 11741, 187, 210, 3, 0, 0, '', 83, 139.77380952380952),\n",
       " ('1137971839', '未知群名称', 3136, 49, 51, 0, 0, 0, '', 48, 64.0),\n",
       " ('1148919551', '未知群名称', 9880, 155, 335, 76, 2, 9, '', 18, 520.0),\n",
       " ('571227947', '未知群名称', 327, 4, 12, 6, 0, 0, '3326696298', 1, 163.5),\n",
       " ('639012167', '未知群名称', 14140, 227, 247, 4, 0, 0, '', 26, 523.7037037037037),\n",
       " ('967829872', '未知群名称', 404, 6, 6, 0, 0, 0, '', 4, 80.8),\n",
       " ('1049114938', '未知群名称', 810, 13, 19, 3, 0, 0, '', 18, 42.63157894736842),\n",
       " ('621160572', '未知群名称', 46, 0, 2, 0, 0, 0, '', 11, 3.8333333333333335),\n",
       " ('868599948',\n",
       "  '未知群名称',\n",
       "  75636,\n",
       "  2681,\n",
       "  3228,\n",
       "  1268,\n",
       "  50,\n",
       "  50,\n",
       "  '',\n",
       "  69,\n",
       "  1080.5142857142857),\n",
       " ('1031360904', '未知群名称', 108, 1, 5, 8, 0, 3, '', 5, 18.0),\n",
       " ('1067811957', '未知群名称', 45, 0, 2, 0, 0, 0, '', 6, 6.428571428571429),\n",
       " ('1074477186',\n",
       "  '决战龙巫教',\n",
       "  39609,\n",
       "  680,\n",
       "  788,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  171,\n",
       "  230.28488372093022),\n",
       " ('780170816',\n",
       "  '未知群名称',\n",
       "  65410,\n",
       "  1188,\n",
       "  1525,\n",
       "  57,\n",
       "  1,\n",
       "  4,\n",
       "  '',\n",
       "  80,\n",
       "  807.5308641975308),\n",
       " ('867865209', '未知群名称', 22644, 390, 480, 3, 0, 0, '', 33, 666.0),\n",
       " ('1056049149',\n",
       "  '未知群名称',\n",
       "  4910,\n",
       "  212,\n",
       "  226,\n",
       "  480,\n",
       "  13,\n",
       "  13,\n",
       "  '',\n",
       "  16,\n",
       "  288.8235294117647),\n",
       " ('706729478',\n",
       "  '未知群名称',\n",
       "  183965,\n",
       "  3221,\n",
       "  7995,\n",
       "  284,\n",
       "  1,\n",
       "  43,\n",
       "  '1992335297',\n",
       "  85,\n",
       "  2139.1279069767443),\n",
       " ('737884037', '未知群名称', 1625, 92, 96, 51, 0, 0, '', 68, 23.55072463768116),\n",
       " ('837387082', '未知群名称', 5717, 100, 126, 0, 0, 0, '', 18, 300.89473684210526),\n",
       " ('555191164', '未知群名称', 1601, 28, 32, 0, 0, 0, '', 37, 42.13157894736842),\n",
       " ('592880891', '未知群名称', 8832, 142, 315, 1, 0, 0, '', 95, 92.0),\n",
       " ('632967445', '未知群名称', 21610, 411, 445, 32, 0, 0, '', 34, 617.4285714285714),\n",
       " ('925180477', '未知群名称', 1126, 20, 32, 4, 0, 0, '', 15, 70.375),\n",
       " ('514676922', '未知群名称', 4352, 75, 118, 0, 0, 0, '', 6, 621.7142857142857),\n",
       " ('1029706704', '未知群名称', 389, 6, 25, 8, 0, 3, '', 13, 27.785714285714285),\n",
       " ('1134253026', '未知群名称', 7181, 135, 142, 6, 0, 0, '', 4, 1436.2),\n",
       " ('806972171', '未知群名称', 3980, 75, 90, 1, 0, 0, '', 69, 56.857142857142854),\n",
       " ('1028863833', '未知群名称', 4302, 89, 90, 5, 0, 0, '', 53, 79.66666666666667),\n",
       " ('311758620', '未知群名称', 3293, 62, 86, 0, 0, 0, '', 12, 253.30769230769232),\n",
       " ('682702083', '未知群名称', 4886, 60, 420, 3, 0, 3, '', 53, 90.48148148148148),\n",
       " ('575625928', '未知群名称', 10393, 204, 246, 0, 0, 0, '', 73, 140.44594594594594),\n",
       " ('791158259', '未知群名称', 69, 1, 1, 4, 0, 0, '', 1, 34.5),\n",
       " ('873885624', '未知群名称', 10638, 205, 294, 0, 0, 0, '', 39, 265.95),\n",
       " ('746700843', '未知群名称', 21361, 433, 491, 5, 0, 0, '', 46, 454.48936170212767),\n",
       " ('695471286', '未知群名称', 17532, 352, 399, 0, 0, 0, '', 51, 337.15384615384613),\n",
       " ('933394549', '未知群名称', 27, 0, 0, 0, 0, 0, '', 4, 5.4),\n",
       " ('742016391', '未知群名称', 221, 4, 4, 0, 0, 0, '', 18, 11.631578947368421),\n",
       " ('1140494791', '未知群名称', 12616, 259, 303, 24, 0, 0, '', 2, 4205.333333333333),\n",
       " ('750785050', '未知群名称', 550, 11, 11, 0, 0, 0, '', 8, 61.111111111111114),\n",
       " ('116780953', '未知群名称', 376, 3, 43, 0, 0, 0, '', 4, 75.2),\n",
       " ('887566038', '未知群名称', 26, 0, 0, 0, 0, 0, '', 6, 3.7142857142857144),\n",
       " ('849370730',\n",
       "  '未知群名称',\n",
       "  76167,\n",
       "  1659,\n",
       "  1896,\n",
       "  24,\n",
       "  0,\n",
       "  0,\n",
       "  '3367517428',\n",
       "  84,\n",
       "  896.0823529411765),\n",
       " ('931848924', '未知群名称', 190, 2, 16, 0, 0, 0, '', 11, 15.833333333333334),\n",
       " ('975894974', '未知群名称', 12853, 277, 299, 0, 0, 0, '', 47, 267.7708333333333),\n",
       " ('1084349067', '未知群名称', 43493, 938, 1039, 0, 0, 0, '', 57, 749.8793103448276),\n",
       " ('858617844', '未知群名称', 122, 2, 3, 0, 0, 0, '', 3, 30.5),\n",
       " ('1058784767', '绿萝岛', 22500, 492, 532, 0, 0, 0, '', 140, 159.5744680851064),\n",
       " ('753823529', '未知群名称', 629, 10, 41, 0, 0, 0, '', 36, 17.0),\n",
       " ('783622623', '未知群名称', 1607, 25, 193, 26, 0, 0, '', 13, 114.78571428571429),\n",
       " ('1136537388', '未知群名称', 16445, 379, 436, 15, 1, 1, '', 31, 513.90625),\n",
       " ('1082512111', '未知群名称', 24, 0, 0, 0, 0, 0, '', 5, 4.0),\n",
       " ('297275260',\n",
       "  '未知群名称',\n",
       "  29495,\n",
       "  910,\n",
       "  1037,\n",
       "  171,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  58,\n",
       "  499.91525423728814),\n",
       " ('1071690138', '未知群名称', 21191, 508, 525, 7, 0, 0, '', 57, 365.36206896551727),\n",
       " ('1005948208', '未知群名称', 2543, 49, 144, 0, 0, 0, '', 83, 30.273809523809526),\n",
       " ('875286570', '未知群名称', 20431, 494, 601, 10, 0, 0, '', 85, 237.56976744186048),\n",
       " ('553769528', '未知群名称', 65, 1, 1, 0, 0, 0, '', 8, 7.222222222222222),\n",
       " ('932109892', '未知群名称', 4029, 92, 127, 0, 0, 0, '', 20, 191.85714285714286),\n",
       " ('715655056', '未知群名称', 7997, 190, 202, 0, 0, 0, '', 21, 363.5),\n",
       " ('669392293', '未知群名称', 4610, 100, 206, 0, 0, 0, '', 45, 100.21739130434783),\n",
       " ('964305219', '未知群名称', 55632, 1346, 1531, 3, 0, 0, '', 92, 598.1935483870968),\n",
       " ('714491485', '未知群名称', 227, 5, 5, 0, 0, 0, '', 23, 9.458333333333334),\n",
       " ('696530453',\n",
       "  '未知群名称',\n",
       "  9947,\n",
       "  266,\n",
       "  429,\n",
       "  20,\n",
       "  1,\n",
       "  2,\n",
       "  '1489850546',\n",
       "  85,\n",
       "  115.66279069767442),\n",
       " ('1049777979', '未知群名称', 266, 6, 6, 0, 0, 0, '', 5, 44.333333333333336),\n",
       " ('1087806866', '未知群名称', 834, 26, 89, 207, 2, 2, '', 2, 278.0),\n",
       " ('718860985', '未知群名称', 462, 11, 11, 0, 0, 0, '', 3, 115.5),\n",
       " ('600875413',\n",
       "  '未知群名称',\n",
       "  63248,\n",
       "  2317,\n",
       "  2405,\n",
       "  618,\n",
       "  5,\n",
       "  5,\n",
       "  '',\n",
       "  47,\n",
       "  1317.6666666666667),\n",
       " ('778641809', '未知群名称', 5366, 128, 190, 0, 0, 0, '', 85, 62.395348837209305),\n",
       " ('1156244480', '未知群名称', 767, 17, 34, 0, 0, 0, '', 21, 34.86363636363637),\n",
       " ('858170926',\n",
       "  '未知群名称',\n",
       "  14293,\n",
       "  639,\n",
       "  753,\n",
       "  208,\n",
       "  7,\n",
       "  7,\n",
       "  '',\n",
       "  53,\n",
       "  264.68518518518516),\n",
       " ('579906770', '未知群名称', 10925, 221, 791, 0, 0, 0, '', 63, 170.703125),\n",
       " ('1159019069', '未知群名称', 207, 4, 5, 6, 1, 1, '', 2, 69.0),\n",
       " ('834558499', '未知群名称', 3031, 52, 314, 0, 0, 0, '', 48, 61.857142857142854),\n",
       " ('950476395',\n",
       "  '蓝蝰蛇佣兵团DND5E',\n",
       "  31539,\n",
       "  781,\n",
       "  1410,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  182.3063583815029),\n",
       " ('1104014925',\n",
       "  '未知群名称',\n",
       "  4718,\n",
       "  175,\n",
       "  226,\n",
       "  126,\n",
       "  1,\n",
       "  1,\n",
       "  '',\n",
       "  14,\n",
       "  314.53333333333336),\n",
       " ('1078585318',\n",
       "  '蠢乌鸦的小金库',\n",
       "  216090,\n",
       "  6038,\n",
       "  6461,\n",
       "  19,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  1249.0751445086705),\n",
       " ('858669815', '未知群名称', 20, 0, 0, 0, 0, 0, '', 6, 2.857142857142857),\n",
       " ('1127298957', '未知群名称', 681, 17, 30, 0, 0, 0, '', 10, 61.90909090909091),\n",
       " ('966375015', '未知群名称', 91, 2, 2, 0, 0, 0, '', 14, 6.066666666666666),\n",
       " ('389349513', '未知群名称', 25534, 688, 956, 0, 0, 0, '', 99, 255.34),\n",
       " ('1140768881',\n",
       "  '潮音洞穴探险队',\n",
       "  8731,\n",
       "  237,\n",
       "  322,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  104,\n",
       "  83.15238095238095),\n",
       " ('1083907434',\n",
       "  '渡鸽之影',\n",
       "  162283,\n",
       "  4553,\n",
       "  4949,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  171,\n",
       "  943.5058139534884),\n",
       " ('630861195', '未知群名称', 17945, 495, 613, 0, 0, 0, '', 32, 543.7878787878788),\n",
       " ('1105300028', '未知群名称', 7700, 217, 239, 0, 0, 0, '', 61, 124.19354838709677),\n",
       " ('836397763',\n",
       "  '鸽子冒险团',\n",
       "  179475,\n",
       "  5056,\n",
       "  5848,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  1037.4277456647399),\n",
       " ('1065048711',\n",
       "  '未知群名称',\n",
       "  14186,\n",
       "  816,\n",
       "  1141,\n",
       "  754,\n",
       "  96,\n",
       "  97,\n",
       "  '',\n",
       "  25,\n",
       "  545.6153846153846),\n",
       " ('1056112609',\n",
       "  '这玩意竟然还可以修改',\n",
       "  7041,\n",
       "  111,\n",
       "  1523,\n",
       "  12,\n",
       "  0,\n",
       "  9,\n",
       "  '',\n",
       "  171,\n",
       "  40.93604651162791),\n",
       " ('1006327751',\n",
       "  '夏乏◆没活动の游戏部',\n",
       "  126354,\n",
       "  3714,\n",
       "  4599,\n",
       "  11,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  730.3699421965318),\n",
       " ('1058528193', '未知群名称', 25618, 1394, 1572, 438, 0, 0, '', 49, 512.36),\n",
       " ('1135885563', '未知群名称', 7661, 280, 403, 34, 0, 0, '', 62, 121.60317460317461),\n",
       " ('1087554004', '未知群名称', 3509, 86, 278, 0, 0, 0, '', 77, 44.98717948717949),\n",
       " ('1103553184', '未知群名称', 14618, 452, 523, 10, 1, 1, '', 27, 522.0714285714286),\n",
       " ('1150656724', '未知群名称', 116, 3, 4, 0, 0, 0, '', 14, 7.733333333333333),\n",
       " ('1085575368', '未知群名称', 6349, 189, 299, 0, 0, 0, '', 31, 198.40625),\n",
       " ('1047268521',\n",
       "  '今日菜单（？',\n",
       "  16086,\n",
       "  436,\n",
       "  1125,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  157,\n",
       "  101.81012658227849),\n",
       " ('787533595', '未知群名称', 16601, 528, 550, 0, 0, 0, '', 65, 251.53030303030303),\n",
       " ('869372966', '未知群名称', 559, 17, 21, 0, 0, 0, '', 25, 21.5),\n",
       " ('704327436',\n",
       "  '大興土木',\n",
       "  66888,\n",
       "  2157,\n",
       "  2506,\n",
       "  5,\n",
       "  0,\n",
       "  0,\n",
       "  '865767086',\n",
       "  102,\n",
       "  649.3980582524272),\n",
       " ('1015847995', '未知群名称', 5005, 120, 507, 0, 0, 0, '', 74, 66.73333333333333),\n",
       " ('1130337522', '未知群名称', 44, 0, 8, 0, 0, 0, '', 9, 4.4),\n",
       " ('725286483', '未知群名称', 6758, 167, 718, 2, 0, 0, '', 81, 82.41463414634147),\n",
       " ('1020636665', '未知群名称', 12915, 420, 486, 0, 0, 0, '', 48, 263.57142857142856),\n",
       " ('729783014', '未知群名称', 15596, 532, 546, 11, 0, 0, '', 44, 346.5777777777778),\n",
       " ('387730546', '未知群名称', 5184, 168, 205, 0, 0, 0, '', 80, 64.0),\n",
       " ('294529085', '未知群名称', 10734, 355, 426, 2, 0, 0, '', 20, 511.14285714285717),\n",
       " ('1160448774', '未知群名称', 6703, 293, 307, 195, 9, 9, '', 11, 558.5833333333334),\n",
       " ('912893588', '未知群名称', 2378, 78, 110, 3, 0, 0, '', 12, 182.92307692307693),\n",
       " ('376537653', '未知群名称', 82537, 2706, 3663, 3, 0, 0, '', 84, 971.0235294117647),\n",
       " ('330240408', '未知群名称', 1847, 63, 65, 0, 0, 0, '', 43, 41.97727272727273),\n",
       " ('1067593714',\n",
       "  '未知群名称',\n",
       "  16062,\n",
       "  576,\n",
       "  651,\n",
       "  13,\n",
       "  1,\n",
       "  5,\n",
       "  '',\n",
       "  62,\n",
       "  254.95238095238096),\n",
       " ('1141772832',\n",
       "  '龙癌的宝山',\n",
       "  45653,\n",
       "  1614,\n",
       "  1707,\n",
       "  9,\n",
       "  2,\n",
       "  2,\n",
       "  '',\n",
       "  102,\n",
       "  443.2330097087379),\n",
       " ('676224795',\n",
       "  '未知群名称',\n",
       "  12976,\n",
       "  240,\n",
       "  2192,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '2856019414',\n",
       "  83,\n",
       "  154.47619047619048),\n",
       " ('258408277',\n",
       "  '未知群名称',\n",
       "  136775,\n",
       "  4882,\n",
       "  6198,\n",
       "  53,\n",
       "  0,\n",
       "  5,\n",
       "  '',\n",
       "  89,\n",
       "  1519.7222222222222),\n",
       " ('739705886', '未知群名称', 1995, 71, 75, 3, 0, 0, '', 6, 285.0),\n",
       " ('1070938722', '未知群名称', 1703, 58, 81, 0, 0, 0, '', 6, 243.28571428571428),\n",
       " ('416746886', '未知群名称', 271, 9, 11, 0, 0, 0, '', 1, 135.5),\n",
       " ('1150385501', '未知群名称', 55, 1, 5, 0, 0, 0, '', 27, 1.9642857142857142),\n",
       " ('1087237345', '未知群名称', 4412, 269, 294, 236, 22, 24, '', 15, 275.75),\n",
       " ('178019374', '未知群名称', 19834, 793, 1094, 34, 0, 0, '', 74, 264.4533333333333),\n",
       " ('739368432', '未知群名称', 15262, 561, 655, 2, 0, 0, '', 72, 209.06849315068493),\n",
       " ('1033246217',\n",
       "  '未知群名称',\n",
       "  58010,\n",
       "  2125,\n",
       "  2483,\n",
       "  11,\n",
       "  5,\n",
       "  5,\n",
       "  '',\n",
       "  34,\n",
       "  1657.4285714285713),\n",
       " ('439507586', '未知群名称', 13860, 516, 529, 0, 0, 0, '', 99, 138.6),\n",
       " ('977090200', '未知群名称', 1915, 103, 111, 33, 0, 5, '', 26, 70.92592592592592),\n",
       " ('971655489', '未知群名称', 7161, 257, 376, 0, 0, 0, '', 51, 137.71153846153845),\n",
       " ('1103792100', '未知群名称', 38, 1, 1, 38, 1, 1, '', 0, 38.0),\n",
       " ('1079546598',\n",
       "  '未知群名称',\n",
       "  22483,\n",
       "  851,\n",
       "  1041,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '514841214',\n",
       "  85,\n",
       "  261.43023255813955),\n",
       " ('1134570636',\n",
       "  '沼泽地的异动',\n",
       "  55844,\n",
       "  2171,\n",
       "  2226,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  106,\n",
       "  521.9065420560747),\n",
       " ('1107082869', '未知群名称', 1444, 56, 57, 0, 0, 0, '', 14, 96.26666666666667),\n",
       " ('1078790628', '未知群名称', 164, 6, 6, 1, 0, 0, '', 1, 82.0),\n",
       " ('558425252', '未知群名称', 5631, 231, 240, 8, 0, 0, '', 31, 175.96875),\n",
       " ('1004119067', '未知群名称', 7, 0, 0, 1, 0, 0, '', 6, 1.0),\n",
       " ('699458499', '未知群名称', 66, 2, 3, 0, 0, 0, '', 6, 9.428571428571429),\n",
       " ('317200746', '未知群名称', 14530, 614, 721, 9, 1, 2, '', 99, 145.3),\n",
       " ('1158357045', '未知群名称', 9710, 399, 410, 0, 0, 0, '', 20, 462.3809523809524),\n",
       " ('1159129428', '未知群名称', 9851, 399, 494, 0, 0, 0, '', 15, 615.6875),\n",
       " ('1002390202', '未知群名称', 22109, 915, 1020, 0, 0, 0, '', 42, 514.1627906976744),\n",
       " ('931894691', '未知群名称', 935, 42, 45, 29, 0, 0, '', 2, 311.6666666666667),\n",
       " ('1150198353', '未知群名称', 34, 0, 8, 0, 0, 0, '', 15, 2.125),\n",
       " ('1101348183',\n",
       "  '逃离深渊',\n",
       "  132001,\n",
       "  5797,\n",
       "  6245,\n",
       "  11,\n",
       "  0,\n",
       "  0,\n",
       "  '1073195270',\n",
       "  159,\n",
       "  825.00625),\n",
       " ('746440113', '未知群名称', 1347, 59, 62, 0, 0, 0, '', 11, 112.25),\n",
       " ('1109387102', '未知群名称', 5536, 238, 308, 0, 0, 0, '', 36, 149.6216216216216),\n",
       " ('421314816', '未知群名称', 6872, 305, 309, 0, 0, 0, '', 48, 140.24489795918367),\n",
       " ('1156708494', '未知群名称', 6377, 284, 284, 0, 0, 0, '', 24, 255.08),\n",
       " ('1057806650', '未知群名称', 4077, 182, 185, 0, 0, 0, '', 20, 194.14285714285714),\n",
       " ('903711049',\n",
       "  '鸽子聚集地？？？',\n",
       "  26883,\n",
       "  1173,\n",
       "  1706,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  135,\n",
       "  197.6691176470588),\n",
       " ('277900093', '未知群名称', 3101, 126, 273, 0, 0, 0, '', 99, 31.01),\n",
       " ('746924725', '未知群名称', 12, 0, 0, 0, 0, 0, '', 3, 3.0),\n",
       " ('594178139', '未知群名称', 19223, 888, 957, 0, 0, 0, '', 57, 331.4310344827586),\n",
       " ('1159422527', '未知群名称', 658, 30, 33, 0, 0, 0, '', 15, 41.125),\n",
       " ('472370321', '未知群名称', 137, 6, 6, 0, 0, 0, '', 27, 4.892857142857143),\n",
       " ('243574275', '未知群名称', 7739, 376, 379, 7, 0, 0, '', 12, 595.3076923076923),\n",
       " ('1098596807',\n",
       "  '提勒因提拉两日游',\n",
       "  20124,\n",
       "  1022,\n",
       "  2503,\n",
       "  25,\n",
       "  0,\n",
       "  10,\n",
       "  '',\n",
       "  172,\n",
       "  116.32369942196532),\n",
       " ('630443825', '未知群名称', 15054, 739, 752, 3, 0, 0, '', 49, 301.08),\n",
       " ('1035179673', '未知群名称', 9150, 445, 461, 0, 0, 0, '', 19, 457.5),\n",
       " ('1090568038',\n",
       "  '未知群名称',\n",
       "  18136,\n",
       "  863,\n",
       "  1521,\n",
       "  19,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  50,\n",
       "  355.6078431372549),\n",
       " ('785323132', '未知群名称', 2641, 129, 133, 0, 0, 0, '', 15, 165.0625),\n",
       " ('902679053', '未知群名称', 36, 1, 3, 0, 0, 0, '', 2, 12.0),\n",
       " ('828284732', '未知群名称', 32414, 1573, 2030, 5, 0, 0, '', 83, 385.8809523809524),\n",
       " ('668208242', '未知群名称', 16029, 895, 923, 52, 0, 0, '', 39, 400.725),\n",
       " ('550996530',\n",
       "  '狂躁眼魔大姐头会梦见',\n",
       "  27622,\n",
       "  1391,\n",
       "  1433,\n",
       "  4,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  103,\n",
       "  265.59615384615387),\n",
       " ('1136097417', '未知群名称', 3387, 178, 206, 5, 0, 0, '', 50, 66.41176470588235),\n",
       " ('916901147', '未知群名称', 7830, 388, 416, 0, 0, 0, '', 11, 652.5),\n",
       " ('1092382018', '未知群名称', 11, 0, 0, 0, 0, 0, '', 3, 2.75),\n",
       " ('1065789982', '未知群名称', 11, 0, 0, 0, 0, 0, '', 3, 2.75),\n",
       " ('1079553874', '未知群名称', 11, 0, 0, 0, 0, 0, '', 2, 3.6666666666666665),\n",
       " ('102152309', '未知群名称', 4660, 221, 317, 29, 7, 7, '', 3, 1165.0),\n",
       " ('637659678',\n",
       "  '未知群名称',\n",
       "  40693,\n",
       "  2087,\n",
       "  2923,\n",
       "  26,\n",
       "  0,\n",
       "  0,\n",
       "  '894490037',\n",
       "  85,\n",
       "  473.1744186046512),\n",
       " ('1108030415',\n",
       "  '奇幻创作交流群',\n",
       "  8538,\n",
       "  384,\n",
       "  862,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  141,\n",
       "  60.12676056338028),\n",
       " ('480533750', '未知群名称', 26, 0, 7, 0, 0, 0, '', 2, 8.666666666666666),\n",
       " ('801962740',\n",
       "  '主群',\n",
       "  40806,\n",
       "  3032,\n",
       "  3244,\n",
       "  192,\n",
       "  50,\n",
       "  50,\n",
       "  '',\n",
       "  101,\n",
       "  400.05882352941177),\n",
       " ('1146605598',\n",
       "  '未知群名称',\n",
       "  18660,\n",
       "  972,\n",
       "  1019,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  69,\n",
       "  266.57142857142856),\n",
       " ('294996769', '未知群名称', 427, 13, 91, 0, 0, 0, '', 8, 47.44444444444444),\n",
       " ('810149469', '未知群名称', 6658, 343, 377, 0, 0, 0, '', 12, 512.1538461538462),\n",
       " ('1037511017',\n",
       "  '暮色妙妙屋',\n",
       "  42690,\n",
       "  2434,\n",
       "  3004,\n",
       "  35,\n",
       "  2,\n",
       "  2,\n",
       "  '',\n",
       "  147,\n",
       "  288.44594594594594),\n",
       " ('764967123', '未知群名称', 2504, 130, 133, 0, 0, 0, '', 5, 417.3333333333333),\n",
       " ('576284000', '未知群名称', 1013, 50, 80, 0, 0, 0, '', 60, 16.60655737704918),\n",
       " ('1039216001',\n",
       "  '未知群名称',\n",
       "  7327,\n",
       "  406,\n",
       "  486,\n",
       "  16,\n",
       "  9,\n",
       "  12,\n",
       "  '',\n",
       "  44,\n",
       "  162.82222222222222),\n",
       " ('1077867371',\n",
       "  '未知群名称',\n",
       "  12827,\n",
       "  640,\n",
       "  1084,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  67,\n",
       "  188.63235294117646),\n",
       " ('975552472', '未知群名称', 13114, 711, 761, 0, 0, 0, '', 53, 242.85185185185185),\n",
       " ('832658880',\n",
       "  '虚空之间',\n",
       "  59120,\n",
       "  3275,\n",
       "  3507,\n",
       "  5,\n",
       "  0,\n",
       "  0,\n",
       "  '494532153',\n",
       "  167,\n",
       "  351.9047619047619),\n",
       " ('367143709', '未知群名称', 37715, 2079, 2326, 0, 0, 0, '', 99, 377.15),\n",
       " ('1083284855',\n",
       "  'SCPxDND世设实验跑团群',\n",
       "  16977,\n",
       "  1018,\n",
       "  1083,\n",
       "  8,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  146,\n",
       "  115.48979591836735),\n",
       " ('1162164645', '未知群名称', 86, 4, 7, 0, 0, 0, '', 8, 9.555555555555555),\n",
       " ('541418992', '未知群名称', 2186, 124, 124, 0, 0, 0, '', 17, 121.44444444444444),\n",
       " ('819025784', '未知群名称', 15127, 856, 964, 0, 0, 0, '', 81, 184.47560975609755),\n",
       " ('948928572', '未知群名称', 5078, 290, 302, 0, 0, 0, '', 21, 230.8181818181818),\n",
       " ('906424501', '鸡者稽也的世界', 9877, 555, 710, 0, 0, 0, '', 103, 94.97115384615384),\n",
       " ('583318763', '未知群名称', 4416, 256, 257, 0, 0, 0, '', 15, 276.0),\n",
       " ('789042741', '未知群名称', 3805, 244, 244, 10, 0, 0, '', 37, 100.13157894736842),\n",
       " ('689613561', '未知群名称', 7602, 439, 488, 0, 0, 0, '', 5, 1267.0),\n",
       " ('182695671', '未知群名称', 469, 27, 27, 0, 0, 0, '', 48, 9.571428571428571),\n",
       " ('981998150', '未知群名称', 5488, 326, 328, 0, 0, 0, '', 49, 109.76),\n",
       " ('688410549',\n",
       "  'DND新手团-失落矿坑',\n",
       "  3827,\n",
       "  179,\n",
       "  617,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  103,\n",
       "  36.79807692307692),\n",
       " ('1127029577', '未知群名称', 11834, 695, 791, 0, 0, 0, '', 76, 153.6883116883117),\n",
       " ('1097733437',\n",
       "  '未知群名称',\n",
       "  57979,\n",
       "  3379,\n",
       "  4334,\n",
       "  4,\n",
       "  2,\n",
       "  3,\n",
       "  '',\n",
       "  97,\n",
       "  591.6224489795918),\n",
       " ('914145389', '未知群名称', 22235, 1334, 1453, 4, 1, 1, '', 81, 271.1585365853659),\n",
       " ('972979767', '未知群名称', 14525, 864, 960, 0, 0, 0, '', 56, 254.82456140350877),\n",
       " ('557566106', '未知群名称', 318, 18, 25, 0, 0, 0, '', 10, 28.90909090909091),\n",
       " ('514413562', '未知群名称', 1753, 105, 116, 0, 0, 0, '', 25, 67.42307692307692),\n",
       " ('982536797', '未知群名称', 2432, 131, 296, 0, 0, 0, '', 47, 50.666666666666664),\n",
       " ('1029271910', '未知群名称', 7378, 417, 801, 0, 0, 0, '', 80, 91.08641975308642),\n",
       " ('858541957',\n",
       "  '龙金劫',\n",
       "  142164,\n",
       "  8834,\n",
       "  10234,\n",
       "  8,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  821.7572254335261),\n",
       " ('106844024', '未知群名称', 139, 8, 10, 0, 0, 0, '', 3, 34.75),\n",
       " ('1129875626',\n",
       "  '艾恩葛朗特',\n",
       "  10824,\n",
       "  638,\n",
       "  1062,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  106,\n",
       "  101.1588785046729),\n",
       " ('789110718', '未知群名称', 24194, 1518, 1707, 0, 0, 0, '', 47, 504.0416666666667),\n",
       " ('799659577',\n",
       "  'dnd萌新群',\n",
       "  65827,\n",
       "  4136,\n",
       "  4777,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  103,\n",
       "  632.9519230769231),\n",
       " ('770167107', '未知群名称', 93, 7, 36, 1, 0, 1, '', 76, 1.2077922077922079),\n",
       " ('765728113', '未知群名称', 7023, 447, 510, 0, 0, 0, '', 17, 390.1666666666667),\n",
       " ('1132431333',\n",
       "  '趴趴的dnd后备基地',\n",
       "  10465,\n",
       "  671,\n",
       "  792,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  104,\n",
       "  99.66666666666667),\n",
       " ('1165389882', '未知群名称', 100, 6, 6, 0, 0, 0, '', 1, 50.0),\n",
       " ('1040735759',\n",
       "  '楚尔特（每周六晚8点',\n",
       "  3821,\n",
       "  237,\n",
       "  361,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  103,\n",
       "  36.74038461538461),\n",
       " ('340115648',\n",
       "  '未知群名称',\n",
       "  10236,\n",
       "  657,\n",
       "  806,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '2651528974',\n",
       "  84,\n",
       "  120.4235294117647),\n",
       " ('1158413265', '未知群名称', 592, 36, 68, 0, 0, 0, '', 15, 37.0),\n",
       " ('785626121', '未知群名称', 4838, 311, 506, 0, 0, 0, '', 94, 50.92631578947368),\n",
       " ('949016025', '未知群名称', 3287, 221, 271, 0, 0, 0, '', 80, 40.58024691358025),\n",
       " ('323771700', '未知群名称', 43869, 2967, 3559, 0, 0, 0, '', 61, 707.5645161290323),\n",
       " ('946243658', '未知群名称', 5712, 394, 490, 1, 0, 0, '3278429434', 83, 68.0),\n",
       " ('791871851', '未知群名称', 2064, 163, 213, 4, 0, 2, '', 79, 25.8),\n",
       " ('1121560880', '未知群名称', 6803, 493, 517, 2, 0, 0, '', 14, 453.53333333333336),\n",
       " ('975029544', '未知群名称', 4493, 302, 518, 0, 0, 0, '', 82, 54.13253012048193),\n",
       " ('868424515', '未知群名称', 4960, 361, 379, 0, 0, 0, '', 37, 130.52631578947367),\n",
       " ('912850854', '未知群名称', 4810, 351, 363, 0, 0, 0, '', 18, 253.1578947368421),\n",
       " ('1128854358',\n",
       "  '未知群名称',\n",
       "  11099,\n",
       "  867,\n",
       "  1182,\n",
       "  15,\n",
       "  12,\n",
       "  12,\n",
       "  '',\n",
       "  80,\n",
       "  137.02469135802468),\n",
       " ('1149922033', '未知群名称', 904, 65, 85, 0, 0, 0, '', 13, 64.57142857142857),\n",
       " ('332968799', '未知群名称', 18180, 1348, 1482, 0, 0, 0, '', 47, 378.75),\n",
       " ('1107522219', '未知群名称', 3141, 247, 265, 21, 0, 8, '', 8, 349.0),\n",
       " ('914973407', '未知群名称', 33732, 2498, 3073, 0, 0, 0, '', 74, 449.76),\n",
       " ('1138255763', '未知群名称', 2037, 154, 201, 1, 1, 1, '', 77, 26.115384615384617),\n",
       " ('914294418', '未知群名称', 1160, 69, 246, 0, 0, 0, '', 29, 38.666666666666664),\n",
       " ('1145451263',\n",
       "  '未知群名称',\n",
       "  11188,\n",
       "  826,\n",
       "  1388,\n",
       "  2,\n",
       "  0,\n",
       "  2,\n",
       "  '',\n",
       "  80,\n",
       "  138.12345679012347),\n",
       " ('1131890973',\n",
       "  '未知群名称',\n",
       "  16947,\n",
       "  1338,\n",
       "  1359,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  90,\n",
       "  186.23076923076923),\n",
       " ('923866921', '未知群名称', 7405, 599, 637, 2, 0, 0, '', 34, 211.57142857142858),\n",
       " ('1051877221', '未知群名称', 22, 1, 3, 0, 0, 0, '', 6, 3.142857142857143),\n",
       " ('653301967', '未知群名称', 17148, 1376, 1482, 0, 0, 0, '', 66, 255.9402985074627),\n",
       " ('828278921', '未知群名称', 3520, 290, 291, 0, 0, 0, '', 27, 125.71428571428571),\n",
       " ('736314772',\n",
       "  '未知群名称',\n",
       "  22042,\n",
       "  1793,\n",
       "  2053,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '1141596332',\n",
       "  85,\n",
       "  256.30232558139534),\n",
       " ('1033428377', '未知群名称', 4082, 335, 364, 0, 0, 0, '', 5, 680.3333333333334),\n",
       " ('1162371311', '未知群名称', 8, 0, 1, 0, 0, 0, '', 8, 0.8888888888888888),\n",
       " ('158917091', '未知群名称', 920, 76, 80, 0, 0, 0, '', 60, 15.081967213114755),\n",
       " ('1107859581',\n",
       "  '未知群名称',\n",
       "  36676,\n",
       "  3046,\n",
       "  3390,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  94,\n",
       "  386.06315789473683),\n",
       " ('1128793837', '未知群名称', 6787, 570, 606, 0, 0, 0, '', 42, 157.8372093023256),\n",
       " ('1137678096', '未知群名称', 1361, 112, 137, 0, 0, 0, '', 31, 42.53125),\n",
       " ('433600224',\n",
       "  '未知群名称',\n",
       "  28653,\n",
       "  2386,\n",
       "  3227,\n",
       "  7,\n",
       "  0,\n",
       "  1,\n",
       "  '',\n",
       "  84,\n",
       "  337.09411764705885),\n",
       " ('824457820', '未知群名称', 1267, 109, 109, 0, 0, 0, '', 24, 50.68),\n",
       " ('652718794', '未知群名称', 5112, 421, 612, 0, 0, 0, '', 75, 67.26315789473684),\n",
       " ('1092097684', '逃离深渊', 41740, 3752, 4035, 1, 0, 0, '', 110, 376.036036036036),\n",
       " ('1080477931', '未知群名称', 6460, 571, 691, 0, 0, 0, '', 74, 86.13333333333334),\n",
       " ('923427184', '未知群名称', 1117, 98, 130, 0, 0, 0, '', 23, 46.541666666666664),\n",
       " ('995967087', '未知群名称', 5115, 465, 723, 8, 0, 0, '', 33, 150.44117647058823),\n",
       " ('613649918', '未知群名称', 116, 5, 12, 9, 5, 6, '', 2, 38.666666666666664),\n",
       " ('797592365', '未知群名称', 3, 0, 0, 3, 0, 0, '', 0, 3.0),\n",
       " ('1129923710', '未知群名称', 6247, 611, 651, 8, 2, 3, '', 46, 132.91489361702128),\n",
       " ('724577068', '未知群名称', 3528, 319, 411, 0, 0, 0, '', 82, 42.506024096385545),\n",
       " ('492065497', '未知群名称', 231, 13, 149, 2, 0, 1, '', 38, 5.923076923076923),\n",
       " ('1087743176', '未知群名称', 2476, 240, 246, 3, 3, 3, '', 36, 66.91891891891892),\n",
       " ('1163686700', '未知群名称', 99, 9, 9, 0, 0, 0, '', 4, 19.8),\n",
       " ('757522691', '未知群名称', 268, 19, 78, 0, 0, 0, '', 23, 11.166666666666666),\n",
       " ('729800368', '未知群名称', 948, 91, 99, 0, 0, 0, '', 42, 22.046511627906977),\n",
       " ('861919492',\n",
       "  '伊丽莎白粉丝群',\n",
       "  41869,\n",
       "  6113,\n",
       "  11195,\n",
       "  152,\n",
       "  8,\n",
       "  35,\n",
       "  '',\n",
       "  172,\n",
       "  242.01734104046244),\n",
       " ('947790325', '未知群名称', 6195, 608, 629, 0, 0, 0, '', 58, 105.0),\n",
       " ('910564566', '未知群名称', 9, 0, 3, 0, 0, 0, '', 3, 2.25),\n",
       " ('908317369', '未知群名称', 686, 49, 224, 0, 0, 0, '', 13, 49.0),\n",
       " ('872675007', '未知群名称', 7568, 752, 889, 0, 0, 0, '', 65, 114.66666666666667),\n",
       " ('864063914',\n",
       "  '安格里斯议会大厅',\n",
       "  10934,\n",
       "  1034,\n",
       "  1975,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  102,\n",
       "  106.15533980582525),\n",
       " ('805855706',\n",
       "  '骰子姬的后宫群',\n",
       "  11184,\n",
       "  1111,\n",
       "  1573,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  171,\n",
       "  65.02325581395348),\n",
       " ('887460683', '未知群名称', 5965, 619, 664, 0, 0, 0, '', 41, 142.02380952380952),\n",
       " ('714416356', '未知群名称', 528, 55, 60, 0, 0, 0, '', 2, 176.0),\n",
       " ('790631400', '未知群名称', 21635, 2378, 2523, 11, 0, 6, '', 79, 270.4375),\n",
       " ('586704892', '未知群名称', 210, 22, 23, 0, 0, 0, '', 32, 6.363636363636363),\n",
       " ('1131835244', '未知群名称', 3464, 367, 488, 0, 0, 0, '', 64, 53.292307692307695),\n",
       " ('827618836', '未知群名称', 179, 17, 38, 0, 0, 0, '', 30, 5.774193548387097),\n",
       " ('1136559140', '未知群名称', 5, 0, 0, 0, 0, 0, '', 5, 0.8333333333333334),\n",
       " ('945268384', '未知群名称', 5, 0, 0, 0, 0, 0, '', 2, 1.6666666666666667),\n",
       " ('861784705', '未知群名称', 5, 0, 0, 0, 0, 0, '', 1, 2.5),\n",
       " ('684181845',\n",
       "  '【half-leaf】半片树叶同',\n",
       "  51582,\n",
       "  5597,\n",
       "  7153,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '1311215054',\n",
       "  156,\n",
       "  328.54777070063693),\n",
       " ('824076957',\n",
       "  '芜湖航空',\n",
       "  19633,\n",
       "  2124,\n",
       "  3055,\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  113.48554913294798),\n",
       " ('1137960520', '未知群名称', 705, 77, 97, 0, 0, 0, '', 53, 13.055555555555555),\n",
       " ('1159779642', '未知群名称', 984, 114, 114, 0, 0, 0, '', 14, 65.6),\n",
       " ('729754100', '未知群名称', 4654, 529, 715, 0, 0, 0, '', 73, 62.891891891891895),\n",
       " ('924215863', '未知群名称', 3364, 397, 416, 0, 0, 0, '', 32, 101.93939393939394),\n",
       " ('952116578', '未知群名称', 38, 4, 4, 0, 0, 0, '', 2, 12.666666666666666),\n",
       " ('885956404',\n",
       "  '乔瑟夫的奇妙故事记录',\n",
       "  8089,\n",
       "  1109,\n",
       "  1366,\n",
       "  10,\n",
       "  1,\n",
       "  3,\n",
       "  '',\n",
       "  119,\n",
       "  67.40833333333333),\n",
       " ('115409310', '未知群名称', 533, 65, 71, 0, 0, 0, '', 3, 133.25),\n",
       " ('293100087', '未知群名称', 3552, 434, 519, 0, 0, 0, '', 39, 88.8),\n",
       " ('827241326', '未知群名称', 76, 9, 11, 0, 0, 0, '', 15, 4.75),\n",
       " ('1060445759', '未知群名称', 3483, 462, 561, 2, 0, 0, '', 69, 49.75714285714286),\n",
       " ('970407943', '未知群名称', 89, 17, 19, 1, 1, 1, '', 56, 1.5614035087719298),\n",
       " ('951314256', '未知群名称', 75, 9, 17, 0, 0, 0, '', 44, 1.6666666666666667),\n",
       " ('983618971', '未知群名称', 1978, 276, 278, 0, 0, 0, '', 80, 24.419753086419753),\n",
       " ('310267651', '未知群名称', 7818, 1113, 1186, 2, 1, 1, '', 99, 78.18),\n",
       " ('1087876457',\n",
       "  '未知群名称',\n",
       "  11580,\n",
       "  1677,\n",
       "  1714,\n",
       "  4,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  62,\n",
       "  183.8095238095238),\n",
       " ('1074891946',\n",
       "  '跑团小飞机✈️',\n",
       "  10096,\n",
       "  1398,\n",
       "  1798,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  172,\n",
       "  58.358381502890175),\n",
       " ('1142843997', '未知群名称', 2372, 342, 416, 0, 0, 0, '', 52, 44.75471698113208),\n",
       " ('477793831', '未知群名称', 1937, 289, 315, 0, 0, 0, '', 58, 32.83050847457627),\n",
       " ('961587082', '未知群名称', 13, 1, 5, 0, 0, 0, '2054667975', 1, 6.5),\n",
       " ('821207125', '未知群名称', 573, 362, 377, 38, 21, 21, '', 51, 11.01923076923077),\n",
       " ('781611353', '未知群名称', 43, 6, 9, 0, 0, 0, '', 16, 2.5294117647058822),\n",
       " ('1161319236', '未知群名称', 34, 5, 5, 0, 0, 0, '', 9, 3.4),\n",
       " ('1093044826', '未知群名称', 6, 0, 4, 0, 0, 0, '', 9, 0.6),\n",
       " ('799675652', '未知群名称', 4544, 842, 852, 24, 4, 4, '', 21, 206.54545454545453),\n",
       " ('218946446', '未知群名称', 180, 30, 34, 0, 0, 0, '', 18, 9.473684210526315),\n",
       " ('1126509207', '未知群名称', 726, 134, 135, 6, 0, 0, '', 4, 145.2),\n",
       " ('1130546543',\n",
       "  '未知群名称',\n",
       "  25238,\n",
       "  4573,\n",
       "  4765,\n",
       "  1,\n",
       "  0,\n",
       "  1,\n",
       "  '1737931682',\n",
       "  91,\n",
       "  274.32608695652175),\n",
       " ('815863497', '未知群名称', 6750, 1241, 1285, 0, 0, 0, '', 79, 84.375),\n",
       " ('177152754', '未知群名称', 3, 0, 0, 0, 0, 0, '', 5, 0.5),\n",
       " ('1065638828', '未知群名称', 3, 0, 0, 0, 0, 0, '', 5, 0.5),\n",
       " ('710097270', '未知群名称', 3, 0, 0, 0, 0, 0, '', 1, 1.5),\n",
       " ('1160614940', '未知群名称', 235, 45, 49, 1, 0, 0, '', 9, 23.5),\n",
       " ('761143197', '未知群名称', 195, 35, 45, 0, 0, 0, '', 9, 19.5),\n",
       " ('716646945', '🎉、沙子、绝望', 3000, 555, 691, 0, 0, 0, '', 101, 29.41176470588235),\n",
       " ('200156210', '未知群名称', 1163, 211, 315, 0, 0, 0, '', 80, 14.358024691358025),\n",
       " ('1136731940', '未知群名称', 2067, 403, 412, 0, 0, 0, '', 82, 24.903614457831324),\n",
       " ('838625832', '未知群名称', 1017, 209, 236, 0, 0, 0, '', 74, 13.56),\n",
       " ('976489522', '未知群名称', 1323, 247, 509, 0, 0, 0, '', 54, 24.054545454545455),\n",
       " ('1137864021', '未知群名称', 2016, 962, 993, 31, 0, 0, '', 78, 25.518987341772153),\n",
       " ('680557727', '未知群名称', 13, 1, 13, 0, 0, 0, '', 7, 1.625),\n",
       " ('1039742562', '未知群名称', 4602, 1021, 1045, 0, 0, 0, '', 49, 92.04),\n",
       " ('1162796593', '未知群名称', 73, 20, 23, 3, 1, 1, '', 7, 9.125),\n",
       " ('874310127', '未知群名称', 24, 5, 5, 0, 0, 0, '', 12, 1.8461538461538463),\n",
       " ('909882201', '未知群名称', 25, 4, 16, 0, 0, 0, '', 33, 0.7352941176470589),\n",
       " ('823975729', '未知群名称', 211, 50, 52, 0, 0, 0, '', 50, 4.137254901960785),\n",
       " ('961341527', '未知群名称', 52, 12, 12, 0, 0, 0, '', 5, 8.666666666666666),\n",
       " ('413717851', '未知群名称', 3343, 882, 1031, 3, 0, 0, '', 81, 40.76829268292683),\n",
       " ('780593387', '未知群名称', 10, 2, 2, 0, 0, 0, '', 14, 0.6666666666666666),\n",
       " ('906805713', '未知群名称', 19, 4, 10, 0, 0, 0, '', 23, 0.7916666666666666),\n",
       " ('1074661613', '未知群名称', 2, 0, 0, 0, 0, 0, '', 4, 0.4),\n",
       " ('1107233299', '未知群名称', 2, 0, 0, 0, 0, 0, '', 2, 0.6666666666666666),\n",
       " ('1092290228', '未知群名称', 2, 0, 0, 0, 0, 0, '', 2, 0.6666666666666666),\n",
       " ('289353358', '未知群名称', 2, 0, 0, 0, 0, 0, '', 1, 1.0),\n",
       " ('1125389793', '未知群名称', 1409, 400, 408, 0, 0, 0, '', 68, 20.420289855072465),\n",
       " ('1067075270', '未知群名称', 124, 36, 45, 0, 0, 0, '', 12, 9.538461538461538),\n",
       " ('943640283', '未知群名称', 981, 295, 310, 0, 0, 0, '', 77, 12.576923076923077),\n",
       " ('934876731', '未知群名称', 9, 2, 4, 0, 0, 0, '', 15, 0.5625),\n",
       " ('1049158128',\n",
       "  '未知群名称',\n",
       "  734,\n",
       "  223,\n",
       "  261,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '821480843',\n",
       "  85,\n",
       "  8.534883720930232),\n",
       " ('490638981', '未知群名称', 922, 286, 294, 0, 0, 0, '', 21, 41.90909090909091),\n",
       " ('977129437', '未知群名称', 11, 3, 3, 0, 0, 0, '', 17, 0.6111111111111112),\n",
       " ('1050373551', '未知群名称', 252, 124, 130, 2, 0, 1, '', 64, 3.876923076923077),\n",
       " ('1134086518', '未知群名称', 8, 2, 4, 0, 0, 0, '', 17, 0.4444444444444444),\n",
       " ('1003411434', '未知群名称', 341, 119, 122, 0, 0, 0, '', 80, 4.209876543209877),\n",
       " ('872843401', 'DM帷幕', 434, 159, 270, 0, 0, 0, '', 166, 2.5988023952095807),\n",
       " ('1103813819', '未知群名称', 230, 96, 109, 0, 0, 0, '', 7, 28.75),\n",
       " ('901175666', '未知群名称', 218, 92, 105, 0, 0, 0, '', 26, 8.074074074074074),\n",
       " ('866439070', '未知群名称', 121, 48, 90, 0, 0, 0, '', 33, 3.5588235294117645),\n",
       " ('1032874255',\n",
       "  '智乃、伊丽莎白、魔…',\n",
       "  2764,\n",
       "  1321,\n",
       "  1334,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  142,\n",
       "  19.32867132867133),\n",
       " ('937959483', '未知群名称', 2454, 1156, 1336, 0, 0, 0, '', 95, 25.5625),\n",
       " ('1104170666',\n",
       "  '伊丽莎白',\n",
       "  5257,\n",
       "  2569,\n",
       "  3002,\n",
       "  1,\n",
       "  0,\n",
       "  1,\n",
       "  '',\n",
       "  168,\n",
       "  31.106508875739646),\n",
       " ('188576606', '未知群名称', 28, 13, 14, 0, 0, 0, '', 8, 3.111111111111111),\n",
       " ('170249749', '未知群名称', 83, 40, 47, 1, 1, 1, '', 2, 27.666666666666668),\n",
       " ('805756288', '未知群名称', 2293, 1162, 1344, 0, 0, 0, '', 69, 32.75714285714286),\n",
       " ('593471916', '未知群名称', 311, 159, 168, 0, 0, 0, '', 55, 5.553571428571429),\n",
       " ('1159485040', '未知群名称', 62, 30, 45, 0, 0, 0, '', 15, 3.875),\n",
       " ('1053997244', '未知群名称', 41, 21, 21, 0, 0, 0, '', 1, 20.5),\n",
       " ('967348037', '未知群名称', 104, 100, 101, 9, 9, 9, '', 11, 8.666666666666666),\n",
       " ('536944918', '未知群名称', 52, 27, 29, 0, 0, 0, '', 24, 2.08),\n",
       " ('949963169', '未知群名称', 634, 347, 361, 0, 0, 0, '', 77, 8.128205128205128),\n",
       " ('972122552', '未知群名称', 1, 0, 0, 0, 0, 0, '', 4, 0.2),\n",
       " ('1147681377', '未知群名称', 1, 0, 0, 0, 0, 0, '', 4, 0.2),\n",
       " ('1108960013', '未知群名称', 1, 0, 0, 0, 0, 0, '', 3, 0.25),\n",
       " ('875400381', '未知群名称', 1, 0, 0, 0, 0, 0, '', 3, 0.25),\n",
       " ('1131712070', '未知群名称', 1, 0, 0, 0, 0, 0, '', 2, 0.3333333333333333),\n",
       " ('477341677', '未知群名称', 1049, 580, 621, 0, 0, 0, '', 99, 10.49),\n",
       " ('979578599', '未知群名称', 48, 26, 28, 0, 0, 0, '', 48, 0.9795918367346939),\n",
       " ('496289850', '未知群名称', 341, 180, 269, 0, 0, 0, '', 65, 5.166666666666667),\n",
       " ('815308828', '未知群名称', 65, 37, 43, 0, 0, 0, '', 26, 2.4074074074074074),\n",
       " ('478350531', '未知群名称', 2590, 1543, 1832, 0, 0, 0, '', 95, 26.979166666666668),\n",
       " ('1160318328', '未知群名称', 45, 26, 37, 0, 0, 0, '', 13, 3.2142857142857144),\n",
       " ('1157531738', '未知群名称', 120, 73, 79, 0, 0, 0, '', 22, 5.217391304347826),\n",
       " ('740950119', '未知群名称', 36, 22, 22, 0, 0, 0, '', 17, 2.0),\n",
       " ('743142757', '未知群名称', 47, 29, 30, 0, 0, 0, '', 15, 2.9375),\n",
       " ('870162378', '未知群名称', 45, 28, 28, 0, 0, 0, '', 45, 0.9782608695652174),\n",
       " ('431225190', '未知群名称', 15, 9, 9, 0, 0, 0, '', 16, 0.8823529411764706),\n",
       " ('1107516852', '未知群名称', 640, 484, 592, 3, 3, 3, '', 45, 13.91304347826087),\n",
       " ('852857743', '未知群名称', 18, 11, 13, 0, 0, 0, '', 22, 0.782608695652174),\n",
       " ('261536887', '未知群名称', 158, 104, 104, 0, 0, 0, '', 18, 8.31578947368421),\n",
       " ('713891751', '未知群名称', 116, 75, 94, 0, 0, 0, '', 74, 1.5466666666666666),\n",
       " ('748891434', '未知群名称', 1226, 815, 886, 0, 0, 0, '', 52, 23.132075471698112),\n",
       " ('1030257209', '未知群名称', 57, 37, 46, 0, 0, 0, '', 62, 0.9047619047619048),\n",
       " ('1106820176', '未知群名称', 18, 12, 12, 0, 0, 0, '', 26, 0.6666666666666666),\n",
       " ('1160205573', '未知群名称', 35, 24, 27, 0, 0, 0, '', 13, 2.5),\n",
       " ('856317944', '未知群名称', 52, 41, 41, 20, 19, 19, '', 1, 26.0),\n",
       " ('341820238', '未知群名称', 666, 489, 502, 0, 0, 0, '', 99, 6.66),\n",
       " ('1070415189', '未知群名称', 309, 228, 236, 0, 0, 0, '', 83, 3.6785714285714284),\n",
       " ('189585177', '未知群名称', 516, 380, 415, 0, 0, 0, '', 78, 6.531645569620253),\n",
       " ('936701170', '未知群名称', 2, 1, 1, 0, 0, 0, '', 6, 0.2857142857142857),\n",
       " ('555475258', '未知群名称', 6, 4, 6, 0, 0, 0, '', 11, 0.5),\n",
       " ('1070552575', '未知群名称', 576, 462, 473, 0, 0, 0, '', 67, 8.470588235294118),\n",
       " ('946705971', '未知群名称', 13, 10, 10, 0, 0, 0, '', 9, 1.3),\n",
       " ('831908723', '未知群名称', 25, 20, 21, 0, 0, 0, '', 17, 1.3888888888888888),\n",
       " ('483554625', '未知群名称', 363, 299, 305, 0, 0, 0, '', 81, 4.426829268292683),\n",
       " ('964837514', '未知群名称', 2, 1, 2, 0, 0, 0, '', 6, 0.2857142857142857),\n",
       " ('995096415',\n",
       "  '法术查询/魔法物品查',\n",
       "  1502,\n",
       "  1263,\n",
       "  1325,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  '',\n",
       "  171,\n",
       "  8.732558139534884),\n",
       " ('879179168', '未知群名称', 12, 10, 10, 0, 0, 0, '', 13, 0.8571428571428571),\n",
       " ('1064808211', '未知群名称', 5, 5, 5, 0, 0, 0, '', 7, 0.625)]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 检查发言情况\n",
    "temp = []\n",
    "total = 0\n",
    "for gId in b.groupInfoDict:\n",
    "    temp.append((gId, b.groupInfoDict[gId]['name'], b.groupInfoDict[gId]['messageAccu'], b.groupInfoDict[gId]['dndCommandAccu'],b.groupInfoDict[gId]['commandAccu'],\n",
    "                b.groupInfoDict[gId]['messageDaily'], b.groupInfoDict[gId]['dndCommandDaily'],b.groupInfoDict[gId]['commandDaily']\n",
    "                ,b.groupInfoDict[gId]['inviter'],b.groupInfoDict[gId]['days'], b.groupInfoDict[gId]['messageAccu']/(b.groupInfoDict[gId]['days']+1)))\n",
    "    total += b.groupInfoDict[gId]['dndCommandAccu']\n",
    "temp = sorted(temp, key = lambda x: -((x[2]/(x[9]+1)+x[5])/(x[3]*0.8+x[6]+x[4]*0.1+x[7]*0.2+0.5))*(x[9]+1))\n",
    "print(len(temp), total)\n",
    "print(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2249\n",
      "1593230397 3301\n",
      "980980\n"
     ]
    }
   ],
   "source": [
    "total = 0\n",
    "total_com = 0\n",
    "max_credit = 0\n",
    "max_uid = ''\n",
    "for gId in b.userInfoDict:\n",
    "    total_com += b.userInfoDict[gId]['commandAccu']\n",
    "    if b.userInfoDict[gId]['credit'] > 100:\n",
    "        total += 1\n",
    "    if b.userInfoDict[gId]['credit'] > max_credit:\n",
    "        max_credit = b.userInfoDict[gId]['credit']\n",
    "        max_uid = gId\n",
    "print(total)\n",
    "print(max_uid, max_credit)\n",
    "print(total_com)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3347\n",
      "573\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAEL5JREFUeJzt3X3MnXV9x/H3Z+XBRcgooxBW6lpMl4jJVkmDJCzGjclD/aOYaFL+kIaR1GyQaOL+qJoMpiHBZWpG4jA4GmFxIvMhNLMbdozF+AcPxVVo7ZBbZFLb0LoqakzcwO/+OL9bj+V+7t373Ke/9ys5Odf5nt91zve6etpPr991nftOVSFJ6s9vjLoBSdJoGACS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkTp026gZmct5559XatWtH3YYkjZUnn3zyB1W1arZxyzoA1q5dy549e0bdhiSNlST/PZdxTgFJUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnlvU3gU/U2u1fGcn7Pn/H20fyvpI0Hx4BSFKnZg2AJGuSPJLkQJL9Sd7b6rcl+X6Sve22aWidDySZSPJMkquH6te02kSS7SdnkyRJczGXKaCXgfdX1TeSnA08mWR3e+4TVfU3w4OTXAJsAd4I/A7wb0l+rz39SeBtwEHgiSQ7q+pbi7EhkqT5mTUAquowcLgt/yTJAWD1DKtsBu6vqp8D300yAVzWnpuoqucAktzfxhoAkjQC8zoHkGQt8CbgsVa6JclTSXYkWdlqq4EXhlY72GrT1Y9/j21J9iTZc/To0fm0J0mahzkHQJKzgC8C76uqHwN3Aa8HNjA4QvjY5NApVq8Z6r9eqLq7qjZW1cZVq2b9fQaSpAWa02WgSU5n8I//Z6vqSwBV9eLQ858G/rk9PAisGVr9IuBQW56uLklaYnO5CijAPcCBqvr4UP3CoWHvAPa15Z3AliRnJlkHrAceB54A1idZl+QMBieKdy7OZkiS5msuRwBXAO8Gnk6yt9U+CFyfZAODaZzngfcAVNX+JA8wOLn7MnBzVb0CkOQW4CFgBbCjqvYv4rZIkuZhLlcBfZ2p5+93zbDO7cDtU9R3zbSeJGnp+E1gSeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnDABJ6pQBIEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSpwwASeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6NWsAJFmT5JEkB5LsT/LeVj83ye4kz7b7la2eJHcmmUjyVJJLh15raxv/bJKtJ2+zJEmzmcsRwMvA+6vqDcDlwM1JLgG2Aw9X1Xrg4fYY4FpgfbttA+6CQWAAtwJvBi4Dbp0MDUnS0ps1AKrqcFV9oy3/BDgArAY2A/e2YfcC17XlzcB9NfAocE6SC4Grgd1VdayqfgjsBq5Z1K2RJM3ZvM4BJFkLvAl4DLigqg7DICSA89uw1cALQ6sdbLXp6pKkEZhzACQ5C/gi8L6q+vFMQ6eo1Qz1499nW5I9SfYcPXp0ru1JkuZpTgGQ5HQG//h/tqq+1Movtqkd2v2RVj8IrBla/SLg0Az1X1NVd1fVxqrauGrVqvlsiyRpHuZyFVCAe4ADVfXxoad2ApNX8mwFHhyq39CuBroceKlNET0EXJVkZTv5e1WrSZJG4LQ5jLkCeDfwdJK9rfZB4A7ggSQ3Ad8D3tWe2wVsAiaAnwE3AlTVsSQfAZ5o4z5cVccWZSskSfM2awBU1deZev4e4Mopxhdw8zSvtQPYMZ8GJUknh98ElqROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnDABJ6pQBIEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSpwwASeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpU7MGQJIdSY4k2TdUuy3J95PsbbdNQ899IMlEkmeSXD1Uv6bVJpJsX/xNkSTNx1yOAD4DXDNF/RNVtaHddgEkuQTYAryxrfN3SVYkWQF8ErgWuAS4vo2VJI3IabMNqKqvJVk7x9fbDNxfVT8HvptkArisPTdRVc8BJLm/jf3WvDuWJC2KEzkHcEuSp9oU0cpWWw28MDTmYKtNV5ckjchCA+Au4PXABuAw8LFWzxRja4b6qyTZlmRPkj1Hjx5dYHuSpNksKACq6sWqeqWqfgF8ml9N8xwE1gwNvQg4NEN9qte+u6o2VtXGVatWLaQ9SdIcLCgAklw49PAdwOQVQjuBLUnOTLIOWA88DjwBrE+yLskZDE4U71x425KkEzXrSeAknwPeCpyX5CBwK/DWJBsYTOM8D7wHoKr2J3mAwcndl4Gbq+qV9jq3AA8BK4AdVbV/0bdGkjRnc7kK6PopyvfMMP524PYp6ruAXfPqTpJ00vhNYEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnDABJ6pQBIEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSpwwASeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnZg2AJDuSHEmyb6h2bpLdSZ5t9ytbPUnuTDKR5Kkklw6ts7WNfzbJ1pOzOZKkuZrLEcBngGuOq20HHq6q9cDD7THAtcD6dtsG3AWDwABuBd4MXAbcOhkakqTRmDUAquprwLHjypuBe9vyvcB1Q/X7auBR4JwkFwJXA7ur6lhV/RDYzatDRZK0hBZ6DuCCqjoM0O7Pb/XVwAtD4w622nT1V0myLcmeJHuOHj26wPYkSbNZ7JPAmaJWM9RfXay6u6o2VtXGVatWLWpzkqRfWWgAvNimdmj3R1r9ILBmaNxFwKEZ6pKkEVloAOwEJq/k2Qo8OFS/oV0NdDnwUpsiegi4KsnKdvL3qlaTJI3IabMNSPI54K3AeUkOMria5w7ggSQ3Ad8D3tWG7wI2ARPAz4AbAarqWJKPAE+0cR+uquNPLEuSltCsAVBV10/z1JVTjC3g5mleZwewY17dSZJOGr8JLEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSpwwASeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ0yACSpUwaAJHXKAJCkThkAktQpA0CSOmUASFKnDABJ6pQBIEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSp04oAJI8n+TpJHuT7Gm1c5PsTvJsu1/Z6klyZ5KJJE8luXQxNkCStDCLcQTwR1W1oao2tsfbgYeraj3wcHsMcC2wvt22AXctwntLkhboZEwBbQbubcv3AtcN1e+rgUeBc5JceBLeX5I0BycaAAV8NcmTSba12gVVdRig3Z/f6quBF4bWPdhqkqQROO0E17+iqg4lOR/YneS/ZhibKWr1qkGDINkG8LrXve4E25MkTeeEjgCq6lC7PwJ8GbgMeHFyaqfdH2nDDwJrhla/CDg0xWveXVUbq2rjqlWrTqQ9SdIMFhwASV6b5OzJZeAqYB+wE9jahm0FHmzLO4Eb2tVAlwMvTU4VSZKW3olMAV0AfDnJ5Ov8Y1X9a5IngAeS3AR8D3hXG78L2ARMAD8DbjyB95YknaAFB0BVPQf8wRT1/wGunKJewM0LfT9J0uLym8CS1KkTvQpIU1i7/Ssje+/n73j7yN5b0njxCECSOmUASFKnDABJ6pQBIEmdMgAkqVMGgCR1ygCQpE4ZAJLUKQNAkjplAEhSpwwASeqUASBJnTIAJKlTBoAkdcoAkKROGQCS1CkDQJI6ZQBIUqcMAEnqlAEgSZ3yl8KfYkb1C+n9ZfTS+PEIQJI6ZQBIUqcMAEnqlAEgSZ0yACSpU14FpEXh1UfS+PEIQJI6ZQBIUqeWfAooyTXA3wIrgL+vqjuWugedOkY19QROP2n8LWkAJFkBfBJ4G3AQeCLJzqr61lL2IS0Gz3to3C31FNBlwERVPVdV/wvcD2xe4h4kSSz9FNBq4IWhxweBNy9xD9JYG+W0l5bOUhzpLXUAZIpa/dqAZBuwrT38aZJn5vja5wE/OIHeRmlcex/XvmF8ex/XvmF8ex9J3/noCa3+u3MZtNQBcBBYM/T4IuDQ8ICquhu4e74vnGRPVW08sfZGY1x7H9e+YXx7H9e+YXx7H9e+52KpzwE8AaxPsi7JGcAWYOcS9yBJYomPAKrq5SS3AA8xuAx0R1XtX8oeJEkDS/49gKraBew6CS8972mjZWRcex/XvmF8ex/XvmF8ex/XvmeVqpp9lCTplOOPgpCkTp0SAZDkmiTPJJlIsn3U/RwvyfNJnk6yN8meVjs3ye4kz7b7la2eJHe2bXkqyaVL3OuOJEeS7BuqzbvXJFvb+GeTbB1R37cl+X7b73uTbBp67gOt72eSXD1UX9LPUpI1SR5JciDJ/iTvbfVx2OfT9T4O+/01SR5P8s3W+1+1+rokj7V9+Pl2sQpJzmyPJ9rza2fbprFQVWN9Y3Ay+TvAxcAZwDeBS0bd13E9Pg+cd1ztr4HtbXk78NG2vAn4FwbfmbgceGyJe30LcCmwb6G9AucCz7X7lW155Qj6vg34iynGXtI+J2cC69rnZ8UoPkvAhcClbfls4Nutv3HY59P1Pg77PcBZbfl04LG2Px8AtrT6p4A/a8t/DnyqLW8BPj/TNp3M3hfzdiocAYzrj5fYDNzblu8Frhuq31cDjwLnJLlwqZqqqq8Bx44rz7fXq4HdVXWsqn4I7AauGUHf09kM3F9VP6+q7wITDD5HS/5ZqqrDVfWNtvwT4ACDb8yPwz6frvfpLKf9XlX10/bw9HYr4I+BL7T68ft98s/jC8CVSTLDNo2FUyEApvrxEjN9CEehgK8meTKDbzoDXFBVh2HwFwk4v9WX4/bMt9fltA23tKmSHZPTKCzTvtu0wpsY/G90rPb5cb3DGOz3JCuS7AWOMAjM7wA/qqqXp+jjlz22518CfntUvS+WUyEAZv3xEsvAFVV1KXAtcHOSt8wwdhy2Z9J0vS6XbbgLeD2wATgMfKzVl13fSc4Cvgi8r6p+PNPQKWrLrfex2O9V9UpVbWDwEwkuA94wQx/LqvfFcioEwKw/XmLUqupQuz8CfJnBh+3Fyamddn+kDV+O2zPfXpfFNlTVi+0v+S+AT/OrQ/Nl1XeS0xn8A/rZqvpSK4/FPp+q93HZ75Oq6kfAfzA4B3BOksnvRw338cse2/O/xWDKcVl81hfqVAiAZf3jJZK8NsnZk8vAVcA+Bj1OXqmxFXiwLe8EbmhXe1wOvDQ5FTBC8+31IeCqJCvb4f9Vrbakjjt38g4G+x0GfW9pV3asA9YDjzOCz1KbR74HOFBVHx96atnv8+l6H5P9virJOW35N4E/YXAO4xHgnW3Y8ft98s/jncC/1+As8HTbNB5GfRZ6MW4Mroz4NoM5vA+Nup/jeruYwVUC3wT2T/bHYP7wYeDZdn9uq4fBL835DvA0sHGJ+/0cg8P2/2Pwv5ubFtIr8KcMTohNADeOqO9/aH09xeAv6oVD4z/U+n4GuHZUnyXgDxlMGTwF7G23TWOyz6frfRz2++8D/9l63Af8ZatfzOAf8Angn4AzW/017fFEe/7i2bZpHG5+E1iSOnUqTAFJkhbAAJCkThkAktQpA0CSOmUASFKnDABJ6pQBIEmdMgAkqVP/D96LtLuL+WYLAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "credits =[]\n",
    "temp = 0\n",
    "for uid in b.userInfoDict:\n",
    "    if b.userInfoDict[uid]['credit'] >= 50:\n",
    "        credits.append(b.userInfoDict[uid]['credit'])\n",
    "    if b.userInfoDict[uid]['credit'] >= 500:\n",
    "        temp += 1\n",
    "# print(sorted(credits, key = lambda x: -1*x))\n",
    "print(len(credits))\n",
    "print(temp)\n",
    "plt.hist(credits)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # %%time\n",
    "# # # 计算期望\n",
    "# import math\n",
    "\n",
    "# # xDyKz\n",
    "# def ComputeException(x, y, z = 1):\n",
    "#     return z + z*(y-1)*(2*x-z+1)/(2*x+2)+0.5\n",
    "# print(ComputeException(x=4, y=6, z = 3))\n",
    "# print(ComputeException(x=2, y=20, z = 1))\n",
    "# n = 5000\n",
    "# times = 0\n",
    "# error = 0\n",
    "# for x in [4, 6, 8, 10]:\n",
    "#     for y in [4, 6, 8, 10]:\n",
    "#         for z in [1, 2, 3, 4]:\n",
    "#             for r in range(10):\n",
    "#                 total = 0\n",
    "#                 for i in range(n):\n",
    "#                     error, output, rollResult = tool_dice.RollDiceCommand(f'{x}d{y}k{z}')\n",
    "#                     total += rollResult.totalValueList[0]\n",
    "#                 mean = total/n\n",
    "#                 exp = ComputeException(x, y, z)\n",
    "#                 error += mean-exp\n",
    "#                 times+=1\n",
    "# print(error/times)\n",
    "\n",
    "# ${\\sum_{i=1}^z(1+\\frac{(x-i+1)(y-1)}{x+1})}$\n",
    "# ${=z+\\sum_{i=1}^z\\frac{(x-i+1)(y-1)}{x+1}}$\n",
    "# ${=z+\\frac{y-1}{x+1}\\sum_{i=1}^z(x-i+1)}$\n",
    "# ${=z+\\frac{y-1}{x+1}(zx+z+\\sum_{i=1}^z(-i))}$\n",
    "# ${=z+\\frac{y-1}{x+1}(zx+z+\\frac{-z(1+z)}{2})}$\n",
    "# ${=z+\\frac{y-1}{x+1}\\frac{2zx+2z-z-z^2)}{2}}$\n",
    "# ${=z+\\frac{z(y-1)}{x+1}\\frac{(2x-z+1)}{2}}$\n",
    "# ${=0.5+z+\\frac{z(y-1)(2x-z+1)}{2x+2}}$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dict_keys(['酸液飞溅', '援助术', '警报术', '变身术', '化兽为友', '动物信使', '动物形态', '操纵死尸', '活化物件', '防活物护罩', '反魔法力场', '嫌恶/关怀术', '秘法眼', '秘法门', '秘法锁', '艾嘉西斯之铠', '哈达之臂', '星界投影', '卜筮术', '生命灵光', '净化灵光', '活力灵光', '启蒙术', '灾祸术', '放逐斩', '放逐术', '树肤术', '希望信标', '野兽知觉', '降咒', '毕格比之手', '剑刃护壁', '剑刃防护', '祝福术', '枯萎术', '致盲斩', '目盲/耳聋术', '闪现术', '朦胧术', '印记斩', '燃烧之手', '召雷术', '安定心神', '连锁闪电', '魅惑人类', '冻寒之触', '繁彩球', '死亡法阵', '原力法阵', '鹰眼术', '克隆术', '匕首之云', '死云术', '七彩喷射', '命令术', '通神术', '问道自然', '强令对决', '通晓语言', '强迫术', '寒冰锥', '困惑术', '召唤动物', '召唤箭雨', '召唤天界生物', '召唤元素生物', '召唤精类生物', '召唤次级元素生物', '万箭齐发', '召唤林地之精', '异界探知', '疫病术', '触发术', '不灭明焰', '操控水体', '操控天气', '警戒之箭', '法术反制', '造粮术', '造水/枯水术', '唤起死灵', '造物术', '疯狂冠冕', '十字军披风', '疗伤术', '舞光术', '黑暗术', '黑暗视觉', '昼明术', '防死结界', '延迟爆裂火球', '创造半位面', '湮灭波', '侦测善恶', '侦测魔法', '侦测毒性和疾病', '侦测思想', '任意门', '易容术', '解离术', '反制善恶', '解除魔法', '不谐低语', '预言术', '神恩', '圣言术', '支配野兽', '支配怪物', '支配人类', '卓姆吉瞬间召唤', '托梦术', '德鲁伊伎俩', '地震术', '魔能爆', '元素武器', '强化属性', '变巨/缩小术', '诱捕打击', '纠缠术', '注目术', '以太化', '艾伐黑触手', '脚底抹油', '摄心目光', '鬼斧神工', '妖火', '虚假生命', '恐惧术', '羽落术', '弱智术', '假死术', '获得魔宠', '召唤坐骑', '寻路术', '寻找陷阱', '死亡一指', '火球术', '火焰箭', '火焰护盾', '火焰风暴', '火焰刀', '焰击术', '炽焰法球', '石化术', '飞行术', '云雾术', '禁制术', '魔力监牢', '预警术', '行动自如', '交友术', '气化形体', '异界之门', '指使术', '遗体防腐', '巨虫术', '花言巧语', '法术无效结界', '守卫刻文', '神莓术', '擒抱藤', '油腻术', '高等隐形术', '高等复原术', '信仰守卫', '铜墙铁壁', '神导术', '曳光弹', '造风术', '棘雹术', '圣居', '幻景', '重伤术', '加速术', '医疗术', '治愈真言', '灼热金属', '炼狱叱喝', '英雄宴', '英雄气概', '脆弱诅咒', '怪物定身术', '人类定身术', '圣洁灵光', '哈达之欲', '猎人印记', '催眠图纹', '冰风暴', '鉴定术', '迷幻手稿', '禁锢术', '焚云术', '致伤术', '疫病虫群', '隐形术', '跳跃术', '敲击术', '通晓传奇', '李欧蒙秘藏箱', '李欧蒙小屋', '次级复原术', '浮空术', '光亮术', '闪电箭', '闪电束', '动植物定位术', '生物定位术', '物件定位术', '大步奔行', '法师护甲', '法师之手', '防护法阵', '魔魂壶', '魔法飞弹', '魔嘴术', '魔化武器', '高等幻影', '群体疗伤术', '群体医疗术', '群体治愈真言', '群体暗示术', '迷宫术', '融身入石', '马友夫强酸箭', '修复术', '传讯术', '流星爆', '心灵屏障', '次级幻影', '海市蜃楼', '镜影术', '假象术', '迷踪步', '篡改记忆', '月华之光', '摩登肯忠犬', '摩登肯豪宅术', '摩登肯私人密室', '摩登肯之剑', '地动术', '回避侦测', '涅斯图魔法灵光', '欧提路克冰封法球', '欧提路克弹力法球', '奥图迷舞', '行动无踪', '穿墙术', '魅影之力', '魅影杀手', '魅影驹', '异界盟誓', '异界誓缚', '异界传送', '植物滋长', '毒气喷溅', '变形术', '律令医疗', '律令死亡', '律令震慑', '治疗祷言', '魔法伎俩', '虹光喷射', '虹光法墙', '燃火术', '预置幻影', '投影术', '防护能量伤害', '防护善恶', '防护毒素', '净化食粮', '死者复活', '拉瑞心灵联结', '衰弱射线', '冷冻射线', '致病射线', '再生术', '转生术', '移除诅咒', '提升抗性', '复生术', '反重力', '回生术', '魔绳术', '圣火术', '庇护术', '灼热射线', '探知', '炽焰斩', '识破隐形', '伪装术', '短讯术', '隔离术', '形体变化', '粉碎音波', '护盾术', '虔诚护盾', '橡棍术', '电爪', '沉默术', '无声幻影', '拟像术', '睡眠术', '雪雨暴', '缓慢术', '维生术', '动物交谈', '死者交谈', '植物交谈', '蛛行术', '荆棘丛生', '灵体卫士', '灵体武器', '惊惧斩', '臭云术', '塑石术', '石肤术', '复仇风暴', '暗示术', '阳炎射线', '阳炎爆', '迅捷箭袋', '魔法徽记', '塔莎狂笑术', '心灵遥控', '心灵感应', '传送术', '传送法阵', '谭森浮碟术', '奇术', '荆棘之鞭', '雷鸣斩', '雷鸣波', '时间停止', '巧言术', '木遁术', '树跃术', '完全变形术', '完全复生术', '真知术', '克敌机先', '海啸术', '隐形仆役', '吸血鬼之触', '恶言相加', '火墙术', '力场墙', '冰墙术', '石墙术', '棘墙术', '守护之链', '水下呼吸', '水上行走', '蛛网术', '怪影杀手', '御风而行', '风墙术', '祈愿术', '巫术箭', '回返真言', '激愤斩', '诚实之域', '亚比达奇凋死术', '吸收元素', '阿迦纳萨喷火术', '兽之联结', '地之骨', '弹射', '创造篝火', '控火', '操控风力', '尘土恶魔', '地缚', '地动', '元素灾厄', '土石喷发', '火箭', '霜噬', '舞风', '冰刃', '焚烧', '炽焰赋权', '寒冰赋权', '磐石赋权', '清风赋权', '大漩涡', '魔石', '麦克斯米利安的地之攫', '马友夫微流星', '塑土', '烟火', '操水', '写入空中', '史尼洛雪球群', '暴风球', '鸣雷破', '潮涌', '浓酸球', '沙墙', '水墙', '守护之风', '碧水球', '旋风', '虫群孳生', '原初蛮击', '亡者丧钟', '光耀祷词', '造成恐惧', '典礼术', '混乱箭', '魔法圈套', '西风打击', '龙息术', '治愈之魂', '心灵尖刺', '幽影刃', '假寐术', '敌群环绕', '生命转换', '召唤次级恶魔', '雷霆步', '迷你仆役', '魅惑怪物', '获得高等坐骑', '自然守卫', '莫伊之影', '致病辐射', '召唤高等恶魔', '骷髅之舞', '拂晓', '汲能术', '渺远步', '神圣武器', '地狱呼唤', '负能量洪流', '授予技能', '钢风斩', '突触静止', '转化岩石', '光墙', '自然之怒', '创造小人', '德鲁伊林地', '精神监狱', '原初守护', '散射术', '灵魂牢笼', '谭森变形术', '众星冠冕', '律令痛苦', '神庙术', '幻影巨龙', '疯狂之暗', '坚固堡垒', '无敌术', '群体变形术', '心灵尖啸', '轰雷剑', '翠炎剑', '闪电牵引', '剑刃爆发', '思想编码', '魔宠群', '加德尔急速邮差', '加德尔高塔术', '血羽', '血之狂暴', '血液沸腾', '酸蚀创伤', '血红利刃', '收割打击', '秘术骇入', '问道城市', '召唤智机', '数字魅影', '获得载具', '故障术', '无误转达', '屏蔽摄像', '开关术', '防护弹道', '远程接入', '设备崩溃', '一分不差', '系统后门'])\n",
      "酸液飞溅Acid Splash\n",
      "咒法 戏法（术士，法师，奇械师）\n",
      "出处：玩家手册\n",
      "施法时间：1动作\n",
      "施法距离：60尺\n",
      "法术成分：V、S\n",
      "持续时间：立即\n",
      "你掷出一颗酸液球。在施法距离内指定一个生物，或者在距离内指定两个相距不超过5尺的生物。每个目标必须进行一次敏捷豁免，豁免失败则受到1d6点强酸伤害。你到达5级时，该法术的伤害增加1d6（变为2d6）。11级时再加1d6（变为3d6），17级时再加1d6（变为4d6）。\n"
     ]
    }
   ],
   "source": [
    "# # 录入查询资料\n",
    "# queryDict = {}\n",
    "\n",
    "# fileName = '5E_法术大全_by梨子'\n",
    "# title = ''\n",
    "# content = ''\n",
    "# with open(f'../资料/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     while data:\n",
    "#         data = data.strip()\n",
    "#         if not data:\n",
    "#             if title:\n",
    "#                 if len(title) > 20:\n",
    "#                     print(\"Title too long?\"+title+\"##\"+content)\n",
    "#                 elif len(content) < 20:\n",
    "#                     print(\"Content too small?\"+title+\"##\"+content)\n",
    "#                 content = content.replace('【换行】', '\\n')\n",
    "#                 queryDict[title] = content[:-1]\n",
    "#             title = ''\n",
    "#             content = ''\n",
    "#         else:\n",
    "#             if not title:\n",
    "#                 title = data\n",
    "#             else:\n",
    "#                 content += data.strip() + '\\n'\n",
    "#         data = f.readline()\n",
    "# content = content.replace('【换行】', '\\n')\n",
    "# queryDict[title] = content[:-1]\n",
    "# print(queryDict.keys())\n",
    "# print(queryDict[list(queryDict.keys())[0]])\n",
    "# utils.UpdateJson(queryDict, f'./plugins/custom_data/{fileName}_query.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入牌堆\n",
    "# import re\n",
    "# fileName = '库藏宝藏cr17+'\n",
    "# deckTitle = ''\n",
    "# deckList = []\n",
    "# deckRelayList = []\n",
    "# deckDict = {}\n",
    "# totalWeight = 0\n",
    "# keyList = [['WEIGHT', re.compile('WEIGHT\\(.*?\\)')], ['ROLL', re.compile('ROLL\\(.*?\\)')],\n",
    "#            ['DRAW', re.compile('DRAW\\(.*?\\)')], ['END', re.compile('END\\(\\)')]]\n",
    "# with open(f'../资料/牌堆/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     deckTitle = data\n",
    "#     data = f.readline().strip()\n",
    "#     if data[:3] == '依赖:':\n",
    "#         deckRelayList = data[3:].split('/')\n",
    "#         deckRelayList = [relay.strip() for relay in deckRelayList]\n",
    "#         data = f.readline().strip()\n",
    "#     while data:\n",
    "#         weight = 1\n",
    "#         end = False\n",
    "#         rawContent = data\n",
    "#         content = []\n",
    "#         for key in keyList:\n",
    "#             resultList = key[1].findall(data)\n",
    "#             if resultList:\n",
    "#                 if key[0] == 'WEIGHT':\n",
    "#                     assert len(resultList) == 1, 'WEIGHT指令只能出现一次'\n",
    "#                     weight = int(resultList[0][7:-1])\n",
    "#                     data = data.replace(resultList[0], '')\n",
    "#                     assert weight >= 1\n",
    "#                 elif key[0] == 'END':\n",
    "#                     assert len(resultList) == 1, 'END指令只能出现一次'\n",
    "#                     end = True\n",
    "#                     data = data.replace(resultList[0], '')\n",
    "#                 else:\n",
    "#                     for result in resultList:\n",
    "#                         index = data.find(result)\n",
    "#                         arg = data[index+len(key[0])+1:index+len(result)-1]\n",
    "#                         if index != 0:\n",
    "#                             if data[:index].split():\n",
    "#                                 content.append(['TEXT',data[:index].replace('\\\\n', '\\n')])\n",
    "#                         if key[0] == 'DRAW':\n",
    "#                             targetDeck = arg.split('/')[0]\n",
    "#                             assert len(arg.split('/')) <= 2\n",
    "#                             assert targetDeck == deckTitle or targetDeck in deckRelayList, targetDeck\n",
    "#                         elif key[0] == 'ROLL':\n",
    "#                             assert tool_dice.isDiceCommand(arg)\n",
    "#                         content.append([key[0],arg])\n",
    "#                         data = data[index+len(result):]\n",
    "#         if data.split():\n",
    "#             content.append(['TEXT', data.replace('\\\\n', '\\n')])\n",
    "#         assert content, rawContent\n",
    "#         totalWeight += weight\n",
    "#         deckList.append({'weight':weight, 'content':content, 'end':end, 'raw':rawContent})\n",
    "#         data = f.readline().strip()\n",
    "\n",
    "# deckDict['title'] = deckTitle\n",
    "# deckDict['relay'] = deckRelayList\n",
    "# deckDict['totalWeight'] = totalWeight\n",
    "# deckDict['list'] = deckList\n",
    "# utils.UpdateJson(deckDict, f'./plugins/custom_data/{fileName}_deck.json')\n",
    "# print(deckDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入菜谱\n",
    "# fileName = '饮料与酒水'\n",
    "# cookDict = {}\n",
    "# curName = ''\n",
    "# with open(f'../资料/菜谱/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     while data:\n",
    "#         data = data.split(':')\n",
    "#         if data[0] == '名称':\n",
    "#             cookDict[data[1]] = {}\n",
    "#             curName = data[1]\n",
    "#         if data[0] == '美味' or data[0] == '难度':\n",
    "#             data[1] = int(data[1])\n",
    "#         if data[0] == '菜系' or data[0] == '种类' or data[0] == '风格':\n",
    "#             data[1] = data[1].split('/')\n",
    "#         cookDict[curName][data[0]] = data[1]\n",
    "#         data = f.readline().strip()\n",
    "#         if data == '':\n",
    "#             data = f.readline().strip()\n",
    "#             cookDict[curName]['关键词'] = cookDict[curName]['菜系'] + cookDict[curName]['种类'] + cookDict[curName]['风格']\n",
    "# print(cookDict)\n",
    "# utils.UpdateJson(cookDict, f'./plugins/custom_data/{fileName}_menu.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入笑话\n",
    "# joke_path = '../资料/笑话'\n",
    "# filesPath = os.listdir(joke_path) #读取所有文件名\n",
    "# for fp in filesPath: # 去除文件名中的空格\n",
    "#     absPath = os.path.join(joke_path, fp)\n",
    "#     fpNew = fp.replace(' ', '')\n",
    "#     absPathNew = os.path.join(joke_path, fpNew)\n",
    "#     os.rename(absPath, absPathNew)\n",
    "# filesPath = os.listdir(joke_path) #再次读取所有文件名\n",
    "# filesPath = sorted(filesPath)\n",
    "# jokeDict = {}\n",
    "# jokeListStr = []\n",
    "# jokeListImg = []\n",
    "# for fp in filesPath:\n",
    "#     try:\n",
    "#         if fp[-4:] == '.txt':\n",
    "#             print('txt', fp)\n",
    "#             absPath = os.path.join(joke_path, fp)\n",
    "#             with open(absPath, 'r') as f:\n",
    "#                 jokeCur = ''\n",
    "#                 data = f.readline()\n",
    "#                 while data:\n",
    "#                     jokeCur += data\n",
    "#                     data = f.readline()\n",
    "#                 jokeCur = jokeCur.strip()\n",
    "#                 if jokeCur:\n",
    "#                     jokeListStr.append(jokeCur)\n",
    "#         elif fp[-4:] == '.png' or fp[-4:] == '.gif' or fp[-4:] == '.jpg':\n",
    "#             print('img', fp)\n",
    "#             jokeListImg.append(fp)\n",
    "#     except Exception as e:\n",
    "#         print(f'error:{e}')\n",
    "# assert len(jokeListStr) > 0\n",
    "# print(f'笑话资料库加载成功! 共{len(jokeListStr)}个文字条目, {len(jokeListImg)}个图片条目')\n",
    "# jokeDict['word'] = jokeListStr\n",
    "# jokeDict['img'] = jokeListImg\n",
    "# utils.UpdateJson(jokeDict, f'./plugins/custom_data/joke.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入同义词\n",
    "# synDict = {}\n",
    "# fileName = 'syn_spell'\n",
    "# with open(f'../资料/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     while data:\n",
    "#         synInfo = data.split(':')\n",
    "#         synInfo[0] = synInfo[0].split('/')\n",
    "#         for syn in synInfo[0]:\n",
    "#             synDict[syn] = synInfo[1]\n",
    "#         data = f.readline().strip()\n",
    "# print(synDict)\n",
    "# utils.UpdateJson(synDict, f'./plugins/custom_data/{fileName}.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 检索职业和法术列表\n",
    "# queryDict = {}\n",
    "\n",
    "# fileName = '5E_法术列表_by梨子'\n",
    "# title = ''\n",
    "# content = ''\n",
    "# with open(f'../资料/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     while data:\n",
    "#         data = data.strip()\n",
    "#         if not data:\n",
    "#             if title:\n",
    "#                 title = title.split(':')[0]\n",
    "#                 try:\n",
    "#                     queryDict[title] += ' ' + content[:-1]\n",
    "#                 except:\n",
    "#                     queryDict[title] = content[:-1]\n",
    "#             title = ''\n",
    "#             content = ''\n",
    "#         else:\n",
    "#             if not title:\n",
    "#                 title = data\n",
    "#             else:\n",
    "#                 content += data.strip() + '\\n'\n",
    "#         data = f.readline()\n",
    "        \n",
    "# title = title.split(':')[0]\n",
    "# queryDict[title] += ' ' + content[:-1]\n",
    "# # print(queryDict.keys())\n",
    "# # print(queryDict[list(queryDict.keys())[0]])\n",
    "# target = '典礼术'\n",
    "# result = '（'\n",
    "# for c in queryDict.keys():\n",
    "#     if target in queryDict[c]:\n",
    "#         result += c + '，'\n",
    "# result = result[:-1] + '）'\n",
    "# print(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入姓氏\n",
    "# import xlrd\n",
    "# nameDict = {}\n",
    "# data = xlrd.open_workbook('../资料/姓名/姓名大全.xlsx')\n",
    "# raceList = data.sheet_names()\n",
    "# nameDict['meta'] = {}\n",
    "# nameDict['info'] = {}\n",
    "# for i in range(len(raceList)):\n",
    "#     race = raceList[i]\n",
    "#     nameDict['info'][race] = []\n",
    "#     table = data.sheet_by_index(i)\n",
    "#     for j in range(table.ncols//2):\n",
    "#         resultCol = []\n",
    "#         firstCol = table.col_values(j*2)\n",
    "#         secondCol = table.col_values(j*2+1)\n",
    "#         firstValid = 0\n",
    "#         secondValid = 0\n",
    "#         for k in range(1, len(firstCol)):\n",
    "#             if firstCol[k].strip(): firstValid = k\n",
    "#         for k in range(1, len(secondCol)):\n",
    "#             if secondCol[k].strip(): secondValid = k\n",
    "#         assert firstValid == secondValid\n",
    "#         for k in range(1, firstValid):\n",
    "#             resultCol.append([firstCol[k], secondCol[k]])\n",
    "#         assert len(resultCol) != 0\n",
    "#         nameDict['info'][race].append(resultCol)\n",
    "\n",
    "# with open('../资料/姓名/name_config.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "#     data = f.readline().strip()\n",
    "#     while data:\n",
    "#         temp = data.split(':')\n",
    "#         index = temp[0]\n",
    "#         targetList = temp[1].split('|')\n",
    "#         detail = []\n",
    "#         for t in targetList:\n",
    "#             detail.append(t.split('-'))\n",
    "#             assert len(detail[-1]) > 1\n",
    "#             assert detail[-1][0] in nameDict['info'].keys()\n",
    "#             for d in range(1,len(detail[-1])):\n",
    "#                 detail[-1][d] = int(detail[-1][d])\n",
    "#                 assert detail[-1][d] >= 0\n",
    "#                 assert detail[-1][d] < len(nameDict['info'][detail[-1][0]])\n",
    "#         nameDict['meta'][index] = detail\n",
    "#         data = f.readline().strip()\n",
    "# print(raceList)\n",
    "# print(nameDict['meta'])\n",
    "# utils.UpdateJson(nameDict, f'./plugins/custom_data/name.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # 录入题目\n",
    "# questionDict = {}\n",
    "# sourcePath = '../资料/题目'\n",
    "# filesPath = os.listdir(sourcePath) #读取所有文件名\n",
    "# filesPath = sorted(filesPath)\n",
    "# for fp in filesPath:\n",
    "#     assert fp[-4:] == '.txt'\n",
    "#     title = fp[:-4]\n",
    "#     questionDict[title] = []\n",
    "#     absPath = os.path.join(sourcePath, fp)\n",
    "#     with open(absPath, 'r', encoding=\"utf-8-sig\") as f:\n",
    "#         data = f.readline().strip()\n",
    "#         tempQuestion = ['', '', '']\n",
    "#         index = 0\n",
    "#         while data:\n",
    "#             content = ''\n",
    "#             if data[:2] == '题目':\n",
    "#                 index = 0\n",
    "#                 content = data[3:].strip() # 考虑中间有一个分隔符\n",
    "#             elif data[:2] == '答案':\n",
    "#                 index = 1\n",
    "#                 content = data[3:].strip()\n",
    "#                 assert content in ['T', 'F', 'A','B', 'C', 'D']\n",
    "#             elif data[:2] == '解析':\n",
    "#                 index = 2\n",
    "#                 content = data[3:].strip()\n",
    "#             else:\n",
    "#                 content = '\\n' + data\n",
    "#             tempQuestion[index] = tempQuestion[index] + content\n",
    "#             data = f.readline().strip()\n",
    "#             if not data:\n",
    "#                 assert len(tempQuestion[0]) != 0 and len(tempQuestion[1]) != 0\n",
    "#                 questionDict[title].append(tempQuestion)\n",
    "#                 tempQuestion = ['', '', '']\n",
    "#                 index = 0\n",
    "#                 data = f.readline().strip()\n",
    "#     assert len(questionDict[title]) != 0\n",
    "#     print(len(questionDict[title]))\n",
    "# utils.UpdateJson(questionDict, f'./plugins/custom_data/question.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "职业等级  熟练加值  武艺  气  无甲移动  职业特性\n",
      "1st  +2  1d4  -  -  无甲防御，武艺\n",
      "2nd  +2  1d4  2  +10尺  气，无甲移动\n",
      "3rd  +2  1d4  3  +10尺  选择宗派，拨挡飞弹\n",
      "4th  +2  1d4  4  +10尺  属性值提升，轻身坠\n",
      "5th  +3  1d6  5  +10尺  额外攻击，震慑拳\n",
      "6th  +3  1d6  6  +15尺  真气驻拳，宗派特性\n",
      "7th  +3  1d6  7  +15尺  反射闪避，心如止水\n",
      "8th  +3  1d6  8  +15尺  属性值提升\n",
      "9th  +4  1d6  9  +15尺  无甲移动增效\n",
      "10th  +4  1d6  10  +20尺  百病不侵\n",
      "11th  +4  1d8  11  +20尺  宗派特性\n",
      "12th  +4  1d8  12  +20尺  属性值提升\n",
      "13th  +5  1d8  13  +20尺  天语通\n",
      "14th  +5  1d8  14  +25尺  金刚魂\n",
      "15th  +5  1d8  15  +25尺  不朽身\n",
      "16th  +5  1d8  16  +25尺  属性值提升\n",
      "17th  +6  1d10  17  +25尺  宗派特性\n",
      "18th  +6  1d10  18  +30尺  空灵体\n",
      "19th  +6  1d10  19  +30尺  属性值提升\n",
      "20th  +6  1d10  20  +30尺  超凡入圣\n",
      "\n"
     ]
    }
   ],
   "source": [
    "## # 将chm表格排版\n",
    "fileName = '职业表'\n",
    "result = ''\n",
    "indexRange = list(range(0,99)) #+[0]\n",
    "index = 0\n",
    "# split = '    '\n",
    "# split = '/'\n",
    "split = '  '\n",
    "with open(f'../资料/{fileName}.txt', 'r', encoding=\"utf-8-sig\") as f:\n",
    "    data = f.readline().strip()\n",
    "    while data:\n",
    "        if index in indexRange:\n",
    "            result += data + split\n",
    "        index += 1\n",
    "        data = f.readline().strip()\n",
    "        if data == '':\n",
    "            data = f.readline().strip()\n",
    "            result = result[:-1].strip() + '\\n'\n",
    "            index = 0\n",
    "result = result.replace('—', '-')\n",
    "print(result)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}