{"action":"closed","issue":{"url":"https://api.github.com/repos/pydata/pandas-datareader/issues/522","repository_url":"https://api.github.com/repos/pydata/pandas-datareader","labels_url":"https://api.github.com/repos/pydata/pandas-datareader/issues/522/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas-datareader/issues/522/comments","events_url":"https://api.github.com/repos/pydata/pandas-datareader/issues/522/events","html_url":"https://github.com/pydata/pandas-datareader/issues/522","id":315959622,"number":522,"title":"UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 12: ordinal not in range(128)","user":{"login":"boromirmonk","id":38536004,"avatar_url":"https://avatars3.githubusercontent.com/u/38536004?v=4","gravatar_id":"","url":"https://api.github.com/users/boromirmonk","html_url":"https://github.com/boromirmonk","followers_url":"https://api.github.com/users/boromirmonk/followers","following_url":"https://api.github.com/users/boromirmonk/following{/other_user}","gists_url":"https://api.github.com/users/boromirmonk/gists{/gist_id}","starred_url":"https://api.github.com/users/boromirmonk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boromirmonk/subscriptions","organizations_url":"https://api.github.com/users/boromirmonk/orgs","repos_url":"https://api.github.com/users/boromirmonk/repos","events_url":"https://api.github.com/users/boromirmonk/events{/privacy}","received_events_url":"https://api.github.com/users/boromirmonk/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-04-19T16:53:23Z","updated_at":"2018-05-01T22:55:59Z","closed_at":"2018-05-01T22:55:59Z","author_association":"NONE","body":"```\r\nmydata_02.to_excel('C:\\Users\\Gustavo Abreu\\Documents\\Python\\eMarketer.xlsx')\r\n#mydata_03 = pd.read_excel('C:\\Users\\Gustavo Abreu\\Documents\\Python\\eMarketer.xlsx')\r\n\r\n---------------------------------------------------------------------------\r\nUnicodeDecodeError                        Traceback (most recent call last)\r\n<ipython-input-16-573373e6c7be> in <module>()\r\n----> 1 mydata_02.to_excel('C:\\Users\\Gustavo Abreu\\Documents\\Python\\eMarketer.xlsx')\r\n      2 #mydata_03 = pd.read_excel('C:\\Users\\Gustavo Abreu\\Documents\\Python\\eMarketer.xlsx')\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\pandas\\core\\frame.pyc in to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes)\r\n   1543         formatter.write(excel_writer, sheet_name=sheet_name, startrow=startrow,\r\n   1544                         startcol=startcol, freeze_panes=freeze_panes,\r\n-> 1545                         engine=engine)\r\n   1546 \r\n   1547     def to_stata(self, fname, convert_dates=None, write_index=True,\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\pandas\\io\\formats\\excel.py in write(self, writer, sheet_name, startrow, startcol, freeze_panes, engine)\r\n    649                            freeze_panes=freeze_panes)\r\n    650         if need_save:\r\n--> 651             writer.save()\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\pandas\\io\\excel.pyc in save(self)\r\n   1600         \"\"\"\r\n   1601 \r\n-> 1602         return self.book.close()\r\n   1603 \r\n   1604     def write_cells(self, cells, sheet_name=None, startrow=0, startcol=0,\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\workbook.py in close(self)\r\n    308         if not self.fileclosed:\r\n    309             self.fileclosed = 1\r\n--> 310             self._store_workbook()\r\n    311 \r\n    312     def set_size(self, width, height):\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\workbook.py in _store_workbook(self)\r\n    616         packager._set_tmpdir(self.tmpdir)\r\n    617         packager._set_in_memory(self.in_memory)\r\n--> 618         xml_files = packager._create_package()\r\n    619 \r\n    620         # Free up the Packager object.\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\packager.py in _create_package(self)\r\n    137         self._write_comment_files()\r\n    138         self._write_table_files()\r\n--> 139         self._write_shared_strings_file()\r\n    140         self._write_app_file()\r\n    141         self._write_core_file()\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\packager.py in _write_shared_strings_file(self)\r\n    284 \r\n    285         sst._set_xml_writer(self._filename('xl/sharedStrings.xml'))\r\n--> 286         sst._assemble_xml_file()\r\n    287 \r\n    288     def _write_app_file(self):\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\sharedstrings.py in _assemble_xml_file(self)\r\n     52 \r\n     53         # Write the sst strings.\r\n---> 54         self._write_sst_strings()\r\n     55 \r\n     56         # Close the sst tag.\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\sharedstrings.py in _write_sst_strings(self)\r\n     82 \r\n     83         for string in (self.string_table._get_strings()):\r\n---> 84             self._write_si(string)\r\n     85 \r\n     86     def _write_si(self, string):\r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\sharedstrings.py in _write_si(self, string)\r\n    120             self._xml_rich_si_element(string)\r\n    121         else:\r\n--> 122             self._xml_si_element(string, attributes)\r\n    123 \r\n    124 \r\n\r\nC:\\Anaconda2\\lib\\site-packages\\xlsxwriter\\xmlwriter.py in _xml_si_element(self, string, attributes)\r\n    120         string = self._escape_data(string)\r\n    121 \r\n--> 122         self.fh.write(\"\"\"<si><t%s>%s</t></si>\"\"\" % (attr, string))\r\n    123 \r\n    124     def _xml_rich_si_element(self, string):\r\n\r\nC:\\Anaconda2\\lib\\codecs.pyc in write(self, data)\r\n    704     def write(self, data):\r\n    705 \r\n--> 706         return self.writer.write(data)\r\n    707 \r\n    708     def writelines(self, list):\r\n\r\nC:\\Anaconda2\\lib\\codecs.pyc in write(self, object)\r\n    367         \"\"\" Writes the object's contents encoded to self.stream.\r\n    368         \"\"\"\r\n--> 369         data, consumed = self.encode(object, self.errors)\r\n    370         self.stream.write(data)\r\n    371 \r\n\r\nUnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 12: ordinal not in range(128)\r\n```"}}
{"actor":{"display_login":"boromirmonk"}}