pandas loc vs. iloc vs. at vs. iat?

by

loc: only work on index
iloc: work on position
at: get scalar values. It’s a very fast loc
iat: Get scalar values. It’s a very fast iloc

Also,

at and iat are meant to access a scalar, that is, a single element
in the dataframe, while loc and iloc are ments to access several
elements at the same time, potentially to perform vectorized
operations.

http://pyciencia.blogspot.com/2015/05/obtener-y-filtrar-datos-de-un-dataframe.html

More Related Contents:

  1. What is the performance impact of non-unique indexes in pandas?
  2. When should I (not) want to use pandas apply() in my code?
  3. Why does concatenation of DataFrames get exponentially slower?
  4. How to convert index of a pandas dataframe into a column
  5. Replace values in a pandas series via dictionary efficiently
  6. What is the most efficient way to loop through dataframes with pandas?
  7. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  8. Pandas split DataFrame by column value
  9. Selecting a row of pandas series/dataframe by integer index
  10. What is the difference between using squared brackets or dot to access a column?
  11. how do I insert a column at a specific column index in pandas?
  12. Pandas: peculiar performance drop for inplace rename after dropna
  13. Python Pandas: Get index of rows which column matches certain value
  14. Remove index name in pandas
  15. Update row values where certain condition is met in pandas
  16. Fastest way to sort each row in a pandas dataframe
  17. Get column index from column name in python pandas
  18. Vectorizing Haversine distance calculation in Python
  19. Pandas pd.Series.isin performance with set versus array
  20. Vectorized lookup on a pandas dataframe
  21. Pandas – Compute z-score for all columns
  22. Python Pandas: Get index of rows where column matches certain value
  23. Selecting pandas column by location
  24. Pandas max value index
  25. Get first row value of a given column
  26. Python: Removing Rows on Count condition
  27. In Python pandas, start row index from 1 instead of zero without creating additional column
  28. Select the max row per group – pandas performance issue
  29. What’s the alternative to pandas chain indexing?
  30. Can I perform dynamic cumsum of rows in pandas?

Leave a Comment