Tutorial by Topics: pandas

Pandas is a Python package providing fast, flexible, and expressive data structures designed to make working with “relational” or “labeled” data both easy and intuitive. It aims to be the fundamental high-level building block for doing practical, real world data analysis in Python. The official P...

ParameterDescriptionpath_or_bufstring or file handle, default None File path or object, if None is provided the result is returned as a string.sepcharacter, default ‘,’ Field delimiter for the output file.na_repstring, default ‘’ Missing data representationfloat_formatstring, default None Format st...

The Pandas datareader is a sub package that allows one to create a dataframe from various internet datasources, currently including: Yahoo! Finance Google Finance St.Louis FED (FRED) Kenneth French’s data library World Bank Google Analytics For more information, see here.

The pandas official documentation includes a page on IO Tools with a list of relevant functions to read and write to files, as well as some examples and common parameters.

Gotcha in general is a construct that is although documented, but not intuitive. Gotchas produce some output that is normally not expected because of its counter-intuitive character. Pandas package has several gotchas, that can confuse someone, who is not aware of them, and some of them are prese...

This section shows basic code for reading, sub-setting and writing external data files using pandas.