Pretty Printing a pandas dataframe

by

I’ve just found a great tool for that need, it is called tabulate.

It prints tabular data and works with DataFrame.

from tabulate import tabulate
import pandas as pd

df = pd.DataFrame({'col_two' : [0.0001, 1e-005 , 1e-006, 1e-007],
                   'column_3' : ['ABCD', 'ABCD', 'long string', 'ABCD']})

print(tabulate(df, headers="keys", tablefmt="psql"))

+----+-----------+-------------+
|    |   col_two | column_3    |
|----+-----------+-------------|
|  0 |    0.0001 | ABCD        |
|  1 |    1e-05  | ABCD        |
|  2 |    1e-06  | long string |
|  3 |    1e-07  | ABCD        |
+----+-----------+-------------+

Note:

To suppress row indices for all types of data, pass showindex="never" or showindex=False.

More Related Contents:

  1. How to iterate over rows in a DataFrame in Pandas
  2. How to deal with SettingWithCopyWarning in Pandas
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. How to add pandas data to an existing csv file?
  5. How to explode a list inside a Dataframe cell into separate rows
  6. How to print pandas DataFrame without index
  7. Combine two pandas Data Frames (join on a common column)
  8. How to map numeric data into categories / bins in Pandas dataframe
  9. Coalesce values from 2 columns into a single column in a pandas dataframe
  10. Cumsum as a new column in an existing Pandas data
  11. Rolling Mean on pandas on a specific column
  12. replace column values in one dataframe by values of another dataframe
  13. Pandas expand rows from list data available in column
  14. python pandas – creating a column which keeps a running count of consecutive values
  15. Turn Pandas Multi-Index into column
  16. How can I use cumsum within a group in Pandas?
  17. Selecting/excluding sets of columns in pandas [duplicate]
  18. What is the fastest and most efficient way to append rows to a DataFrame?
  19. Why does df.apply(tuple) work but not df.apply(list)?
  20. Reverse a get_dummies encoding in pandas
  21. Merge a list of pandas dataframes
  22. pandas divide row value by aggregated sum with a condition set by other cell
  23. Updating a value in a pandas dataframe in an iterrows loop
  24. How to repeat a Pandas DataFrame?
  25. Check if rows in one dataframe exist in another dataframe
  26. Get column name where value is something in pandas dataframe
  27. Pandas – Interleave / Zip two DataFrames by row
  28. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  29. Python: Adding hours to pandas timestamp
  30. Pandas: Join dataframe with condition

Leave a Comment