Show DataFrame as table in iPython Notebook

by

You’ll need to use the HTML() or display() functions from IPython’s display module:

from IPython.display import display, HTML

# Assuming that dataframes df1 and df2 are already defined:
print "Dataframe 1:"
display(df1)
print "Dataframe 2:"
display(HTML(df2.to_html()))

Note that if you just print df1.to_html() you’ll get the raw, unrendered HTML.

You can also import from IPython.core.display with the same effect

More Related Contents:

  1. Jupyter notebook display two pandas tables side by side
  2. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  3. How can I left justify text in a pandas DataFrame column in an IPython notebook
  4. How to provide a reproducible copy of your DataFrame with to_clipboard()
  5. Pandas bar plot changes date format
  6. How do I add python3 kernel to jupyter (IPython)
  7. Pandas – Plotting a stacked Bar Chart
  8. Pretty Printing a pandas dataframe
  9. Pandas: Setting no. of max rows
  10. Export from pandas to_excel without row names (index)?
  11. Make Pandas DataFrame apply() use all cores?
  12. pandas reading CSV data formatted with comma for thousands separator
  13. After rename column get keyerror
  14. Adding a column thats result of difference in consecutive rows in pandas
  15. Python/Pandas: counting the number of missing/NaN in each row
  16. pandas dataframe group and sort by weekday
  17. Merge two data frames based on common column values in Pandas
  18. Pandas: convert date in month to the 1st day of next month
  19. Getting Colorbar instance of scatter plot in pandas/matplotlib
  20. All possible combinations of columns in dataframe -pandas/python
  21. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  22. Format a number with commas to separate thousands
  23. Jupyter python3 notebook cannot recognize pandas
  24. Pandas & AWS Lambda
  25. Scrape tables into dataframe with BeautifulSoup
  26. How to remove illegal characters so a dataframe can write to Excel
  27. Plot pandas dataframe containing NaNs
  28. Turn pandas dataframe into a file-like object in memory?
  29. concise way of flattening multiindex columns
  30. Convert dataframe with start and end date to daily data

Leave a Comment