Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ponpoko1968/bff8eca9932328ef62c522659fe1c321 to your computer and use it in GitHub Desktop.
Save ponpoko1968/bff8eca9932328ef62c522659fe1c321 to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"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