What’s the alternative to pandas chain indexing?

by

Use multi-axis indexing, e.g.

df.loc['a', '1']

When you use df['1']['a'], you are first accessing the series object s = df['1'], and then accessing the series element s['a'], resulting in two __getitem__ calls, both of which are heavily overloaded (handle a lot of scenarios, like slicing, boolean mask indexing, and so on).

It’s much more efficient to use the df.loc indexer.

More Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. pandas loc vs. iloc vs. at vs. iat?
  4. How to reset index in a pandas dataframe? [duplicate]
  5. What rules does Pandas use to generate a view vs a copy?
  6. Pandas split DataFrame by column value
  7. Selecting a row of pandas series/dataframe by integer index
  8. How to avoid Python/Pandas creating an index in a saved csv?
  9. What is the difference between using squared brackets or dot to access a column?
  10. how do I insert a column at a specific column index in pandas?
  11. Python Pandas: Get index of rows which column matches certain value
  12. Remove index name in pandas
  13. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  14. What is the point of indexing in pandas?
  15. Python pandas slice dataframe by multiple index ranges
  16. Update row values where certain condition is met in pandas
  17. How to query MultiIndex index columns values in pandas
  18. Get column index from column name in python pandas
  19. Pandas – Compute z-score for all columns
  20. How to avoid pandas creating an index in a saved csv
  21. Python Pandas: Get index of rows where column matches certain value
  22. Selecting pandas column by location
  23. Pandas max value index
  24. Get first row value of a given column
  25. Python: Removing Rows on Count condition
  26. Using replace efficiently in pandas
  27. In Python pandas, start row index from 1 instead of zero without creating additional column
  28. Selecting a range of columns in a dataframe
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. start index at 1 for Pandas DataFrame

Leave a Comment