equivalent of R's View for Python's pandas

Question

The View is a very useful function to allow me to see cross-section of large data frames in R.

Is there any equivalent of R's View function for Python's pandas DataFrame?

I use RStudio for R and PyCharm for Python.

Answer 1

A quicker option might be to set the pandas dataframe so it doesn't line wrap by putting this line of code:

import pandas pandas.set_option('expand_frame_repr', False) 

I'm using Sublime Text 2 and this is how it looks:

Before putting in option (Notice how the output wraps the text around)

After putting in option (Notice how the output continues)

Also make sure that 'View' > 'Word Wrap' is not checked.

Additionally, you can print out more or less as you need by using head(#) like this:

mydf = pandas.DataFrame.from_csv('myfile.csv', header=1) print mydf.head(20) # Prints first 20 lines 

Here's some other pandas options:

pandas.set_option('display.max_columns', 0) # Display any number of columns pandas.set_option('display.max_rows', 0) # Display any number of rows 

Answer 2

Spyder within Anaconda (or R Studio for Python as I like to call it) gives you the ability to view and sort entire dataframes the same way you would in R using the variable explorer.

https://www.continuum.io/