how to print multiple columns as a data frame - python

Question

I need to print 2 specific columns as a data frame and not a series.

this question is different from when df1 is printed it returns a series. movie title and movie year are the columns I need to print. I used the df = my_series.to_frame() function but it still returns a series.

def find_movie_by_year():
    x = input("enter movie year")
    d = df[df["title_year"] == int(x)]
    df1 = d[["movie_title","title_year"]]
    print('''

    ''')
    print(df1)

EDIT 1:

this is the output format i need:

this is the output format i get from the code:

question from:https://stackoverflow.com/questions/65859714/how-to-print-multiple-columns-as-a-data-frame-python

Answer 1

You can use display function instead of simply printing it.

def find_movie_by_year():
x = input("enter movie year")
d = df[df["title_year"] == int(x)]
df1 = d[["movie_title","title_year"]]
print('''

''')
#print(df1)
display(df1)