鏈枃灏嗛€氳繃涓€涓叿浣撶殑渚嬪瓙鏉ヨ鏄庡浣曚娇鐢⊿hell杩涜楂樻晥鐨勬暟鎹粺璁″拰鍒嗘瀽銆傝繎鏃ワ紝鍖椾含鍚姩浜嗘柊涓€鎵圭Н鍒嗙櫥璁板伐浣溿€傛伆濂芥湰鏂囩敤shell瀵瑰寳浜鎵圭Н鍒嗗埗瀛︾敓杩涜浜嗏€滃ぇ鏁版嵁鈥濆垎鏋愩€傚浠婏紝鍚勭鈥滃ぇ鏁版嵁鈥濇棤澶勪笉鍦紝鑰屾湰鏂囧垎鏋愮殑瀵硅薄鍙槸绗竴鎵瑰叆椹荤Н鍒嗙殑6000澶氭潯鏁版嵁锛屾樉鐒朵笉鑳界畻澶ф暟鎹€傚嵃璞′腑锛岃寰楀畼缃?000澶氭潯鏁版嵁涔熸槸鍙互涓€娆℃€get鐨勶紙鍚庣浼拌娌℃湁闄愬埗锛屽彲鑳戒細绋嶅井璋冩暣涓€涓嬫帴鍙ｇ殑鍒嗛〉鍙傛暟锛岃繕鏈夋棤闇€涓ユ牸鎸夌収鍚勭鍒嗛〉澶氭涓嬭浇锛夈€傞棶棰樻弿杩拌緭鍏ョ殑鏄痡son鏁版嵁銆傛牸寮忓寲鍚庣殑json鏁版嵁涓讳綋缁撴瀯濡備笅銆俽ows鏄竴涓暟缁勶紝鏁扮粍涓殑鍏冪礌鎵€浠ｈ〃鐨勫璞℃弿杩颁簡鑾峰緱鍖椾含鎴风睄鐨勫鐢熺殑鍚勭灞炴€э細姣斿鍒嗘暟銆佸悕娆°€佽韩浠借瘉銆傜紪鍙凤紙鍚庡洓浣嶇紪鐮侊級銆佸叕鍙哥瓑淇℃伅銆?rows":[{"id":62981,"idCard":"32092219721222****","idCardSHA":"9ef70bde894959a4e4a1d1b2b9592b470294f9e4012a8cf480319665d1a7c1c6","insertTime":1539518353000,"integralQualified":1,"internetAnnual":{"骞村害鈥濓細2018锛屸€渋d鈥濓細43锛屸€渋nsertTime鈥濓細1539518353000锛屸€減ublicityEnd鈥濓細1540224000000锛屸€減ublicityStart鈥濓細1539591600000锛屸€減ublishResultEndDate鈥濓細1541679300000锛屸€減ublishResultStartDate鈥濓細15309059160锛屸€減ublishResultStartDate鈥濓細15309059160:90.75,"status":1},"md5Code":"54e9ff7ce0b004f7141b157f8afc66db","name":"鏉ㄦ檽宄?,"pxid":1,"ranking":1,"s1":51,"s10":0锛屸€渟2鈥濓細12.59锛屸€渟3鈥濓細15锛屸€渟4鈥濓細0锛屸€渟5鈥濓細4锛屸€渟6鈥濓細0锛屸€渟7鈥濓細20锛屸€渟8鈥濓細20锛屸€渟9鈥濓細0锛屸€渟core"":122.59,"unit":"BeijingLidehuafuElectricTechnologyCo.,Ltd."}锛屼负浜嗘柟渚垮ぇ瀹剁粌涔犲拰娴嬭瘯鏁版嵁锛屾垜鍦ㄨ繖閲岄檮涓婃枃绔犱腑鐨勬暟鎹細*https://www.tanglei.name/reso...*鑾峰彇杩欎釜鏂囦欢锛屼緥濡傦紝甯屾湜浣犺兘浠ユ渶蹇殑鏂瑰紡鑾峰彇浠ヤ笅淇℃伅锛屼綘浼氭€庝箞鍋氾紵鑾峰彇鑾峰緱璐︽埛鍚嶉鏈€澶氱殑top10鍏徃鑾峰彇鑾峰緱璐︽埛鍚嶉鏈€澶氱殑浜虹殑濮撴皬鏈€娴佽鐨勮处鎴峰悕鏄粈涔堬紵鑾峰彇骞撮緞鍒嗗竷銆傝幏鍙栬幏寰楄处鍙风殑鍚屽鐨勭敓鑲?鏄熷骇/鐢熸棩鍓?0鍚嶃€傚綋鐒讹紝鏂规硶鏈夊緢澶氾紝姣斿鐔熸倝鍚勭缂栫▼璇█锛屾瘮濡俻ython銆乸hp銆乯ava绛夌瓑锛屽啓涓€涓畝鍗曠殑鑴氭湰绋嬪簭锛屽氨鍙互鏇村揩鐨勫緱鍒扮瓟妗堟垨鑰呮彁鍙栫浉搴旂殑鏁版嵁锛屾斁鍒癳xcel涓€傚鏋滀綘鐔熸倝Shell锛岀湡鐨勯渶瑕佸嚑鍒嗛挓锛屼綘搴旇鍙互鍦ㄥ嚑绉掗挓鍐呭緱鍒扮瓟妗堛€傚嵆浣挎槸鐢⊿hell瀹炵幇锛屼笉鍚岀殑浜轰篃鍙兘鏈変笉鍚岀殑鍐欐硶銆傜◢鍚庢垜灏嗗垪鍑哄叾涓竴涓潵瑙ｅ喅杩欎簺闂銆傛湰鏂囧Shell鐨勫悇涓叿浣撳懡浠や笉浣滆繃澶氳В閲娿€備笉鐔熸倝鐨勫悓瀛﹀彲浠ョ洿鎺ョ敤man$cmd鎴栬€?cmd--help绛夋煡鐪嬨€傞棶棰樿В绛旇幏鍙栬幏寰楄处鎴锋渶澶氱殑鍓?0瀹跺叕鍙搞€傛兂绉垎鍏ラ┗锛岀湅鐪嬪摢浜涘叕鍙告渶濂藉姞鍏ワ紝鍝堝搱銆傘€婂崟浣嶃€嬶細銆婂寳浜埄寰峰崕绂忕數姘旂鎶€鏈夐檺鍏徃銆嬪厛閫氳繃grep鑾峰彇鍖呭惈鍏徃鍚嶇殑琛岋紝鐒跺悗鐢ㄢ€?鈥濆垎鍓瞔ut锛屼粠绗簩鍒楄幏鍙栧叕鍙稿悕锛屽缁撴灉杩涜鎺掑簭锛屽幓閲島niq缁熻寰楀埌閲嶅娆℃暟锛岀浜屼釜缁撴灉涓洪噸澶嶆鏁扮殑鍏徃鍚嶇О锛岀劧鍚庡皢绗竴鍒?k1涓噸澶嶇殑鏁板瓧杩涜鍊掑簭鎺掑簭-nr锛屽嵆鎺掑簭-nr-k1锛屾渶鍚庡彇缁撴灉澶寸殑鍓?0琛?n10.鉃滅Н鍒嗚惤鎴?grep'unit'jifenluohu.json|鍒?f2-d锛殀鎺掑簭|uniq-c|鎺掑簭-nr-k1|head-n10137鈥滃寳浜崕涓烘暟瀛楁妧鏈湁闄愬叕鍙糕€?3銆婁腑澶數瑙嗗彴銆?7銆婂寳浜閽㈠缓璁鹃泦鍥㈡湁闄愬叕鍙搞€?5銆婄櫨搴﹀湪绾跨綉缁滄妧鏈紙鍖椾含锛夋湁闄愬叕鍙搞€?8銆婅仈鎯筹紙鍖椾含锛夋湁闄愬叕鍙搞€?0銆婂寳浜浼佷汉鍔涜祫婧愭湇鍔℃湁闄愬叕鍙搞€?0銆婁腑鍥芥皯鐢熼摱琛岃偂浠芥湁闄愬叕鍙搞€?9銆婂浗闄呭晢鐢ㄦ満鍣紙涓浗锛夋姇璧勬湁闄愬叕鍙搞€?9銆婁腑鍥藉浗闄呮妧鏈櫤鍔涘悎浣滄湁闄愬叕鍙搞€?7銆婂崕涓烘妧鏈湁闄愬叕鍙稿寳浜爺绌堕櫌銆嬭幏寰楄处鍙峰悕棰濈殑浜轰腑濮撴皬鏈€澶氱殑浜哄氨鏄渶濂界殑銆傚浠€涔堬紝鍝堝搱銆?name":"鏉ㄦ檽宄?锛屽璺拰涔嬪墠涓€鏍凤紝杩欓噷灏变笉鐐逛簡銆備笅闈㈢殑shell鍏跺疄灏辨槸鎶婅繖涓€琛岋紝鍒犻櫎浜嗙湡鍚嶅墠鐨勬墍鏈夊瓧绗︼紝鍙墿涓嬪悕瀛楃殑寮€澶淬€傚彇琛岄鐨勭涓€涓瓧绗ut-c1寰楀埌濮撴皬锛岀劧鍚庢寜鐓у墠闈㈢殑濂楄矾灏卞彲浠ュ緱鍒般€傚叾瀹炰换浣曠敤鏉ユ浛鎹㈠浣欏瓧绗︾殑sed閮芥槸澶氫綑鐨勶紝鍥犱负json鐨勬牸寮忓ソ锛屽彲浠ョ洿鎺ョ敤cut-c?寰楀埌濮撴皬鐨勭壒寰併€備笉鐢ㄤ竴涓竴涓粺璁″瓧绗︿釜鏁帮紝鐩存帴澶嶅埗鍑烘潵锛岀劧鍚巈cho-n$paste|wc-c鍙互缁熻瀛楃鏁般€備粠缁撴灉鏉ョ湅锛屸€滃紶銆佺帇鈥濅箣绫荤殑濮撴皬鏈€鏈夎叮銆傪煒?鎴栬€単rep'"name":'jifenluohu.json|sed's|"name":"||g'|sed's|[[:space:]]||g'|cut-c1|sort|uniq-c|sort-nr-k1|head-n10鉃滅Н鍒嗚惤鎴?grep'"name":'jifenluohu.json|sed's|"name":"||g'|sed鐨剕||g'|鍒?c1|鎺掑簭|uniq-c|鎺掑簭-nr-k1|head-n10541Zhang531Wang462Li376Liu205Chen193Yang166Zhao132Sun95Guo95Xu鑾峰彇璐﹀彿鍚嶆渶鐏殑濂楄矾鍚嶅瓧閮藉樊涓嶅锛屽氨涓嶅瑙ｉ噴浜嗐€傗灉绉垎钀芥埛>grep'"name":'jifenluohu.json|sed's|"name":"||g'|sed's|[[:space:]]||g'|cut-c2-4|sort|uniq-c|sort-nr-k1|head-n1051鍗?,39缁?,38閬?,36鍕?,36鍐?,32姘?,31钀?,30褰?,28鏉?,28涓?,#鍚嶅瓧,蹇呴』鍖呭惈2characters鉃滅Н鍒嗚处鎴?grep'"name":'jifenluohu.json|sed's|"name":"||g'|sed鐨剕[[:space:]]||g'|鍒?c2-3|sed'/"/d'|sort|uniq-c|sort-nr-k1|head-n1019娴锋稕19灏忎笢12蹇楀己11娴风嚂11姘稿己11寤哄崕10闆9娴烽緳9涓藉8娲稕浣滀负浠ｇ爜farmer锛屼竴瀹氳鍏绘垚瀵硅嚜宸卞緱鍒扮殑缁撴灉杩涜鑷祴鐨勪範鎯紝鎵€浠ュ鏋滃鑷繁鐨勭粨鏋滄病鏈変俊蹇冿紝鍙互鏀规銆傚幓璁＄畻鏈€鍚庣殑缁撴灉銆傛瘮濡傚彲浠ョ畝鍗昰rep楠岃瘉涓€涓嬫槸鍚︽湁19涓悕瀛楀彨鈥滄捣娑涒€濈殑浜衡灉绉垎宸茶В鍐?grep'娴锋稕'jifenluohu.json|wc-l19鑾峰彇骞撮緞鍒嗗竷鐨勬€濊矾鏄埅鍙朓D涓唬琛ㄥ嚭鐢熷勾浠界殑4浣嶆暟瀛梟umber锛岀劧鍚庣敤褰撳墠骞翠唤2019鍑忓幓鍑虹敓骞翠唤寰楀埌骞撮緞锛屽悗闈㈢殑濂楄矾鏄竴鏍风殑銆俠c涓€涓畝鍗曠殑璁＄畻鍣ㄧ▼搴忥紝鏄庣櫧鍚楋紵鉃渟hell-train>echo"3+2-5/5"|bc4鉃渟hell-train>echo"3.141592*5-4"|bc11.707960#鎬濊矾涓€锛歚cut-c9-12`寰楀埌鍑虹敓骞翠唤锛屾嫾鎺ヨ〃杈惧紡`2019-yearofbirth`寰楀埌骞撮緞銆傗灉绉垎璐︽埛>grep'"idCard":'jifenluohu.json|鍒?f2-d锛殀鍓垏-c9-12|xargs-n1鍥炲０2019-|bc|鎺掑簭|uniq-c33413353936109371623830239507407734179942813437574458645507463784723848454995042551614551614161awk鏄釜濂戒笢瑗匡紝澶氱粌涔犮€?鎷垮埌鐢熸棩鍚庣洿鎺ラ€氳繃awk璁＄畻缁撴灉杈撳嚭鉃滅Н鍒嗙粨绠?grep'"idCard":'jifenluohu.json|鍒?f2-d锛殀cut-c9-12|awk'{print2019-$1}'|鎺掑簭|uniq-c334133539361093716238302395074077341799428134375744586455074637847238485249934355165551655161鑾峰彇鑾峰緱鎴风睄鐨勫鐢熷墠10鍚嶆埛绫嶅湴杩涜鍚庣画璁＄畻銆傛瘮濡傚厛鑾峰彇top10韬唤璇佷唬琛ㄧ殑灞呬綇鍦板洓浣嶄唬鐮侊紝杩欓噷闇€瑕佺敤鍙﹀涓€涓〃绀鸿韩浠借瘉灞呬綇鍦扮殑浠ｇ爜鏉ュ搴斻€傚€熸鏈轰細瑙ｉ噴涓€涓媕oin鍛戒护銆?浠ヨ韩浠借瘉鍓?浣嶄负渚嬶紝鑾峰彇灞呬綇鍦癵rep'"idCard":'jifenluohu.json|鍒?f2-d锛殀鍒?c3-6|鎺掑簭|uniq-c|sort-nr-k1>topcity.code#鍩庡競鍒楄〃鉃滅Н鍒嗚惤鎴?morecity.csv11,鍖椾含甯?101,鍖椾含甯?10101,鍖椾含甯備笢鍩庡尯110102,鍖椾含甯傝タ鍩庡尯110103,鍖椾含甯傚磭鏂囧尯110104,鍖椾含甯傜巹姝﹀尯110105,鍖椾含甯傛湞闃冲尯#grep-E'^[0-9]{4},'city.csv|sed鐨剕,||g'>city.code4鉃渟hell-train>head-n2city.code41101鍖椾含甯傚煄鍖?102鍖椾含甯傚幙鉃渟hell-train>head-n2topcity.code19712011561302鉃渟hell-train>joinusage:join[-鏂囦欢鍙穦-vfileno][-estring][-1field][-2field][-olist][-tchar]file1file2鍏跺疄join绫讳技浜?..innerjoin...on...鍦╯ql涓紝-t鍒嗛殧绗︼紝榛樿鏄┖鏍兼垨鍒惰〃绗︺€?鏈帓搴忥紝鎵€浠ヤ笉鏄叏閮ㄥ鍑猴紙join闇€瑕佹帓搴忥級鉃渟hell-train>join-11-22city.code4topcity.code1201澶╂触甯傚尯1971302娌冲寳鐪佸攼灞卞競1562301榛戦緳姹熷搱灏旀花甯?234201婀栧寳鐪佹姹夊競11861011006201闄曡タ鐪佽タ瀹夊競1006201鐢樿們鐪佸叞宸炲競596501鏂扮枂涔岄瞾鏈ㄩ綈甯?96523鏂扮枂鏄屽悏鍥炴棌鑷不宸?1鏄惁闇€瑕佸皢缁撴灉杈撳嚭鍒版枃浠朵腑鎵嶈兘杩涜锛熶笉蹇呰銆備娇鐢ㄧ閬撴柟娉晐灏嗕笂涓€鏉″懡浠ょ殑杈撳嚭浣滀负涓嬩竴鏉″懡浠ょ殑杈撳叆锛屼娇鐢?(command)鏂规硶灏嗗懡浠ょ殑杈撳嚭浣滀负鏂囦欢杈撳叆銆?闇€瑕佹帓搴忊灉shell-train>join-11-22city.code4<(head-n10topcity.code|sort-k2)1201澶╂触甯傚煄鍖?971301娌冲寳鐪佺煶瀹跺簞甯?141302娌冲寳鐪佸攼灞卞競1561324娌冲寳鐪佷繚瀹氬競1031501鍐呰挋鍙ゅ懠鍜屾旦鐗瑰競882101杈藉畞鐪佹矇闃冲競1092201鍚夋灄鐪侀暱鏄ュ競1132301榛戦緳姹熺渷鍝堝皵婊ㄥ競1234201婀栧寳姝︽眽甯?186101闄曡タ瑗垮畨甯?00鐢ㄤ簬灏嗕袱涓枃浠舵寜鍒楀悎骞跺湪涓€璧凤細鉃渟hell-train>catpaste.f1浣犲ソ锛屾垜鏄笘鐣岋紝浣犳槸鉃渟hell-train>catpaste.f2tanglei锛屽井淇℃槸锛歵angleithu?,haha鈥嬧€媓a鉃渟hell-train>pastepaste.f1paste.f2hello锛屾垜鏄痶anglei锛屽井淇℃槸锛歵angleithuworld锛屼綘鏄紵锛屽搱鍝堝搱涓婇潰鐢╬aste鎶婁袱涓枃浠跺悎骞跺埌涓€璧蜂簡銆備簨瀹炰笂锛屽畠鍙互鍦ㄦ病鏈夊閮ㄦ枃浠跺府鍔╃殑鎯呭喌涓嬮€氳繃<(cmd)鏉ュ畬鎴愩€傛柟娉曞涓嬶細鉃渟hell-train>paste<(echo"浣犲ソ锛屾垜鏄痋nworld锛屼綘鏄?)<(echo"tanglei,wechatis:tangleithu\n?,鍝堝搱鍝?)浣犲ソ锛屾垜鏄痶anglei锛屽井淇℃槸锛歵angleithuworld锛屼綘鏄?锛屽搱鍝堝搱浠ヤ笂鏄壇铏氭暀绋嬬綉涓哄悇浣嶅皬浼欎即鍒嗕韩鐨凷hell鍛戒护鐜╂硶銆備互涓婂氨鏄壇搴忔暀绋嬬綉涓哄悇浣嶅皬浼欎即浠垎浜殑Linux鐩稿叧鐭ヨ瘑銆?/p>
