get the count occurence of a words in text python code example

Example 1: count the frequency of words in a file

from collections import Counter
def word_count(fname):
        with open(fname) as f:
                return Counter(f.read().split())

print("Number of words in the file :",word_count("test.txt"))

Example 2: python number of upper words in csv file

hello wrodl