{"cells":[{"metadata":{},"cell_type":"markdown","source":"# Translation of Site & Floor Names from Chinese to English\n\nThere are 205 sites present in the data for the competition \"[Indoor Location & Navigation](https://www.kaggle.com/c/indoor-location-navigation)\". The names of the sites are in Chinese. This kernel translates these site names from Chinese to English using `googletrans` library.\n\nAlso, there are 5 cases where the floor name is also in chinese. Those have also been translated.\n\nTranslated Site & Floor Names are published in the following dataset:\n\nhttps://www.kaggle.com/arnabbiswas1/indoor-location-navigation-sitename-in-english\n\nOr the CSV file mapping the chinese to english names (`site_name_eng.csv` and `floor_name_eng.csv`) are saved as the output of this kernel."},{"metadata":{"trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"! pip install googletrans==4.0.0-rc1","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"from googletrans import Translator\nimport pandas as pd\n\npd.options.display.max_rows = 300\n\n\ntranslator = Translator()\n\nsite_name_ch = [\"西溪银泰城\", \"远洋乐堤港_new\", \"远洋乐堤港\", \"特力时尚汇\", \"嘉尚坊\", \"红太阳商业广场\", \"乐坊精致生活广场\", \"百联南方购物中心\", \"九六广场\", \"1088广场\", \"缤谷广场\", \"百盛优客城市广场\", \"亚繁生活时尚广场\", \"宝乐汇\", \"壹丰广场\", \"凯迪·新都汇\", \"七宝万科广场\", \"百联又一城购物中心\", \"鑫都商业广场\", \"绿色米兰城市奥特莱斯(米兰广场店)\", \"中信广场\", \"益丰·外滩源\", \"宝山宝龙城市广场\", \"瑞虹生活广场\", \"中原城市广场\", \"189弄购物中心\", \"香港名都\", \"我格广场\", \"光启城\", \"昊元生活广场\", \"日月光中心\", \"绿地乐和城\", \"王子生活馆\", \"新大陆广场\", \"深喜迪运商场\", \"大华锦绣嘉年华\", \"力宝广场购物中心\", \"凯德龙之梦购物中心(莘庄店)\", \"东阔生活广场\", \"巴黎春天百货(淮海店)\", \"浦东商场(昌里店)\", \"悦达889广场\", \"曲阳生活购物中心\", \"弘基时尚生活中心\", \"玫瑰坊\", \"福佑门商厦\", \"凯德龙之梦购物中心(长宁店)\", \"芳汇广场\", \"杨浦商贸延吉商业中心\", \"同济联合广场\", \"旭辉Mall\", \"万达广场(颛桥店)\", \"新天地时尚\", \"长风大悦城\", \"金沙和美广场\", \"盛源生活广场\", \"海伦精致生活广场\", \"百联滨江购物中心\", \"巴黎春天(杨浦店)\", \"来福士广场\", \"久光百货\", \"巴黎春天(宝山店)\", \"太平洋百货(不夜城店)\", \"诺亚新天地\", \"汇暻生活广场\", \"上海新天地南里\", \"百盛(淮海路店)\", \"KiNG\", \"世博源\", \"高岛屋\", \"嘉杰国际广场\", \"曹杨商城\", \"利通广场\", \"尚嘉中心\", \"福源商厦(城隍庙店)\", \"大华虎城嘉年华\", \"晶品\", \"上海大悦城\", \"万达广场(宝山店)\", \"环龙商场\", \"飞洲国际广场\", \"圣德娜商厦\", \"汇金百货(虹桥店)\", \"万达广场(江桥店)\", \"黄金广场\", \"巴黎春天(浦建店)\", \"华宁·弘基生活中心\", \"香港广场\", \"黄金钫\", \"恒隆广场\", \"凯德龙之梦(虹口店)\", \"天虹商业广场\", \"绿地金御广场\", \"黄浦逸城\", \"巴黎春天(陕西路店)\", \"瑞虹天地月亮湾\", \"淞南购物中心\", \"新宜街A1座\", \"上海环球港\", \"百联北上海购物中心\", \"正大乐城\", \"俪人街商场\", \"圣和圣时尚汇\", \"弘基广场\", \"合生汇\", \"九隆坊\", \"新邻天地\", \"五月花生活广场\", \"上海环贸iapm商场\", \"米格天地\", \"万达广场(松江店)\", \"大润发(杨浦店)\", \"森晟世洋国际广场\", \"红星美凯龙(汶水店)\", \"vanke2049海上传奇\", \"999兆丰广场\", \"奉贤宝龙城市广场\", \"兴业太古汇\", \"百联社区商业中心\", \"吾悦广场\", \"东鼎购物中心\", \"云洲古玩城\", \"绿地缤纷城(徐汇店)\", \"成泰百货\", \"东方商厦(青浦店)\", \"文汇新天地\", \"嘉亭荟城市生活广场\", \"海外滩\", \"上海第一八佰伴新世纪商厦\", \"长宁来福士\", \"九百购物中心\", \"莲花国际广场\", \"聚丰购物广场\", \"宝地广场\", \"瑞虹天地星星堂\", \"同乐生活广场\", \"塞纳左岸生活广场\", \"华轻梅陇购物中心\", \"三湘商业广场\", \"双高广场\", \"新理想广场\", \"开元地中海商业广场\", \"尚网商场\", \"新梅联合广场\", \"沃尔玛购物广场(南浦大桥店)\", \"安亭财富广场\", \"新九广场\", \"麦多生活广场11座\", \"嘉实生活广场\", \"嘉和休闲广场\", \"世纪联华(车站南路店)\", \"佘山湾生活购物广场\", \"亚美尚购物广场\", \"松江商城\", \"浦商百货\", \"上海豪浦服饰城\", \"七浦路服装批发市场\", \"临港宝龙城市广场\", \"大融城\", \"白马高级服装市场\", \"连城商业广场\", \"正大广场\", \"红星美凯龙金桥商场\", \"亚新生活广场\", \"置业广场\", \"罗宾森广场\", \"东方商厦(嘉定店)\", \"曹丰建材家居商场\", \"长城·弘基广场\", \"汇阳广场\", \"淞发建材家居市场\", \"金悦·生活广场\", \"丰庄茶城\", \"鹿都国际购物广场\", \"申越广场\", \"云山休闲广场\", \"玩酷天地商业广场\", \"汇融天地\", \"百联南桥购物中心\", \"卜蜂莲花(南奉店)\", \"万达广场(金山店)\", \"银泰城(城西店)\", \"水晶城购物中心\", \"华联·星光大道二期\", \"银泰百货(庆春店)\", \"利星名品(铭德广场店)\", \"印象城(古墩路店)\", \"万达广场(拱墅店)\", \"西田城购物中心\", \"银泰百货(武林店)\", \"福雷德广场\", \"印象城(西溪店)\", \"运河上街购物中心\", \"下沙商贸城\", \"杭州嘉里中心\", \"昆仑·西城广场\", \"万泰城\", \"永旺梦乐城\", \"城市生活广场\", \"银泰百货\", \"和达城商场\", \"万象城\", \"杭州来福士\", \"杭州大悦城\", \"龙湖杭州滨江天街\"]\n\nfloor_name_ch = [\"地下一层\", \"一层\", \"二层\", \"三层\", \"四层\"]\n\nsite_name_eng_dict = {}\nfor name in site_name_ch:\n    site_name_eng = translator.translate(name).text\n    site_name_eng_dict[name] = site_name_eng\n\nfloor_name_eng_dict = {}\nfor name in floor_name_ch:\n    floor_name_eng = translator.translate(name).text\n    floor_name_eng_dict[name] = floor_name_eng\n\nsite_name_eng_df = pd.DataFrame.from_dict(site_name_eng_dict, orient='index')\nsite_name_eng_df = site_name_eng_df.reset_index(drop=False)\nsite_name_eng_df.columns = [\"site_name_chinese\", \"site_name_english\"]\nsite_name_eng_df.to_csv(\"site_name_eng.csv\", index=False)\n\nfloor_name_eng_df = pd.DataFrame.from_dict(floor_name_eng_dict, orient='index')\nfloor_name_eng_df = floor_name_eng_df.reset_index(drop=False)\nfloor_name_eng_df.columns = [\"floor_name_chinese\", \"floor_name_english\"]\nfloor_name_eng_df.to_csv(\"floor_name_eng.csv\", index=False)","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"## Here are the translated Site Names"},{"metadata":{"_kg_hide-input":true,"trusted":true},"cell_type":"code","source":"site_name_eng_df","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"## Here are the translated Floor Names","execution_count":null,"outputs":[]},{"metadata":{"_kg_hide-input":true,"trusted":true},"cell_type":"code","source":"floor_name_eng_df","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat":4,"nbformat_minor":4}