how to print out dataframe in python

Question

normally using jupyternotes I can import pandas make my dataframe and export to csv.

I'm trying to automate this reoccurring query with a python script. I can't figure out how to test my script because I cant print out the df to screen. In jupyternotes I just need to type out the df name in any cell and it will display.

here what I'm doing

import pandas as pd
def run_agg_query(db):
    df1 = pd.read_sql( "select some query",conn)
    display(df1)

but I cant get the df to display.

Will print(df1) not work? or you may need from IPython.display import display ? Also, are you getting any error? — niraj
– niraj, Commented Apr 14, 2018 at 1:10

rowana · Accepted Answer · 2018-04-14 02:02:33Z

8

I think printing the dataframe as a string should do the job for you. Something like this might work -

print(df.to_string())

Hope this helps!

answered Apr 14, 2018 at 2:02

rowana

7483 gold badges8 silver badges21 bronze badges

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

Comments

chowpay · Accepted Answer · 2018-04-16 21:22:04Z

5

turns out print(df) works just fine it just took a long time to render due to the size of the table. I tried the suggestions above but had strange errors, eventually this worked print(df['colName']) which lead me to the above... sometimes the solution is the obvious one *facepalm.

answered Apr 16, 2018 at 21:22

chowpay

1,7158 gold badges25 silver badges57 bronze badges

Comments

CertainPerformance · Accepted Answer · 2018-08-09 05:05:06Z

0

Use this:

print("data frame is:\n{}".format(data_pandas))

edited Aug 9, 2018 at 5:05

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

answered Aug 9, 2018 at 4:48

sarveswara rao vangala

11 bronze badge

Comments

Hamid Naghipour · Accepted Answer · 2020-09-11 07:12:13Z

-1

df = pandas.read_csv("data.csv")

pandas.set_option('display.max_rows', df.shape[0]+1)

print(df)

edited Sep 11, 2020 at 7:12

Hamid Naghipour

3,6362 gold badges30 silver badges56 bronze badges

answered Sep 11, 2020 at 3:26

adinda aulia

1931 gold badge4 silver badges13 bronze badges

Collectives™ on Stack Overflow

how to print out dataframe in python

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related