# https://www.globalsino.com/ICs/page4853.html
# Count duplicates and show unique values in a csv file


import pandas as pd


MyFileName = (r'C:\GlobalSino\images\TestImages\Excel\CityDateB.csv')

users = pd.read_csv(open(MyFileName))

print(users)

# Count the column in "Date" column
print('Name     Occurrence')
print(pd.value_counts(users['Date']))

print ('===================')
# Display unique values
print(users['Date'].unique())