{"action":"created","issue":{"url":"https://api.github.com/repos/maybelinot/df2gspread/issues/19","repository_url":"https://api.github.com/repos/maybelinot/df2gspread","labels_url":"https://api.github.com/repos/maybelinot/df2gspread/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/maybelinot/df2gspread/issues/19/comments","events_url":"https://api.github.com/repos/maybelinot/df2gspread/issues/19/events","html_url":"https://github.com/maybelinot/df2gspread/issues/19","id":178367801,"number":19,"title":"Having issues writing a \"Note\" column with various encodings","user":{"login":"schwallie2","id":11052386,"avatar_url":"https://avatars.githubusercontent.com/u/11052386?v=3","gravatar_id":"","url":"https://api.github.com/users/schwallie2","html_url":"https://github.com/schwallie2","followers_url":"https://api.github.com/users/schwallie2/followers","following_url":"https://api.github.com/users/schwallie2/following{/other_user}","gists_url":"https://api.github.com/users/schwallie2/gists{/gist_id}","starred_url":"https://api.github.com/users/schwallie2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schwallie2/subscriptions","organizations_url":"https://api.github.com/users/schwallie2/orgs","repos_url":"https://api.github.com/users/schwallie2/repos","events_url":"https://api.github.com/users/schwallie2/events{/privacy}","received_events_url":"https://api.github.com/users/schwallie2/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-09-21T14:43:17Z","updated_at":"2016-09-21T15:03:37Z","closed_at":null,"body":"The specific sentence the upload stops working on is here:\r\n\r\n> u'Love what you do to help the most kindest souls on the planet!!\\x1a\\x1a Thank you so so much!!!!'\r\n\r\nWhat happens is basically the grouped object (This is row 1100 / 7000) shows it as writing, and the cells object ( `wks.update_cells(list(cells))` ) looks totally fine, but it just doesn't write correctly to the Google doc. The ~20 or so rows in the group end up being blank, with the index written previous still being there.\r\n\r\nI've tried using:\r\n`d['Note'] = d['Note'].str.decode('utf8')`\r\n\r\nAlong with encoding to utf8. Encoding to ascii/others doesn't work on the series as I get errors.\r\n\r\nIs there a specific encoding I should be using, or some kind of safe method to get this to write?"},"comment":{"url":"https://api.github.com/repos/maybelinot/df2gspread/issues/comments/248640190","html_url":"https://github.com/maybelinot/df2gspread/issues/19#issuecomment-248640190","issue_url":"https://api.github.com/repos/maybelinot/df2gspread/issues/19","id":248640190,"user":{"login":"maybelinot","id":5212597,"avatar_url":"https://avatars.githubusercontent.com/u/5212597?v=3","gravatar_id":"","url":"https://api.github.com/users/maybelinot","html_url":"https://github.com/maybelinot","followers_url":"https://api.github.com/users/maybelinot/followers","following_url":"https://api.github.com/users/maybelinot/following{/other_user}","gists_url":"https://api.github.com/users/maybelinot/gists{/gist_id}","starred_url":"https://api.github.com/users/maybelinot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maybelinot/subscriptions","organizations_url":"https://api.github.com/users/maybelinot/orgs","repos_url":"https://api.github.com/users/maybelinot/repos","events_url":"https://api.github.com/users/maybelinot/events{/privacy}","received_events_url":"https://api.github.com/users/maybelinot/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T15:03:37Z","updated_at":"2016-09-21T15:03:37Z","body":"@schwallie2 The problem is on google side and I think that warning should came from [gspread](https://github.com/burnash/gspread) package because all API calls happens there.. It's too expensive to check if uploaded data is identical with original one.. But I think there could be added some flag, like `verify_downloading` or something like that.."}}
{"actor":{"display_login":"maybelinot"}}