How to load a Pandas dataframe in memory as a batch

This article is for comments to:

Please comment +1 if this How to is important to you.

Am interested in profiling data in active Python dataframes, not just that from files or databases.
Would be interested in how to do that in Python, so far failing to find a basic doc that describes this.