How could I identify all the Pandas DataFrames created in my current notebook session?
Something like in SAS seeing all the members in the Work library would be ideal.
Thanks.
Method 2: Using set_option() A function set_option() is provided by pandas to display all rows of the data frame. display. max_rows represents the maximum number of rows that pandas will display while displaying a data frame. The default value of max_rows is 10.
You can visualize a pandas dataframe in Jupyter notebooks by using the display(<dataframe-name>) function. The display() function is supported only on PySpark kernels. The Qviz framework supports 1000 rows and 100 columns.
You can use the print() method to print the dataframe in a table format. You can convert the dataframe to String using the to_string() method and pass it to the print method which will print the dataframe.
%who DataFrame
... seeing all the members in the Work library would be ideal.
In [1]:
a = 10
b = 'abs'
c = [1, 2, 3]
%who
shows all used names:
In [2]:
%who
a b c
Conveniently as a list:
In [3]:
%who_ls
Out[3]:
['a', 'b', 'c']
Or as table with data types:
In [4]:
%whos
Variable Type Data/Info
----------------------------
a int 10
b str abs
c list n=3
In [5]:
import pandas as pd
df1 = pd.DataFrame({'a': [100, 200, 300]})
df2 = pd.DataFrame({'b': [100, 200, 300]})
In [6]:
%whos DataFrame
Variable Type Data/Info
---------------------------------
df1 DataFrame a\n0 100\n1 200\n2 300
df2 DataFrame b\n0 100\n1 200\n2 300
In [7]:
%who DataFrame
df1 df2
In [8]:
%who_ls DataFrame
Out[8]:
['df1', 'df2']
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With