I want to read a .xlsx file using the Pandas Library of python and port the data to a postgreSQL table. All I could do up until now is: import pandas as pd data = pd.ExcelFile(“*File Name*”) Now I know that the step got executed successfully, but I want to know how i can parse … Read more
In a iPython notebook, I have a while loop that listens to a Serial port and print the received data in real time. What I want to achieve to only show the latest received data (i.e only one line showing the most recent data. no scrolling in the cell output area) What I need(i think) … Read more
I am using ipython Jupyter notebook. Let’s say I defined a function that occupies a lot of space on my screen. Is there a way to collapse the cell? I want the function to remain executed and callable, yet I want to hide / collapse the cell in order to better visualize the notebook. How … Read more
I have a problem viewing the following DataFrame: n = 100 foo = DataFrame(index=range(n)) foo[‘floats’] = np.random.randn(n) foo The problem is that it does not print all rows per default in ipython notebook, but I have to slice to view the resulting rows. Even the following option does not change the output: pd.set_option(‘display.max_rows’, 500) Does … Read more
I use IPython notebooks and would like to be able to select to create a 2.x or 3.x python notebook in IPython. I initially had Anaconda. With Anaconda a global environment variable had to be changed to select what version of python you want and then IPython could be started. This is not what I … Read more
I am using iPython notebook. When I do this: df I get a beautiful table with cells. However, if i do this: df1 df2 it doesn’t print the first beautiful table. If I try this: print df1 print df2 It prints out the table in a different format that spills columns over and makes the … Read more
My Jupyter notebooks installed with python 2 kernel. I do not understand why. I might have messed something up when I did the install. I already have python 3 installed. How can I add it to Jupyter? Here’s a screenshot of what the default Jupyter insalled with python3 -m install jupyter and opened in the … Read more
I’m looking at using the *.ipynb files as the source of truth and programmatically ‘compiling’ them into .py files for scheduled jobs/tasks. The only way I understand to do this is via the GUI. Is there a way to do it via command line? 14 Answers 14
