93 lines
18 KiB
Plaintext
93 lines
18 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "code",
|
|
"id": "initial_id",
|
|
"metadata": {
|
|
"collapsed": true,
|
|
"ExecuteTime": {
|
|
"end_time": "2025-03-03T09:28:29.697368Z",
|
|
"start_time": "2025-03-03T09:28:27.041827Z"
|
|
}
|
|
},
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"from googletrans import Translator\n",
|
|
"\n",
|
|
"# 初始化翻译器\n",
|
|
"translator = Translator()\n",
|
|
"\n",
|
|
"# 读取Excel文件\n",
|
|
"file_path = r\"C:\\Users\\Administrator.DESKTOP-7IC2USJ\\Desktop\\新建文件夹\\Product68_1.xls\" # 替换为你的Excel文件路径\n",
|
|
"df = pd.read_excel(file_path,sheet_name='Products')\n",
|
|
"\n",
|
|
"# 定义一个函数来翻译单元格内容\n",
|
|
"def translate_text(text, src='zh-cn', dest='th'):\n",
|
|
" try:\n",
|
|
" translated = translator.translate(text, src=src, dest=dest)\n",
|
|
" return translated.text\n",
|
|
" except Exception as e:\n",
|
|
" print(f\"Error translating text '{text}': {e}\")\n",
|
|
" return text\n",
|
|
"\n",
|
|
"# 遍历DataFrame并翻译每个单元格的内容\n",
|
|
"for column in df.columns:\n",
|
|
" df[column] = df[column].apply(lambda x: translate_text(str(x)) if isinstance(x, str) else x)\n",
|
|
"\n",
|
|
"# 保存翻译后的DataFrame到新的Excel文件\n",
|
|
"output_file_path = r'C:\\Users\\Administrator.DESKTOP-7IC2USJ\\Desktop\\新建文件夹、translated_excel_file.xlsx' # 替换为你想要保存的文件路径\n",
|
|
"df.to_excel(output_file_path, index=False)\n",
|
|
"\n",
|
|
"print(\"Translation complete and saved to\", output_file_path)"
|
|
],
|
|
"outputs": [
|
|
{
|
|
"ename": "UnicodeDecodeError",
|
|
"evalue": "'gbk' codec can't decode byte 0xaa in position 0: illegal multibyte sequence",
|
|
"output_type": "error",
|
|
"traceback": [
|
|
"\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
|
|
"\u001B[1;31mUnicodeDecodeError\u001B[0m Traceback (most recent call last)",
|
|
"Cell \u001B[1;32mIn[1], line 9\u001B[0m\n\u001B[0;32m 7\u001B[0m \u001B[38;5;66;03m# 读取Excel文件\u001B[39;00m\n\u001B[0;32m 8\u001B[0m file_path \u001B[38;5;241m=\u001B[39m \u001B[38;5;124mr\u001B[39m\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mC:\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mUsers\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mAdministrator.DESKTOP-7IC2USJ\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mDesktop\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124m新建文件夹\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mProduct68_1.xls\u001B[39m\u001B[38;5;124m\"\u001B[39m \u001B[38;5;66;03m# 替换为你的Excel文件路径\u001B[39;00m\n\u001B[1;32m----> 9\u001B[0m df \u001B[38;5;241m=\u001B[39m pd\u001B[38;5;241m.\u001B[39mread_excel(file_path,sheet_name\u001B[38;5;241m=\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mProducts\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m 11\u001B[0m \u001B[38;5;66;03m# 定义一个函数来翻译单元格内容\u001B[39;00m\n\u001B[0;32m 12\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtranslate_text\u001B[39m(text, src\u001B[38;5;241m=\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mzh-cn\u001B[39m\u001B[38;5;124m'\u001B[39m, dest\u001B[38;5;241m=\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mth\u001B[39m\u001B[38;5;124m'\u001B[39m):\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\pandas\\io\\excel\\_base.py:495\u001B[0m, in \u001B[0;36mread_excel\u001B[1;34m(io, sheet_name, header, names, index_col, usecols, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, parse_dates, date_parser, date_format, thousands, decimal, comment, skipfooter, storage_options, dtype_backend, engine_kwargs)\u001B[0m\n\u001B[0;32m 493\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;129;01mnot\u001B[39;00m \u001B[38;5;28misinstance\u001B[39m(io, ExcelFile):\n\u001B[0;32m 494\u001B[0m should_close \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;01mTrue\u001B[39;00m\n\u001B[1;32m--> 495\u001B[0m io \u001B[38;5;241m=\u001B[39m ExcelFile(\n\u001B[0;32m 496\u001B[0m io,\n\u001B[0;32m 497\u001B[0m storage_options\u001B[38;5;241m=\u001B[39mstorage_options,\n\u001B[0;32m 498\u001B[0m engine\u001B[38;5;241m=\u001B[39mengine,\n\u001B[0;32m 499\u001B[0m engine_kwargs\u001B[38;5;241m=\u001B[39mengine_kwargs,\n\u001B[0;32m 500\u001B[0m )\n\u001B[0;32m 501\u001B[0m \u001B[38;5;28;01melif\u001B[39;00m engine \u001B[38;5;129;01mand\u001B[39;00m engine \u001B[38;5;241m!=\u001B[39m io\u001B[38;5;241m.\u001B[39mengine:\n\u001B[0;32m 502\u001B[0m \u001B[38;5;28;01mraise\u001B[39;00m \u001B[38;5;167;01mValueError\u001B[39;00m(\n\u001B[0;32m 503\u001B[0m \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mEngine should not be specified when passing \u001B[39m\u001B[38;5;124m\"\u001B[39m\n\u001B[0;32m 504\u001B[0m \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124man ExcelFile - ExcelFile already has the engine set\u001B[39m\u001B[38;5;124m\"\u001B[39m\n\u001B[0;32m 505\u001B[0m )\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\pandas\\io\\excel\\_base.py:1567\u001B[0m, in \u001B[0;36mExcelFile.__init__\u001B[1;34m(self, path_or_buffer, engine, storage_options, engine_kwargs)\u001B[0m\n\u001B[0;32m 1564\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mengine \u001B[38;5;241m=\u001B[39m engine\n\u001B[0;32m 1565\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mstorage_options \u001B[38;5;241m=\u001B[39m storage_options\n\u001B[1;32m-> 1567\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_reader \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_engines[engine](\n\u001B[0;32m 1568\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_io,\n\u001B[0;32m 1569\u001B[0m storage_options\u001B[38;5;241m=\u001B[39mstorage_options,\n\u001B[0;32m 1570\u001B[0m engine_kwargs\u001B[38;5;241m=\u001B[39mengine_kwargs,\n\u001B[0;32m 1571\u001B[0m )\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\pandas\\io\\excel\\_xlrd.py:46\u001B[0m, in \u001B[0;36mXlrdReader.__init__\u001B[1;34m(self, filepath_or_buffer, storage_options, engine_kwargs)\u001B[0m\n\u001B[0;32m 44\u001B[0m err_msg \u001B[38;5;241m=\u001B[39m \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mInstall xlrd >= 2.0.1 for xls Excel support\u001B[39m\u001B[38;5;124m\"\u001B[39m\n\u001B[0;32m 45\u001B[0m import_optional_dependency(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mxlrd\u001B[39m\u001B[38;5;124m\"\u001B[39m, extra\u001B[38;5;241m=\u001B[39merr_msg)\n\u001B[1;32m---> 46\u001B[0m \u001B[38;5;28msuper\u001B[39m()\u001B[38;5;241m.\u001B[39m\u001B[38;5;21m__init__\u001B[39m(\n\u001B[0;32m 47\u001B[0m filepath_or_buffer,\n\u001B[0;32m 48\u001B[0m storage_options\u001B[38;5;241m=\u001B[39mstorage_options,\n\u001B[0;32m 49\u001B[0m engine_kwargs\u001B[38;5;241m=\u001B[39mengine_kwargs,\n\u001B[0;32m 50\u001B[0m )\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\pandas\\io\\excel\\_base.py:573\u001B[0m, in \u001B[0;36mBaseExcelReader.__init__\u001B[1;34m(self, filepath_or_buffer, storage_options, engine_kwargs)\u001B[0m\n\u001B[0;32m 571\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mhandles\u001B[38;5;241m.\u001B[39mhandle\u001B[38;5;241m.\u001B[39mseek(\u001B[38;5;241m0\u001B[39m)\n\u001B[0;32m 572\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[1;32m--> 573\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mbook \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mload_workbook(\u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mhandles\u001B[38;5;241m.\u001B[39mhandle, engine_kwargs)\n\u001B[0;32m 574\u001B[0m \u001B[38;5;28;01mexcept\u001B[39;00m \u001B[38;5;167;01mException\u001B[39;00m:\n\u001B[0;32m 575\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mclose()\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\pandas\\io\\excel\\_xlrd.py:63\u001B[0m, in \u001B[0;36mXlrdReader.load_workbook\u001B[1;34m(self, filepath_or_buffer, engine_kwargs)\u001B[0m\n\u001B[0;32m 61\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;28mhasattr\u001B[39m(filepath_or_buffer, \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mread\u001B[39m\u001B[38;5;124m\"\u001B[39m):\n\u001B[0;32m 62\u001B[0m data \u001B[38;5;241m=\u001B[39m filepath_or_buffer\u001B[38;5;241m.\u001B[39mread()\n\u001B[1;32m---> 63\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m open_workbook(file_contents\u001B[38;5;241m=\u001B[39mdata, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mengine_kwargs)\n\u001B[0;32m 64\u001B[0m \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[0;32m 65\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m open_workbook(filepath_or_buffer, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mengine_kwargs)\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\__init__.py:172\u001B[0m, in \u001B[0;36mopen_workbook\u001B[1;34m(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows, ignore_workbook_corruption)\u001B[0m\n\u001B[0;32m 169\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m file_format \u001B[38;5;129;01mand\u001B[39;00m file_format \u001B[38;5;241m!=\u001B[39m \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mxls\u001B[39m\u001B[38;5;124m'\u001B[39m:\n\u001B[0;32m 170\u001B[0m \u001B[38;5;28;01mraise\u001B[39;00m XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]\u001B[38;5;241m+\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124m; not supported\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[1;32m--> 172\u001B[0m bk \u001B[38;5;241m=\u001B[39m open_workbook_xls(\n\u001B[0;32m 173\u001B[0m filename\u001B[38;5;241m=\u001B[39mfilename,\n\u001B[0;32m 174\u001B[0m logfile\u001B[38;5;241m=\u001B[39mlogfile,\n\u001B[0;32m 175\u001B[0m verbosity\u001B[38;5;241m=\u001B[39mverbosity,\n\u001B[0;32m 176\u001B[0m use_mmap\u001B[38;5;241m=\u001B[39muse_mmap,\n\u001B[0;32m 177\u001B[0m file_contents\u001B[38;5;241m=\u001B[39mfile_contents,\n\u001B[0;32m 178\u001B[0m encoding_override\u001B[38;5;241m=\u001B[39mencoding_override,\n\u001B[0;32m 179\u001B[0m formatting_info\u001B[38;5;241m=\u001B[39mformatting_info,\n\u001B[0;32m 180\u001B[0m on_demand\u001B[38;5;241m=\u001B[39mon_demand,\n\u001B[0;32m 181\u001B[0m ragged_rows\u001B[38;5;241m=\u001B[39mragged_rows,\n\u001B[0;32m 182\u001B[0m ignore_workbook_corruption\u001B[38;5;241m=\u001B[39mignore_workbook_corruption,\n\u001B[0;32m 183\u001B[0m )\n\u001B[0;32m 185\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m bk\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\book.py:107\u001B[0m, in \u001B[0;36mopen_workbook_xls\u001B[1;34m(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows, ignore_workbook_corruption)\u001B[0m\n\u001B[0;32m 105\u001B[0m bk\u001B[38;5;241m.\u001B[39m_sheet_list \u001B[38;5;241m=\u001B[39m [\u001B[38;5;28;01mNone\u001B[39;00m \u001B[38;5;28;01mfor\u001B[39;00m sh \u001B[38;5;129;01min\u001B[39;00m bk\u001B[38;5;241m.\u001B[39m_sheet_names]\n\u001B[0;32m 106\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;129;01mnot\u001B[39;00m on_demand:\n\u001B[1;32m--> 107\u001B[0m bk\u001B[38;5;241m.\u001B[39mget_sheets()\n\u001B[0;32m 108\u001B[0m bk\u001B[38;5;241m.\u001B[39mnsheets \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mlen\u001B[39m(bk\u001B[38;5;241m.\u001B[39m_sheet_list)\n\u001B[0;32m 109\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m biff_version \u001B[38;5;241m==\u001B[39m \u001B[38;5;241m45\u001B[39m \u001B[38;5;129;01mand\u001B[39;00m bk\u001B[38;5;241m.\u001B[39mnsheets \u001B[38;5;241m>\u001B[39m \u001B[38;5;241m1\u001B[39m:\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\book.py:722\u001B[0m, in \u001B[0;36mBook.get_sheets\u001B[1;34m(self)\u001B[0m\n\u001B[0;32m 720\u001B[0m \u001B[38;5;28;01mfor\u001B[39;00m sheetno \u001B[38;5;129;01min\u001B[39;00m xrange(\u001B[38;5;28mlen\u001B[39m(\u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sheet_names)):\n\u001B[0;32m 721\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m DEBUG: \u001B[38;5;28mprint\u001B[39m(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mGET_SHEETS: sheetno =\u001B[39m\u001B[38;5;124m\"\u001B[39m, sheetno, \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sheet_names, \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sh_abs_posn, file\u001B[38;5;241m=\u001B[39m\u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mlogfile)\n\u001B[1;32m--> 722\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mget_sheet(sheetno)\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\book.py:713\u001B[0m, in \u001B[0;36mBook.get_sheet\u001B[1;34m(self, sh_number, update_pos)\u001B[0m\n\u001B[0;32m 702\u001B[0m \u001B[38;5;66;03m# assert biff_version == self.biff_version ### FAILS\u001B[39;00m\n\u001B[0;32m 703\u001B[0m \u001B[38;5;66;03m# Have an example where book is v7 but sheet reports v8!!!\u001B[39;00m\n\u001B[0;32m 704\u001B[0m \u001B[38;5;66;03m# It appears to work OK if the sheet version is ignored.\u001B[39;00m\n\u001B[0;32m 705\u001B[0m \u001B[38;5;66;03m# Confirmed by Daniel Rentz: happens when Excel does \"save as\"\u001B[39;00m\n\u001B[0;32m 706\u001B[0m \u001B[38;5;66;03m# creating an old version file; ignore version details on sheet BOF.\u001B[39;00m\n\u001B[0;32m 707\u001B[0m sh \u001B[38;5;241m=\u001B[39m sheet\u001B[38;5;241m.\u001B[39mSheet(\n\u001B[0;32m 708\u001B[0m \u001B[38;5;28mself\u001B[39m,\n\u001B[0;32m 709\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_position,\n\u001B[0;32m 710\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sheet_names[sh_number],\n\u001B[0;32m 711\u001B[0m sh_number,\n\u001B[0;32m 712\u001B[0m )\n\u001B[1;32m--> 713\u001B[0m sh\u001B[38;5;241m.\u001B[39mread(\u001B[38;5;28mself\u001B[39m)\n\u001B[0;32m 714\u001B[0m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sheet_list[sh_number] \u001B[38;5;241m=\u001B[39m sh\n\u001B[0;32m 715\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m sh\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\sheet.py:838\u001B[0m, in \u001B[0;36mSheet.read\u001B[1;34m(self, bk)\u001B[0m\n\u001B[0;32m 836\u001B[0m rowx, colx, xf_index \u001B[38;5;241m=\u001B[39m local_unpack(\u001B[38;5;124m'\u001B[39m\u001B[38;5;124m<HHH\u001B[39m\u001B[38;5;124m'\u001B[39m, data[\u001B[38;5;241m0\u001B[39m:\u001B[38;5;241m6\u001B[39m])\n\u001B[0;32m 837\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m bv \u001B[38;5;241m<\u001B[39m BIFF_FIRST_UNICODE:\n\u001B[1;32m--> 838\u001B[0m strg \u001B[38;5;241m=\u001B[39m unpack_string(data, \u001B[38;5;241m6\u001B[39m, bk\u001B[38;5;241m.\u001B[39mencoding \u001B[38;5;129;01mor\u001B[39;00m bk\u001B[38;5;241m.\u001B[39mderive_encoding(), lenlen\u001B[38;5;241m=\u001B[39m\u001B[38;5;241m2\u001B[39m)\n\u001B[0;32m 839\u001B[0m \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[0;32m 840\u001B[0m strg \u001B[38;5;241m=\u001B[39m unpack_unicode(data, \u001B[38;5;241m6\u001B[39m, lenlen\u001B[38;5;241m=\u001B[39m\u001B[38;5;241m2\u001B[39m)\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\biffh.py:250\u001B[0m, in \u001B[0;36munpack_string\u001B[1;34m(data, pos, encoding, lenlen)\u001B[0m\n\u001B[0;32m 248\u001B[0m nchars \u001B[38;5;241m=\u001B[39m unpack(\u001B[38;5;124m'\u001B[39m\u001B[38;5;124m<\u001B[39m\u001B[38;5;124m'\u001B[39m \u001B[38;5;241m+\u001B[39m \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mBH\u001B[39m\u001B[38;5;124m'\u001B[39m[lenlen\u001B[38;5;241m-\u001B[39m\u001B[38;5;241m1\u001B[39m], data[pos:pos\u001B[38;5;241m+\u001B[39mlenlen])[\u001B[38;5;241m0\u001B[39m]\n\u001B[0;32m 249\u001B[0m pos \u001B[38;5;241m+\u001B[39m\u001B[38;5;241m=\u001B[39m lenlen\n\u001B[1;32m--> 250\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m unicode(data[pos:pos\u001B[38;5;241m+\u001B[39mnchars], encoding)\n",
|
|
"File \u001B[1;32mD:\\ProgramTools\\Anaconda\\Lib\\site-packages\\xlrd\\timemachine.py:31\u001B[0m, in \u001B[0;36m<lambda>\u001B[1;34m(b, enc)\u001B[0m\n\u001B[0;32m 29\u001B[0m REPR \u001B[38;5;241m=\u001B[39m ascii\n\u001B[0;32m 30\u001B[0m xrange \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mrange\u001B[39m\n\u001B[1;32m---> 31\u001B[0m unicode \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;01mlambda\u001B[39;00m b, enc: b\u001B[38;5;241m.\u001B[39mdecode(enc)\n\u001B[0;32m 32\u001B[0m ensure_unicode \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;01mlambda\u001B[39;00m s: s\n\u001B[0;32m 33\u001B[0m unichr \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mchr\u001B[39m\n",
|
|
"\u001B[1;31mUnicodeDecodeError\u001B[0m: 'gbk' codec can't decode byte 0xaa in position 0: illegal multibyte sequence"
|
|
]
|
|
}
|
|
],
|
|
"execution_count": 1
|
|
}
|
|
],
|
|
"metadata": {
|
|
"kernelspec": {
|
|
"display_name": "Python 3",
|
|
"language": "python",
|
|
"name": "python3"
|
|
},
|
|
"language_info": {
|
|
"codemirror_mode": {
|
|
"name": "ipython",
|
|
"version": 2
|
|
},
|
|
"file_extension": ".py",
|
|
"mimetype": "text/x-python",
|
|
"name": "python",
|
|
"nbconvert_exporter": "python",
|
|
"pygments_lexer": "ipython2",
|
|
"version": "2.7.6"
|
|
}
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 5
|
|
}
|