I would like to count suppose cmd.exe or svchost.exe occurence among the Pandas Dataframe without using for loop.
I can do that for a specific column but I would like to search the whole dataframe [all columns] and count a particular/given string.
This is sample data:
enter image description hereenter image description here
import pyarrow.parquet as pq
import pandas as pd
import pyarrow as pa
processes_dataset = pq.ParquetDataset('/dataset/w32processes')
df = processes_dataset.read().to_pandas()
print(df['name'].value_counts()['cmd.exe'])
output: 10
