After using Pandas for a little bit, I have a few observations:
- Pandas is great for database like use. When you have tabular data from which you would like to efficiently select sub-tables based on critera, Pandas is great.
- Pandas is great for time-series like data, where the rows are ordered. In such cases pandas allows you to combine multiple tables, or plot, or do analyses based on the time series nature of the rows.
- Pandas, however, is a little unwieldy when you wish to add rows (adding columns is very easy) and in data manipulation in general