Pandas
keyboard_arrow_down 655 guides
chevron_leftMiscellaneous Cookbook
Adjusting number of rows that are printedAppending DataFrame to an existing CSV fileChecking differences between two indexesChecking if a DataFrame is emptyChecking if a variable is a DataFrameChecking if index is sortedChecking if value exists in IndexChecking memory usage of DataFrameChecking whether a Pandas object is a view or a copyConcatenating a list of DataFramesConverting a DataFrame to a listConverting a DataFrame to a SeriesConverting DataFrame to a list of dictionariesConverting DataFrame to list of tuplesCounting the number of negative valuesCreating a DataFrame using cartesian product of two DataFramesDisplaying DataFrames side by sideDisplaying full non-truncated DataFrame valuesDrawing frequency histogram of DataFrame columnExporting Pandas DataFrame to PostgreSQL tableHighlighting a particular cell of a DataFrameHighlighting DataFrame cell based on valueHow to solve "ValueError: If using all scalar values, you must pass an index"Importing BigQuery table as Pandas DataFramePlotting two columns of DataFramePrinting DataFrame on a single linePrinting DataFrame without indexPrinting DataFrames in tabular formatRandomly splitting DataFrame into multiple DataFrames of equal sizeReducing DataFrame memory sizeSaving a DataFrame as a CSV fileSaving DataFrame as Excel fileSaving DataFrame as feather fileSetting all values to zeroShowing all dtypes without truncationSplitting DataFrame into multiple DataFrames based on valueSplitting DataFrame into smaller equal-sized DataFramesWriting DataFrame to SQLite
check_circle
Mark as learned thumb_up
5
thumb_down
0
chat_bubble_outline
1
Comment auto_stories Bi-column layout
settings
Printing DataFrame on a single line in Pandas
schedule Aug 11, 2023
Last updated local_offer
Tags Python●Pandas
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
To print a DataFrame on a single line instead of across multiple lines use the pd.set_option(~) method setting the 'expand_frame_repr' setting to False.
Example
Consider the following DataFrame:
from sklearn import datasetsimport pandas as pdimport numpy as np
bunch_iris = datasets.load_iris()
# Construct a DataFrame from the Bunch Objectdf = pd.DataFrame(data=np.c_[bunch_iris['data'], bunch_iris['target']], columns=bunch_iris['feature_names'] + ['target'])print(df.head())
sepal length (cm) sepal width (cm) petal length (cm) petal width (cm) \0 5.1 3.5 1.4 0.2 1 4.9 3.0 1.4 0.2 2 4.7 3.2 1.3 0.2 3 4.6 3.1 1.5 0.2 4 5.0 3.6 1.4 0.2 target 0 0.0 1 0.0 2 0.0 3 0.0 4 0.0
Notice how the printed DataFrame is automatically formatted across multiple lines.
To print the DataFrame on a single line:
pd.set_option('expand_frame_repr', False)print(df.head())
sepal length (cm) sepal width (cm) petal length (cm) petal width (cm) target0 5.1 3.5 1.4 0.2 0.01 4.9 3.0 1.4 0.2 0.02 4.7 3.2 1.3 0.2 0.03 4.6 3.1 1.5 0.2 0.04 5.0 3.6 1.4 0.2 0.0
By setting expand_frame_repr to False we can prevent the DataFrame from being printed across multiple lines.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
5
thumb_down
0
chat_bubble_outline
1
settings
Enjoy our search
Hit / to insta-search docs and recipes!
