Why is np.where faster than pd.apply

by

I think np.where is faster because use numpy array vectorized way and pandas is built on this arrays.

df.apply is slow, because it use loops.

vectorize operations are the fastest, then cython routines and then apply.

See this answer with better explanation of developer of pandas – Jeff.

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Convert pandas dataframe to NumPy array
  3. String concatenation of two pandas columns
  4. Pandas read_csv low_memory and dtype options
  5. What does axis in pandas mean?
  6. How can I split a column of tuples in a Pandas dataframe?
  7. replace() method not working on Pandas DataFrame
  8. How to map numeric data into categories / bins in Pandas dataframe
  9. Calculate average of every x rows in a table and create new table
  10. Find column name in pandas that matches an array
  11. Coalesce values from 2 columns into a single column in a pandas dataframe
  12. Conditionally fill column values based on another columns value in pandas
  13. How can I map True/False to 1/0 in a Pandas DataFrame?
  14. Group duplicate column IDs in pandas dataframe
  15. Select multiple ranges of columns in Pandas DataFrame
  16. Pandas lookup from one of multiple columns, based on value
  17. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  18. ‘DataFrame’ object has no attribute ‘sort’
  19. python pandas flatten a dataframe to a list
  20. how to read certain columns from Excel using Pandas – Python
  21. What is dtype(‘O’), in pandas?
  22. which is faster for load: pickle or hdf5 in python
  23. vectorize conditional assignment in pandas dataframe
  24. How can I count the number of consecutive TRUEs in a DataFrame?
  25. Binning a column with pandas
  26. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  27. Filling in date gaps in MultiIndex Pandas Dataframe
  28. Store numpy.array in cells of a Pandas.DataFrame
  29. Filtering pandas dataframe with multiple Boolean columns
  30. What’s the best way to sum all values in a Pandas dataframe? [duplicate]

Leave a Comment