Pandas: How to find a particular pattern in a dataframe column?

by

Using the magic of list comprehensions:

[df.index[i - len(pattern)] # Get the datetime index 
 for i in range(len(pattern), len(df)) # For each 3 consequent elements 
 if all(df['ColA'][i-len(pattern):i] == pattern)] # If the pattern matched 

# [Timestamp('2017-07-10 00:00:00')]

More Related Contents:

  1. Still getting ModuleNotFoundError: No module named ‘pandas’ ‘ despite having installed Pandas, anaconda, [closed]
  2. how can I loop to get the list named vlist?
  3. How to add multiple columns to pandas dataframe in one assignment?
  4. Replacing column values in a pandas DataFrame
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How to do/workaround a conditional join in python Pandas?
  7. How to check if a value is in the list in selection from pandas data frame?
  8. shuffling/permutating a DataFrame in pandas
  9. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  10. How to read file with space separated values in pandas
  11. Replace invalid values with None in Pandas DataFrame
  12. How to filter a dataframe of dates by a particular month/day?
  13. Python remove stop words from pandas dataframe
  14. Pandas monthly rolling operation
  15. Count number of words per row
  16. How to select all columns except one in pandas?
  17. What techniques can be used to measure performance of pandas/numpy solutions
  18. Pandas groupby nlargest sum
  19. Appending a list or series to a pandas DataFrame as a row?
  20. Move non-empty cells to the left in pandas DataFrame
  21. Python Numpy TypeError: ufunc ‘isfinite’ not supported for the input types
  22. Convert Pandas Series to DateTime in a DataFrame
  23. Add a sequential counter column on groups to a pandas dataframe
  24. Pandas max value index
  25. Opposite of melt in python pandas
  26. Pandas read_csv dtype leading zeros
  27. How to get column by number in Pandas?
  28. Xticks by pandas plot, rename with the string
  29. How to automatically annotate maximum value in pyplot
  30. Pandas: split list in column into multiple rows [duplicate]

Leave a Comment