Mixing
'utf-8' codec can't decode byte 0xc0 in position 1
0
I have got number of queries from the list, and I am executing them and saving them on excel file. Now each result will be store on each sheet of the excel file.
I am trying to run the queries in SQL Server, I was running the same code on Oracle and it was working, but its not working on SQL Server.
getting_list = self.create_list(connection_number)
query_sheet = os.path.abspath(os.getcwd()+'/Docs/query_results.xlsx')
# writer = pd.ExcelWriter(query_sheet)
for q in self.queries:
df = pd.read_sql_query(q, self.conn)
writer = pd.ExcelWriter(query_sheet, engine='xlsxwriter')
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
writer.save()
On running I am having this exception
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc0 in position 1: invalid start byte
and this exception is appearing on following line.
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
Please Tell me where I am making mistake.
python pandas unicode utf-8
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
|
show 1 more comment
0
I have got number of queries from the list, and I am executing them and saving them on excel file. Now each result will be store on each sheet of the excel file.
I am trying to run the queries in SQL Server, I was running the same code on Oracle and it was working, but its not working on SQL Server.
getting_list = self.create_list(connection_number)
query_sheet = os.path.abspath(os.getcwd()+'/Docs/query_results.xlsx')
# writer = pd.ExcelWriter(query_sheet)
for q in self.queries:
df = pd.read_sql_query(q, self.conn)
writer = pd.ExcelWriter(query_sheet, engine='xlsxwriter')
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
writer.save()
On running I am having this exception
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc0 in position 1: invalid start byte
and this exception is appearing on following line.
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
Please Tell me where I am making mistake.
python pandas unicode utf-8
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
xlsxis a zip package containing XML files. It doesn't have encodings. Supposingquery_results.xlsxis a realxlsxfile and not eg acsvorhtmlfile with a fake extension, what does the dataframe contain?
– Panagiotis Kanavos
Nov 20 '18 at 10:56
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00
|
show 1 more comment
0
0
0
I have got number of queries from the list, and I am executing them and saving them on excel file. Now each result will be store on each sheet of the excel file.
I am trying to run the queries in SQL Server, I was running the same code on Oracle and it was working, but its not working on SQL Server.
getting_list = self.create_list(connection_number)
query_sheet = os.path.abspath(os.getcwd()+'/Docs/query_results.xlsx')
# writer = pd.ExcelWriter(query_sheet)
for q in self.queries:
df = pd.read_sql_query(q, self.conn)
writer = pd.ExcelWriter(query_sheet, engine='xlsxwriter')
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
writer.save()
On running I am having this exception
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc0 in position 1: invalid start byte
and this exception is appearing on following line.
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
Please Tell me where I am making mistake.
python pandas unicode utf-8
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
I have got number of queries from the list, and I am executing them and saving them on excel file. Now each result will be store on each sheet of the excel file.
I am trying to run the queries in SQL Server, I was running the same code on Oracle and it was working, but its not working on SQL Server.
getting_list = self.create_list(connection_number)
query_sheet = os.path.abspath(os.getcwd()+'/Docs/query_results.xlsx')
# writer = pd.ExcelWriter(query_sheet)
for q in self.queries:
df = pd.read_sql_query(q, self.conn)
writer = pd.ExcelWriter(query_sheet, engine='xlsxwriter')
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
writer.save()
On running I am having this exception
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc0 in position 1: invalid start byte
and this exception is appearing on following line.
df.to_excel(writer, sheet_name=sheet_name=str(self.queries.index(q) + 1))
Please Tell me where I am making mistake.
python pandas unicode utf-8
python pandas unicode utf-8
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
asked Nov 20 '18 at 10:44
taimoor pasha taimoor pasha
32
32
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
xlsxis a zip package containing XML files. It doesn't have encodings. Supposingquery_results.xlsxis a realxlsxfile and not eg acsvorhtmlfile with a fake extension, what does the dataframe contain?
– Panagiotis Kanavos
Nov 20 '18 at 10:56
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00
|
show 1 more comment
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
xlsxis a zip package containing XML files. It doesn't have encodings. Supposingquery_results.xlsxis a realxlsxfile and not eg acsvorhtmlfile with a fake extension, what does the dataframe contain?
– Panagiotis Kanavos
Nov 20 '18 at 10:56
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
xlsx is a zip package containing XML files. It doesn't have encodings. Supposing query_results.xlsx is a real xlsx file and not eg a csv or html file with a fake extension, what does the dataframe contain?– Panagiotis Kanavos
Nov 20 '18 at 10:56
xlsx is a zip package containing XML files. It doesn't have encodings. Supposing query_results.xlsx is a real xlsx file and not eg a csv or html file with a fake extension, what does the dataframe contain?– Panagiotis Kanavos
Nov 20 '18 at 10:56
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53391261%2futf-8-codec-cant-decode-byte-0xc0-in-position-1%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53391261%2futf-8-codec-cant-decode-byte-0xc0-in-position-1%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
try to add encoding in the argument of your function : I would suggest encoding='iso8859-1' for example.. What language is used in your data?
– Matina G
Nov 20 '18 at 10:46
Sorry, I didn't get that.How can I achieve that?
– taimoor pasha
Nov 20 '18 at 10:50
xlsxis a zip package containing XML files. It doesn't have encodings. Supposingquery_results.xlsxis a realxlsxfile and not eg acsvorhtmlfile with a fake extension, what does the dataframe contain?– Panagiotis Kanavos
Nov 20 '18 at 10:56
SQL query results.
– taimoor pasha
Nov 20 '18 at 10:58
@taimoorpasha obviously. What data does it contain? Text, numbers? If text, is it Unicode or encoded? Does it come from a non-Unicode database field? If so, the code will choke when it finds the first non-ANSI byte.
– Panagiotis Kanavos
Nov 20 '18 at 11:00