Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Converting file
#1
How do you convert an .xlsx or .csv to .ipynb?

I am using Juypter notebook and I want to upload a file but it will only upload files that are .ipynb.
Reply
#2
Probably a question better suited for the Juypter community.
If it ain't broke, I just haven't gotten to it yet.
OS: Windows 10, openSuse 42.3, freeBSD 11, Raspian "Stretch"
Python 3.6.5, IDE: PyCharm 2018 Community Edition
Reply
#3
I think you misunderstood the concept.
Example you load/read .csv or .xlsx in eg Pandas.
Do stuff eg make calculation and some plot.
Now can save it as .ipynb.

Then export .ipynb to gist and then Nbviewer.
Now can the notebook with csv/xlsx be shared.
You see in this notebook that .csv i been read in.
Reply
#4
What stuff/calculation would I have to do?
This is the page I am having problems with

[Image: g5JMlXQ.png]
Reply
#5
Is that a website for converting to shared Notebook?
Where it say Notebook File you point to your saved .ipynb
In Juypter Notebook it's File --> Download as --> Ipython Notebook(.ipynb).

I just posted a Notebook here.
I do the manual way  Download as --> Ipython Notebook(.ipynb).
Then copy all contend in .ipynb file paste to Gist and Create public gist.
Then link from Gist i paste into Nbviewer and i get a Nootebook link to share.
Reply
#6
No. This is not the website for converting. This is the website where I want to upload my file but I can only upload a .ipynb.

I have an excel sheet. I want to convert it to .ipynb so I can use that site to upload my data. I was able to convert it to cvs but not .ipynb.
Reply
#7
(Jul-24-2017, 07:28 PM)tierra32 Wrote: I have an excel sheet. I want to convert it to .ipynb so I can use that site to upload my data.
You can not convert Excel sheet to .ipynb.
You have to read excel in with eg Pandas pd.read_excel() in Jupyter notebook.
Common Excel Tasks Demonstrated in Pandas
After that can save to .ipynb,then it will have the read in excel sheet.
Reply
#8
Thank you! That explains everything. I cannot convert it.
Jupyter notebook is giving me difficulties coding. I am trying to use Brunel to make visual graph but I am having difficulties. Wall Wall
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help batch converting .json chosen file to MySQL BrandonKastning 2 2,287 Mar-14-2020, 09:19 PM
Last Post: BrandonKastning
  [split] Converting excel file to txt file unexceptionalhobby 2 4,312 Oct-16-2019, 06:34 PM
Last Post: unexceptionalhobby
  Converting excel file to txt file muhsin 3 21,596 Oct-13-2017, 07:52 PM
Last Post: nilamo
  The problem of converting string to float by using CSV file CChen 2 12,887 Jul-11-2017, 03:32 PM
Last Post: CChen

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020