Styjun

GDPR: What happens to deleted contacts re-entered through imports

Can MuseScore be used programmatically?

Is it true that different variants of the same model aircraft don't require pilot retraining?

Why is there not a willingness from the world to step in between Pakistan and India?

Does NASA use any type of office/groupware software and which is that?

Time difference between banns and marriage

How do we improve collaboration with problematic tester team?

Why does a sticker slowly peel off, but if it is pulled quickly it tears?

Force SQL Server to use fragmented indexes?

How to determine algebraically whether an equation has an infinite solutions or not?

Commercial company wants me to list all prior "inventions", give up everything not listed

Etymology of "Talo" (Finnish for "house"). Can it be a cognate of Thalamus?

Talk interpreter

Units in general relativity

Find most "academic" implementation of doubly linked list

Many many thanks

How to force GCC to assume that a floating-point expression is non-negative?

Is a Centaur PC considered an animal when calculating carrying capacity for vehicles?

Do sharpies or markers damage soft rock climbing gear?

Are strlen optimizations really needed in glibc?

Dotted background on a flowchart

Why didn't Doc believe Marty was from the future?

Why does Windows store Wi-Fi passwords in a reversible format?

Why did James Cameron decide to give Alita big eyes?

custom magic to run selected lines in a cell

How to run an IPython magic from a script (or timing a Python script)Using IPython notebooks under version controlJupyter: Write a custom magic that modifies the contents of the cell it's inIntegrating R with Python - how to use R magics as input and output of a python processadding syntax highlighting to Jupyter notebook cell magicIs there a way to time each line of a Python script?Jupyter asynchronously interact with running cellImport .py flie into Jupyter Notebook line by line

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am using Jupyter to run Python code from web browser. It runs one cell at a time. My python code looks like this

spark.sql('''
select * from table 
''').toPandas()

Ideally, I would like to only write sql in the cell. Mutliple sql statements at a time. Then select one sql statement, hit run key, the custom magic wrap the sql query in the spark.sql(''' ''') syntax and submit to the server. This will improve my efficiency.
Thanks for any suggestions.

jupyter-notebook ipython

share|improve this question

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am now able to use %%html code to create a textarea below the current cell and listen to F8 key, if F8 is pressed, the selected text (python code) in textarea is captured in the javascript variable. But how do I submit this piece of python code to server to run?
  
  – shane zhang
  Mar 29 at 20:15
  
  

  
  
  
  

add a comment | 

0

I am using Jupyter to run Python code from web browser. It runs one cell at a time. My python code looks like this

spark.sql('''
select * from table 
''').toPandas()

Ideally, I would like to only write sql in the cell. Mutliple sql statements at a time. Then select one sql statement, hit run key, the custom magic wrap the sql query in the spark.sql(''' ''') syntax and submit to the server. This will improve my efficiency.
Thanks for any suggestions.

jupyter-notebook ipython

share|improve this question

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am now able to use %%html code to create a textarea below the current cell and listen to F8 key, if F8 is pressed, the selected text (python code) in textarea is captured in the javascript variable. But how do I submit this piece of python code to server to run?
  
  – shane zhang
  Mar 29 at 20:15
  
  

  
  
  
  

add a comment | 

I am using Jupyter to run Python code from web browser. It runs one cell at a time. My python code looks like this

spark.sql('''
select * from table 
''').toPandas()

Ideally, I would like to only write sql in the cell. Mutliple sql statements at a time. Then select one sql statement, hit run key, the custom magic wrap the sql query in the spark.sql(''' ''') syntax and submit to the server. This will improve my efficiency.
Thanks for any suggestions.

jupyter-notebook ipython

share|improve this question

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

spark.sql('''
select * from table 
''').toPandas()

share|improve this question

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

share|improve this question

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

edited Mar 27 at 20:31

Gary Kerr

8,77622 gold badges3636 silver badges4545 bronze badges

asked Mar 27 at 20:24

shane zhangshane zhang

1

asked Mar 27 at 20:24

shane zhangshane zhang

1