Return two data frames from a function with data frame format

Question

I want to return two data frames from a function, like this:

def test():
    df1 = pd.DataFrame([1,2,3], ['a','b','c'])
    df2 = pd.DataFrame([4,5,6], ['d','e','f'])
    return df1
    return df2
test()

But the function only returns one data frame df1. How to return both in pretty data frame format, not in cmd black background format?

When I tried to return both using

return df1, df2

in the Jupyter Notebook, the output returns the data frames in a black background cmd-like format, and not in proper data frame format.

I think you should just have one return statement. return df1, df2 — Tripp Cannella
– Tripp Cannella, Commented Sep 29, 2018 at 12:42
@TrippCannella That is what I don't want. It returns both in black background like cmd. I am using Jupyter Notebook btw. I want the data frames to be returned in proper table format. — luminare
– luminare, Commented Sep 29, 2018 at 12:43

petezurich · Accepted Answer · 2018-09-29 12:51:16Z

30

How about this:

def test():
    df1 = pd.DataFrame([1,2,3], ['a','b','c'])
    df2 = pd.DataFrame([4,5,6], ['d','e','f'])
    return df1, df2

a, b = test()
display(a, b)

This prints out:

answered Sep 29, 2018 at 12:51

petezurich

10.3k10 gold badges48 silver badges63 bronze badges

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

Comments

Sourav Ghosh · Accepted Answer · 2022-06-18 22:36:32Z

-1

Call IPython (module) in it display(module) and then import display(function) from it

from IPython.display import display

answered Jun 18, 2022 at 22:36

Sourav Ghosh

393 bronze badges

Collectives™ on Stack Overflow

Return two data frames from a function with data frame format

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related