Reply
CrhIT
Frequent Visitor

How to get a variable from one Notebook into another

I'm running a notebook, which output needs to be stored and used in a new notebook. How can this be done?

 

Let's say in Notebook_1 the code is

import pandas as pd

# Create an example pandas DataFrame
data = {
    "ID": [1, 2, 3, 4, 5],
    "Name": ["Alice", "Bob", "Charlie", "David", "Eve"],
    "Age": [25, 30, 35, 40, 45],
    "Salary": [50000, 60000, 70000, 80000, 90000],
    "Department": ["HR", "IT", "Finance", "Marketing", "Sales"]
}

df = pd.DataFrame(data)

 

I want to reference df in a new notebook so I have no need to rewrite the whole code in the new notebook.

1 ACCEPTED SOLUTION
nilendraFabric
Community Champion
Community Champion

Hello @CrhIT 

 

The `%run` magic command allows you to execute another notebook within the same workspace and access its variables directly.

 

Notebook1

 

import pandas as pd

data = {
"ID": [1, 2, 3, 4, 5],
"Name": ["Alice", "Bob", "Charlie", "David", "Eve"],
"Age": [25, 30, 35, 40, 45],
"Salary": [50000, 60000, 70000, 80000, 90000],
"Department": ["HR", "IT", "Finance", "Marketing", "Sales"]
}
df = pd.DataFrame(data)

 

In Notebook_2, use `%run` to call Notebook_1:
%run Notebook_1
print(df.head())


This method works only if both notebooks are in the same workspace.
• Variables defined in Notebook_1 will be available in Notebook_2

You can use `mssparkutils.notebook.run()`


Hope this is helpful. 

please accept the answer and give kudos if this helps 

 

View solution in original post

2 REPLIES 2
nilendraFabric
Community Champion
Community Champion

@CrhIT if this is helpful , please accept the answer as it will help community to find the right information quickly.

nilendraFabric
Community Champion
Community Champion

Hello @CrhIT 

 

The `%run` magic command allows you to execute another notebook within the same workspace and access its variables directly.

 

Notebook1

 

import pandas as pd

data = {
"ID": [1, 2, 3, 4, 5],
"Name": ["Alice", "Bob", "Charlie", "David", "Eve"],
"Age": [25, 30, 35, 40, 45],
"Salary": [50000, 60000, 70000, 80000, 90000],
"Department": ["HR", "IT", "Finance", "Marketing", "Sales"]
}
df = pd.DataFrame(data)

 

In Notebook_2, use `%run` to call Notebook_1:
%run Notebook_1
print(df.head())


This method works only if both notebooks are in the same workspace.
• Variables defined in Notebook_1 will be available in Notebook_2

You can use `mssparkutils.notebook.run()`


Hope this is helpful. 

please accept the answer and give kudos if this helps 

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors (Last Month)