Count similar strings in an array of strings

count_string_occurence.py

import csv
import pandas as pd

lines = []

with open('search_kpi.csv') as csvfile:
    readCSV = csv.reader(x.replace('\0', '') for x in csvfile)
    for row in readCSV:
        lines.append(row[1])

df = pd.DataFrame({'term': lines})
print(df)

print(df.groupby(['term']).size().sort_values(ascending=False)[:20])