Created
August 12, 2018 10:14
-
-
Save ponpoko1968/bff8eca9932328ef62c522659fe1c321 to your computer and use it in GitHub Desktop.
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
{ | |
"cells": [ | |
{ | |
"cell_type": "code", | |
"execution_count": 116, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"import pandas as pd\n", | |
"import numpy as np\n", | |
"from functools import reduce" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 117, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"appname_str = '''0 podium\n", | |
"1 inkskape\n", | |
"2 artlantis studio\n", | |
"3 3D MYHOME designer\n", | |
"4 V-Ray\n", | |
"5 Google earth\n", | |
"6 SAI\n", | |
"7 procreate\n", | |
"8 layout\n", | |
"9 Musescore\n", | |
"? 不明\n", | |
"A ARCHCAD\n", | |
"B Blender\n", | |
"C cinema 4D\n", | |
"G micro GDS\n", | |
"H 手書き一般\n", | |
"I indesign\n", | |
"L laser Cutter\n", | |
"M 3ds MAX\n", | |
"P powerpoint\n", | |
"R Revit\n", | |
"S shade\n", | |
"V VectorMapMaker\n", | |
"a AutoCAD\n", | |
"b bentley archtecture\n", | |
"c clip studio paint\n", | |
"d DRACAD\n", | |
"e autodesk ecotect analysis\n", | |
"g GIMP\n", | |
"i illustrator\n", | |
"j JW CAD\n", | |
"l lumion\n", | |
"m microstation\n", | |
"p photoshop\n", | |
"r Rhino\n", | |
"s sketchup\n", | |
"v vectorworks\n", | |
"'''\n", | |
"\n", | |
"proj_raw = '''1,vrp\n", | |
"2,ips\n", | |
"3,vpg\n", | |
"4,vsip\n", | |
"5,ips\n", | |
"6,ip\n", | |
"7,Api\n", | |
"8,ipa\n", | |
"9,Api\n", | |
"10,H\n", | |
"11,9A\n", | |
"12,3dp\n", | |
"13,ipA\n", | |
"14,vip\n", | |
"15,vpi\n", | |
"16,iprv\n", | |
"17,ipvr\n", | |
"18,rmipl\n", | |
"19,ipsaR\n", | |
"20,aip\n", | |
"21,vipg\n", | |
"22,vip\n", | |
"23,rpiI\n", | |
"24,ipV\n", | |
"25,jvip\n", | |
"26,vipr\n", | |
"27,vsripl\n", | |
"28,vP\n", | |
"29,ip\n", | |
"30,ipv\n", | |
"31,ripA\n", | |
"32,vpis\n", | |
"33,vpi\n", | |
"34,vpi\n", | |
"35,vip\n", | |
"36,vipsr\n", | |
"37,ipvsH\n", | |
"38,vpi\n", | |
"39,pisaH\n", | |
"40,vip\n", | |
"41,vsip\n", | |
"42,vip\n", | |
"43,vipH\n", | |
"44,vip\n", | |
"45,vApi\n", | |
"46,vips\n", | |
"47,aMsip\n", | |
"48,rip\n", | |
"49,vrip\n", | |
"50,Aips\n", | |
"51,ipv\n", | |
"52,aRip\n", | |
"53,arip\n", | |
"54,rvpiL\n", | |
"55,ip?\n", | |
"56,ipar\n", | |
"57,api\n", | |
"58,vpi\n", | |
"59,rip\n", | |
"60,breipl\n", | |
"61,aipc\n", | |
"62,vsip\n", | |
"63,vip\n", | |
"64,as01rpi\n", | |
"65,Rsip\n", | |
"66,vip\n", | |
"67,vsp\n", | |
"68,jvp\n", | |
"69,Aip\n", | |
"70,vrip\n", | |
"71,AspiI\n", | |
"72,Api\n", | |
"73,rCip\n", | |
"74,vip\n", | |
"75,Aip\n", | |
"76,H\n", | |
"77,ipvs\n", | |
"78,Rlip\n", | |
"79,viprC\n", | |
"80,ipG\n", | |
"81,ipAj\n", | |
"82,ipA\n", | |
"83,v\n", | |
"84,ipvH\n", | |
"85,Hip\n", | |
"86,vps2\n", | |
"87,ipjs\n", | |
"88,vips4\n", | |
"89,rip\n", | |
"90,ipa\n", | |
"91,api\n", | |
"92,Hip\n", | |
"93,vip\n", | |
"94,spiv\n", | |
"95,Aip\n", | |
"96,ipA\n", | |
"97,rip\n", | |
"98,Arip\n", | |
"99,vipr\n", | |
"100,rip\n", | |
"101,ipra5\n", | |
"102,ipr6\n", | |
"103,ipr\n", | |
"104,vpi\n", | |
"105,ipv\n", | |
"106,ipc7\n", | |
"107,ipra\n", | |
"108,iap\n", | |
"109,Hip\n", | |
"110,ipv\n", | |
"111,ApiI\n", | |
"112,asip\n", | |
"113,vip\n", | |
"114,Hi\n", | |
"115,Hip\n", | |
"116,sBp\n", | |
"117,vip\n", | |
"118,Hvip\n", | |
"119,aiA\n", | |
"120,v\n", | |
"121,H\n", | |
"122,ApiI\n", | |
"123,vp\n", | |
"124,pvS\n", | |
"125,ip\n", | |
"126,apsH\n", | |
"127,vip\n", | |
"128,rip\n", | |
"129,vAip\n", | |
"130,asip\n", | |
"131,aips\n", | |
"132,iprH\n", | |
"133,jpis0\n", | |
"134,I\n", | |
"135,ipR\n", | |
"136,jip\n", | |
"137,s80\n", | |
"138,jip\n", | |
"139,vip\n", | |
"140,ipv\n", | |
"141,ipA\n", | |
"142,vip\n", | |
"143,Aic'''" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 118, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"name_dict = dict()\n", | |
"for name_pair in appname_str.splitlines():\n", | |
" n = name_pair.split(' ')\n", | |
" if len(n)>=2:\n", | |
" appchar = n[0]\n", | |
" name_dict[appchar] = ' '.join(n[1:])" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 119, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"projs = list()\n", | |
"for proj in proj_raw.split(\"\\n\"):\n", | |
" a = proj.split(',')[1]\n", | |
" projs.append( set(a))" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 120, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"freq=dict()\n", | |
"for proj in projs:\n", | |
" for app in proj:\n", | |
" if app in name_dict:\n", | |
" if app not in freq:\n", | |
" freq[app] = 0\n", | |
" freq[app] = freq[app]+1\n", | |
"\n", | |
" \n" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 123, | |
"metadata": {}, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": [ | |
"[('p', 'photoshop', 131),\n", | |
" ('i', 'illustrator', 124),\n", | |
" ('v', 'vectorworks', 62),\n", | |
" ('r', 'Rhino', 31),\n", | |
" ('s', 'sketchup', 30),\n", | |
" ('A', 'ARCHCAD', 22),\n", | |
" ('a', 'AutoCAD', 21),\n", | |
" ('H', '手書き一般', 15),\n", | |
" ('j', 'JW CAD', 7),\n", | |
" ('R', 'Revit', 5),\n", | |
" ('I', 'indesign', 5),\n", | |
" ('l', 'lumion', 4),\n", | |
" ('c', 'clip studio paint', 3),\n", | |
" ('0', 'podium', 3),\n", | |
" ('g', 'GIMP', 2),\n", | |
" ('C', 'cinema 4D', 2),\n", | |
" ('9', 'Musescore', 1),\n", | |
" ('d', 'DRACAD', 1),\n", | |
" ('3', '3D MYHOME designer', 1),\n", | |
" ('m', 'microstation', 1),\n", | |
" ('V', 'VectorMapMaker', 1),\n", | |
" ('P', 'powerpoint', 1),\n", | |
" ('M', '3ds MAX', 1),\n", | |
" ('L', 'laser Cutter', 1),\n", | |
" ('?', '不明', 1),\n", | |
" ('b', 'bentley archtecture', 1),\n", | |
" ('e', 'autodesk ecotect analysis', 1),\n", | |
" ('1', 'inkskape', 1),\n", | |
" ('G', 'micro GDS', 1),\n", | |
" ('2', 'artlantis studio', 1),\n", | |
" ('4', 'V-Ray', 1),\n", | |
" ('5', 'Google earth', 1),\n", | |
" ('6', 'SAI', 1),\n", | |
" ('7', 'procreate', 1),\n", | |
" ('B', 'Blender', 1),\n", | |
" ('S', 'shade', 1),\n", | |
" ('8', 'layout', 1)]" | |
] | |
}, | |
"execution_count": 123, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"sorted([(v[0],name_dict[v[0]],v[1] ) for v in freq.items()], key=lambda v: v[2], reverse=True)" | |
] | |
}, | |
{ | |
"cell_type": "markdown", | |
"metadata": {}, | |
"source": [] | |
} | |
], | |
"metadata": { | |
"kernelspec": { | |
"display_name": "Python 3", | |
"language": "python", | |
"name": "python3" | |
}, | |
"language_info": { | |
"codemirror_mode": { | |
"name": "ipython", | |
"version": 3 | |
}, | |
"file_extension": ".py", | |
"mimetype": "text/x-python", | |
"name": "python", | |
"nbconvert_exporter": "python", | |
"pygments_lexer": "ipython3", | |
"version": "3.7.0" | |
} | |
}, | |
"nbformat": 4, | |
"nbformat_minor": 2 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment