Created
May 1, 2015 21:33
-
-
Save tikazyq/ae991f568bc0663ce29c to your computer and use it in GitHub Desktop.
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"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"}}}} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment