About Loading the csv File on the jupyter

Asked 2 years ago, Updated 2 years ago, 35 views

After uploading the Excel file on jupyter, I checked it.

Error!C:\Users\user\sample.xlsx is not UTF-8 encoded
Saving disabled.
See Console for more details.

That's what comes out.
The same goes for changing the save format.

I don't know the cause at all, but what should I do?

python

2022-09-30 19:16

1 Answers

If you click on a non-Notebook file on Jupiter (in ipynb format), it opens as text and opens the edit screen.It appears that the only supported character code is UTF-8.

Recently, XML is used internally in Excel, which can be said to be text data, but when you summarize it into *.xlsx, it is compressed by zip to form a binary file.I can't open this in Jupiter.On the other hand, the CSV format is text data, so if it is UTF-8, click to open it.

Learn about the differences between *.xlsx and *.csv and how to understand the character code and save or convert it in the desired format, such as your spreadsheet software.Even if it can be saved in CSV format, it is not necessarily UTF-8, and it may be Shift JIS."If you search by the word ""Excel csvutf-8"", you will understand most of it."

However, I don't think there is any particular point in opening and editing CSV format files in Jupiter.As a bonus for the main Notebook, it comes with a simple text editor, but it doesn't have any more features.


2022-09-30 19:16

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.