This is the IPython notebook for fetching and cleaning backlinks data for Windeln so that we can futher analyze the referral sites behind Windeln.de.

backlinks

{"nbformat_minor": 0, "cells": [{"source": "#Windeln Backlinks Data", "cell_type": "markdown", "metadata": {}}, {"source": "The script is for fetching and cleaning backlinks data for Windeln so that we can futher analyze the referral sites behind Windeln.de.", "cell_type": "markdown", "metadata": {}}, {"execution_count": 1, "cell_type": "code", "source": "from urlparse import urlparse\nfrom lxml import etree\nimport json\nimport re\nimport os\n\nimport requests\nfrom bs4 import BeautifulSoup\nfrom pandas import *\nimport numpy as np\nimport matplotlib.pyplot as plt\nimport seaborn as sns\n\n%matplotlib inline", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}, {"source": "##Backlinks Data", "cell_type": "markdown", "metadata": {}}, {"source": "The data is downloaded from http://webmeup.com/.", "cell_type": "markdown", "metadata": {}}, {"execution_count": 3, "cell_type": "code", "source": "# data downloaded from http://webmeup.com/\nfpath = 'C:/workspace/analysis_reporting/joe/milk_china/windeln.de-1430237039144.csv'\n\ndf = read_csv(fpath, encoding='utf-16', sep='\\t')\ndf.columns = [\n    'source_url','source_title','anchor_url','anchor_text',\n    'is_text','nofollow','linking_domain_country','linking_domain_ip','check_date','first_seen'\n]\ndf['source_domain'] = df.source_url.apply(lambda x: urlparse(x).netloc)\ndf['source_path'] = df.source_url.apply(lambda x: urlparse(x).path)\ndf['anchor_path'] = df.anchor_url.apply(lambda x: urlparse(x).path)\ndf['anchor_domain'] = df.anchor_url.apply(lambda x: urlparse(x).netloc)", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 4, "cell_type": "code", "source": "df_cn = df[(df.linking_domain_country=='cn') & (df['anchor_domain']=='www.windeln.de')]", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 5, "cell_type": "code", "source": "print df.shape", "outputs": [{"output_type": "stream", "name": "stdout", "text": "(214827, 14)\n"}], "metadata": {"collapsed": false, "trusted": true}}, {"source": "##Traffic Data of Linked Site", "cell_type": "markdown", "metadata": {}}, {"source": "As we know, the number of backlinks doesn't necessarily correlate with the actual referral traffic. \n\nTherefore, we need to evaluate the overall site ranking / traffic / influnce of the each website. \n\nWe can use Alexa for each source domain. http://data.alexa.com/data?cli=10&url={domain}. ", "cell_type": "markdown", "metadata": {}}, {"execution_count": 5, "cell_type": "code", "source": "def get_alexa_rank(domain):\n    def get_attr(path, attr, default):\n        return tree.find(path).attrib[attr] if tree.find(path) is not None else default\n    \n    res_default = {\n        'alexa_domain': domain,\n        'alexa_gl_rank': -1,\n        'alexa_cc_rank': -1,\n        'alexa_cc': -1\n    }\n    \n    try:\n        url = 'http://data.alexa.com/data?cli=10&url={0}'.format(domain)\n#         url = 'http://www.alexa.com/siteinfo/{0}'.format(domain)\n    except Exception, err:\n        return res_default, None\n    \n    sc = 0\n    err_count = 0\n    while err_count < 2:\n        try:\n            r = requests.get(url)\n            sc = r.status_code\n            \n            tree = etree.XML(r.content)\n            cc_rank = int(get_attr('SD/COUNTRY', 'RANK', -1))\n            gl_rank = int(get_attr('SD/REACH', 'RANK', -1))\n            cc = get_attr('SD/COUNTRY', 'CODE', '')\n            title = get_attr('DMOZ/SITE', 'TITLE', '')\n            desc = get_attr('DMOZ/SITE', 'DESC', '')\n            \n            if ((title == '') or (desc == '')) and (0 < cc_rank < 10000):\n                title, desc = fetch_meta(domain)\n    \n            return {\n                'alexa_domain': domain,\n                'alexa_cc_rank': cc_rank,\n                'alexa_gl_rank': gl_rank,\n                'alexa_cc': cc,\n                'alexa_title': title,\n                'alexa_title_en': translate(title) if title != '' else '',\n                'alexa_desc': desc,\n                'alexa_desc_en': translate(desc) if desc != '' else '',\n            }, r\n        \n        except Exception, err:\n            print err\n            err_count += 1\n            \n    return res_default, r\n\ndef fetch_meta(url):\n    if re.search('http', url) is None:\n        url = 'http://' + url\n    try:\n        r = requests.get(url)\n    except Exception, err:\n        print err\n        return ''\n    if r.status_code==200:\n        soup = BeautifulSoup(r.content)\n        try:\n            return soup.select('meta[name=\"description\"]')[0]['content'], soup.select('title')[0].text\n        except Exception, err:\n            return '', ''\n    else:\n        return '', ''\n\n    \ndef translate(t):\n    api_key = 'trnsl.1.1.20150429T194039Z.49a0abddd64a0760.b4a75adeabde25bb28d0fe58ad10f3ee994fcf6b'\n    url = u'https://translate.yandex.net/api/v1.5/tr.json/translate?key={0}&lang=zh-en&text={1}'\\\n        .format(api_key, t)\n    try:\n        r = requests.get(url)\n        if r.status_code == 200:\n            data = json.loads(r.content)\n            return data.get('text')[0] if data.get('text') is not None else ''\n        else:\n            return ''\n    except Exception, err:\n        print err\n        return ''\n\n    \ndef is_thread(url):\n    return re.search('thread|forum|community', url) is not None\n            \n    \ndef get_thread_stats(url):\n    def get_num(pat):\n        m = re.search(pat, raw)\n        if m is not None:\n            n = m.groups()[0]\n            try:\n                return int(n)\n            except Exception, err:\n                return n\n        return None\n    \n    pat_views = u'(?:\u67e5\u770b|\u6d4f\u89c8)(?:: ?)(\\d+)'\n    pat_replies = u'(?:\u56de\u590d)(?:: ?)(\\d+)'\n    global r\n    if is_thread(url):\n        try:\n            r = requests.get(url)\n        except Exception, err:\n            return None\n        \n        if r.status_code == 200:\n            soup = BeautifulSoup(r.content)\n            raw = soup.text\n            \n            views = get_num(pat_views)\n            replies = get_num(pat_replies)\n            \n            return {\n                'views': views,\n                'replies': replies,\n                'soup': soup,\n            }\n            \n    return None\n\ndef get_connection_links(soup, domains):\n    links = []\n    for a in soup.select('a'):\n        href = a.get('href')\n        try:\n            p = urlparse(href)\n        except:\n            return links\n        if p is not None and p.netloc in domains:\n            links.append(href)\n    return links\n            \ndef has_promotion(soup):\n    m = re.search('\u4f18\u60e0\u7801', soup.text)\n    return m is not None\n\ndef output(df):\n    for c in df.columns:\n        try:\n            df.ix[:,c] = df.ix[:, c].apply(lambda x: re.sub('[\\n\\r]',' ', x))\n        except:\n            pass\n        \n    df.to_csv('C:/workspace/analysis_reporting/joe/milk_china/anchor_urls.csv', sep='\\t', encoding='utf-8')\n    df.sort('alexa_cc_rank',ascending=1)\\\n    .ix[:,['alexa_cc_rank','source_domain', \n           'alexa_title','alexa_desc', \n           'alexa_title_en','alexa_desc_en']].drop_duplicates()\\\n        .to_csv('C:/workspace/analysis_reporting/joe/milk_china/anchor_domain.csv', sep='\\t', encoding='utf-8')", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 6, "cell_type": "code", "source": "fpath = 'df_rank_cn.csv'\nif not os.path.exists(fpath):\n    domain_rank_cn = []\n    for i, sd in enumerate(df_cn.source_domain.unique()):\n        res, resp = get_alexa_rank(sd)\n        domain_rank_cn.append(res)\n\n        if i > 0 and not (i % 10):\n            try:\n                print '{1} processed {0}. res: {2}'.format(sd, i, json.dumps(res))\n            except:\n                print '{1} processed {0}. res:'.format('', i, json.dumps(res))\n    df_rank_cn = DataFrame(domain_rank_cn)\n    df_rank_cn.to_csv(fpath,index=0, encoding='utf-8')\nelse:\n    df_rank_cn = read_csv(fpath)\n                ", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 7, "cell_type": "code", "source": "# join the alexa data with backlinks data frame\ndf_cn_ = merge(\n    df_cn,\n    df_rank_cn,\n    left_on='source_domain',\n    right_on='alexa_domain',\n    how='left'\n)", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}, {"source": "We don't care about the source domains with no China rank (which means they are not influential). \n\nLet's filter them out.", "cell_type": "markdown", "metadata": {}}, {"execution_count": 9, "cell_type": "code", "source": "df_cn2 = df_cn_[df_cn_['alexa_cc_rank']!=-1]  # get all source urls with CN ranking\ndf_cn2.sort('alexa_cc_rank',ascending=1)\\\n    .ix[:,['alexa_cc_rank','source_domain', \n           'alexa_title','alexa_desc',\n           'alexa_title_en','alexa_desc_en']].drop_duplicates()", "outputs": [{"execution_count": 9, "output_type": "execute_result", "data": {"text/plain": "       alexa_cc_rank          source_domain  \\\n70992             21           g.alipay.com   \n70223             26   best.pconline.com.cn   \n21903             28      dongxi.douban.com   \n166               50       www.babytree.com   \n70514             82       bbs.haiwainet.cn   \n79029            178          www.huihui.cn   \n70377            204             www.boc.cn   \n299              213      home.qqbaobao.com   \n72969            232          www.ebrun.com   \n400              236          www.mgpyh.com   \n75569            360       www.letsebuy.com   \n78692            405       www.55haitao.com   \n70432            508          bbs.55bbs.com   \n71679            513        bbs.bozhong.com   \n70933            513       riji.bozhong.com   \n251              529         bbs.seedit.com   \n78953            605           guangdiu.com   \n70214            622         forum.51nb.com   \n79952            656           www.deyi.com   \n157              753           bbs.8080.net   \n70759            758      www.haitaobei.com   \n36362            803    bbs.fobshanghai.com   \n71450            806      www.123haitao.com   \n413             1003          www.ebama.net   \n70637           1032         we.walatao.com   \n22638           1065         bbs.ahlife.com   \n16554           1436            www.020.com   \n70537           1487         www.gzmama.com   \n70481           1570      bbs.rebatesme.com   \n77751           1580         www.buytong.cn   \n...              ...                    ...   \n70247          22732       woliwowai.com.cn   \n79951          22785          bbs.wfits.com   \n70751          23119      www.buluanmai.com   \n71808          23251      bbs.shunderen.com   \n77426          23650        superhaitao.com   \n71732          23650    www.superhaitao.com   \n71323          23904           bbs.3uol.com   \n71428          23975          www.90792.com   \n8031           24435          ebuybible.com   \n70667          24435      www.ebuybible.com   \n70286          25932         zhengpinle.com   \n78594          26597      www.zhbaby.com.cn   \n79620          26597          zhbaby.com.cn   \n79961          26993       www.9iyouhui.com   \n18562          27738         www.symama.com   \n70981          29926           www.ht51.com   \n70891          29965     www.easyhaitao.com   \n71425          30976      www.axoeurope.com   \n22341          31313         www.wxmama.com   \n70574          34972        www.178good.com   \n270            37583      www.jmmama.com.cn   \n70262          38707           hao.yqie.com   \n44218          41147    shopping.ladymax.cn   \n70784          43437         www.csmama.net   \n70844          43606        www.herebbs.com   \n116            43606            herebbs.com   \n71080          49894          www.hack6.com   \n71479         767521         www.shmama.net   \n8936             NaN          \uff57\uff57\uff57.\uff44\uff44\uff12\uff18\uff18.\uff43\uff4f\uff4d   \n70489            NaN  www.bank\uff0dof\uff0dchina.com   \n\n                                             alexa_title  \\\n70992                                         Alipay.com   \n70223                                             \u592a\u5e73\u6d0b\u7535\u8111\u7f51   \n21903                                                 \u8c46\u74e3   \n166                                                  \u5b9d\u5b9d\u6811   \n70514                                                \u6d77\u5916\u7f51   \n79029                                                \u60e0\u60e0\u7f51   \n70377                                               \u4e2d\u56fd\u94f6\u884c   \n299                                        \u80b2\u513f\u793e\u533a ,\u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b   \n72969                                               \u4ebf\u90a6\u52a8\u529b   \n400    \u4e70\u4e2a\u4fbf\u5b9c\u8d27\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u81f4\u529b\u4e8e\u63d0\u4f9b\u6700\u9760\u8c31\u7684\u6d77\u6dd8\u3001\u56fd\u5185\u8d2d\u7269\u4f18\u60e0\u8d44\u8baf\u3001\u6c47\u96c6\u6570\u5341\u4e07\u7f51\u53cb\u7684\u667a\u6167\uff0c\u5206\u4eab\u771f...   \n75569                                                \u95e8\u6237    \n78692  55\u6d77\u6dd8\u7f51\u662f\u76ee\u524d\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u4e13\u4e1a\u6d77\u6dd8\u7ad9\uff0c\u5305\u62ec\u7f8e\u56fd\u4e3b\u6d41\u7684\u6d77\u6dd8\u7f51\u7ad9\uff0c\u8be6\u5c3d\u7684\u6d77\u6dd8\u7f51\u5740\u5927\u5168\uff0c\u66f4\u662f\u76ee\u524d...   \n70432                                               \u6211\u7231\u6253\u6298   \n71679                                                \u64ad\u79cd\u7f51   \n70933                                                \u64ad\u79cd\u7f51   \n251                                                  \u64ad\u79cd\u7f51   \n78953  \u6700\u5168\u7684\u5b9e\u65f6\u6298\u6263\u805a\u5408\uff0c\u6c47\u805a\u4e86\u4ec0\u4e48\u503c\u5f97\u4e70\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u3001\u6298800\u3001\u60e0\u60e0\u7f51\u3001\u5317\u7f8e\u7701\u94b1\u5feb\u62a5\u3001360\u7279\u60e0...   \n70214                                                \u4e13\u95e8\u7f51   \n79952  \u5f97\u610f\u751f\u6d3b(deyi.com)\u662f\u6b66\u6c49\u6700\u5927\u7684\u672c\u5730\u751f\u6d3b\u4ea4\u6d41\u4e0e\u670d\u52a1\u5e73\u53f0,\u63d0\u4f9b\u6700\u65b0\u6700\u5168\u7684\u6b66\u6c49\u6253\u6298\u3001\u6b66\u6c49...   \n157                                                  \u6781\u901f\u7f51   \n70759                                       \u6d77\u6dd8\u8d1d-\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u793e\u533a   \n36362                                 FOB Business Forum   \n71450  \u6781\u5ba2\u6d77\u6dd8\uff08123haitao.com\uff09\uff0c\u662f\u4ee5\u54c1\u8d28\u751f\u6d3b\u4e3a\u4e3b\u9898\u7684\u8d2d\u7269\u5206\u4eab\u5f00\u653e\u793e\u533a\uff0c\u9f13\u52b1\u6bcf\u4e00\u4e2a\u7f51\u53cb...   \n413                                                  \u9996\u9875    \n70637  \u74e6\u62c9\u6dd8\u662f\u4e00\u6b3e\u81f4\u529b\u4e8e\u8ba9\u4f60\u6d77\u6dd8\u66f4\u4fbf\u6377\u7684\u6d4f\u89c8\u5668\u63d2\u4ef6\uff0c\u7b80\u5316\u6d77\u6dd8\u8d2d\u7269\u6d41\u7a0b\uff0c\u63d0\u4f9b\u8bf8\u591a\u5b9e\u7528\u5c0f\u5de5\u5177\uff0c\u5982\uff1a\u5168\u6587...   \n22638  \u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\uff0cTOGO\u8bba\u575b\u662f\u5408\u80a5\u6210\u7acb\u8f83\u65e9\u7684\uff0c2003\u5e74\u4fbf\u6210\u7acb\u4e86\u3002\u662f\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\u6700\u5927\u7684\u751f\u6d3b...   \n16554                                                \u5e7f\u5dde\u7f51   \n70537  \u5e7f\u5dde\u5988\u5988\u7f51\uff1a\u5e7f\u5dde\u5988\u5988\u9996\u9009\u7684\u5907\u5b55\u3001\u6000\u5b55\u3001\u80b2\u513f\u3001\u65e9\u6559\u7b49\u80b2\u513f\u4ea4\u6d41\u5e73\u53f0\uff0c\u6c47\u96c6\u5e7f\u5dde\u7f8e\u98df\u3001\u8d2d\u7269\u3001\u60c5\u611f\u3001\u751f...   \n70481  RebatesMe\u6d77\u6dd8\u8bba\u575b\u662f\u4e00\u4e2a\u5185\u5bb9\u4e30\u5bcc\u7684\u6d77\u6dd8\u4ea4\u6d41\u5e73\u53f0\uff0c\u4e3a\u60a8\u63d0\u4f9b\u6d77\u6dd8\u6559\u7a0b\u3001\u6d77\u6dd8\u653b\u7565\u3001\u6d77\u6dd8\u5546\u5bb6...   \n77751                                                NaN   \n...                                                  ...   \n70247                                                NaN   \n79951                                               \u6f4d\u574a\u8bba\u575b   \n70751                                            \u4e0d\u4e71\u4e70\u540d\u54c1\u8d2d\u7269   \n71808                                              \u987a\u5fb7\u4eba\u7f51\u7ad9   \n77426                                                NaN   \n71732                                                NaN   \n71323                                               \u4e09\u4f18\u4e4b\u5bb6   \n71428                                                NaN   \n8031                                                 NaN   \n70667                                                NaN   \n70286                                                NaN   \n78594                                                NaN   \n79620                                                NaN   \n79961                                                NaN   \n18562                                                NaN   \n70981                                                NaN   \n70891                                                NaN   \n71425                                                NaN   \n22341                                                NaN   \n70574                                                NaN   \n270                                                \u6c5f\u95e8\u5988\u5988\u7f51   \n70262                                                NaN   \n44218                                         Ladymax\u5973\u6027\u7f51   \n70784                                                NaN   \n70844                                                NaN   \n116                                                  NaN   \n71080                                                NaN   \n71479                                                NaN   \n8936                                                 NaN   \n70489                                                NaN   \n\n                                              alexa_desc  \\\n70992  Launched in 2004, Alipay is China's leading th...   \n70223                        \u63d0\u4f9b\u7535\u8111\u4ea7\u54c1\u4ecb\u7ecd\u3001\u4ef7\u683c\u4fe1\u606f\u3001\u4f01\u4e1a\u540d\u5f55\u53ca\u7535\u8111\u77e5\u8bc6\u548c\u65b0\u95fb\u3002   \n21903  Douban.com is a multi-products web platform wh...   \n166    \u4e2d\u56fd\u6700\u5927\u7684\u80b2\u513f\u7f51\u7ad9\u793e\u533a\uff0c\u63d0\u4f9b\u80b2\u513f\u535a\u5ba2\u300110G\u8d85\u5927\u7a7a\u95f4\u514d\u8d39\u7535\u5b50\u76f8\u518c\u3001\u5728\u7ebf\u4ea4\u6d41\u80b2\u513f\u8bba\u575b\u7b49\u670d\u52a1\uff0c\u4e3a...   \n70514  \u6d77\u5916\u7f51\u662f\u4eba\u6c11\u65e5\u62a5\u6d77\u5916\u7248\u6570\u5b57\u5316\u8f6c\u578b\u5efa\u8bbe\u7684\u6838\u5fc3\u5185\u5bb9\u548c\u91cd\u8981\u652f\u6491\u5e73\u53f0\u3002\u6d77\u5916\u7248\u901a\u8fc7\u6570\u5b57\u5316\u8f6c\u578b\uff0c\u5c06\u9010\u6b65\u6784...   \n79029              \u7f51\u6613\u65d7\u4e0b\u8d2d\u7269\u641c\u7d22\u548c\u7f51\u8d2d\u63a8\u8350\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e3b\u6d41\u8d2d\u7269\u7f51\u7ad9\u7684\u5546\u54c1\u6bd4\u4ef7\u548c\u8d2d\u7269\u8fd4\u73b0\u670d\u52a1\u3002   \n70377  \u4e2d\u56fd\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff0c\u56fd\u6709\u63a7\u80a1\u91d1\u878d\u673a\u6784\uff0c\u4e1a\u52a1\u8303\u56f4\u6db5\u76d6\u5546\u4e1a\u94f6\u884c\u3001\u6295\u8d44\u94f6\u884c\u548c\u4fdd\u9669\u9886\u57df\uff0c\u65d7\u4e0b\u6709\u4e2d\u94f6...   \n299                                    \u80b2\u513f\u793e\u533a - \u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b -    \n72969  \u4e2d\u56fd\u6700\u5927\u7684\u7535\u5b50\u5546\u52a1\u7f51\u7edc\u5a92\u4f53\uff0c\u4e3a\u505a\u7535\u5b50\u5546\u52a1\u7684\u4f01\u4e1a\u3001\u7535\u5546\u7ecf\u7406\u4eba\uff0c\u6bcf\u65e5\u63d0\u4f9b\u7535\u5546\u884c\u4e1a\u7684\u516c\u53f8\u3001\u4eba\u7269\u3001\u653f...   \n400              \\r\\n        \\r\\n\\t       \u4e70\u4e2a\u4fbf\u5b9c\u8d27\uff1a\u4e70\u5f97\u5230\u7684\u7f8e\u597d\u751f\u6d3b   \n75569  \u6d77\u6dd8\u7f51\u7ad9_\u6d77\u5916\u4ee3\u8d2d\u7f51\u7ad9_\u6d77\u6dd8\u653b\u7565_\u6d77\u6dd8_\u7f51\u4e0a\u4ee3\u8d2d_\u5c3d\u5728\u6d77\u5916E\u8d2d-letsebuy\u5b98\u7f51 -  ...   \n78692                    \u6d77\u6dd8\u7f51\u7ad9-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u65cf\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u6d77\u6dd8\u8fd4\u5229\u7f51\u7ad9|55\u6d77\u6dd8\u7f51   \n70432                      \u8d2d\u7269\u3001\u7f8e\u98df\u3001\u5a31\u4e50\u3001\u4e3d\u4eba\u2026\u2026\u6700\u5177\u4eba\u6c14\u7684\u751f\u6d3b\u6d88\u8d39\u8d44\u8baf\u5206\u4eab\u793e\u533a\u3002   \n71679  \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...   \n70933  \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...   \n251    \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...   \n78953                                      \u901b\u4e22 | \u5b9e\u65f6\u540c\u6b65\u5168\u7f51\u6298\u6263   \n70214                                     \u4e13\u4e1a\u7684\u7b14\u8bb0\u672c\u7535\u8111\u6280\u672f\u4ea4\u6d41\u7f51\u7ad9   \n79952                            \u5f97\u610f\u751f\u6d3b_\u6b66\u6c49\u751f\u6d3b\u6d88\u8d39\u793e\u533a_\u6b66\u6c49\u8bba\u575b_\u6b66\u6c49\u6253\u6298   \n157                  \u534e\u4e1c\u5730\u533a\u6700\u5177\u5546\u4e1a\u4ef7\u503cIT\u95e8\u6237\u7f51\u7ad9\uff0c\u7acb\u8db3\u5357\u4eac\u653e\u773c\u5168\u7403\uff0c\u8d34\u8fd1\u5e02\u573a\u5f70\u663e\u4e13\u4e1a\u3002   \n70759  \u6d77\u6dd8\u8d1d\u662f\u4e00\u5bb6\u57fa\u4e8eSNS\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u4ea4\u6d41\u7f51\u7ad9\u3002\u5728\u6d77\u6dd8\u8d1d\u4f60\u53ef\u4ee5\u5c55\u793a\u8fbe\u4eba\u98ce\u91c7\uff0c\u5206\u4eab\u6d77\u6dd8\u5b9d\u8d1d\uff0c\u4ea4\u6d41\u6700...   \n36362  Business Forum with information on Chinese and...   \n71450                                    \u6781\u5ba2\u6d77\u6dd8\uff0c\u5c5e\u4e8e\u4f60\u7684\u8d2d\u7269\u5206\u4eab\u793e\u533a   \n413                    \u7231\u5b69\u5b50,\u7231\u4e0a\u7238\u5988\u7f51-\u5e7c\u513f\u82f1\u8bed|\u5c11\u513f\u82f1\u8bed|\u513f\u7ae5\u82f1\u8bed|\u513f\u7ae5\u6559\u80b2 -     \n70637                                           \u6d77\u6dd8\u767e\u79d1_\u74e6\u62c9\u6dd8   \n22638                \u5408\u80a5\u8bba\u575b_TOGO\u8bba\u575b_\u5b89\u5fbd\u751f\u6d3b\u7f51\u8bba\u575b_\u7cbe\u81f4\u751f\u6d3b \u5c3d\u5728\u5b89\u5fbd\u751f\u6d3b\u7f51 -    \n16554                           \u5e7f\u5dde\u7f51\u793e\u533a\u63d0\u4f9b\u5a5a\u5ac1\u3001\u5bb6\u5c45\u3001\u7f8e\u98df\u3001\u623f\u4ea7\u7b49\u8ba8\u8bba\u4ea4\u6d41\u3002   \n70537                  \u5e7f\u5dde\u5988\u5988\u7f51_\u5b98\u65b9\u7f51\u7ad9\uff0c\u5e7f\u5dde\u5988\u5988\u9996\u9009\u80b2\u513f\u3001\u751f\u6d3b\u7b49\u4ea4\u6d41\u4e92\u52a8\u793e\u533a -     \n70481         RebatesMe\u6d77\u6dd8\u8bba\u575b|\u6d77\u6dd8\u4ea4\u6d41-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u4f18\u60e0-\u6d77\u6dd8\u653b\u7565\u52a9\u60a8\u8f7b\u677e\u6d77\u6dd8 -    \n77751                                                NaN   \n...                                                  ...   \n70247                                                NaN   \n79951          \u672c\u5730\u8bba\u575b\uff0c\u8bbe\u6709\u6f4d\u574a\u751f\u6d3b\u3001\u5403\u904d\u6f4d\u574a\u3001\u539f\u521b\u6444\u5f71\u3001\u6f4d\u574a\u5546\u4e1a\u8857\u3001\u4ea4\u53cb\u5929\u5730\u3001\u60c5\u611f\u5929\u7a7a\u7b49\u677f\u5757\u3002   \n70751  \u4e0d\u4e71\u4e70(www.buluanmai.com)\u662f\u4e00\u4e2a\u5168\u4e2d\u6587\u7684\u65f6\u5c1a\u6d77\u6dd8\u5bfc\u8d2d\u7f51\u7ad9\u3002\u8fd9\u91cc\u6c47\u96c6\u4e86100...   \n71808                                        \u4e00\u4e2a\u987a\u5fb7\u4eba\u7684\u7efc\u5408\u793e\u533a\u3002   \n77426                                                NaN   \n71732                                                NaN   \n71323  \u201c\u4e09\u4f18\u201d\u5373\u4f18\u751f\u3001\u4f18\u80b2\u3001\u4f18\u6559\u3002\u4e09\u4f18\u4e4b\u5bb6\u7f51\uff0c\u662f\u9762\u5411\u5168\u56fd\u5b55\u4ea7\u80b2\u513f\u4eba\u7fa4\u63d0\u4f9b\u4e13\u4e1a\u4f18\u751f\u4f18\u80b2\u670d\u52a1\u7684\u5927\u578b\u793e\u533a...   \n71428                                                NaN   \n8031                                                 NaN   \n70667                                                NaN   \n70286                                                NaN   \n78594                                                NaN   \n79620                                                NaN   \n79961                                                NaN   \n18562                                                NaN   \n70981                                                NaN   \n70891                                                NaN   \n71425                                                NaN   \n22341                                                NaN   \n70574                                                NaN   \n270    \u6c5f\u95e8\u5988\u5988\u7f51\u662f\u5173\u4e8e\u5bb6\u5ead\u751f\u6d3b\u3001\u4eb2\u5b50\u80b2\u513f\u3001\u5a5a\u59fb\u5bb6\u5ead\u3001\u5de5\u4f5c\u60c5\u611f\u3001\u6000\u5b55\u54a8\u8be2\u7684\u4e92\u52a9\u4e92\u52a8\u793e\u533a\uff0c\u96c6\u805a\u4f1a\u6d3b\u52a8\u3001...   \n70262                                                NaN   \n44218                 \u4e13\u4e1a\u5973\u6027\u65f6\u5c1a\u7f51\u7ad9\u3002\u6700\u7231\u5206\u4eab \u65f6\u5c1a\u8d2d\u7269\u5165\u53e3 \u5305\u62ec\u7f8e\u5bb9 \u670d\u9970\u642d\u914d\u7b49\u8d44\u8baf\u3002   \n70784                                                NaN   \n70844                                                NaN   \n116                                                  NaN   \n71080                                                NaN   \n71479                                                NaN   \n8936                                                 NaN   \n70489                                                NaN   \n\n                                          alexa_title_en  \\\n70992                                         Alipay.com   \n70223                           Pacific computer network   \n21903                                               Bean   \n166                                        The baby tree   \n70514                                   Overseas network   \n79029                          Benefits benefits network   \n70377                                         China Bank   \n299    Childcare community ,my precious Internet pare...   \n72969                              Million Federal power   \n400    Buy cheap United States, cheap committed to pr...   \n75569                                            Portal    \n78692  55 sea phase network is by far the most trustw...   \n70432                                  I love a discount   \n71679                                   The seed network   \n70933                                   The seed network   \n251                                     The seed network   \n78953  Best real-time discounts cohesion, bringing to...   \n70214                                      Dedicated web   \n79952  Get a life(deyi. com)is Wuhan's largest local ...   \n157                                        Speed network   \n70759    Sea phase.-sea-going shopping sharing community   \n36362                                 FOB Business Forum   \n71450  The geek, the sea phase (the 123haitao. com), ...   \n413                                   On the first page    \n70637  The phase is a commitment to make your sea pha...   \n22638  Hefei Forum website, TOGO Forum is the fat est...   \n16554                                  Guangzhou network   \n70537  Guangzhou mother network: Guangzhou, mom's fir...   \n70481  RebatesMe sea phase Forum is a content-rich se...   \n77751                                                NaN   \n...                                                  ...   \n70247                                                NaN   \n79951                                       \u6f4d mill Forum   \n70751                  Don't buy name products, shopping   \n71808                                  By German website   \n77426                                                NaN   \n71732                                                NaN   \n71323                                         Three home   \n71428                                                NaN   \n8031                                                 NaN   \n70667                                                NaN   \n70286                                                NaN   \n78594                                                NaN   \n79620                                                NaN   \n79961                                                NaN   \n18562                                                NaN   \n70981                                                NaN   \n70891                                                NaN   \n71425                                                NaN   \n22341                                                NaN   \n70574                                                NaN   \n270                               Jiang door mom network   \n70262                                                NaN   \n44218                             Ladymax female network   \n70784                                                NaN   \n70844                                                NaN   \n116                                                  NaN   \n71080                                                NaN   \n71479                                                NaN   \n8936                                                 NaN   \n70489                                                NaN   \n\n                                           alexa_desc_en  \n70992  Launched in 2004, Alipay is China's leading th...  \n70223  To provide a computer product profile, pricing...  \n21903  Douban.com is a multi-products web platform wh...  \n166    China's largest childcare website communities,...  \n70514  The overseas network of the People's daily ove...  \n79029  Web easy banner shopping search and online sho...  \n70377  China Bank, Inc., the holding financial instit...  \n299    Parenting community - my precious Internet par...  \n72969  China's largest e-Commerce Network Media, to e...  \n400                 \\r\\n\\r\\nBuy cheap: buy the good life  \n75569  Sea phase network Station-overseas purchased o...  \n78692  Sea-going website-the phase to return the-sea ...  \n70432  Shopping, food, entertainment, beautiful peopl...  \n71679  The seed network(bozhong. com)was created in 2...  \n70933  The seed network(bozhong. com)was created in 2...  \n251    The seed network(bozhong. com)was created in 2...  \n78953  Around lose | real-time synchronization of the...  \n70214    Professional laptop technology exchange website  \n79952  That life of _ Wuhan consumer communities _ Wu...  \n157    East China region the most commercial value of...  \n70759  The sea phase is a home-based SNS sea-going sh...  \n36362  Business Forum with information on Chinese and...  \n71450  Geek-sea phase of your shopping sharing community  \n413    Love the kid,love mom and dad web-kindergarten...  \n70637            Sea phase ENCYCLOPAEDIA of _ Vala phase  \n22638  Hefei Forum _TOGO Forum of _ of Anhui, live we...  \n16554  Guangzhou web community to provide marriage, f...  \n70537  Guangzhou mother network _ official website, G...  \n70481  RebatesMe sea-going Forum|sea-phase exchange-t...  \n77751                                                NaN  \n...                                                  ...  \n70247                                                NaN  \n79951  Local forum, there are \u6f4d mill life, eat \u6f4d mill...  \n70751  Don't buy(www. buluanmai. com)is one of the Ch...  \n71808                 One way of integrated communities.  \n77426                                                NaN  \n71732                                                NaN  \n71323  \u201cThe Big Three\u201dnamely, students, nurturing and...  \n71428                                                NaN  \n8031                                                 NaN  \n70667                                                NaN  \n70286                                                NaN  \n78594                                                NaN  \n79620                                                NaN  \n79961                                                NaN  \n18562                                                NaN  \n70981                                                NaN  \n70891                                                NaN  \n71425                                                NaN  \n22341                                                NaN  \n70574                                                NaN  \n270    Jiang door, mom network, on family life, paren...  \n70262                                                NaN  \n44218  Professional female fashion website. Most love...  \n70784                                                NaN  \n70844                                                NaN  \n116                                                  NaN  \n71080                                                NaN  \n71479                                                NaN  \n8936                                                 NaN  \n70489                                                NaN  \n\n[147 rows x 6 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>alexa_cc_rank</th>\n      <th>source_domain</th>\n      <th>alexa_title</th>\n      <th>alexa_desc</th>\n      <th>alexa_title_en</th>\n      <th>alexa_desc_en</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>70992</th>\n      <td>21</td>\n      <td>g.alipay.com</td>\n      <td>Alipay.com</td>\n      <td>Launched in 2004, Alipay is China's leading th...</td>\n      <td>Alipay.com</td>\n      <td>Launched in 2004, Alipay is China's leading th...</td>\n    </tr>\n    <tr>\n      <th>70223</th>\n      <td>26</td>\n      <td>best.pconline.com.cn</td>\n      <td>\u592a\u5e73\u6d0b\u7535\u8111\u7f51</td>\n      <td>\u63d0\u4f9b\u7535\u8111\u4ea7\u54c1\u4ecb\u7ecd\u3001\u4ef7\u683c\u4fe1\u606f\u3001\u4f01\u4e1a\u540d\u5f55\u53ca\u7535\u8111\u77e5\u8bc6\u548c\u65b0\u95fb\u3002</td>\n      <td>Pacific computer network</td>\n      <td>To provide a computer product profile, pricing...</td>\n    </tr>\n    <tr>\n      <th>21903</th>\n      <td>28</td>\n      <td>dongxi.douban.com</td>\n      <td>\u8c46\u74e3</td>\n      <td>Douban.com is a multi-products web platform wh...</td>\n      <td>Bean</td>\n      <td>Douban.com is a multi-products web platform wh...</td>\n    </tr>\n    <tr>\n      <th>166</th>\n      <td>50</td>\n      <td>www.babytree.com</td>\n      <td>\u5b9d\u5b9d\u6811</td>\n      <td>\u4e2d\u56fd\u6700\u5927\u7684\u80b2\u513f\u7f51\u7ad9\u793e\u533a\uff0c\u63d0\u4f9b\u80b2\u513f\u535a\u5ba2\u300110G\u8d85\u5927\u7a7a\u95f4\u514d\u8d39\u7535\u5b50\u76f8\u518c\u3001\u5728\u7ebf\u4ea4\u6d41\u80b2\u513f\u8bba\u575b\u7b49\u670d\u52a1\uff0c\u4e3a...</td>\n      <td>The baby tree</td>\n      <td>China's largest childcare website communities,...</td>\n    </tr>\n    <tr>\n      <th>70514</th>\n      <td>82</td>\n      <td>bbs.haiwainet.cn</td>\n      <td>\u6d77\u5916\u7f51</td>\n      <td>\u6d77\u5916\u7f51\u662f\u4eba\u6c11\u65e5\u62a5\u6d77\u5916\u7248\u6570\u5b57\u5316\u8f6c\u578b\u5efa\u8bbe\u7684\u6838\u5fc3\u5185\u5bb9\u548c\u91cd\u8981\u652f\u6491\u5e73\u53f0\u3002\u6d77\u5916\u7248\u901a\u8fc7\u6570\u5b57\u5316\u8f6c\u578b\uff0c\u5c06\u9010\u6b65\u6784...</td>\n      <td>Overseas network</td>\n      <td>The overseas network of the People's daily ove...</td>\n    </tr>\n    <tr>\n      <th>79029</th>\n      <td>178</td>\n      <td>www.huihui.cn</td>\n      <td>\u60e0\u60e0\u7f51</td>\n      <td>\u7f51\u6613\u65d7\u4e0b\u8d2d\u7269\u641c\u7d22\u548c\u7f51\u8d2d\u63a8\u8350\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e3b\u6d41\u8d2d\u7269\u7f51\u7ad9\u7684\u5546\u54c1\u6bd4\u4ef7\u548c\u8d2d\u7269\u8fd4\u73b0\u670d\u52a1\u3002</td>\n      <td>Benefits benefits network</td>\n      <td>Web easy banner shopping search and online sho...</td>\n    </tr>\n    <tr>\n      <th>70377</th>\n      <td>204</td>\n      <td>www.boc.cn</td>\n      <td>\u4e2d\u56fd\u94f6\u884c</td>\n      <td>\u4e2d\u56fd\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff0c\u56fd\u6709\u63a7\u80a1\u91d1\u878d\u673a\u6784\uff0c\u4e1a\u52a1\u8303\u56f4\u6db5\u76d6\u5546\u4e1a\u94f6\u884c\u3001\u6295\u8d44\u94f6\u884c\u548c\u4fdd\u9669\u9886\u57df\uff0c\u65d7\u4e0b\u6709\u4e2d\u94f6...</td>\n      <td>China Bank</td>\n      <td>China Bank, Inc., the holding financial instit...</td>\n    </tr>\n    <tr>\n      <th>299</th>\n      <td>213</td>\n      <td>home.qqbaobao.com</td>\n      <td>\u80b2\u513f\u793e\u533a ,\u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b</td>\n      <td>\u80b2\u513f\u793e\u533a - \u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b -</td>\n      <td>Childcare community ,my precious Internet pare...</td>\n      <td>Parenting community - my precious Internet par...</td>\n    </tr>\n    <tr>\n      <th>72969</th>\n      <td>232</td>\n      <td>www.ebrun.com</td>\n      <td>\u4ebf\u90a6\u52a8\u529b</td>\n      <td>\u4e2d\u56fd\u6700\u5927\u7684\u7535\u5b50\u5546\u52a1\u7f51\u7edc\u5a92\u4f53\uff0c\u4e3a\u505a\u7535\u5b50\u5546\u52a1\u7684\u4f01\u4e1a\u3001\u7535\u5546\u7ecf\u7406\u4eba\uff0c\u6bcf\u65e5\u63d0\u4f9b\u7535\u5546\u884c\u4e1a\u7684\u516c\u53f8\u3001\u4eba\u7269\u3001\u653f...</td>\n      <td>Million Federal power</td>\n      <td>China's largest e-Commerce Network Media, to e...</td>\n    </tr>\n    <tr>\n      <th>400</th>\n      <td>236</td>\n      <td>www.mgpyh.com</td>\n      <td>\u4e70\u4e2a\u4fbf\u5b9c\u8d27\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u81f4\u529b\u4e8e\u63d0\u4f9b\u6700\u9760\u8c31\u7684\u6d77\u6dd8\u3001\u56fd\u5185\u8d2d\u7269\u4f18\u60e0\u8d44\u8baf\u3001\u6c47\u96c6\u6570\u5341\u4e07\u7f51\u53cb\u7684\u667a\u6167\uff0c\u5206\u4eab\u771f...</td>\n      <td>\\r\\n        \\r\\n\\t       \u4e70\u4e2a\u4fbf\u5b9c\u8d27\uff1a\u4e70\u5f97\u5230\u7684\u7f8e\u597d\u751f\u6d3b</td>\n      <td>Buy cheap United States, cheap committed to pr...</td>\n      <td>\\r\\n\\r\\nBuy cheap: buy the good life</td>\n    </tr>\n    <tr>\n      <th>75569</th>\n      <td>360</td>\n      <td>www.letsebuy.com</td>\n      <td>\u95e8\u6237</td>\n      <td>\u6d77\u6dd8\u7f51\u7ad9_\u6d77\u5916\u4ee3\u8d2d\u7f51\u7ad9_\u6d77\u6dd8\u653b\u7565_\u6d77\u6dd8_\u7f51\u4e0a\u4ee3\u8d2d_\u5c3d\u5728\u6d77\u5916E\u8d2d-letsebuy\u5b98\u7f51 -  ...</td>\n      <td>Portal</td>\n      <td>Sea phase network Station-overseas purchased o...</td>\n    </tr>\n    <tr>\n      <th>78692</th>\n      <td>405</td>\n      <td>www.55haitao.com</td>\n      <td>55\u6d77\u6dd8\u7f51\u662f\u76ee\u524d\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u4e13\u4e1a\u6d77\u6dd8\u7ad9\uff0c\u5305\u62ec\u7f8e\u56fd\u4e3b\u6d41\u7684\u6d77\u6dd8\u7f51\u7ad9\uff0c\u8be6\u5c3d\u7684\u6d77\u6dd8\u7f51\u5740\u5927\u5168\uff0c\u66f4\u662f\u76ee\u524d...</td>\n      <td>\u6d77\u6dd8\u7f51\u7ad9-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u65cf\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u6d77\u6dd8\u8fd4\u5229\u7f51\u7ad9|55\u6d77\u6dd8\u7f51</td>\n      <td>55 sea phase network is by far the most trustw...</td>\n      <td>Sea-going website-the phase to return the-sea ...</td>\n    </tr>\n    <tr>\n      <th>70432</th>\n      <td>508</td>\n      <td>bbs.55bbs.com</td>\n      <td>\u6211\u7231\u6253\u6298</td>\n      <td>\u8d2d\u7269\u3001\u7f8e\u98df\u3001\u5a31\u4e50\u3001\u4e3d\u4eba\u2026\u2026\u6700\u5177\u4eba\u6c14\u7684\u751f\u6d3b\u6d88\u8d39\u8d44\u8baf\u5206\u4eab\u793e\u533a\u3002</td>\n      <td>I love a discount</td>\n      <td>Shopping, food, entertainment, beautiful peopl...</td>\n    </tr>\n    <tr>\n      <th>71679</th>\n      <td>513</td>\n      <td>bbs.bozhong.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n      <td>The seed network</td>\n      <td>The seed network(bozhong. com)was created in 2...</td>\n    </tr>\n    <tr>\n      <th>70933</th>\n      <td>513</td>\n      <td>riji.bozhong.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n      <td>The seed network</td>\n      <td>The seed network(bozhong. com)was created in 2...</td>\n    </tr>\n    <tr>\n      <th>251</th>\n      <td>529</td>\n      <td>bbs.seedit.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n      <td>The seed network</td>\n      <td>The seed network(bozhong. com)was created in 2...</td>\n    </tr>\n    <tr>\n      <th>78953</th>\n      <td>605</td>\n      <td>guangdiu.com</td>\n      <td>\u6700\u5168\u7684\u5b9e\u65f6\u6298\u6263\u805a\u5408\uff0c\u6c47\u805a\u4e86\u4ec0\u4e48\u503c\u5f97\u4e70\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u3001\u6298800\u3001\u60e0\u60e0\u7f51\u3001\u5317\u7f8e\u7701\u94b1\u5feb\u62a5\u3001360\u7279\u60e0...</td>\n      <td>\u901b\u4e22 | \u5b9e\u65f6\u540c\u6b65\u5168\u7f51\u6298\u6263</td>\n      <td>Best real-time discounts cohesion, bringing to...</td>\n      <td>Around lose | real-time synchronization of the...</td>\n    </tr>\n    <tr>\n      <th>70214</th>\n      <td>622</td>\n      <td>forum.51nb.com</td>\n      <td>\u4e13\u95e8\u7f51</td>\n      <td>\u4e13\u4e1a\u7684\u7b14\u8bb0\u672c\u7535\u8111\u6280\u672f\u4ea4\u6d41\u7f51\u7ad9</td>\n      <td>Dedicated web</td>\n      <td>Professional laptop technology exchange website</td>\n    </tr>\n    <tr>\n      <th>79952</th>\n      <td>656</td>\n      <td>www.deyi.com</td>\n      <td>\u5f97\u610f\u751f\u6d3b(deyi.com)\u662f\u6b66\u6c49\u6700\u5927\u7684\u672c\u5730\u751f\u6d3b\u4ea4\u6d41\u4e0e\u670d\u52a1\u5e73\u53f0,\u63d0\u4f9b\u6700\u65b0\u6700\u5168\u7684\u6b66\u6c49\u6253\u6298\u3001\u6b66\u6c49...</td>\n      <td>\u5f97\u610f\u751f\u6d3b_\u6b66\u6c49\u751f\u6d3b\u6d88\u8d39\u793e\u533a_\u6b66\u6c49\u8bba\u575b_\u6b66\u6c49\u6253\u6298</td>\n      <td>Get a life(deyi. com)is Wuhan's largest local ...</td>\n      <td>That life of _ Wuhan consumer communities _ Wu...</td>\n    </tr>\n    <tr>\n      <th>157</th>\n      <td>753</td>\n      <td>bbs.8080.net</td>\n      <td>\u6781\u901f\u7f51</td>\n      <td>\u534e\u4e1c\u5730\u533a\u6700\u5177\u5546\u4e1a\u4ef7\u503cIT\u95e8\u6237\u7f51\u7ad9\uff0c\u7acb\u8db3\u5357\u4eac\u653e\u773c\u5168\u7403\uff0c\u8d34\u8fd1\u5e02\u573a\u5f70\u663e\u4e13\u4e1a\u3002</td>\n      <td>Speed network</td>\n      <td>East China region the most commercial value of...</td>\n    </tr>\n    <tr>\n      <th>70759</th>\n      <td>758</td>\n      <td>www.haitaobei.com</td>\n      <td>\u6d77\u6dd8\u8d1d-\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u793e\u533a</td>\n      <td>\u6d77\u6dd8\u8d1d\u662f\u4e00\u5bb6\u57fa\u4e8eSNS\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u4ea4\u6d41\u7f51\u7ad9\u3002\u5728\u6d77\u6dd8\u8d1d\u4f60\u53ef\u4ee5\u5c55\u793a\u8fbe\u4eba\u98ce\u91c7\uff0c\u5206\u4eab\u6d77\u6dd8\u5b9d\u8d1d\uff0c\u4ea4\u6d41\u6700...</td>\n      <td>Sea phase.-sea-going shopping sharing community</td>\n      <td>The sea phase is a home-based SNS sea-going sh...</td>\n    </tr>\n    <tr>\n      <th>36362</th>\n      <td>803</td>\n      <td>bbs.fobshanghai.com</td>\n      <td>FOB Business Forum</td>\n      <td>Business Forum with information on Chinese and...</td>\n      <td>FOB Business Forum</td>\n      <td>Business Forum with information on Chinese and...</td>\n    </tr>\n    <tr>\n      <th>71450</th>\n      <td>806</td>\n      <td>www.123haitao.com</td>\n      <td>\u6781\u5ba2\u6d77\u6dd8\uff08123haitao.com\uff09\uff0c\u662f\u4ee5\u54c1\u8d28\u751f\u6d3b\u4e3a\u4e3b\u9898\u7684\u8d2d\u7269\u5206\u4eab\u5f00\u653e\u793e\u533a\uff0c\u9f13\u52b1\u6bcf\u4e00\u4e2a\u7f51\u53cb...</td>\n      <td>\u6781\u5ba2\u6d77\u6dd8\uff0c\u5c5e\u4e8e\u4f60\u7684\u8d2d\u7269\u5206\u4eab\u793e\u533a</td>\n      <td>The geek, the sea phase (the 123haitao. com), ...</td>\n      <td>Geek-sea phase of your shopping sharing community</td>\n    </tr>\n    <tr>\n      <th>413</th>\n      <td>1003</td>\n      <td>www.ebama.net</td>\n      <td>\u9996\u9875</td>\n      <td>\u7231\u5b69\u5b50,\u7231\u4e0a\u7238\u5988\u7f51-\u5e7c\u513f\u82f1\u8bed|\u5c11\u513f\u82f1\u8bed|\u513f\u7ae5\u82f1\u8bed|\u513f\u7ae5\u6559\u80b2 -</td>\n      <td>On the first page</td>\n      <td>Love the kid,love mom and dad web-kindergarten...</td>\n    </tr>\n    <tr>\n      <th>70637</th>\n      <td>1032</td>\n      <td>we.walatao.com</td>\n      <td>\u74e6\u62c9\u6dd8\u662f\u4e00\u6b3e\u81f4\u529b\u4e8e\u8ba9\u4f60\u6d77\u6dd8\u66f4\u4fbf\u6377\u7684\u6d4f\u89c8\u5668\u63d2\u4ef6\uff0c\u7b80\u5316\u6d77\u6dd8\u8d2d\u7269\u6d41\u7a0b\uff0c\u63d0\u4f9b\u8bf8\u591a\u5b9e\u7528\u5c0f\u5de5\u5177\uff0c\u5982\uff1a\u5168\u6587...</td>\n      <td>\u6d77\u6dd8\u767e\u79d1_\u74e6\u62c9\u6dd8</td>\n      <td>The phase is a commitment to make your sea pha...</td>\n      <td>Sea phase ENCYCLOPAEDIA of _ Vala phase</td>\n    </tr>\n    <tr>\n      <th>22638</th>\n      <td>1065</td>\n      <td>bbs.ahlife.com</td>\n      <td>\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\uff0cTOGO\u8bba\u575b\u662f\u5408\u80a5\u6210\u7acb\u8f83\u65e9\u7684\uff0c2003\u5e74\u4fbf\u6210\u7acb\u4e86\u3002\u662f\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\u6700\u5927\u7684\u751f\u6d3b...</td>\n      <td>\u5408\u80a5\u8bba\u575b_TOGO\u8bba\u575b_\u5b89\u5fbd\u751f\u6d3b\u7f51\u8bba\u575b_\u7cbe\u81f4\u751f\u6d3b \u5c3d\u5728\u5b89\u5fbd\u751f\u6d3b\u7f51 -</td>\n      <td>Hefei Forum website, TOGO Forum is the fat est...</td>\n      <td>Hefei Forum _TOGO Forum of _ of Anhui, live we...</td>\n    </tr>\n    <tr>\n      <th>16554</th>\n      <td>1436</td>\n      <td>www.020.com</td>\n      <td>\u5e7f\u5dde\u7f51</td>\n      <td>\u5e7f\u5dde\u7f51\u793e\u533a\u63d0\u4f9b\u5a5a\u5ac1\u3001\u5bb6\u5c45\u3001\u7f8e\u98df\u3001\u623f\u4ea7\u7b49\u8ba8\u8bba\u4ea4\u6d41\u3002</td>\n      <td>Guangzhou network</td>\n      <td>Guangzhou web community to provide marriage, f...</td>\n    </tr>\n    <tr>\n      <th>70537</th>\n      <td>1487</td>\n      <td>www.gzmama.com</td>\n      <td>\u5e7f\u5dde\u5988\u5988\u7f51\uff1a\u5e7f\u5dde\u5988\u5988\u9996\u9009\u7684\u5907\u5b55\u3001\u6000\u5b55\u3001\u80b2\u513f\u3001\u65e9\u6559\u7b49\u80b2\u513f\u4ea4\u6d41\u5e73\u53f0\uff0c\u6c47\u96c6\u5e7f\u5dde\u7f8e\u98df\u3001\u8d2d\u7269\u3001\u60c5\u611f\u3001\u751f...</td>\n      <td>\u5e7f\u5dde\u5988\u5988\u7f51_\u5b98\u65b9\u7f51\u7ad9\uff0c\u5e7f\u5dde\u5988\u5988\u9996\u9009\u80b2\u513f\u3001\u751f\u6d3b\u7b49\u4ea4\u6d41\u4e92\u52a8\u793e\u533a -</td>\n      <td>Guangzhou mother network: Guangzhou, mom's fir...</td>\n      <td>Guangzhou mother network _ official website, G...</td>\n    </tr>\n    <tr>\n      <th>70481</th>\n      <td>1570</td>\n      <td>bbs.rebatesme.com</td>\n      <td>RebatesMe\u6d77\u6dd8\u8bba\u575b\u662f\u4e00\u4e2a\u5185\u5bb9\u4e30\u5bcc\u7684\u6d77\u6dd8\u4ea4\u6d41\u5e73\u53f0\uff0c\u4e3a\u60a8\u63d0\u4f9b\u6d77\u6dd8\u6559\u7a0b\u3001\u6d77\u6dd8\u653b\u7565\u3001\u6d77\u6dd8\u5546\u5bb6...</td>\n      <td>RebatesMe\u6d77\u6dd8\u8bba\u575b|\u6d77\u6dd8\u4ea4\u6d41-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u4f18\u60e0-\u6d77\u6dd8\u653b\u7565\u52a9\u60a8\u8f7b\u677e\u6d77\u6dd8 -</td>\n      <td>RebatesMe sea phase Forum is a content-rich se...</td>\n      <td>RebatesMe sea-going Forum|sea-phase exchange-t...</td>\n    </tr>\n    <tr>\n      <th>77751</th>\n      <td>1580</td>\n      <td>www.buytong.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>70247</th>\n      <td>22732</td>\n      <td>woliwowai.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79951</th>\n      <td>22785</td>\n      <td>bbs.wfits.com</td>\n      <td>\u6f4d\u574a\u8bba\u575b</td>\n      <td>\u672c\u5730\u8bba\u575b\uff0c\u8bbe\u6709\u6f4d\u574a\u751f\u6d3b\u3001\u5403\u904d\u6f4d\u574a\u3001\u539f\u521b\u6444\u5f71\u3001\u6f4d\u574a\u5546\u4e1a\u8857\u3001\u4ea4\u53cb\u5929\u5730\u3001\u60c5\u611f\u5929\u7a7a\u7b49\u677f\u5757\u3002</td>\n      <td>\u6f4d mill Forum</td>\n      <td>Local forum, there are \u6f4d mill life, eat \u6f4d mill...</td>\n    </tr>\n    <tr>\n      <th>70751</th>\n      <td>23119</td>\n      <td>www.buluanmai.com</td>\n      <td>\u4e0d\u4e71\u4e70\u540d\u54c1\u8d2d\u7269</td>\n      <td>\u4e0d\u4e71\u4e70(www.buluanmai.com)\u662f\u4e00\u4e2a\u5168\u4e2d\u6587\u7684\u65f6\u5c1a\u6d77\u6dd8\u5bfc\u8d2d\u7f51\u7ad9\u3002\u8fd9\u91cc\u6c47\u96c6\u4e86100...</td>\n      <td>Don't buy name products, shopping</td>\n      <td>Don't buy(www. buluanmai. com)is one of the Ch...</td>\n    </tr>\n    <tr>\n      <th>71808</th>\n      <td>23251</td>\n      <td>bbs.shunderen.com</td>\n      <td>\u987a\u5fb7\u4eba\u7f51\u7ad9</td>\n      <td>\u4e00\u4e2a\u987a\u5fb7\u4eba\u7684\u7efc\u5408\u793e\u533a\u3002</td>\n      <td>By German website</td>\n      <td>One way of integrated communities.</td>\n    </tr>\n    <tr>\n      <th>77426</th>\n      <td>23650</td>\n      <td>superhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71732</th>\n      <td>23650</td>\n      <td>www.superhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71323</th>\n      <td>23904</td>\n      <td>bbs.3uol.com</td>\n      <td>\u4e09\u4f18\u4e4b\u5bb6</td>\n      <td>\u201c\u4e09\u4f18\u201d\u5373\u4f18\u751f\u3001\u4f18\u80b2\u3001\u4f18\u6559\u3002\u4e09\u4f18\u4e4b\u5bb6\u7f51\uff0c\u662f\u9762\u5411\u5168\u56fd\u5b55\u4ea7\u80b2\u513f\u4eba\u7fa4\u63d0\u4f9b\u4e13\u4e1a\u4f18\u751f\u4f18\u80b2\u670d\u52a1\u7684\u5927\u578b\u793e\u533a...</td>\n      <td>Three home</td>\n      <td>\u201cThe Big Three\u201dnamely, students, nurturing and...</td>\n    </tr>\n    <tr>\n      <th>71428</th>\n      <td>23975</td>\n      <td>www.90792.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8031</th>\n      <td>24435</td>\n      <td>ebuybible.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70667</th>\n      <td>24435</td>\n      <td>www.ebuybible.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70286</th>\n      <td>25932</td>\n      <td>zhengpinle.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>78594</th>\n      <td>26597</td>\n      <td>www.zhbaby.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79620</th>\n      <td>26597</td>\n      <td>zhbaby.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79961</th>\n      <td>26993</td>\n      <td>www.9iyouhui.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>18562</th>\n      <td>27738</td>\n      <td>www.symama.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70981</th>\n      <td>29926</td>\n      <td>www.ht51.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70891</th>\n      <td>29965</td>\n      <td>www.easyhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71425</th>\n      <td>30976</td>\n      <td>www.axoeurope.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>22341</th>\n      <td>31313</td>\n      <td>www.wxmama.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70574</th>\n      <td>34972</td>\n      <td>www.178good.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>270</th>\n      <td>37583</td>\n      <td>www.jmmama.com.cn</td>\n      <td>\u6c5f\u95e8\u5988\u5988\u7f51</td>\n      <td>\u6c5f\u95e8\u5988\u5988\u7f51\u662f\u5173\u4e8e\u5bb6\u5ead\u751f\u6d3b\u3001\u4eb2\u5b50\u80b2\u513f\u3001\u5a5a\u59fb\u5bb6\u5ead\u3001\u5de5\u4f5c\u60c5\u611f\u3001\u6000\u5b55\u54a8\u8be2\u7684\u4e92\u52a9\u4e92\u52a8\u793e\u533a\uff0c\u96c6\u805a\u4f1a\u6d3b\u52a8\u3001...</td>\n      <td>Jiang door mom network</td>\n      <td>Jiang door, mom network, on family life, paren...</td>\n    </tr>\n    <tr>\n      <th>70262</th>\n      <td>38707</td>\n      <td>hao.yqie.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>44218</th>\n      <td>41147</td>\n      <td>shopping.ladymax.cn</td>\n      <td>Ladymax\u5973\u6027\u7f51</td>\n      <td>\u4e13\u4e1a\u5973\u6027\u65f6\u5c1a\u7f51\u7ad9\u3002\u6700\u7231\u5206\u4eab \u65f6\u5c1a\u8d2d\u7269\u5165\u53e3 \u5305\u62ec\u7f8e\u5bb9 \u670d\u9970\u642d\u914d\u7b49\u8d44\u8baf\u3002</td>\n      <td>Ladymax female network</td>\n      <td>Professional female fashion website. Most love...</td>\n    </tr>\n    <tr>\n      <th>70784</th>\n      <td>43437</td>\n      <td>www.csmama.net</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70844</th>\n      <td>43606</td>\n      <td>www.herebbs.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>116</th>\n      <td>43606</td>\n      <td>herebbs.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71080</th>\n      <td>49894</td>\n      <td>www.hack6.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71479</th>\n      <td>767521</td>\n      <td>www.shmama.net</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8936</th>\n      <td>NaN</td>\n      <td>\uff57\uff57\uff57.\uff44\uff44\uff12\uff18\uff18.\uff43\uff4f\uff4d</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70489</th>\n      <td>NaN</td>\n      <td>www.bank\uff0dof\uff0dchina.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>147 rows \u00d7 6 columns</p>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"source": "There are payment websites like g.alipay.com. Filter them out as well.", "cell_type": "markdown", "metadata": {}}, {"execution_count": 10, "cell_type": "code", "source": "banned_str = u'\u94f6\u884c|\u8f6c\u8fd0|\u90ae\u5bc4|\u5a92\u4f53|\u65b0\u95fb|Alipay'\ndf_cn3 = df_cn2[~df_cn2.alexa_desc.fillna('').str.contains(banned_str)]\ndf_cn3.sort('alexa_cc_rank',ascending=1)\\\n    .ix[:,['alexa_cc_rank','source_domain', \n           'alexa_title','alexa_desc']].drop_duplicates()", "outputs": [{"execution_count": 10, "output_type": "execute_result", "data": {"text/plain": "       alexa_cc_rank          source_domain  \\\n70223             26   best.pconline.com.cn   \n21903             28      dongxi.douban.com   \n166               50       www.babytree.com   \n70514             82       bbs.haiwainet.cn   \n77102            178          www.huihui.cn   \n70377            204             www.boc.cn   \n299              213      home.qqbaobao.com   \n72969            232          www.ebrun.com   \n16               236          www.mgpyh.com   \n76535            360       www.letsebuy.com   \n35610            405       www.55haitao.com   \n70432            508          bbs.55bbs.com   \n71679            513        bbs.bozhong.com   \n70933            513       riji.bozhong.com   \n251              529         bbs.seedit.com   \n76214            605           guangdiu.com   \n70216            622         forum.51nb.com   \n79952            656           www.deyi.com   \n157              753           bbs.8080.net   \n70759            758      www.haitaobei.com   \n36078            803    bbs.fobshanghai.com   \n71450            806      www.123haitao.com   \n413             1003          www.ebama.net   \n70637           1032         we.walatao.com   \n23466           1065         bbs.ahlife.com   \n16554           1436            www.020.com   \n20329           1487         www.gzmama.com   \n70481           1570      bbs.rebatesme.com   \n77751           1580         www.buytong.cn   \n71843           1735         www.tompda.com   \n...              ...                    ...   \n70247          22732       woliwowai.com.cn   \n79951          22785          bbs.wfits.com   \n70751          23119      www.buluanmai.com   \n71808          23251      bbs.shunderen.com   \n77426          23650        superhaitao.com   \n71732          23650    www.superhaitao.com   \n71323          23904           bbs.3uol.com   \n71428          23975          www.90792.com   \n8031           24435          ebuybible.com   \n70667          24435      www.ebuybible.com   \n70286          25932         zhengpinle.com   \n78594          26597      www.zhbaby.com.cn   \n79620          26597          zhbaby.com.cn   \n79961          26993       www.9iyouhui.com   \n18562          27738         www.symama.com   \n70981          29926           www.ht51.com   \n70891          29965     www.easyhaitao.com   \n71425          30976      www.axoeurope.com   \n22341          31313         www.wxmama.com   \n70574          34972        www.178good.com   \n270            37583      www.jmmama.com.cn   \n70262          38707           hao.yqie.com   \n44218          41147    shopping.ladymax.cn   \n70784          43437         www.csmama.net   \n70844          43606        www.herebbs.com   \n116            43606            herebbs.com   \n71080          49894          www.hack6.com   \n71479         767521         www.shmama.net   \n8936             NaN          \uff57\uff57\uff57.\uff44\uff44\uff12\uff18\uff18.\uff43\uff4f\uff4d   \n70489            NaN  www.bank\uff0dof\uff0dchina.com   \n\n                                             alexa_title  \\\n70223                                             \u592a\u5e73\u6d0b\u7535\u8111\u7f51   \n21903                                                 \u8c46\u74e3   \n166                                                  \u5b9d\u5b9d\u6811   \n70514                                                \u6d77\u5916\u7f51   \n77102                                                \u60e0\u60e0\u7f51   \n70377                                               \u4e2d\u56fd\u94f6\u884c   \n299                                        \u80b2\u513f\u793e\u533a ,\u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b   \n72969                                               \u4ebf\u90a6\u52a8\u529b   \n16     \u4e70\u4e2a\u4fbf\u5b9c\u8d27\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u81f4\u529b\u4e8e\u63d0\u4f9b\u6700\u9760\u8c31\u7684\u6d77\u6dd8\u3001\u56fd\u5185\u8d2d\u7269\u4f18\u60e0\u8d44\u8baf\u3001\u6c47\u96c6\u6570\u5341\u4e07\u7f51\u53cb\u7684\u667a\u6167\uff0c\u5206\u4eab\u771f...   \n76535                                                \u95e8\u6237    \n35610  55\u6d77\u6dd8\u7f51\u662f\u76ee\u524d\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u4e13\u4e1a\u6d77\u6dd8\u7ad9\uff0c\u5305\u62ec\u7f8e\u56fd\u4e3b\u6d41\u7684\u6d77\u6dd8\u7f51\u7ad9\uff0c\u8be6\u5c3d\u7684\u6d77\u6dd8\u7f51\u5740\u5927\u5168\uff0c\u66f4\u662f\u76ee\u524d...   \n70432                                               \u6211\u7231\u6253\u6298   \n71679                                                \u64ad\u79cd\u7f51   \n70933                                                \u64ad\u79cd\u7f51   \n251                                                  \u64ad\u79cd\u7f51   \n76214  \u6700\u5168\u7684\u5b9e\u65f6\u6298\u6263\u805a\u5408\uff0c\u6c47\u805a\u4e86\u4ec0\u4e48\u503c\u5f97\u4e70\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u3001\u6298800\u3001\u60e0\u60e0\u7f51\u3001\u5317\u7f8e\u7701\u94b1\u5feb\u62a5\u3001360\u7279\u60e0...   \n70216                                                \u4e13\u95e8\u7f51   \n79952  \u5f97\u610f\u751f\u6d3b(deyi.com)\u662f\u6b66\u6c49\u6700\u5927\u7684\u672c\u5730\u751f\u6d3b\u4ea4\u6d41\u4e0e\u670d\u52a1\u5e73\u53f0,\u63d0\u4f9b\u6700\u65b0\u6700\u5168\u7684\u6b66\u6c49\u6253\u6298\u3001\u6b66\u6c49...   \n157                                                  \u6781\u901f\u7f51   \n70759                                       \u6d77\u6dd8\u8d1d-\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u793e\u533a   \n36078                                 FOB Business Forum   \n71450  \u6781\u5ba2\u6d77\u6dd8\uff08123haitao.com\uff09\uff0c\u662f\u4ee5\u54c1\u8d28\u751f\u6d3b\u4e3a\u4e3b\u9898\u7684\u8d2d\u7269\u5206\u4eab\u5f00\u653e\u793e\u533a\uff0c\u9f13\u52b1\u6bcf\u4e00\u4e2a\u7f51\u53cb...   \n413                                                  \u9996\u9875    \n70637  \u74e6\u62c9\u6dd8\u662f\u4e00\u6b3e\u81f4\u529b\u4e8e\u8ba9\u4f60\u6d77\u6dd8\u66f4\u4fbf\u6377\u7684\u6d4f\u89c8\u5668\u63d2\u4ef6\uff0c\u7b80\u5316\u6d77\u6dd8\u8d2d\u7269\u6d41\u7a0b\uff0c\u63d0\u4f9b\u8bf8\u591a\u5b9e\u7528\u5c0f\u5de5\u5177\uff0c\u5982\uff1a\u5168\u6587...   \n23466  \u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\uff0cTOGO\u8bba\u575b\u662f\u5408\u80a5\u6210\u7acb\u8f83\u65e9\u7684\uff0c2003\u5e74\u4fbf\u6210\u7acb\u4e86\u3002\u662f\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\u6700\u5927\u7684\u751f\u6d3b...   \n16554                                                \u5e7f\u5dde\u7f51   \n20329  \u5e7f\u5dde\u5988\u5988\u7f51\uff1a\u5e7f\u5dde\u5988\u5988\u9996\u9009\u7684\u5907\u5b55\u3001\u6000\u5b55\u3001\u80b2\u513f\u3001\u65e9\u6559\u7b49\u80b2\u513f\u4ea4\u6d41\u5e73\u53f0\uff0c\u6c47\u96c6\u5e7f\u5dde\u7f8e\u98df\u3001\u8d2d\u7269\u3001\u60c5\u611f\u3001\u751f...   \n70481  RebatesMe\u6d77\u6dd8\u8bba\u575b\u662f\u4e00\u4e2a\u5185\u5bb9\u4e30\u5bcc\u7684\u6d77\u6dd8\u4ea4\u6d41\u5e73\u53f0\uff0c\u4e3a\u60a8\u63d0\u4f9b\u6d77\u6dd8\u6559\u7a0b\u3001\u6d77\u6dd8\u653b\u7565\u3001\u6d77\u6dd8\u5546\u5bb6...   \n77751                                                NaN   \n71843                                             TomPda   \n...                                                  ...   \n70247                                                NaN   \n79951                                               \u6f4d\u574a\u8bba\u575b   \n70751                                            \u4e0d\u4e71\u4e70\u540d\u54c1\u8d2d\u7269   \n71808                                              \u987a\u5fb7\u4eba\u7f51\u7ad9   \n77426                                                NaN   \n71732                                                NaN   \n71323                                               \u4e09\u4f18\u4e4b\u5bb6   \n71428                                                NaN   \n8031                                                 NaN   \n70667                                                NaN   \n70286                                                NaN   \n78594                                                NaN   \n79620                                                NaN   \n79961                                                NaN   \n18562                                                NaN   \n70981                                                NaN   \n70891                                                NaN   \n71425                                                NaN   \n22341                                                NaN   \n70574                                                NaN   \n270                                                \u6c5f\u95e8\u5988\u5988\u7f51   \n70262                                                NaN   \n44218                                         Ladymax\u5973\u6027\u7f51   \n70784                                                NaN   \n70844                                                NaN   \n116                                                  NaN   \n71080                                                NaN   \n71479                                                NaN   \n8936                                                 NaN   \n70489                                                NaN   \n\n                                              alexa_desc  \n70223                        \u63d0\u4f9b\u7535\u8111\u4ea7\u54c1\u4ecb\u7ecd\u3001\u4ef7\u683c\u4fe1\u606f\u3001\u4f01\u4e1a\u540d\u5f55\u53ca\u7535\u8111\u77e5\u8bc6\u548c\u65b0\u95fb\u3002  \n21903  Douban.com is a multi-products web platform wh...  \n166    \u4e2d\u56fd\u6700\u5927\u7684\u80b2\u513f\u7f51\u7ad9\u793e\u533a\uff0c\u63d0\u4f9b\u80b2\u513f\u535a\u5ba2\u300110G\u8d85\u5927\u7a7a\u95f4\u514d\u8d39\u7535\u5b50\u76f8\u518c\u3001\u5728\u7ebf\u4ea4\u6d41\u80b2\u513f\u8bba\u575b\u7b49\u670d\u52a1\uff0c\u4e3a...  \n70514  \u6d77\u5916\u7f51\u662f\u4eba\u6c11\u65e5\u62a5\u6d77\u5916\u7248\u6570\u5b57\u5316\u8f6c\u578b\u5efa\u8bbe\u7684\u6838\u5fc3\u5185\u5bb9\u548c\u91cd\u8981\u652f\u6491\u5e73\u53f0\u3002\u6d77\u5916\u7248\u901a\u8fc7\u6570\u5b57\u5316\u8f6c\u578b\uff0c\u5c06\u9010\u6b65\u6784...  \n77102              \u7f51\u6613\u65d7\u4e0b\u8d2d\u7269\u641c\u7d22\u548c\u7f51\u8d2d\u63a8\u8350\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e3b\u6d41\u8d2d\u7269\u7f51\u7ad9\u7684\u5546\u54c1\u6bd4\u4ef7\u548c\u8d2d\u7269\u8fd4\u73b0\u670d\u52a1\u3002  \n70377  \u4e2d\u56fd\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff0c\u56fd\u6709\u63a7\u80a1\u91d1\u878d\u673a\u6784\uff0c\u4e1a\u52a1\u8303\u56f4\u6db5\u76d6\u5546\u4e1a\u94f6\u884c\u3001\u6295\u8d44\u94f6\u884c\u548c\u4fdd\u9669\u9886\u57df\uff0c\u65d7\u4e0b\u6709\u4e2d\u94f6...  \n299                                    \u80b2\u513f\u793e\u533a - \u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b -   \n72969  \u4e2d\u56fd\u6700\u5927\u7684\u7535\u5b50\u5546\u52a1\u7f51\u7edc\u5a92\u4f53\uff0c\u4e3a\u505a\u7535\u5b50\u5546\u52a1\u7684\u4f01\u4e1a\u3001\u7535\u5546\u7ecf\u7406\u4eba\uff0c\u6bcf\u65e5\u63d0\u4f9b\u7535\u5546\u884c\u4e1a\u7684\u516c\u53f8\u3001\u4eba\u7269\u3001\u653f...  \n16               \\r\\n        \\r\\n\\t       \u4e70\u4e2a\u4fbf\u5b9c\u8d27\uff1a\u4e70\u5f97\u5230\u7684\u7f8e\u597d\u751f\u6d3b  \n76535  \u6d77\u6dd8\u7f51\u7ad9_\u6d77\u5916\u4ee3\u8d2d\u7f51\u7ad9_\u6d77\u6dd8\u653b\u7565_\u6d77\u6dd8_\u7f51\u4e0a\u4ee3\u8d2d_\u5c3d\u5728\u6d77\u5916E\u8d2d-letsebuy\u5b98\u7f51 -  ...  \n35610                    \u6d77\u6dd8\u7f51\u7ad9-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u65cf\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u6d77\u6dd8\u8fd4\u5229\u7f51\u7ad9|55\u6d77\u6dd8\u7f51  \n70432                      \u8d2d\u7269\u3001\u7f8e\u98df\u3001\u5a31\u4e50\u3001\u4e3d\u4eba\u2026\u2026\u6700\u5177\u4eba\u6c14\u7684\u751f\u6d3b\u6d88\u8d39\u8d44\u8baf\u5206\u4eab\u793e\u533a\u3002  \n71679  \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...  \n70933  \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...  \n251    \u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...  \n76214                                      \u901b\u4e22 | \u5b9e\u65f6\u540c\u6b65\u5168\u7f51\u6298\u6263  \n70216                                     \u4e13\u4e1a\u7684\u7b14\u8bb0\u672c\u7535\u8111\u6280\u672f\u4ea4\u6d41\u7f51\u7ad9  \n79952                            \u5f97\u610f\u751f\u6d3b_\u6b66\u6c49\u751f\u6d3b\u6d88\u8d39\u793e\u533a_\u6b66\u6c49\u8bba\u575b_\u6b66\u6c49\u6253\u6298  \n157                  \u534e\u4e1c\u5730\u533a\u6700\u5177\u5546\u4e1a\u4ef7\u503cIT\u95e8\u6237\u7f51\u7ad9\uff0c\u7acb\u8db3\u5357\u4eac\u653e\u773c\u5168\u7403\uff0c\u8d34\u8fd1\u5e02\u573a\u5f70\u663e\u4e13\u4e1a\u3002  \n70759  \u6d77\u6dd8\u8d1d\u662f\u4e00\u5bb6\u57fa\u4e8eSNS\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u4ea4\u6d41\u7f51\u7ad9\u3002\u5728\u6d77\u6dd8\u8d1d\u4f60\u53ef\u4ee5\u5c55\u793a\u8fbe\u4eba\u98ce\u91c7\uff0c\u5206\u4eab\u6d77\u6dd8\u5b9d\u8d1d\uff0c\u4ea4\u6d41\u6700...  \n36078  Business Forum with information on Chinese and...  \n71450                                    \u6781\u5ba2\u6d77\u6dd8\uff0c\u5c5e\u4e8e\u4f60\u7684\u8d2d\u7269\u5206\u4eab\u793e\u533a  \n413                    \u7231\u5b69\u5b50,\u7231\u4e0a\u7238\u5988\u7f51-\u5e7c\u513f\u82f1\u8bed|\u5c11\u513f\u82f1\u8bed|\u513f\u7ae5\u82f1\u8bed|\u513f\u7ae5\u6559\u80b2 -    \n70637                                           \u6d77\u6dd8\u767e\u79d1_\u74e6\u62c9\u6dd8  \n23466                \u5408\u80a5\u8bba\u575b_TOGO\u8bba\u575b_\u5b89\u5fbd\u751f\u6d3b\u7f51\u8bba\u575b_\u7cbe\u81f4\u751f\u6d3b \u5c3d\u5728\u5b89\u5fbd\u751f\u6d3b\u7f51 -   \n16554                           \u5e7f\u5dde\u7f51\u793e\u533a\u63d0\u4f9b\u5a5a\u5ac1\u3001\u5bb6\u5c45\u3001\u7f8e\u98df\u3001\u623f\u4ea7\u7b49\u8ba8\u8bba\u4ea4\u6d41\u3002  \n20329                  \u5e7f\u5dde\u5988\u5988\u7f51_\u5b98\u65b9\u7f51\u7ad9\uff0c\u5e7f\u5dde\u5988\u5988\u9996\u9009\u80b2\u513f\u3001\u751f\u6d3b\u7b49\u4ea4\u6d41\u4e92\u52a8\u793e\u533a -    \n70481         RebatesMe\u6d77\u6dd8\u8bba\u575b|\u6d77\u6dd8\u4ea4\u6d41-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u4f18\u60e0-\u6d77\u6dd8\u653b\u7565\u52a9\u60a8\u8f7b\u677e\u6d77\u6dd8 -   \n77751                                                NaN  \n71843  TOMPDA\u96b6\u5c5e\u4e8e\u5317\u4eac\u5174\u534e\u6668\u8f89\u6570\u7801\u79d1\u6280\u6709\u9650\u516c\u53f8\u521b\u529e\u4e8e2002\u5e7412\u6708\uff0c\u662f\u4e2d\u56fd\u77e5\u540d\u7684\u667a\u80fd\u624b\u673a\u4e13...  \n...                                                  ...  \n70247                                                NaN  \n79951          \u672c\u5730\u8bba\u575b\uff0c\u8bbe\u6709\u6f4d\u574a\u751f\u6d3b\u3001\u5403\u904d\u6f4d\u574a\u3001\u539f\u521b\u6444\u5f71\u3001\u6f4d\u574a\u5546\u4e1a\u8857\u3001\u4ea4\u53cb\u5929\u5730\u3001\u60c5\u611f\u5929\u7a7a\u7b49\u677f\u5757\u3002  \n70751  \u4e0d\u4e71\u4e70(www.buluanmai.com)\u662f\u4e00\u4e2a\u5168\u4e2d\u6587\u7684\u65f6\u5c1a\u6d77\u6dd8\u5bfc\u8d2d\u7f51\u7ad9\u3002\u8fd9\u91cc\u6c47\u96c6\u4e86100...  \n71808                                        \u4e00\u4e2a\u987a\u5fb7\u4eba\u7684\u7efc\u5408\u793e\u533a\u3002  \n77426                                                NaN  \n71732                                                NaN  \n71323  \u201c\u4e09\u4f18\u201d\u5373\u4f18\u751f\u3001\u4f18\u80b2\u3001\u4f18\u6559\u3002\u4e09\u4f18\u4e4b\u5bb6\u7f51\uff0c\u662f\u9762\u5411\u5168\u56fd\u5b55\u4ea7\u80b2\u513f\u4eba\u7fa4\u63d0\u4f9b\u4e13\u4e1a\u4f18\u751f\u4f18\u80b2\u670d\u52a1\u7684\u5927\u578b\u793e\u533a...  \n71428                                                NaN  \n8031                                                 NaN  \n70667                                                NaN  \n70286                                                NaN  \n78594                                                NaN  \n79620                                                NaN  \n79961                                                NaN  \n18562                                                NaN  \n70981                                                NaN  \n70891                                                NaN  \n71425                                                NaN  \n22341                                                NaN  \n70574                                                NaN  \n270    \u6c5f\u95e8\u5988\u5988\u7f51\u662f\u5173\u4e8e\u5bb6\u5ead\u751f\u6d3b\u3001\u4eb2\u5b50\u80b2\u513f\u3001\u5a5a\u59fb\u5bb6\u5ead\u3001\u5de5\u4f5c\u60c5\u611f\u3001\u6000\u5b55\u54a8\u8be2\u7684\u4e92\u52a9\u4e92\u52a8\u793e\u533a\uff0c\u96c6\u805a\u4f1a\u6d3b\u52a8\u3001...  \n70262                                                NaN  \n44218                 \u4e13\u4e1a\u5973\u6027\u65f6\u5c1a\u7f51\u7ad9\u3002\u6700\u7231\u5206\u4eab \u65f6\u5c1a\u8d2d\u7269\u5165\u53e3 \u5305\u62ec\u7f8e\u5bb9 \u670d\u9970\u642d\u914d\u7b49\u8d44\u8baf\u3002  \n70784                                                NaN  \n70844                                                NaN  \n116                                                  NaN  \n71080                                                NaN  \n71479                                                NaN  \n8936                                                 NaN  \n70489                                                NaN  \n\n[146 rows x 4 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>alexa_cc_rank</th>\n      <th>source_domain</th>\n      <th>alexa_title</th>\n      <th>alexa_desc</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>70223</th>\n      <td>26</td>\n      <td>best.pconline.com.cn</td>\n      <td>\u592a\u5e73\u6d0b\u7535\u8111\u7f51</td>\n      <td>\u63d0\u4f9b\u7535\u8111\u4ea7\u54c1\u4ecb\u7ecd\u3001\u4ef7\u683c\u4fe1\u606f\u3001\u4f01\u4e1a\u540d\u5f55\u53ca\u7535\u8111\u77e5\u8bc6\u548c\u65b0\u95fb\u3002</td>\n    </tr>\n    <tr>\n      <th>21903</th>\n      <td>28</td>\n      <td>dongxi.douban.com</td>\n      <td>\u8c46\u74e3</td>\n      <td>Douban.com is a multi-products web platform wh...</td>\n    </tr>\n    <tr>\n      <th>166</th>\n      <td>50</td>\n      <td>www.babytree.com</td>\n      <td>\u5b9d\u5b9d\u6811</td>\n      <td>\u4e2d\u56fd\u6700\u5927\u7684\u80b2\u513f\u7f51\u7ad9\u793e\u533a\uff0c\u63d0\u4f9b\u80b2\u513f\u535a\u5ba2\u300110G\u8d85\u5927\u7a7a\u95f4\u514d\u8d39\u7535\u5b50\u76f8\u518c\u3001\u5728\u7ebf\u4ea4\u6d41\u80b2\u513f\u8bba\u575b\u7b49\u670d\u52a1\uff0c\u4e3a...</td>\n    </tr>\n    <tr>\n      <th>70514</th>\n      <td>82</td>\n      <td>bbs.haiwainet.cn</td>\n      <td>\u6d77\u5916\u7f51</td>\n      <td>\u6d77\u5916\u7f51\u662f\u4eba\u6c11\u65e5\u62a5\u6d77\u5916\u7248\u6570\u5b57\u5316\u8f6c\u578b\u5efa\u8bbe\u7684\u6838\u5fc3\u5185\u5bb9\u548c\u91cd\u8981\u652f\u6491\u5e73\u53f0\u3002\u6d77\u5916\u7248\u901a\u8fc7\u6570\u5b57\u5316\u8f6c\u578b\uff0c\u5c06\u9010\u6b65\u6784...</td>\n    </tr>\n    <tr>\n      <th>77102</th>\n      <td>178</td>\n      <td>www.huihui.cn</td>\n      <td>\u60e0\u60e0\u7f51</td>\n      <td>\u7f51\u6613\u65d7\u4e0b\u8d2d\u7269\u641c\u7d22\u548c\u7f51\u8d2d\u63a8\u8350\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e3b\u6d41\u8d2d\u7269\u7f51\u7ad9\u7684\u5546\u54c1\u6bd4\u4ef7\u548c\u8d2d\u7269\u8fd4\u73b0\u670d\u52a1\u3002</td>\n    </tr>\n    <tr>\n      <th>70377</th>\n      <td>204</td>\n      <td>www.boc.cn</td>\n      <td>\u4e2d\u56fd\u94f6\u884c</td>\n      <td>\u4e2d\u56fd\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff0c\u56fd\u6709\u63a7\u80a1\u91d1\u878d\u673a\u6784\uff0c\u4e1a\u52a1\u8303\u56f4\u6db5\u76d6\u5546\u4e1a\u94f6\u884c\u3001\u6295\u8d44\u94f6\u884c\u548c\u4fdd\u9669\u9886\u57df\uff0c\u65d7\u4e0b\u6709\u4e2d\u94f6...</td>\n    </tr>\n    <tr>\n      <th>299</th>\n      <td>213</td>\n      <td>home.qqbaobao.com</td>\n      <td>\u80b2\u513f\u793e\u533a ,\u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b</td>\n      <td>\u80b2\u513f\u793e\u533a - \u4eb2\u5b9d\u7f51\u80b2\u513f\u8bba\u575b -</td>\n    </tr>\n    <tr>\n      <th>72969</th>\n      <td>232</td>\n      <td>www.ebrun.com</td>\n      <td>\u4ebf\u90a6\u52a8\u529b</td>\n      <td>\u4e2d\u56fd\u6700\u5927\u7684\u7535\u5b50\u5546\u52a1\u7f51\u7edc\u5a92\u4f53\uff0c\u4e3a\u505a\u7535\u5b50\u5546\u52a1\u7684\u4f01\u4e1a\u3001\u7535\u5546\u7ecf\u7406\u4eba\uff0c\u6bcf\u65e5\u63d0\u4f9b\u7535\u5546\u884c\u4e1a\u7684\u516c\u53f8\u3001\u4eba\u7269\u3001\u653f...</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>236</td>\n      <td>www.mgpyh.com</td>\n      <td>\u4e70\u4e2a\u4fbf\u5b9c\u8d27\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u81f4\u529b\u4e8e\u63d0\u4f9b\u6700\u9760\u8c31\u7684\u6d77\u6dd8\u3001\u56fd\u5185\u8d2d\u7269\u4f18\u60e0\u8d44\u8baf\u3001\u6c47\u96c6\u6570\u5341\u4e07\u7f51\u53cb\u7684\u667a\u6167\uff0c\u5206\u4eab\u771f...</td>\n      <td>\\r\\n        \\r\\n\\t       \u4e70\u4e2a\u4fbf\u5b9c\u8d27\uff1a\u4e70\u5f97\u5230\u7684\u7f8e\u597d\u751f\u6d3b</td>\n    </tr>\n    <tr>\n      <th>76535</th>\n      <td>360</td>\n      <td>www.letsebuy.com</td>\n      <td>\u95e8\u6237</td>\n      <td>\u6d77\u6dd8\u7f51\u7ad9_\u6d77\u5916\u4ee3\u8d2d\u7f51\u7ad9_\u6d77\u6dd8\u653b\u7565_\u6d77\u6dd8_\u7f51\u4e0a\u4ee3\u8d2d_\u5c3d\u5728\u6d77\u5916E\u8d2d-letsebuy\u5b98\u7f51 -  ...</td>\n    </tr>\n    <tr>\n      <th>35610</th>\n      <td>405</td>\n      <td>www.55haitao.com</td>\n      <td>55\u6d77\u6dd8\u7f51\u662f\u76ee\u524d\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u4e13\u4e1a\u6d77\u6dd8\u7ad9\uff0c\u5305\u62ec\u7f8e\u56fd\u4e3b\u6d41\u7684\u6d77\u6dd8\u7f51\u7ad9\uff0c\u8be6\u5c3d\u7684\u6d77\u6dd8\u7f51\u5740\u5927\u5168\uff0c\u66f4\u662f\u76ee\u524d...</td>\n      <td>\u6d77\u6dd8\u7f51\u7ad9-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u65cf\u6700\u503c\u5f97\u4fe1\u8d56\u7684\u6d77\u6dd8\u8fd4\u5229\u7f51\u7ad9|55\u6d77\u6dd8\u7f51</td>\n    </tr>\n    <tr>\n      <th>70432</th>\n      <td>508</td>\n      <td>bbs.55bbs.com</td>\n      <td>\u6211\u7231\u6253\u6298</td>\n      <td>\u8d2d\u7269\u3001\u7f8e\u98df\u3001\u5a31\u4e50\u3001\u4e3d\u4eba\u2026\u2026\u6700\u5177\u4eba\u6c14\u7684\u751f\u6d3b\u6d88\u8d39\u8d44\u8baf\u5206\u4eab\u793e\u533a\u3002</td>\n    </tr>\n    <tr>\n      <th>71679</th>\n      <td>513</td>\n      <td>bbs.bozhong.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n    </tr>\n    <tr>\n      <th>70933</th>\n      <td>513</td>\n      <td>riji.bozhong.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n    </tr>\n    <tr>\n      <th>251</th>\n      <td>529</td>\n      <td>bbs.seedit.com</td>\n      <td>\u64ad\u79cd\u7f51</td>\n      <td>\u64ad\u79cd\u7f51(bozhong.com)\u521b\u7acb\u4e8e2003\u5e74\uff0c\u521b\u59cb\u4eba\u975e\u975e\u5988\u5988\u662f\u4e00\u4f4d\u6709\u7740\u591a\u5e74\u4ece\u533b\u7ecf\u9a8c\u7684\u5987\u79d1...</td>\n    </tr>\n    <tr>\n      <th>76214</th>\n      <td>605</td>\n      <td>guangdiu.com</td>\n      <td>\u6700\u5168\u7684\u5b9e\u65f6\u6298\u6263\u805a\u5408\uff0c\u6c47\u805a\u4e86\u4ec0\u4e48\u503c\u5f97\u4e70\u3001\u7f8e\u56fd\u4fbf\u5b9c\u8d27\u3001\u6298800\u3001\u60e0\u60e0\u7f51\u3001\u5317\u7f8e\u7701\u94b1\u5feb\u62a5\u3001360\u7279\u60e0...</td>\n      <td>\u901b\u4e22 | \u5b9e\u65f6\u540c\u6b65\u5168\u7f51\u6298\u6263</td>\n    </tr>\n    <tr>\n      <th>70216</th>\n      <td>622</td>\n      <td>forum.51nb.com</td>\n      <td>\u4e13\u95e8\u7f51</td>\n      <td>\u4e13\u4e1a\u7684\u7b14\u8bb0\u672c\u7535\u8111\u6280\u672f\u4ea4\u6d41\u7f51\u7ad9</td>\n    </tr>\n    <tr>\n      <th>79952</th>\n      <td>656</td>\n      <td>www.deyi.com</td>\n      <td>\u5f97\u610f\u751f\u6d3b(deyi.com)\u662f\u6b66\u6c49\u6700\u5927\u7684\u672c\u5730\u751f\u6d3b\u4ea4\u6d41\u4e0e\u670d\u52a1\u5e73\u53f0,\u63d0\u4f9b\u6700\u65b0\u6700\u5168\u7684\u6b66\u6c49\u6253\u6298\u3001\u6b66\u6c49...</td>\n      <td>\u5f97\u610f\u751f\u6d3b_\u6b66\u6c49\u751f\u6d3b\u6d88\u8d39\u793e\u533a_\u6b66\u6c49\u8bba\u575b_\u6b66\u6c49\u6253\u6298</td>\n    </tr>\n    <tr>\n      <th>157</th>\n      <td>753</td>\n      <td>bbs.8080.net</td>\n      <td>\u6781\u901f\u7f51</td>\n      <td>\u534e\u4e1c\u5730\u533a\u6700\u5177\u5546\u4e1a\u4ef7\u503cIT\u95e8\u6237\u7f51\u7ad9\uff0c\u7acb\u8db3\u5357\u4eac\u653e\u773c\u5168\u7403\uff0c\u8d34\u8fd1\u5e02\u573a\u5f70\u663e\u4e13\u4e1a\u3002</td>\n    </tr>\n    <tr>\n      <th>70759</th>\n      <td>758</td>\n      <td>www.haitaobei.com</td>\n      <td>\u6d77\u6dd8\u8d1d-\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u793e\u533a</td>\n      <td>\u6d77\u6dd8\u8d1d\u662f\u4e00\u5bb6\u57fa\u4e8eSNS\u6d77\u6dd8\u8d2d\u7269\u5206\u4eab\u4ea4\u6d41\u7f51\u7ad9\u3002\u5728\u6d77\u6dd8\u8d1d\u4f60\u53ef\u4ee5\u5c55\u793a\u8fbe\u4eba\u98ce\u91c7\uff0c\u5206\u4eab\u6d77\u6dd8\u5b9d\u8d1d\uff0c\u4ea4\u6d41\u6700...</td>\n    </tr>\n    <tr>\n      <th>36078</th>\n      <td>803</td>\n      <td>bbs.fobshanghai.com</td>\n      <td>FOB Business Forum</td>\n      <td>Business Forum with information on Chinese and...</td>\n    </tr>\n    <tr>\n      <th>71450</th>\n      <td>806</td>\n      <td>www.123haitao.com</td>\n      <td>\u6781\u5ba2\u6d77\u6dd8\uff08123haitao.com\uff09\uff0c\u662f\u4ee5\u54c1\u8d28\u751f\u6d3b\u4e3a\u4e3b\u9898\u7684\u8d2d\u7269\u5206\u4eab\u5f00\u653e\u793e\u533a\uff0c\u9f13\u52b1\u6bcf\u4e00\u4e2a\u7f51\u53cb...</td>\n      <td>\u6781\u5ba2\u6d77\u6dd8\uff0c\u5c5e\u4e8e\u4f60\u7684\u8d2d\u7269\u5206\u4eab\u793e\u533a</td>\n    </tr>\n    <tr>\n      <th>413</th>\n      <td>1003</td>\n      <td>www.ebama.net</td>\n      <td>\u9996\u9875</td>\n      <td>\u7231\u5b69\u5b50,\u7231\u4e0a\u7238\u5988\u7f51-\u5e7c\u513f\u82f1\u8bed|\u5c11\u513f\u82f1\u8bed|\u513f\u7ae5\u82f1\u8bed|\u513f\u7ae5\u6559\u80b2 -</td>\n    </tr>\n    <tr>\n      <th>70637</th>\n      <td>1032</td>\n      <td>we.walatao.com</td>\n      <td>\u74e6\u62c9\u6dd8\u662f\u4e00\u6b3e\u81f4\u529b\u4e8e\u8ba9\u4f60\u6d77\u6dd8\u66f4\u4fbf\u6377\u7684\u6d4f\u89c8\u5668\u63d2\u4ef6\uff0c\u7b80\u5316\u6d77\u6dd8\u8d2d\u7269\u6d41\u7a0b\uff0c\u63d0\u4f9b\u8bf8\u591a\u5b9e\u7528\u5c0f\u5de5\u5177\uff0c\u5982\uff1a\u5168\u6587...</td>\n      <td>\u6d77\u6dd8\u767e\u79d1_\u74e6\u62c9\u6dd8</td>\n    </tr>\n    <tr>\n      <th>23466</th>\n      <td>1065</td>\n      <td>bbs.ahlife.com</td>\n      <td>\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\uff0cTOGO\u8bba\u575b\u662f\u5408\u80a5\u6210\u7acb\u8f83\u65e9\u7684\uff0c2003\u5e74\u4fbf\u6210\u7acb\u4e86\u3002\u662f\u5408\u80a5\u8bba\u575b\u7f51\u7ad9\u4e2d\u6700\u5927\u7684\u751f\u6d3b...</td>\n      <td>\u5408\u80a5\u8bba\u575b_TOGO\u8bba\u575b_\u5b89\u5fbd\u751f\u6d3b\u7f51\u8bba\u575b_\u7cbe\u81f4\u751f\u6d3b \u5c3d\u5728\u5b89\u5fbd\u751f\u6d3b\u7f51 -</td>\n    </tr>\n    <tr>\n      <th>16554</th>\n      <td>1436</td>\n      <td>www.020.com</td>\n      <td>\u5e7f\u5dde\u7f51</td>\n      <td>\u5e7f\u5dde\u7f51\u793e\u533a\u63d0\u4f9b\u5a5a\u5ac1\u3001\u5bb6\u5c45\u3001\u7f8e\u98df\u3001\u623f\u4ea7\u7b49\u8ba8\u8bba\u4ea4\u6d41\u3002</td>\n    </tr>\n    <tr>\n      <th>20329</th>\n      <td>1487</td>\n      <td>www.gzmama.com</td>\n      <td>\u5e7f\u5dde\u5988\u5988\u7f51\uff1a\u5e7f\u5dde\u5988\u5988\u9996\u9009\u7684\u5907\u5b55\u3001\u6000\u5b55\u3001\u80b2\u513f\u3001\u65e9\u6559\u7b49\u80b2\u513f\u4ea4\u6d41\u5e73\u53f0\uff0c\u6c47\u96c6\u5e7f\u5dde\u7f8e\u98df\u3001\u8d2d\u7269\u3001\u60c5\u611f\u3001\u751f...</td>\n      <td>\u5e7f\u5dde\u5988\u5988\u7f51_\u5b98\u65b9\u7f51\u7ad9\uff0c\u5e7f\u5dde\u5988\u5988\u9996\u9009\u80b2\u513f\u3001\u751f\u6d3b\u7b49\u4ea4\u6d41\u4e92\u52a8\u793e\u533a -</td>\n    </tr>\n    <tr>\n      <th>70481</th>\n      <td>1570</td>\n      <td>bbs.rebatesme.com</td>\n      <td>RebatesMe\u6d77\u6dd8\u8bba\u575b\u662f\u4e00\u4e2a\u5185\u5bb9\u4e30\u5bcc\u7684\u6d77\u6dd8\u4ea4\u6d41\u5e73\u53f0\uff0c\u4e3a\u60a8\u63d0\u4f9b\u6d77\u6dd8\u6559\u7a0b\u3001\u6d77\u6dd8\u653b\u7565\u3001\u6d77\u6dd8\u5546\u5bb6...</td>\n      <td>RebatesMe\u6d77\u6dd8\u8bba\u575b|\u6d77\u6dd8\u4ea4\u6d41-\u6d77\u6dd8\u8fd4\u5229-\u6d77\u6dd8\u4f18\u60e0-\u6d77\u6dd8\u653b\u7565\u52a9\u60a8\u8f7b\u677e\u6d77\u6dd8 -</td>\n    </tr>\n    <tr>\n      <th>77751</th>\n      <td>1580</td>\n      <td>www.buytong.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71843</th>\n      <td>1735</td>\n      <td>www.tompda.com</td>\n      <td>TomPda</td>\n      <td>TOMPDA\u96b6\u5c5e\u4e8e\u5317\u4eac\u5174\u534e\u6668\u8f89\u6570\u7801\u79d1\u6280\u6709\u9650\u516c\u53f8\u521b\u529e\u4e8e2002\u5e7412\u6708\uff0c\u662f\u4e2d\u56fd\u77e5\u540d\u7684\u667a\u80fd\u624b\u673a\u4e13...</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>70247</th>\n      <td>22732</td>\n      <td>woliwowai.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79951</th>\n      <td>22785</td>\n      <td>bbs.wfits.com</td>\n      <td>\u6f4d\u574a\u8bba\u575b</td>\n      <td>\u672c\u5730\u8bba\u575b\uff0c\u8bbe\u6709\u6f4d\u574a\u751f\u6d3b\u3001\u5403\u904d\u6f4d\u574a\u3001\u539f\u521b\u6444\u5f71\u3001\u6f4d\u574a\u5546\u4e1a\u8857\u3001\u4ea4\u53cb\u5929\u5730\u3001\u60c5\u611f\u5929\u7a7a\u7b49\u677f\u5757\u3002</td>\n    </tr>\n    <tr>\n      <th>70751</th>\n      <td>23119</td>\n      <td>www.buluanmai.com</td>\n      <td>\u4e0d\u4e71\u4e70\u540d\u54c1\u8d2d\u7269</td>\n      <td>\u4e0d\u4e71\u4e70(www.buluanmai.com)\u662f\u4e00\u4e2a\u5168\u4e2d\u6587\u7684\u65f6\u5c1a\u6d77\u6dd8\u5bfc\u8d2d\u7f51\u7ad9\u3002\u8fd9\u91cc\u6c47\u96c6\u4e86100...</td>\n    </tr>\n    <tr>\n      <th>71808</th>\n      <td>23251</td>\n      <td>bbs.shunderen.com</td>\n      <td>\u987a\u5fb7\u4eba\u7f51\u7ad9</td>\n      <td>\u4e00\u4e2a\u987a\u5fb7\u4eba\u7684\u7efc\u5408\u793e\u533a\u3002</td>\n    </tr>\n    <tr>\n      <th>77426</th>\n      <td>23650</td>\n      <td>superhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71732</th>\n      <td>23650</td>\n      <td>www.superhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71323</th>\n      <td>23904</td>\n      <td>bbs.3uol.com</td>\n      <td>\u4e09\u4f18\u4e4b\u5bb6</td>\n      <td>\u201c\u4e09\u4f18\u201d\u5373\u4f18\u751f\u3001\u4f18\u80b2\u3001\u4f18\u6559\u3002\u4e09\u4f18\u4e4b\u5bb6\u7f51\uff0c\u662f\u9762\u5411\u5168\u56fd\u5b55\u4ea7\u80b2\u513f\u4eba\u7fa4\u63d0\u4f9b\u4e13\u4e1a\u4f18\u751f\u4f18\u80b2\u670d\u52a1\u7684\u5927\u578b\u793e\u533a...</td>\n    </tr>\n    <tr>\n      <th>71428</th>\n      <td>23975</td>\n      <td>www.90792.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8031</th>\n      <td>24435</td>\n      <td>ebuybible.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70667</th>\n      <td>24435</td>\n      <td>www.ebuybible.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70286</th>\n      <td>25932</td>\n      <td>zhengpinle.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>78594</th>\n      <td>26597</td>\n      <td>www.zhbaby.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79620</th>\n      <td>26597</td>\n      <td>zhbaby.com.cn</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>79961</th>\n      <td>26993</td>\n      <td>www.9iyouhui.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>18562</th>\n      <td>27738</td>\n      <td>www.symama.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70981</th>\n      <td>29926</td>\n      <td>www.ht51.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70891</th>\n      <td>29965</td>\n      <td>www.easyhaitao.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71425</th>\n      <td>30976</td>\n      <td>www.axoeurope.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>22341</th>\n      <td>31313</td>\n      <td>www.wxmama.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70574</th>\n      <td>34972</td>\n      <td>www.178good.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>270</th>\n      <td>37583</td>\n      <td>www.jmmama.com.cn</td>\n      <td>\u6c5f\u95e8\u5988\u5988\u7f51</td>\n      <td>\u6c5f\u95e8\u5988\u5988\u7f51\u662f\u5173\u4e8e\u5bb6\u5ead\u751f\u6d3b\u3001\u4eb2\u5b50\u80b2\u513f\u3001\u5a5a\u59fb\u5bb6\u5ead\u3001\u5de5\u4f5c\u60c5\u611f\u3001\u6000\u5b55\u54a8\u8be2\u7684\u4e92\u52a9\u4e92\u52a8\u793e\u533a\uff0c\u96c6\u805a\u4f1a\u6d3b\u52a8\u3001...</td>\n    </tr>\n    <tr>\n      <th>70262</th>\n      <td>38707</td>\n      <td>hao.yqie.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>44218</th>\n      <td>41147</td>\n      <td>shopping.ladymax.cn</td>\n      <td>Ladymax\u5973\u6027\u7f51</td>\n      <td>\u4e13\u4e1a\u5973\u6027\u65f6\u5c1a\u7f51\u7ad9\u3002\u6700\u7231\u5206\u4eab \u65f6\u5c1a\u8d2d\u7269\u5165\u53e3 \u5305\u62ec\u7f8e\u5bb9 \u670d\u9970\u642d\u914d\u7b49\u8d44\u8baf\u3002</td>\n    </tr>\n    <tr>\n      <th>70784</th>\n      <td>43437</td>\n      <td>www.csmama.net</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70844</th>\n      <td>43606</td>\n      <td>www.herebbs.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>116</th>\n      <td>43606</td>\n      <td>herebbs.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71080</th>\n      <td>49894</td>\n      <td>www.hack6.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>71479</th>\n      <td>767521</td>\n      <td>www.shmama.net</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8936</th>\n      <td>NaN</td>\n      <td>\uff57\uff57\uff57.\uff44\uff44\uff12\uff18\uff18.\uff43\uff4f\uff4d</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70489</th>\n      <td>NaN</td>\n      <td>www.bank\uff0dof\uff0dchina.com</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>146 rows \u00d7 4 columns</p>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"source": "###Chinese Forum Sites\nWe find out there are quite a lot **bbs/forum-like websites** such as www.bjmama.com and home.qqbaobao.com which attracted quite significant views. As we cannot only rely on Alexa ranking because it only reflects the site's overall traffic and not actual pageviews for particular page. \n\nSo let's scrape their views and replies. ", "cell_type": "markdown", "metadata": {}}, {"execution_count": null, "cell_type": "code", "source": "source_domains = df_cn3.source_domain.unique().tolist()\n\nidx_threads = df_cn3[df_cn3.source_url.str.contains('thread|forum|community')].index.tolist()\n\nfor c,i in enumerate(idx_threads):\n    res = get_thread_stats(df_cn3.ix[i, 'source_url'])\n    if res is not None:\n        df_cn3.ix[i, 'views'] = res.get('views')\n        df_cn3.ix[i, 'replies'] = res.get('replies')\n        soup = res.get('soup')\n        \n        # get links that is connected to the contained domains\n        if soup is not None:\n            links = get_connection_links(soup, [d for d in source_domains if d != df_cn3.ix[i,'source_domain']])\n            df_cn3.ix[i, 'links'] = '|'.join(links)\n            \n            has_promo = has_promotion(soup)\n            df_cn3.ix[i, 'has_promotion'] = has_promo\n        \n        if (c>0) and (not c % 50):\n            print str(c), df_cn3.ix[i, 'source_url'], res.get('views'), res.get('replies'), links", "outputs": [{"output_type": "stream", "name": "stdout", "text": "150 http://www.gzmama.com/thread-3846190-1-1.html 8433 54 ['http://www.bjmama.com/', 'http://www.shmama.net/', 'http://www.szmama.com/', 'http://www.symama.com/', 'http://www.xamama.net/', 'http://www.jnmama.com/', 'http://www.qdmama.net/', 'http://www.csmama.net/', 'http://www.wxmama.com/']\n200 http://www.55haitao.com/bbs/thread-7828-5-1.html None None []\n250 http://www.letsebuy.com/thread-1539361-1-1.html 362 7 ['http://www.boc.cn/sourcedb/whpj/', 'http://www.eur-go.com/', 'http://www.eur-go.com', 'http://www.eur-go.com/price-service-134-eurgo.aspx']\n300 http://www.letsebuy.com/thread-2003552-1-1.html 1087 37 ['http://www.boc.cn/sourcedb/whpj/']\n350"}], "metadata": {"collapsed": false, "trusted": true}}, {"source": "##Output", "cell_type": "markdown", "metadata": {}}, {"execution_count": null, "cell_type": "code", "source": "def output(df):\n    df.to_csv(k, sep='\\t', encoding='utf-8')\n    df.sort('alexa_cc_rank',ascending=1)\\\n    .ix[:,['alexa_cc_rank','source_domain', \n           'alexa_title','alexa_desc', \n           'alexa_title_en','alexa_desc_en']].drop_duplicates()\\\n        .to_csv('C:/workspace/analysis_reporting/joe/milk_china/anchor_domain.csv', sep='\\t', encoding='utf-8')\n        \noutput(df_cn3)", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}], "nbformat": 4, "metadata": {"kernelspec": {"display_name": "Python 2", "name": "python2", "language": "python"}, "language_info": {"mimetype": "text/x-python", "nbconvert_exporter": "python", "version": "2.7.8", "name": "python", "file_extension": ".py", "pygments_lexer": "ipython2", "codemirror_mode": {"version": 2, "name": "ipython"}}}}