How to run / execute input cells in Databricks Python Notebook

Question

I written the following code in Databricks notebook

name = input("Please enter your name: ")
age = input("How old are you, {0}?".format(name))
print(age)

As you guessed, after running the cell I am asked to 'Please enter your name:' The problem is I don't where to make the entry. If this was written in intelliJ IDEA or IDLE I would be given a separate window to enter my name. However, with Databricks notebook, even if I enter the answer in a different cell it appears to be constantly waiting for an input, see image:

I really should know the answer to this

Bob Smith · Accepted Answer · 2022-11-20 22:54:18Z

11

The input function is now natively supported in Databricks for DBR 11.2+.

An example notebook showing the use of input with pdb is available here: https://docs.databricks.com/_static/notebooks/python-debugger.html

A short screencast showing the execution of your example:

edited Nov 20, 2022 at 22:54

Bob Smith

39.1k11 gold badges107 silver badges94 bronze badges

answered Nov 20, 2022 at 22:45

Bob Bricks

1111 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fabio Schultz · Accepted Answer · 2019-01-10 13:07:45Z

7

I think what you need is

dbutils.widgets.text("name", "Please enter your name")
dbutils.widgets.text("age", "How old are you?")

Look at the top of your notebook and you will look the textboxes to fill, fill it and execute another cell with this commands

name = dbutils.widgets.get("name")
print(name)
age = dbutils.widgets.get("age")
print(age)

Doc link https://docs.databricks.com/user-guide/notebooks/widgets.html#widget-types

edited Jan 10, 2019 at 13:07

answered Jan 10, 2019 at 12:28

Fabio Schultz

5272 silver badges9 bronze badges

3 Comments

Carltonp Over a year ago

thanks. I feared that was the answer. I just learning Python so I will train on intelliJ IDEA. Thanks again Fabio

Carltonp Over a year ago

I tried making the 'age' from an text into an integer by changing the code as follows: dbutils.widgets.int("age", "How old are you?"), \n but Databricks doesn't recognize the 'int'. Is there a way of changing to integer?

Carltonp Over a year ago

I figured it out ... age = int(dbutils.widgets.get("age"))

Collectives™ on Stack Overflow

How to run / execute input cells in Databricks Python Notebook

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related