Johan Nilssons Lifestream

Pandas column indexing for searching?

In relational database, we can create index on columns to speed up querying and joining on those columns. I want to do them same thing on pandas dataframe. The row index seems not what relational database offers.

The question is: Are columns in pandas indexed for searching by default?

If not, is it possible to index columns manually and how to do it?

Edit: I have read pandas docs and searched everywhere, but no one mentions indexing and searching/merging performance on pandas. Seem no one care about this issue, although it is critical in relational database. Can any one make a statement about indexing and performance on pandas?

Thanks.

via Stack Overflow

blog comments powered by Disqus
Get the source for phplifestream at Github