alphanumeric alphanumeric - 2 months ago 7
Python Question

How to print DataFrame on single line

With:

import pandas as pd
df = pd.read_csv('pima-data.csv')
print df.head(2)


the print is automatically formatted across multiple lines:

num_preg glucose_conc diastolic_bp thickness insulin bmi diab_pred \
0 6 148 72 35 0 33.6 0.627
1 1 85 66 29 0 26.6 0.351

age skin diabetes
0 50 1.3790 True
1 31 1.1426 False


I wonder if there is a way to avoid the multi-line formatting. I would rather have it printed in a single line like so:

num_preg glucose_conc diastolic_bp thickness insulin bmi diab_pred age skin diabetes
0 6 148 72 35 0 33.6 0.627 50 1.3790 True
1 1 85 66 29 0 26.6 0.351 31 1.1426 False

Answer

You need set:

pd.set_option('expand_frame_repr', False)

option_context context manager has been exposed through the top-level API, allowing you to execute code with given option values. Option values are restored automatically when you exit the with block:

#temporaly set expand_frame_repr
with pd.option_context('expand_frame_repr', False):
    print (df)

Pandas documentation.

Comments